E1: 40G: Reprice Procurement Receipt Batch (R45620) Returns JDB9900600 - Failed to store value, maximum exceeded Error (Doc ID 2920563.1)

Last updated on JUNE 08, 2023

Applies to:

Symptoms

When attempting to run Reprice Procurement Receipt Batch (R45620) over a large data selection the program crashes with the following errors in the JDEDBUG Logs and Work Center:

Steps to Reproduce:

1. Run Reprice Procurement Receipt Batch (R45620) version:
   1. Report Data selection is on one specific Supplier Address
   2. Process Tab Options #3-#5 are set to 1
   3. No tolerance is used.
2. Report PDF is 35 pages.
   1. Prices were updated for all the lines on these pages.
   2. Error message in UBE pdf last page states “The UBE processed with errors - See work message center for details”
3. Execution Detail for this job shows that 4,819 records processed but there were more than that in the data selection.
4. The following errors appear in the Work Center and the JDEDEBUG log
   1. Fetch from table F4105 failed (Error returned by GetItemCost (XF4105))
   2. SQL Statement finds the record but is unable to store a data pointer
      • SELECT * FROM MG920DTA/F4105 WHERE ( COCSIN = 'I' AND COITM = 1139426.000000 AND COMCU = ' 1505' ) ORDER BY COCSIN ASC,COITM ASC,COMCU ASC,COLOCN ASC,COLOTN ASC
      • Fetched the record
      • JDB9900600 - Failed to store value, maximum exceeded. Probable cause is forgetting to call jdeRemoveDataPtr()
5. The maximum of 1,000 data pointers was exceeded causing the program to crash and additional errors to be sent
   1. Null Pointer (4363)
   2. No Memory (4365)

Cause

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