My Oracle Support Banner

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 APRIL 13, 2021

Applies to:

Oracle Applications DBA - Version 12.2.10 and later
Information 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

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


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