My Oracle Support Banner

Issues in Setting Up Multiple Set Of Books in RMS 14.0.0 (Doc ID 1958755.1)

Last updated on MARCH 25, 2019

Applies to:

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


In RMS14.0.0 there is no installation option given to turn on/off MSOB.
At the same time, you need to populate all the MSOB related tables with one set of books.

Situation: Have only one set of book ID ( 1, CNY) and one org_unit (1) and are linking these entities in table ORG_UNIT table.
Getting an error when creating a new store from the RMS front end with currency which is not 'CNY'.

In the Oracle forms code, there is a validation on set_of_book ID and currency when SYSTEM_OPTIONS ORG_UNIT_IND is set to 'Y'.
Tried to set this system_options to 'N', but the constraint CHK_FUN_CONG_OPT_ORG_UNIT_IND will not allow this.  Is this a bug?

And should the system allow different currencies for the stores?


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.