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.

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.

Location

Selection Ranges

Use this group box to select the fiscal year to examine.

Fiscal Year

Enter, or click the drop-down list to select, a valid fiscal year for which to run the toolkit. The validation is performed only for the fiscal year selected.

Description

This field displays the Fiscal Year description.

Error Details

Account, Organization, Pool

This table window displays the invalid account/organization/pool combinations.

Execute

Click to start the toolkit.