FAH Import Transactions Failing into Accounting Hub with Unexpected Error "Failed at record 0 with error ORA-01747: invalid user.table.column, table.column, or column specification"
(Doc ID 2924848.1)
Last updated on FEBRUARY 08, 2023
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.22.10.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.22.10.0 version, Integration
Import Transactions failing into Accounting Hub with unexpected error
When trying to import the transaction in one of the custom FAH subledger the transaction is failing during import with unexpected error.
On further investigation found that the Source_Column_Name value is showing as null for AAA_TRANSACTION_DATE field in the XLA_SOURCES_B for this application.
Though this field is correctly defined from the UI with data type as Date.
ERROR
-----------------------
Failed at record 0 with error ORA-01747: invalid user.table.column, table.column, or column specification
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import FAH Transactions
2. check the error in the log
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import custom sla transactions
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 |