Apurva Tripathi | PeopleSoft Tutorial - Part 29
Apurva Tripathi

Author Archives: Apurva Tripathi

E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS

While doing PeopleTools upgrade via Change Assistant, you may encounter this error: E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS The error message is indicative enough to suggest that there are invalid dba_objects. To make sure, run the below command: SQL> select owner, object_name, object_type, status from dba_objects where […]

Continue reading
2

List of PeopleSoft Integration Broker Tables

Here is the list of PeopleSoft Integration Broker tables according to their categories. Please note that this list will not match completely your PeopleTools version because Oracle tends to add or remove tables with different PeopleTools release. However, the important Integration Broker tables will continue to find favor and will remain in the list. The […]

Continue reading
1 27 28 29 30 31 46
>