R12/CLL: Invalid Object After Patching CLL_F035_CPY_TRX_COD_XML 380/17 PL/SQL: ORA-00904: "SUB_FAMILY_CODE": invalid identifier (Doc ID 2239389.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Cash Management - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Invalid Object
CLL_F035_CPY_TRX_COD_XML 380/17 PL/SQL: ORA-00904: "SUB_FAMILY_CODE": invalid identifier

Symptoms

On : 12.1.3 version, Other Issues
An invalid object error occurs after patching.

SQL> select object_name,object_type,owner,LAST_DDL_TIME from dba_objects where status = 'INVALID' and object_name||owner not in (select object_name||owner from invalids_backup6feb);

OBJECT_NAME
------------------------------------------------------------------------------------------------------------------------
OBJECT_TYPE OWNER LAST_DDL_TIME
------------------- ------------------------------ ------------------
CLL_F035_CPY_TRX_COD_XML
PACKAGE BODY APPS 06-FEB-17

LINE/COL ERROR
-------- -----------------------------------------------------------------
347/9 PL/SQL: SQL Statement ignored
380/17 PL/SQL: ORA-00904: "SUB_FAMILY_CODE": invalid identifier
500/13 PL/SQL: Statement ignored
500/36 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
501/13 PL/SQL: Statement ignored
501/38 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
516/17 PL/SQL: Statement ignored
517/54 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
531/21 PL/SQL: Statement ignored
535/60 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
582/29 PL/SQL: Statement ignored
582/118 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
583/29 PL/SQL: SQL Statement ignored
583/64 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
650/22 PL/SQL: SQL Statement ignored
666/37 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
666/50 PL/SQL: ORA-00984: column not allowed here
SQL> exec sys.utl_recomp.recomp_parallel(10);

PL/SQL procedure successfully completed.Tried running utlrp but invalid still exist

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