Last updated on SEPTEMBER 19, 2017
Applies to:Oracle Retail Merchandising System - Version 14.1.1 and later
Information in this document applies to any platform.
RMS subscribers such as, InvAdj (Inventory Adjustment), TSF (Transfer) and SOStatus (Stock Order Status) fail with ORA-14450 error when run in SYNC mode for NIL (New Item Loc) EVENT_TYPE on COST_EVENT_RUN_TYPE_CONFIG table. Also please note that running in SYNC mode is needed for Allocation approval to be able to create the new item/location in the session that is used for approval. This will ensure that the record will be inserted in the FUTURE_COST table and support the creation of the franchise order.
Steps to Reproduce
1. Consume any of the InvAdj, TSF or SOStatus messages.
2. Notice the ORA-14450 error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms