My Oracle Support Banner

Organization Structure Dimension Population Function Failure (Doc ID 2887432.1)

Last updated on AUGUST 09, 2022

Applies to:

Oracle Financial Services Analytical Applications Reconciliation Framework - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

While executing FN_POP_ORG_STRUCTURE task to Populate dim org structure table is failing with below error

From DT Log:

[INFO][BACKEND][OFSAA][RUNPROCEDURE] Parameters : DT_FN_POP_ORG_STRUCTURE_1,'FSADMINFO_DIMENSION_DATA_RECON_20220627_2','20220627'
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := DT_FN_POP_ORG_STRUCTURE_1('FSADMINFO_DIMENSION_DATA_RECON_20220627_2','20220627'); END;
Error Msg :-> ORA-06550: line 1, column 13:
PLS-00905: object FSARECON.DT_FN_POP_ORG_STRUCTURE_1 is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

VW_STG_ORG_STRUCTURE_MASTER is not available in reconciliation schema

 

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


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