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

Is it possible to create a customer index on Oracle Cloud ERP seeded tables?

Summary:

We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report is functioning well, but it is taking a considerable amount of time to extract the data. Even when there are no transactions to pull, the report still takes approximately 3 minutes to finish.

Therefore, we are feasibility to create an index on the last_updated_date field, as it is the only field we are using in our filters.

Has anyone run into a situation like this before? Can Oracle provide support for creating custom indexes on seeded tables?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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