R12: FND: Error ORA-01858 While Creating Table FND_SEC_GUIDELINES_STATUS During Application Of Patch 30399999 (12.2.10)
(Doc ID 2768109.1)
Last updated on MAY 30, 2024
Applies to:
Oracle Applications DBA - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
The <Patch 30399999> FAILED: file fnd_sec_guidelines_status.xdf on worker 5. The worker log failed with the following error:
Invoking Utility FndXdfCmp ...
Class: oracle.apps.fnd.odf2.FndXdfCmp
Method: applyXDF
Arguments: &un_fnd &pw_fnd &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr table &fullpath_fnd_patch/115/xdf_fnd_sec_guidelines_status.xdf &fullpath_fnd_patch/115/xdf_xsl index_category=small parallel_index_threshold=20000
**** Reseting package states in the current session ****
TimeStamp : [Wed Jan 27 12:53:13 EST 2021]
==========================================================
XDF file application started. Current time is: Wed Jan 27 12:53:13 EST 2021
================================================================================
Applying XDF file : /progiciel/oracle/UNA5/fs1/EBSapps/appl/fnd/12.0.0/patch/115/xdf/fnd_sec_guidelines_status.xdf
================================================================================
Table Name is FND_SEC_GUIDELINES_STATUS
Table does not exist in the target database
Executing create Statement
Create Statement is
CREATE TABLE "APPLSYS"."FND_SEC_GUIDELINES_STATUS"
( "CODE" VARCHAR2(20) NOT NULL ENABLE,
"STATUS" VARCHAR2(2),
"DETAILS" VARCHAR2(3000),
"LAST_UPDATED_BY" NUMBER(15,0),
"LAST_UPDATE_DATE" DATE DEFAULT '01-JAN-1951' NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
STORAGE(INITIAL 4096 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_DATA"
Start time for statement above is Wed Jan 27 12:53:13 EST 2021
Exception occured ORA-01858: a non-numeric character was found where a numeric was expected
java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected
Class: oracle.apps.fnd.odf2.FndXdfCmp
Method: applyXDF
Arguments: &un_fnd &pw_fnd &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr table &fullpath_fnd_patch/115/xdf_fnd_sec_guidelines_status.xdf &fullpath_fnd_patch/115/xdf_xsl index_category=small parallel_index_threshold=20000
**** Reseting package states in the current session ****
TimeStamp : [Wed Jan 27 12:53:13 EST 2021]
==========================================================
XDF file application started. Current time is: Wed Jan 27 12:53:13 EST 2021
================================================================================
Applying XDF file : /progiciel/oracle/UNA5/fs1/EBSapps/appl/fnd/12.0.0/patch/115/xdf/fnd_sec_guidelines_status.xdf
================================================================================
Table Name is FND_SEC_GUIDELINES_STATUS
Table does not exist in the target database
Executing create Statement
Create Statement is
CREATE TABLE "APPLSYS"."FND_SEC_GUIDELINES_STATUS"
( "CODE" VARCHAR2(20) NOT NULL ENABLE,
"STATUS" VARCHAR2(2),
"DETAILS" VARCHAR2(3000),
"LAST_UPDATED_BY" NUMBER(15,0),
"LAST_UPDATE_DATE" DATE DEFAULT '01-JAN-1951' NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
STORAGE(INITIAL 4096 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_DATA"
Start time for statement above is Wed Jan 27 12:53:13 EST 2021
Exception occured ORA-01858: a non-numeric character was found where a numeric was expected
java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected
The table creation SQL shown in the Error is generated during the patch application, based on the content of file xdf_fnd_sec_guidelines_status.xdf
If the table FND_SEC_GUIDELINES_STATUS creation SQL is executed directly in SQL*Plus, NO errors are generated.
Customer has a multi-language installation, with standard AMERICAN English (US) and CANADIAN FRENCH (FRC) installed.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |