ORA-01858 when applying ATG_PF.R12.C delta9 (Patch 3039994) (Doc ID 2731737.1)

Last updated on FEBRUARY 12, 2021

Applies to:

Symptoms

On : 12.2 version, Patch Application Issues

When attempting to apply <Patch 30399994> the following error occurs in adwork001.log

ERROR
================================================================================
Applying XDF file : .../fs2/EBSapps/appl/fnd/12.0.0/patch/115/xdf/fnd_sec_guidelines_status.xdf
================================================================================

Table Name is FND_SEC_GUIDELINES_STATUS
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 5
The table FND_SEC_GUIDELINES_STATUS is missing the column LAST_UPDATE_DATE

Executing statement

ALTER TABLE APPLSYS.FND_SEC_GUIDELINES_STATUS ADD ( LAST_UPDATE_DATE DATE DEFAULT '01-JAN-1951' NOT NULL )

Start time for statement above is Tue Nov 24 16:29:04 JST 2020
End time for statement above is Tue Nov 24 16:29:04 JST 2020
Error in executing statement ALTER TABLE APPLSYS.FND_SEC_GUIDELINES_STATUS ADD ( LAST_UPDATE_DATE DATE DEFAULT '01-JAN-1951' NOT NULL )
Error message is ORA-01858: a non-numeric character found where a digit was expected

Error code is 1858
==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Tue Nov 24 16:29:04 JST 2020]
Updating task with status 1

AD Worker error:
The utility FndXdfCmp returned error for the above task.

AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.

STEPS

adop phase=apply patches=30399994 workers=4

Changes

Followed the document below and ran adop

Applying the R12.ATG_PF.C.Delta.9 Release Update Pack (Doc ID 2661861.1)

-> Section 5: Apply the R12.ATG_PF.C.Delta.9 Release Update PacK

-> 5. Apply the R12.ATG_PF.C.Delta.9 Release Update Pack (Patch 30399994) and the online help patch for R12.ATG_PF.C.Delta.9 (Patch 30399978).

Cause

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