Scribd Logo
Upload

Welcome to Scribd!

  • 185 views

    Add GL Flexfield To Custom Request

    Uploaded by

    Rabindra P.Singh
    This document provides steps to add a GL accounting flexfield range to a customized request in Oracle R12. The steps include: 1) Adding user parameters to the RDF file including for flexfield range; 2) Modifying the main query to include a WHERE clause for the flexfield range; 3) Adding code to the before/after report triggers to populate the flexfield range; and 4) Configuring the concurrent request to prompt for the flexfield range. When complete, the report will filter data based on the flexfield range entered.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Add GL Flexfield To Custom Request

    Uploaded by

    Rabindra P.Singh
    185 views2 pages
    This document provides steps to add a GL accounting flexfield range to a customized request in Oracle R12. The steps include: 1) Adding user parameters to the RDF file including for flexfield range; 2) Modifying the main query to include a WHERE clause for the flexfield range; 3) Adding code to the before/after report triggers to populate the flexfield range; and 4) Configuring the concurrent request to prompt for the flexfield range. When complete, the report will filter data based on the flexfield range entered.

    Original Description:

    Add (GL Accounting Flexfield Range) to a customised request on R12

    Original Title

    Add GL Flexfield to Custom Request

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides steps to add a GL accounting flexfield range to a customized request in Oracle R12. The steps include: 1) Adding user parameters to the RDF file including for flexfield range; 2) Modifying the main query to include a WHERE clause for the flexfield range; 3) Adding code to the before/after report triggers to populate the flexfield range; and 4) Configuring the concurrent request to prompt for the flexfield range. When complete, the report will filter data based on the flexfield range entered.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    185 views2 pages

    Add GL Flexfield To Custom Request

    Uploaded by

    Rabindra P.Singh
    This document provides steps to add a GL accounting flexfield range to a customized request in Oracle R12. The steps include: 1) Adding user parameters to the RDF file including for flexfield range; 2) Modifying the main query to include a WHERE clause for the flexfield range; 3) Adding code to the before/after report triggers to populate the flexfield range; and 4) Configuring the concurrent request to prompt for the flexfield range. When complete, the report will filter data based on the flexfield range entered.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Technical Trick: How to add (GL Accounting Flexfield Range) to a

    customized request on R12 step by step


    Hello Everybody,
    In this article, we will learn how to add (GL Accounting Flexfield Range) to a customized request on R12
    step by step, to filter the data according to the chossen range of the segments.
    See our target in the below snapshot.

    Steps:
    1.

    Open the RDF file with the Report builder.

    2.

    Add the following user parameters in the RDF file:

    P_CONC_REQUEST_ID and make its type (Number 15)

    P_LEDGER_ID and make its type (Number 15)

    P_MAX_FLEX and make its type (Character 200)

    P_MIN_FLEX and make its type (Character 200)

    P_USER_ID and make its type (Number 15)

    STRUCT_NUM and make its type (Number 15)

    WHERE_FLEX and make its type (Character 200)

    3.

    Modify your main query of the RDF file like the following:

    Make sure that the GL_CODE_COMBINATIONS table is in your query and has an alias

    After the last condition in your query add this &WHERE_FLEX

    4.

    Add the following code to the (BEFORE REPORT) Trigger in the RDF file:

    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 SRWINIT');

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


    APPL_SHORT_NAME="SQLGL"
    OUTPUT=":WHERE_FLEX" TABLEALIAS="glc"

    --"glc" in the above line is the GL_CODE_COMBINATIONS alias in the main query
    MODE="WHERE" DISPLAY="ALL"
    OPERATOR="BETWEEN"

    OPERAND1=":P_MIN_FLEX"
    OPERAND2=":P_MAX_FLEX"');

    :WHERE_FLEX := ' AND ' || :WHERE_FLEX;

    5.

    Add the following code to the (AFTER REPORT) Trigger in the RDF file:

    SRW.USER_EXIT('FND SRWEXIT');

    6.

    Save the RDF file and FTP it to the server.

    7.
    Go to the applications and login with any user has a System Administrator
    responsibility.
    8.

    Query on your concurrent request and add to it the following three parameters:
    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

    Required: No

    Displayed: No

    Prompt: Chart of Accounts ID

    Token: STRUCT_NUM

    2.

    Account Flexfield From

    Value Set: GL_SRS_LEDGER_FLEXFIELD

    Required: No

    Displayed: Yes

    Prompt: Account Flexfield From

    Token: P_MIN_FLEX

    3.

    Account Flexfield To

    Value Set: GL_SRS_LEDGER_FLEXFIELD

    Required: No

    Displayed: Yes

    Prompt: Account Flexfield From

    Token: P_MAX_FLEX

    Now save your work and run the report, you will find two parameters have been added to your conccurent
    program as a LOV range of the GL Accounting Flexfield.
    And of course it will filter your data according to your range entered.

    You might also like