Delete Data Loader Batch on STG_ASSET Fails With 'java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name'
(Doc ID 2974833.1)
Last updated on OCTOBER 11, 2023
Applies to:
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service - Version 22.6.1 and laterInformation in this document applies to any platform.
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service (PBSM-CS)
Symptoms
You are trying to delete data from FSI_D_ASSET table using Delete Data Loader program. When you run a Batch with Delete Data Loader and stgTableName = STG_ASSET, the batch fails. The following errors are listed in the Batch Monitor > View Execution Logs:
2 01-SEP-23 04:19:24 PM Info In Delete Loader Batch - batchRunId: <BATCHNAME>_1999-12-31_1693585161710_1, dataFileSpecId: 3, asofdate: 1999-12-31, taskId: 10, srcTable: STG_ASSET, dataFileName:
3 01-SEP-23 04:19:26 PM Info Target Table Name : null
4 01-SEP-23 04:19:26 PM Info Scheduler Service: Target service responded: {"MESSAGE":"java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name\n","STATUS":"error"}
5 01-SEP-23 04:19:26 PM Info Data file Name :
As a result of this issue, you cannot refresh the data in the tables.
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 |