GL Execution failed to load Auto Adjustments data in the PP table with "Adjustments not available for this Execution/Rule." error
(Doc ID 3045985.1)
Last updated on SEPTEMBER 14, 2024
Applies to:
Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and laterInformation in this document applies to any platform.
Symptoms
In GL Version 8.1.1.1.10 Auto Adjustment data are not populating to PP table.
The Adjustment Entries are not being loaded into product base table.
Verified the issue in the log file as noted below:
LOG FILE
-----------------------
Filename = HOST_server.log
See the following error
runGLAdjustments insert sql with global temp:Insert into #Product_processor#GTT (fic_mis_date,#PP_Column#,v_gaap_code,n_load_run_id,#PP_Column#,V_PROD_CODE,V_BRANCH_CODE,V_CUST_REF_CODE,#PP_Column#,#PP_Column#,#PP_Column#,V_CCY_CD,V_LV_CODE,V_GL_CODE,V_ORG_UNIT_CODE) select to_date('07/31/2024','MM/DD/YYYY'), gle.v_adj_exposure_id, gle.v_gaap_code,1, gle.N_EXPOSURE_AMOUNT,'9999999','-1','DUMMY_CUST_UNMAP','-1','-1','-1',gle.V_ISO_CURRENCY_CD,gle.V_ENTITY_CODE,gle.V_GL_CODE,V_ORG_UNIT_CODE FROM FCT_GL_ADJUSTMENT_ENTRIES gle where upper(gle.V_PP_TABLE_NAME) ='#Product_processor#' AND upper(gle.V_PP_BALANCE_COL_NAME) ='#PP_Column#' and gle.V_EXECUTION_IDENTIFIER= '1725337582729_75004242_20240731_1' and v_gl_map_id ='227' AND N_VERSION_NUMBER=21 LOG ERRORS INTO #Product_processor# ('INSERT') REJECT LIMIT UNLIMITED
runGLAdjustments inserted rows:0
setTableNames:[#Product_processor#]
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 575345071, '#BATCH_ID#', TO_DATE('07/31/2024', 'MM/DD/YYYY'), 'STG_XX_NII_DETAILS', 'v_account_number', 'v_gaap_code', 'v_prod_code', 'n_load_run_id', #PP_Column#, v_gaap_code, V_CCY_CD,V_LV_CODE, '#PP_Column#','',#PP_Column#L from ##PPTABLE## where V_XX_SRC_PROD_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)
='#PP_Column#' and V_EXECUTION_IDENTIFIER= '#BATCH_ID#' and v_gl_map_id ='227' AND N_VERSION_NUMBER=21 ){@@}STG_XX_NII_DETAILS]
Adjustments not available for this Execution/Rule.
Changes
No Changes
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 |