PX Tables Clean Up Procedure

To avoid operational problems for Oracle Primavera P6, Px (extended schema) table entries are not automatically deleted when you delete data from P6 tables.

You can use the following clean up procedure to clear the obsolete entries in the Px tables. This does not pose any data issues as users will be looking at the data through the Px views which are joins from the PMDB and the Px tables, therefore if the data is not in the PMDB it will not show in the Px views and consequently the enterprise report.

1. Connect as admuser to perform this activity
2. Clean_Px_Delete Procedure: Use the CLEAN_PX_DELETE stored procedure to purge obsolete entries in the Px tables
3. Truncating the PX Tables: If looking to truncate the data from the PX Tables, the following scripts can be used:
   • If using an Oracle RDBMS:
     • Browse to the following location on the Database media:
       • If r8.2, \P6_R82\p6suite\database\scripts\install\PM_08_02_00
     • Run the following script: orpm_trunc_px_tables.sql
4. After completing the above steps, publication services must be run for data to be accessible for PX reporting.

Cost Loading with Stored Period Actuals, Scenario 3

Cost loading a schedule using resources that are set up to auto calculate $ from Units. Each unit is equal to $ value. The resources are assigned to multiple Activities and we will store period performance

Cost Loading with Stored Period Actuals, Scenario 2

Cost loading a schedule using a single material resource that is set up to auto calculate $ from Units. Each unit is equal to 1 $. You may substitute multiple resources if desired and follow the same steps.

Cost Loading with Stored Period Actuals (Oracle Primavera P6): Scenario 1

Cost loading a schedule using a single material resource that is set up to auto calculate $ from Units. Each unit is equal to 1 $. You may substitute multiple resources if desired and follow the same steps.

• P6 User setup and security has moved from the client to web version starting in version 8
• The steps to setting up users remains the same but the screens look a little different
• Please see the screens below to add or modify P6 users in version 8  

Adding and Modifying P6 Users:

• Open P6 Web
• Click on the Administer dropdown and select User Access

• There are four sections under User Access:  Users, OBS, Global Security Profiles, and Project Security Profiles
• Click on the Users section to add/modify users
• There are two tabs:  Project Access and Module Access
  • Project Access determines which Projects the user can see
  • Module Access determines which P6 functionality the user has