E1: 48S/52: Processing Time When Deleting Lines From An Invoice Batch (P48221) in Contract and Service Billing (Doc ID 2233594.1)

Last updated on OCTOBER 05, 2022

Applies to:

Symptoms

After creating a large Invoice batch (1000s of records) with Invoice Generation (R52121) and drilling into the batch from Batch Review (P48221) when deleting 40 records at one time, the system processes and then stops.
In the Delete Business Function,  the delete happens quick however, the F4822 update process is time consuming. The program is summing up all the remaining records and does the F4822 update for each deletion; hence the process time for each delete and update is about 30 seconds for this large batch. And, not all the records are getting deleted. It seems the process times out at some point.

SQL:
SELECT count(*) FROM CBICRPDTA.F4812
WHERE ( WDDOCO = 14208602.000000 AND WDDCTO = 'R2' AND WDKCOO = '00619' AND WDICU = 445330.000000 AND WDDOCZ = 184032.000000 AND WDDCTI = 'RI' AND WDKCOI = '00619' AND WDSFX = '001' )
 
Count = 38957

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.