My Oracle Support Banner

V23.1.201.6: RTV Head EXT_REF_NO Is Augmented With A Prefix When Sent To INVC_HEAD (Doc ID 2987379.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 to 23.1 [Release 23.1]
Information in this document applies to any platform.

Goal

RTV Head EXT_REF_NO is augmented with a prefix when sent to INVC_HEAD

EXT_REF_NO needs to be consistent between RTV_HEAD and INVC_HEAD as these are keys to the invoice that need to be matched.

RTV_HEAD.EXT_REF_NO: 9465774000
INVC_HEAD.EXT_REF_NO: REF#9465774000


Steps To Recreate:

1. Create/ship any RTV using RTV WS with any value in the external reference number.
2. Run POM batch
3. Review EXT_REF_NO on RTV_HEAD and INVC_HEAD and notice that REF# prefix has been added on INVC_HEAD.EXT_REF_NO


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.