ORDDSCNT Batch Failing With an Error 'ORA-06502: PL/SQL: Numeric Or Value Error: Character To Number Conversion' (Doc ID 2400904.1)

Last updated on MARCH 05, 2019

Applies to:

Symptoms

When a Purchase Order (PO) is open on the PO screen and the ORDDSCNT batch is executed, the process fails with the error below:

 Steps to Recreate:

1. Create an off-invoice deal and approve the deal.
2. Create a purchase order using the same items and location in the created deal.
3. Approve the purchase order.
4. Open the approved purchase order in RMS.
5. Run the ORDDSCNT.pc batch.
6. Error should show that the purchase order is locked; instead the SQL_LIB package is failing.

Cause

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