My Oracle Support Banner

Supplier ID In RMFCS (Doc ID 2793100.1)

Last updated on SEPTEMBER 06, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


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.


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


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.