STAGE_EXT_TRAN_DATA.REF_1, REF_2 Columns are of Length NUMBER(10) While the Associated Columns in Other Tables are of Length NUMBER(12)
(Doc ID 2675845.1)
Last updated on MAY 28, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
While posting order receipt transactions using external system which uses table STAGE_EXT_TRAN_DATA to load transaction data, Order table allows to create order with 12 digit but ref_no_1 column in table STAGE_EXT_TRAN_DATA has only length 10 resulting the transactions insertion failure in table STAGE_EXT_TRAN_DATA.
Steps to recreate:
1. Create a Purchase Order (PO) on RMS.
2. Ship and receive from external system.
3. Send data through Oracle Data Integrator(ODI) to table STAGE_EXT_TRAN_DATA.
4. Since STAGE_EXT_TRAN_DATA.REF_No_1 Column is only Number(10), the transaction insertion fails.
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