AFCS - Missing/Others Entries Not Populated into dimension entity
(Doc ID 2952679.1)
Last updated on JUNE 06, 2023
Applies to:
Oracle Financial Services Accounting Foundation Cloud Service - Version 22.2.1 and laterInformation in this document applies to any platform.
Symptoms
OTH and MSG records are not getting loaded as part of SCD execution
UI monitor log is showing the below error message part of SCD execution:
Error executing query: INSERT INTO DIM_GL_ACCOUNT (
D_AS_OF_DATE,D_RECORD_END_DATE,D_RECORD_START_DATE,F_LATEST_RECORD_INDICATOR,N
_GL_ACCOUNT_ID,N_GL_ACCOUNT_SKEY,V_CUST00050,V_CUST00051,V_CUST00052,V_GL_ACCO
UNT_CODE) values (to_date('20221130', 'YYYYMMDD'),to_date('99991231',
'YYYYMMDD'),to_date('20221130',
'YYYYMMDD'),'Y',-1,-1,'OTH','OTH','OTH','OTH')
Changes
NA
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 |