GL Rule Adjustment Failing with "ORA-00904: "CUSTOM_COLUMN": invalid identifier" Error
(Doc ID 2985731.1)
Last updated on DECEMBER 31, 2023
Applies to:
Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and laterInformation in this document applies to any platform.
Symptoms
In the new Reconciliation Framework, the Adjustment Template External API called in the PMF workflow is failing on a new rule using a new data model GL Field and Balance Field.
The GL Recon rule is successful and writes to the FCT tables. It fails when it tries to assign default values in the next Adjustment Subprocess.
OFSAA Domain Log:
mapTableNames:{#PRODUCT_PROCESSOR#=#PRODUCT_PROCESSOR#_GTT}
jds..............:glAuditSqls[ INSERT INTO FSI_ADJUSTMENT_EXEC_DETAILS (N_ADJUSTMENT_ID, V_BATCH_ID, FIC_MIS_DATE, TARGET_TABLE, PK1_COLUMN, PK2_COLUMN, PK3_COLUMN, PK4_COLUMN, PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, TARGET_COLUMN, PRE_VALUE, POST_VALUE) SELECT distinct 5035958, '1690555453679_19936698_20230131_1', TO_DATE('01/31/2023', 'MM/DD/YYYY'), '#PRODUCT_PROCESSOR#', 'v_account_number', 'v_gaap_code', 'v_prod_code', 'n_load_run_id', V_CONTRACT_CODE, v_gaap_code, V_CONTRACT_CURRENCY,V_LV_CODE,
.
.
.
.
'v_gaap_code', 'v_prod_code', 'n_load_run_id', V_CONTRACT_CODE, v_gaap_code, V_CONTRACT_CURRENCY,V_LV_CODE, 'V_HOLDING_TYPE','',V_HOLDING_TYPE from ##PPTABLE## where V_CONTRACT_CODE in (select gle.v_adj_exposure_id from FCT_GL_ADJUSTMENT_ENTRIES gle where upper(gle.V_PP_TABLE_NAME) ='#PRODUCT_PROCESSOR#' AND upper(gle.V_PP_BALANCE_COL_NAME) ='N_EOP_BAL' and V_EXECUTION_IDENTIFIER= '1690555453679_19936698_20230131_1' and v_gl_map_id ='705' AND N_VERSION_NUMBER=1 ){@@}#PRODUCT_PROCESSOR#]
java.sql.SQLSyntaxErrorException: ORA-00904: "#CUSTOM_COLUMN#": invalid identifier
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
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 |