ORA-24344: success with compilation error when configuring Peoplesoft 9.1 Financials target (Doc ID 1168866.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

On : 5.5.1 version, Install, Migration, Upgrade

CCG does not support or supply metadata for Peoplesoft Financials. Customer wants to build his own metadata for Financials using the Metabuilder product so he is licensing the Financials schema as though it were HR.

When attempting to configure Peoplesoft 9.1 FIN target as version 8.9 HR
the following error occurs in the job log :

ERROR
-----------------------
ORA-24344: success with compilation error


CREATE OR REPLACE FORCE VIEW TICK_HR_ORG_V ( NAME,
ORGANIZATION_ID ) AS SELECT o.NAME
,o.ORGANIZATION_ID
FROM HR.HR_ALL_ORGANIZATION_UNITS o
,HR.HR_ORGANIZATION_INFORMATION o2
WHERE o.ORGANIZATION_ID= o2.ORGANIZATION_ID
AND o2.ORG_INFORMATION_CONTEXT= ''CLASS''
AND o2.ORG_INFORMATION1= ''HR_ORG''

Error in am_deploy_Pkg.perform_target_sql -- ORA-24344: success with compilation
error
ORA-06512: at "SYS.DBMS_SQL", line 1053
***** ORA-24344: success with compilation error
ORA-06512: at "SYS.DBMS_SQL", line 1053



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install ccg 551
2. Configure a Peoplesoft 9.1 FIN target which has been licensed as HR 8.9.
3. Run Agent configuration. Note : (this steps completes without error)
4. Run CCG component configuration
5. View job log for 'create target schema objects' job

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
cannot use Metabuilder to create applications for Peoplesoft Financials

Cause

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