E1: 43: R437002 Stocked Item Reorder Point Output Incorrect After 100 Suppliers (Doc ID 2053480.1)

Last updated on APRIL 17, 2017

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

R437002 Stocked Item Reorder Point output is incorrect if more than 100 different suppliers are processed in the same batch.  After the 100th supplier, the report information contains Order Total lines that display with no item, supplier, quantity or amount information specified.

Logs captured for R437002 reports where more than 100 different suppliers are used get a Max # Cursor error in B4302180 (CacheProcessPODetalCache)

CAC0001017 - (jdeCacheOpenCursor) failed to open cursor due to reach the max #cursors (100) for cache (0B4302180G108921)


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