Archive And Purge OIC Periods Concurrent Program Error"The current Profile value for -OIC: Purge Strategy for Subledger Tables- is "Ghost into Last Purge Period Looking Back" conflicts with the ( ' previous run(s) profile value " " (Doc ID 3081348.1)

Last updated on APRIL 14, 2025

Applies to:

Symptoms

While running Archive and Purge OIC Periods with profile option OIC: Purge Strategy for Subledger Tables- is "Ghost into Last Purge Period Looking Back" ,getting the following error message


ERROR
-----------------------
Cause: FDPSTP failed due to ORA-20002: : : User-Defined Exception
ORA-06512: at "APPS.CN_PURGE_TABLES_PUB", line 254
ORA-06512: at line 1
ERROR : The current Profile value for -OIC: Purge Strategy for Subledger Tables- is "Ghost into Last Purge Period Looking Back" conflicts with the


The issue can be reproduced at will with the following steps:
1. Navigate to Incentive Compensation Administrator
2. Run the Concurrent Program  "Archive and Purge OIC Periods" with profile option OIC: Purge Strategy for Subledger Tables- is "Ghost into Last Purge Period Looking Back"
3. Check the log for the  same 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.