My Oracle Support Banner

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 later
Information 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


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