My Oracle Support Banner

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 later
Information in this document applies to any platform.


On :  5.5.1 version, Integra Apps

When attempting to run custom object designed in metabuilder
the following error occurs(in Debug mode).

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

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


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

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