The performance of AutoInvoice is affected by several factors. Checking the following could improve performance considerably.

• When using the interface_line_attribute fields, create indexes on RA_INTERFACE_LINES_ALL for these fields. Use the minimum number of interface_line_attribute fields.
• Some installations use RA_INTERFACE_DISTRIBUTIONS_ALL to populate accounting details while populatingsegments instead of code combination IDs. In this instance, create an index for segments to improve performance.
• If possible, populate all the code IDs for the RA_CUSTOMER_TRX_TYPES_ALL, MTL_SYSTEMS_ITEMS, and RA_TERRITORIES tables in RA_INTERFACE_LINES_ALL instead of passing values.
• When loading more than 5,000 invoices, split them into batches of 5,000. A batch of more than 5,000 rapidly decreases AutoInvoice performance.
• For a batch with 3,000 to 5,000 invoices, run more than one instance of AutoInvoice by giving a value between five and eight in the Number of Instances field in the AutoInvoice Run screen. This will split your data into five to eight batches (and five to eight import programs), increasing performance.
• The amount of memory allocated to AutoInvoice for validation can affect performance. \Navigate System SystemOptions Invoice and Customers and enter three MB in the Max Memory (In Bytes) field.
• Use SQL*Trace to uncover bottleneck areas.

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips