Apurva Tripathi
Author Archives: Apurva Tripathi
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 readingCannot activate more than one master domain (158,2836)
In PeopleTools release 8.51 and higher, by default, only one domain can be active in the Integration Broker system as no more than one active PUBSUB domain is recommended. Those already in on PeopleTools 8.51 or higher would have seen it and those who’re moving to the latest version of PeopleTools are likely to see […]
Continue readingREL851unDBTSFIX Script Failed – PeopleTools Upgrade Bug
When upgrading database from PeopleTools 8.50 to PeopleTools 8.53.06, you’re likely to see a situation where the step “Updating PeopleTools System Tables” fails. The failure is while running REL851unDBFIX.sql. Subsequently the error is encountered for REL852unDBFIX.sql and REL853unDBFIX.sql as well. The REL851UNDBTSFIX.log will show that all the SQL statements were executed and no errors were […]
Continue reading
SQL Query to find Records and Fields used in a PeopleSoft Page
Many a times you come across a situation when you need to find records behind a page or records associated with a field and so on. Most of such situations arise from the need to debug an issue and find a resolution for the same. In this article you will find a few helpful SQL […]
Continue reading