Invoicing(pin_inv_accts) is Taking Longer Time to Complete
(Doc ID 2092787.1)
Last updated on MARCH 10, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 7.5.0]
Information in this document applies to any platform.
When number of bill is more than fetch_size, 1st time sql goes with >1, and it works fine, but for 2nd set of fetch, it goes with condition "poid_id0 ><last_poid_from_first_fetch>" so for this sql the SQL profile
"BILL_TPROFILE" is NOT getting attached hence it will do full table scan and t takes more time.
In another issue Oracle suggested to increase the fetch_size such that 'fetch_size' is larger than the total number of bills, but now number of bills are getting increased, so CANNOT keep changing the fetch_size.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document