Adding GL Accounting Flexfield to Report

RDF Steps

1) Define Below Parameters in Report

P_MIN_FLEX Char(200)

P_MAX_FLEX Char(200)

STRUCT_NUM Number(15)

P_CONC_REQUEST_ID Number(15)

P_LEDGER_ID Number(15)

P_USER_ID Number(15)

2) Add below code in Before Report Trigger

FND_PROFILE.GET('CONC_REQUEST_ID',:P_CONC_REQUEST_ID);

FND_PROFILE.GET('GL_SET_OF_BKS_ID',:P_LEDGER_ID);

FND_PROFILE.GET('USER_ID',:P_USER_ID);

srw.reference(:STRUCT_NUM);

srw.user_exit('FND FLEXSQL CODE="GL#" NUM=":STRUCT_NUM" APPL_SHORT_NAME="SQLGL"

OUTPUT=":WHERE_FLEX" TABLEALIAS="CC"

MODE="WHERE" DISPLAY="ALL"

OPERATOR="BETWEEN"

OPERAND1=":P_MIN_FLEX"

OPERAND2=":P_MAX_FLEX"');

:WHERE_FLEX := ' AND ' :WHERE_FLEX;

3) Add below code in Report Query to the last line

&WHERE_FLEX

Application Setup Steps

- Add below parameters alongwith value set in Concurrent program Parameters Window

1) Chart of Accounts ID

Value Set- GL_SRS_COA_UNVALIDATED

Default Type- SQL Statement

Default Value- SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = :$PROFILES$.GL_ACCESS_SET_ID

Token- STRUCT_NUM

2) Account Flexfield From

Value Set- GL_SRS_LEDGER_FLEXFIELD

Range- Pair

Token- P_MIN_FLEX

3) Account Flexfield To

Value Set- GL_SRS_LEDGER_FLEXFIELD

Range- Pair

Token- P_MAX_FLEX

/