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 MARCH 13, 2017

Applies to:

JD Edwards EnterpriseOne Contract and Service Billing - Version 9.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms