Error When Running Snapshot On Custom PeopleSoft Metadata In CCG : ORA-06503 and ORA-00942
(Doc ID 1586061.1)
Last updated on OCTOBER 10, 2023
Applies to:
Oracle Configuration Controls Governor - Version 5.5.1 and laterInformation in this document applies to any platform.
Symptoms
On : 5.5.1 version, Integra Apps
When attempting to run custom object designed in metabuilder
the following error occurs(in Debug mode).
ERROR
-----------------------
Building SELECT statement
Processing table PSROLEDEFN (3108)
get_column Error ORA-00942: table or view does not exist
ORA-02063: preceding line from PSHCM91_ERP_LINK
Error: Populate Snapshot Selects routine failed. ORA-06503: PL/SQL: Function returned without value
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create custom objects for PeopleSoft HCM 9.1 environment
2. Run snapshot for objects in #1 against instance PSHCM91
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 |
| References |