My Oracle Support Banner

Business Validation Fails With Error ORA-06502: PL/SQL: Numeric Or Value Error Returned By Program Unit RMSSUB_ASNIN.CONSUME When Loading ASN of Type 'C'. (Doc ID 2781403.1)

Last updated on OCTOBER 01, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Goal

When doing business validation for a purchase order in Data Conversion tool via ship_purchase_orders, it is failing with the error:

"Error ORA-06502: PL/SQL: numeric or value error returned by program unit RMSSUB_ASNIN.CONSUME."

Example of file used in ship_purchase_orders.zip:

asnin_head.dat
,,1221,S,,,,,,,1272332,C,25,,05-MAR-21,05-MAR-21,,,,,,,,,,,,,,,,

asnin_item.dat
1272332,7108550,,1,100000024,0,,,,,100000024,,,,,,,

asnin_po.dat
1272332,7108550,,01-APR-21,

asnin_ctn.dat
1272332,7108550,1221,,,,,,,,,,,,,

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


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