Pre-req Of HRMS Family Pack K Rollup 6 Failed(Oracle Projects Product-4997596) (Doc ID 2109636.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Project Costing - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Patch Application Issues

When attempting to apply <Patch 4997596> 'Oracle Projects Costing Rollup Patch 2 for Oracle Projects Family Pack M (11i.PJ_PF.M)' (functional pre-req for HRMS Family Pack K Rollup 6),
the follow error occurs:
 
ERROR
-----------------------
sqlplus -s APPS/***** @/tst1002/app/aptst1/appl/pa/11.5.0/patch/115/sql/paupgr95.sql
and basis_rbs_version IS NULL ;
  *
ERROR at line 8:
ORA-06550: line 8, column 7:
PL/SQL: ORA-00904: "BASIS_RBS_VERSION": invalid identifier
ORA-06550: line 3, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 24, column 6:
PLS-00364: loop index variable 'C_RULE' use is invalid
ORA-06550: line 24, column 6:
PL/SQL: ORA-00904: "C_RULE"."RULE_ID": invalid identifier
ORA-06550: line 19, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 34, column 17:
PLS-00364: loop index variable 'C_RULE' use is invalid
ORA-06550: line 34, column 17:
PL/SQL: ORA-00904: "C_RULE"."RULE_ID": invalid identifier,
the following error occurs.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. attempt to apply patch 4997596 'Oracle Projects Costing Rollup Patch 2 for Oracle Projects Family Pack M (11i.PJ_PF.M)' (functional pre-req for HRMS Family Pack K Rollup 6).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
None provided at this time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms