Supplier ID In RMFCS (Doc ID 2793100.1)

Last updated on SEPTEMBER 06, 2022

Applies to:

Symptoms

How the Supplier ID in RMFCS (Oracle Retail Merchandising Foundation Cloud Service) is created? It uses a simple SEQUENCE in database or it checks the existence of Supplier ID in RMFCS when the next ID in the sequence is obtained (and retry if already in use).  

FINANCIAL_AP value is A in SYSTEM_OPTIONS table, with the following scenario:
1. Supplier are created in Fusion using an ID.
2. When integrating to RMFCS, it is ignoring this ID and putting a sequence value for the ID.
3. When RMFCS is sending the Supplier ID info to the legacy WMS system, we are getting an error because it explodes 6 digits limit for this legacy system.

Changes

Modified supplier creation to use the next available supplier_seq while financial_ap='A'.

Cause

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