Question

Cleaning up Project Snapshot data in Apps 8?

T
Rank
Badge +2

Does anyone have experience with cleaning up Project Snapshot data in IFS Apps 8?

I reviewed IFS Cleanup routines but did not come across anything covering the project_snapshot_data_tab.

There is a Cleanup_Snapshot_Data.Cleanup_Snapshot_Data procedure but trying to figure out how it gets called in the Application instead of executing it manually.

Thanks in advance.

4 replies

Srikanth
Rank
Userlevel 6
Badge +18

Hi,

You can find the screen to Cleanup Snapshot History Data here in Apps 8:

 

However, we did not have any luck using this screen to delete actual records from project_snapshot_data_tab table and ended up writing our own custom API based on Cleanup_Snapshot_Data.Cleanup_Snapshot_Data.

Cheers, Srikanth
S
Rank
Userlevel 7
Badge +28

We’re on V9, so this might be a little different, we never tried to do this in V8, so sorry if this is not helpful.  It is called from the application here and used in this manner.

 

Procedure

Use the following procedure to perform a cleanup of snapshot history data for projects before a certain date:

  1. Open the Snapshot History Data - Cleanup Information window.
  2. Right-click anywhere in the window and then click Cleanup Snapshot History Data. The Delete Project Snapshot Data dialog box opens up.
  3. Enter a value for the Company ID.
  4. In the Project ID field, use the List button to select a project. You can also enter a wild card (%) to select all projects.
  5. Enter a date in the History Cut Off Date field. All records for selected projects before this date will be deleted from the snapshot history table. Entering a date will also disable the check boxes Closed/Completed/Cancelled.
  6. Click OK.
  7. Populate the Snapshot History Data - Cleanup Information window to see information about data deletions.

 

Use the following procedure to perform a cleanup of snapshot history data for projects in status Closed/Completed/Cancelled:

  1. Open the Snapshot History Data - Cleanup Information window.
  2. Right-click anywhere in the window and then click Cleanup Snapshot History Data. The Delete Project Snapshot Data dialog box opens up.
  3. Enter a value for the Company ID.
  4. In the Project ID field, enter a wild card (%) to select all projects.
  5. Leave the History Cut Off Date field empty. When no History Cut Off Date is entered, all history data according to the other parameters will be deleted and the check boxes Closed/Completed/Cancelled can be selected.
  6. Select type of project status in the check boxes Closed, Completed and/or Cancelled. You can select one or more.
  7. Click OK.
  8. Populate the Snapshot History Data - Cleanup Information window to see information about data deletions.

 

T
Rank
Badge +2

Does anyone have experience with cleaning up Project Snapshot data in IFS Apps 8?

I reviewed IFS Cleanup routines but did not come across anything covering the project_snapshot_data_tab.

There is a Cleanup_Snapshot_Data.Cleanup_Snapshot_Data procedure but trying to figure out how it gets called in the Application instead of executing it m10.0.0.0.1 anually.

Thanks in advance.

 

ISSUE GOT SOLVED!!

S
Rank
Userlevel 7
Badge +28

 

ISSUE GOT SOLVED!!

Please share so if anyone else comes across the thread and has the same question the answer can be found here.

 

Reply


Terms & ConditionsCookie settings