FAILED: File apaphuhf.sql While Running Patch 6678700

Posted by Vasudev Seeram on September 26, 2013 Leave a comment (0) Go to comments

Problem: While running patch 6678700, the following error occurs:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file apaphuhf.sql on worker  2.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checking the worker log file showed:

sqlplus -s APPS/***** @D:\oracle\MFGP\apps\apps_st\appl\ap\12.0.0\patch\115\sql\

apaphuhf.sql &un_ap &batchsize 2 2

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this 
operating system.

DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (AP.AP_PAYMENT_HISTORY_U2) violated
ORA-06512: at line 55

Solution: There is a duplicate value in the “REV_PMT_HIST_ID” column in the AP_PAYMENT_HISTORY_U2. Locate the duplicate value and set it to null.