Basic value set definition

1 set of books: P_LEDGER_ID
Value set GL_SRS_SET_OF_BOOKS
Configuration file,
Default Value: GL_SET_OF_BKS_NAME

2 OU: ORG_ID
Configuration File
Default Value: ORG_ID

3. Inventory organization P_MFG_ID
Configuration File
Default Value: ORGANIZATION_ID

4 accounting period (default: current accounting period): p_period_name_f
Value set: GL_SRS_ALL_PERIODS
Default type: SQL statement
Default Value: select glp. period_name from gl_sets_of_books gls, gl_periods glp
Where gls. period_set_name = glp. period_set_name
And gls. set_of_books_id =: $ FLEX $. P_LEDGER_ID
And sysdate between glp. start_date and glp. end_date

5. Accounting subjects
Step 1:
Set COE parameters:
COA
NUMBER_15
SQL statement
Default Value: select gls. chart_of_accounts_id from gl_sets_of_books gls
Where gls. set_of_books_id =: $ FLEX $. P_LEDGER_ID

Step 2:
P_account_f
GL_SRS_REPORT_FLEXFIELD
Range: pair

Practices in reports:
1. Define the parameter P_COA.
2 Creation percentage: P_ACCOUNT_WHERE
3. Reference percentage in the report: & p_account_where
4. Create a formula column: CF_PERIOD_NAME_F, CF_PERIOD_NAME_T (accounting period from-accounting period)
5. Write the code in the report trigger BEFOREREPORTE:
Begin
SRW. USER_EXIT ('fnd SRWINIT ');

If: P_ACCOUNT_F is not null and: P_ACCOUNT_T is not null then
Srw. reference (: P_COA );
Srw. user_exit ('fnd flexsql code = "GL #"
NUM = ": P_COA"
APPL_SHORT_NAME = "SQLGL"
OUTPUT = ": P_ACCOUNT_WHERE"
MODE = "WHERE"
DISPLAY = "ALL"
OPERATOR = ""
OPERAND1 =: P_ACCOUNT_T
OPERAND2 =: P_ACCOUNT_F
TABLEALIAS = "GCC "');

If: P_ACCOUNT_WHERE is not null then
: P_ACCOUNT_WHERE: = 'and' |: P_ACCOUNT_WHERE;
End if;
End if;

Return (TRUE );
End;