ORA-01858 Error Running Ledger Stat Undo Run Executable
(Doc ID 2310688.1)
Last updated on JULY 29, 2024
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.4.2.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Symptoms
In PFT 6.1.1, when running the Ledger Load Undo by executing the script LEDGER_LOAD_UNDO.SH the following error is found in the agentstartup_xxx.log:
ERROR
Successfully Connected to Config schema.
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
OCI Function: [4] - oexec(), oexn()
SQL Function: [4] - SELECT
Oracle Error: ORA-01858: a non-numeric character was found where a numeric was expected
Driver Function: drv_oci::Execute()
SQL Statement: select FSI_DATA_IDENTITY.identity_code,FSI_DATA_IDENTITY.as_of_date,FSI_DATA_IDENTITY.user_name,FSI_DATA_IDENTITY.source_type,FSI_DATA_IDENTITY.table_name,FSI_DATA_IDENTITY.column_name,
FSI_DATA_IDENTITY.description,FSI_DATA_IDENTITY.number_of_entries,FSI_DATA_IDENTITY.start_time,FSI_DATA_IDENTITY.end_time,FSI_DATA_IDENTITY.batch_name,FSI_DATA_IDENTITY.status_flag from FSI_DATA_IDENTITY where IDENTITY_CODE = 10161 AND AS_OF_DATE = TO_DATE('MIS_DATE','MM/DD/YYYY') AND SOURCE_TYPE = 0 AND UPPER(TABLE_NAME) LIKE 'LEDGER_STAT'
Error(Oracle Financial Services Application error) (203055) Error LoadStart() : Execute() SQL statement.
INFORM : UNDO Execution Successful.
./LEDGER_LOAD_UNDO.SH[5]: ^M: not found
./LEDGER_LOAD_UNDO.SH[6]: ^M: not found
./LEDGER_LOAD_UNDO.SH[7]: ^M: not found
./LEDGER_LOAD_UNDO.SH[8]: ^M: not found
./LEDGER_LOAD_UNDO.SH[9]: ^M: not found
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
OCI Function: [4] - oexec(), oexn()
SQL Function: [4] - SELECT
Oracle Error: ORA-01858: a non-numeric character was found where a numeric was expected
Driver Function: drv_oci::Execute()
SQL Statement: select FSI_DATA_IDENTITY.identity_code,FSI_DATA_IDENTITY.as_of_date,FSI_DATA_IDENTITY.user_name,FSI_DATA_IDENTITY.source_type,FSI_DATA_IDENTITY.table_name,FSI_DATA_IDENTITY.column_name,
FSI_DATA_IDENTITY.description,FSI_DATA_IDENTITY.number_of_entries,FSI_DATA_IDENTITY.start_time,FSI_DATA_IDENTITY.end_time,FSI_DATA_IDENTITY.batch_name,FSI_DATA_IDENTITY.status_flag from FSI_DATA_IDENTITY where IDENTITY_CODE = 10161 AND AS_OF_DATE = TO_DATE('MIS_DATE','MM/DD/YYYY') AND SOURCE_TYPE = 0 AND UPPER(TABLE_NAME) LIKE 'LEDGER_STAT'
Error(Oracle Financial Services Application error) (203055) Error LoadStart() : Execute() SQL statement.
INFORM : UNDO Execution Successful.
./LEDGER_LOAD_UNDO.SH[5]: ^M: not found
./LEDGER_LOAD_UNDO.SH[6]: ^M: not found
./LEDGER_LOAD_UNDO.SH[7]: ^M: not found
./LEDGER_LOAD_UNDO.SH[8]: ^M: not found
./LEDGER_LOAD_UNDO.SH[9]: ^M: not found
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 |
Cause |
Solution |
References |