Auto Invoice – Parameter and Profile Options
Posted By Sanjit Anand On May 27, 2007 @ 6:22 am In Finance,Oracle Receivable | 3 Comments
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.
3 Comments (Open | Close)
Article printed from OracleApps Epicenter: http://www.oracleappshub.com
URL to article: http://www.oracleappshub.com/finance/auto-invoice-parameter-and-profile-options/
Click here to print.
3 Comments To "Auto Invoice – Parameter and Profile Options"
#1 Comment By Arvinda On June 12, 2007 @ 12:59 am
Hi Anand,
Thx fr the gud job, when time permits, can u do a similar write-up on Lockbox too? Wud b great!
Rgrds.
#2 Comment By anand On June 12, 2007 @ 7:05 am
Thanks Arvinda,
will surly share more information for lockbox as well as netting.
keep reading ..
-anand
#3 Comment By Alex Reyderman On February 16, 2009 @ 2:32 pm
Hello Anand,
Thank you for the guidelines – short and to the point!
One other thing I wanted to add is the use of indexes. It’s recommended that you define your interface_line_attribute1….? non-unique indexes for all context values that you have defined. This needs to be done on interface tables as well as corresponding base tables. You may also want to defined indexes for link_to and reference_to DFF.
Thanks,
Alex