Invalid FSI_CF_EDIT_PROC_TABLE and VALIDATE_NODE_MAP_CFE Procedures

(Doc ID 1081074.1)

Last updated on MAY 04, 2010

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 and later   [Release: 7 and later ]
Oracle Financial Services Funds Transfer Pricing - Version: 5.1 and later    [Release: 5 and later]
Information in this document applies to any platform.
OFSAA
OFSAAI

Symptoms

When checking for Invalid Objects after Oracle Financial Services Funds Transfer Pricing installation, found the following procedures are invalid and errors occur during re-compile.

FSI_CF_EDIT_PROC_TABLE 
VALIDATE_NODE_MAP_CFE

Error
Errors for PROCEDURE ATOMIC.FSI_CF_EDIT_PROC_TABLE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
87/1 PL/SQL: SQL Statement ignored
95/31 PL/SQL: ORA-00904: "C"."CASH_FLOW_EDIT_SYS_ID": invalid identifier

Errors for PROCEDURE ATOMIC.VALIDATE_NODE_MAP_CFE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
55/1 PL/SQL: SQL Statement ignored
58/7 PL/SQL: ORA-00904: "CASH_FLOW_EDIT_SYS_ID": invalid identifier
103/1 PL/SQL: SQL Statement ignored
104/34 PL/SQL: ORA-00904: "CASH_FLOW_EDIT_SYS_ID": invalid identifier

Steps
1. Install Oracle Financial Services Funds Transfer Pricing.
2. Create an Information Domain (INFODOM).
3. Check for Invalid Objects.

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