E1: 45: Order and Basket Level Pricing (R42750) Crashes with Error JDB9900600 - Failed to Store Value, Maximum Exceeded (Doc ID 2797637.1)

Last updated on AUGUST 24, 2023

Applies to:

Symptoms

When R42750 is run over more than 1000 detail lines for orders with a Advanced pricing adjustment for a type 3 order level reprice adjustment attached then the UBE crashes due to a memory leak. The jde.log shows error JDB9900600 - Failed to store value, maximum exceeded. Probable cause is forgetting to call jdeRemoveDataPtr()

It appears that BSFN B4202090 - GetF42UI02WFLineNumber create & stores data pointer which are not removed


Steps to Duplicate:
1. Set up an item with an order level reprice group in the P41026/F4102:
2. Create price adjustment for a type 3 order level reprice adjustment and add an adjustment detail record for the specific order level reprice group
3. Add adjustment to adjustment schedule and populate schedule on Customer Master record
4. Enter 10 sales order for the same item / customer
5. Run R42750
6. Check debug.log and note that BSFN B4202090 - GetF42UI02WFLineNumber create & stores data pointer which are not removed
7. log shows error JDB4100006 - DP - While freeing the JDB environment, leaked data pointer (2ABA3660), pointer handle (11), stored from File=B4202090.c, Function=GetF42UI02WFLineNumber, Line=148.  and error JDB4100005 - Application code leaked 10 data pointers which were detected when freeing environment PD920

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.