View Invalid Pools in Project Ledger

Use this toolkit to compare your project burden summary table, your cost pool setup table, ALLOC_APPLIC, for a given fiscal year.

If you have made modifications to your cost pool bases, you must execute the Build Rate Application Table screen to update ALLOC_APPLIC. ALLOC_APPLIC is the table that directs how the Compute Burden Costs screen allocates. When you run the Compute Burden Costs screen, PROJ_BURD_SUM is updated with the burden for the appropriate direct cost. If you have deleted any account/organization/pool combinations from your cost pools (and ALLOC_APPLIC) that already exist in PROJ_BURD_SUM, year-to-date burden still exists for projects using those combinations. Invalid combinations are displayed in the table window and written to the Z_PJPTOOL_ERRORS table, as well. You can correct these invalid combinations with the Repair Invalid Pools in Project Ledger toolkit.

This toolkit compares the ALLOC_APPLIC table to the PROJ_BURD_SUM table, looking for orphaned rows. If it finds any, those acct/orgs are displayed and inserted into a temp table. That temp table is used to fix those rows.

Note: Do not run this toolkit at the same time as the Compute Burden Costs or Compute Revenue processes. Depending on the size of your database, this toolkit could take a significant amount of time to complete.