Oracle Retail Merchandising (RMFCS)
RMFCS is the system of record for item, price, cost, inventory position and the stock ledger. When it is wrong, every downstream system is wrong — and the finance team finds out first.
What actually goes wrong
Stock ledger does not tie to the general ledger
Almost always a transaction-data problem rather than a ledger problem — mis-mapped transaction codes, a missing tran-data record for a specific movement type, or a cost-change event that never posted. Reconciling it means tracing the transaction back through TRAN_DATA to the originating event, not adjusting the ledger.
Migrating on-premise RMS to cloud RMFCS
The hard part is not the data. It is the customisations. Cloud RMFCS removes direct database access, so anything built as a trigger, a package or a batch modification has to be rebuilt against supported extension points — or dropped. Deciding which of those two applies to each customisation is the actual project.
Item and hierarchy design decisions that are expensive to reverse
Merchandise hierarchy depth, differentiator groups, pack item structures and supplier hierarchies are all straightforward to configure on day one and painful to change after two years of transactional history. These decisions deserve more scrutiny than they usually get.