|Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today|
Understanding the profile options and some parameter is essential for autoinvoice execution. Understanding is especially helpful when trouble shooting is required to figure out why and where the processing has failed for certain data scenarios. Here is some informative information for profile Options and parameter required for autoinvoice.
As we know system setup can be done from system options, which is as below.
1.Max Memory (in bytes)
As marked 1 in above picture. This is memory setting for allocating autoinvoice program for validation. It is recommended to set Value to 3,000,000 Bytes.
2.Log File Message Level
This is at 2 in above picture. This is number represents the amount of detail we wish to display Auto Invoice log file.
- Message Level 0
This will gives the following entries in the log file:
Product Version, Program Name, Auto Invoice Start Time, AutoInvoice Concurrent request Arguments, Error and Warning Messages, AutoInvoice End Time, auto Invoice logical Steps.
- Message Level 1
This gives all of the above entries plus: Time-Stamped function labels
- Message Level 2
This gives you all of the above entries plus: Sizes of Allocated Arrays, Dynamic SQL Statements, Number of Rows Updated, Inserted and Deleted
- Message Level 3
This gives you all of the above entries plus: Method IV SQL Array Values.
3. Purge Interface Tables
This is marked 3 in above picture. If this is checked then
- Purges records that are successfully imported into receivables.
It recommended to avoid getting interface tables filled with data that is no more required
4.AR: Autoinvoice Gather Statistics
Specify whether AutoInvoice process analyzes the interface tables or not
- Null is taken as Yes
- This profile should be set to "Yes" if type of data populated in the interface tables changes
5.Number of Instances
This is for Load Balancing.
- Number of CPU -1
- Maximum allowed 500
6.AR: Maximum Lines per Autoinvoice worker
This is setting for let worker know how many records need to pick. This setting is more important, if you are loading very huge set of data. If any one is doing conversion, it is essential to check this value.
The default value is 100000,But the optimal value should be 10000.
Hope this will give a fair idea who is going to utilize autoinvoice First time.