GL Rule Adjustment Failing with "ORA-00904: "CUSTOM_COLUMN": invalid identifier" Error (Doc ID 2985731.1)

Last updated on DECEMBER 31, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.