Performance Limitations for Bulk Updates via ADFDI Template in Price Lists/Discount Lists — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Performance Limitations for Bulk Updates via ADFDI Template in Price Lists/Discount Lists

in Pricing 3 comments

Summary:

We are planning a bulk update of item prices using the ADFDI template in Oracle Fusion. The price list in question has over 20,000 items, and we intend to end-date all existing entries and insert new prices, resulting in 40,000+ rows to be updated in a single operation.

Before proceeding, we would like to understand:

  • What is the maximum number of rows recommended for update using the ADFDI template without encountering performance issues or timeouts?
  • Are there any best practices or limitations we should be aware of when performing such large-scale updates?
  • Would Oracle recommend splitting the update into smaller batches, and if so, what batch size is considered optimal?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!