T2T Failed To Populate FCT_FTP_ACCOUNT_SUMMARY Table Due To "ORA-00936: missing expression" Error
(Doc ID 2946748.1)
Last updated on MAY 07, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and laterInformation in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
T2T - Table to Table Transformation
Symptoms
On FTP 8.0.7.x version, data is not populating in FCT_FTP_ACCOUNT_SUMMARY table.
Batch is failing with "ORA-00936: missing expression" error in T2T log, at step to insert into FCT_FTP_ACCOUNT_SUMMARY.
ERROR
[04-04-23 09:08:02 GMT AM][INFO][BACKEND][OFSAA][T2TCPP] executing insert query
FAILED: ORA ERROR : ORA-00936: missing expression
[04-04-23 09:08:02 GMT AM][SEVERE][BACKEND][OFSAA][T2TCPP] ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. ERROR Message: ORA-00936: missing expression
[04-04-23 09:08:02 GMT AM][INFO][BACKEND][OFSAA][T2TCPP] ClsUBatchLoader::Bulk, Error Messaage : ORA-00936: missing expression
[04-04-23 09:08:02 GMT AM][INFO][BACKEND][OFSAA][T2TCPP] ClsUTableToTableLoad::directLoad, BULK MODE, Back from loader : Rows Loaded : 0
[04-04-23 09:08:02 GMT AM][INFO][BACKEND][OFSAA][T2TCPP] ClsUTableToTableLoad::directLoad, BULK MODE, Back from loader : Rows Rejected : 0
[04-04-23 09:08:02 GMT AM][SEVERE][BACKEND][OFSAA][T2TCPP] ClsUTableToTableLoad::directLoad, BULK MODE, Loading Failed, Number of erroneous records exceeded the reject limit
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 |