My Oracle Support Banner

PO Induction Is Not Working Properly With CFA During PO Creation (Doc ID 2702007.1)

Last updated on AUGUST 25, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

Purchase Order(PO) induction is not working properly with Custom Flex Attributes(CFA) during PO creation with the below error:

Error:
NONE - UNHANDLED EXCEPTION/VALIDATION ERROR
@0PACKAGE_ERROR@1ORA-00001: unique constraint (RMSUSER.SVC_CFA_EXT_U1) violated@2CORESVC_PO.GENERATE_ORDER_NUMBER

Steps To Recreate:
1. Upload the PO induction file to create the PO.
2. Encountered the error in the UI. @0PACKAGE_ERROR@1ORA-00001: unique constraint (RMSUSER.SVC_CFA_EXT_U1) violated@2CORESVC_PO.GENERATE_ORDER_NUMBER.
3. Create a PO(75002) using UI or through PO induction keeping blank the CFA tab. It will create the PO.
4. Update the PO using PO induction. CFA are updated properly for Order no 75002.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.