My Oracle Support Banner

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

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