If you are attempting to load forms or reports into PITSS.CON, and you are unable to load any form or report into PITSS.CON (including ones already been loaded into the PITSS.CON repository) due to the following errors:

Forms:

“Insert code for [TRIGGER or PROGRAM UNIT] – ORA-29875: failed in the execution of the ODCIINDEXINSERT routineORA-”

image

Reports:

No errors in the “Error List” window, but the error “ORA-06502: PL/SQL: numeric or value error” appears in the bottom status bar.

image

 

The indexes for the PITSS.CON user you are using will need to be re-indexed. The MIG user can do this within PITSS.CON:

NOTE: Please disconnect (log out of) all logins of the PITSS.CON user you are using whether it be in PITSS.CON or in any database program such as SQL*Plus, SQL Developer, or Toad before completing the steps below.

1. Log into PITSS.CON with the MIG user.

2. Go to “User Administration”.

image

3. Expand the group the PITSS.CON user belongs to and select your PITSS.CON user. After that, click the “Add User to Task” button.

image

4. Select the check boxes “Compile Invalid Objects” and “Rebuild Indexes”. After both of them are selected, click “Run Task”.

image

5. Please wait until the task is completed. When finished, you will see a status in the status bar at the bottom saying, “Done.”

image

6. Log out of the MIG user and back into your PITSS.CON user.

 

After completing the steps above, you should be able to resume loading your Forms and Reports modules into PITSS.CON.