My Oracle Support Banner

RMS Database Objects Install Failing in Version 19 if Allocation is Not Selected (Doc ID 2756997.1)

Last updated on MARCH 02, 2021

Applies to:

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

Symptoms

RMS 19 DB installer fails with below error.


ERROR

  [exec] 01:07:03 01/31/2021 3 invalid objects remain:
  [exec] 01:07:03 01/31/2021 PACKAGE - STKLEDGR_INSERTS_SQL
  [exec] 01:07:03 01/31/2021 PACKAGE BODY - CORESVC_STKLEDGR_INSERTS_SQL
  [exec] 01:07:03 01/31/2021 PACKAGE BODY - STKLEDGR_INSERTS_SQL
  [exec] 01:07:03 01/31/2021 See logs in detail_logs/dbsql_raf/invalids for user_errors information
  [exec] 01:07:03 01/31/2021 3 invalid objects
  [exec] 01:07:03 01/31/2021 Failed to complete Post-action for action: DBSQL_RAF
  [exec] 01:07:03 01/31/2021 ORPatch session completed with errors
  [echo]
  [echo] #######################################################################
  [echo] Install Summary
  [echo] #######################################################################
  [echo] RETAIL_HOME: /u01/app/oracle/retail_home
  [echo] STATUS: Installation Failed
  [echo] COMPONENTS:
  [echo] DB - RMS
  [echo] Batch
  [echo]


Steps to Reproduce:


The issue can be reproduced at will with the following steps:
1. Export and verify the environment variables.
2. Run the RMS Database Schema Installer.
3. Observe the error.

 

Cause

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
Symptoms
Cause
Solution
References


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