Defining Source Adapter Detail

  To add a source column:

1. On the Setup tab, under Register, select Source Adapter.

2. In Source Adapter, select the Source Column tab.

3. From the Source Column task bar, select Add.

   Entry fields are displayed for the Column Name, Table Name, and Display Name columns.

4. In Column Name, enter the source column name.

   For example, enter SEGMENT1. The source column name must have a corresponding column name in the ODI model.

5. In Table Name, enter the table name.

   For example, enter LOGICAL_BALANCES. The table name must have a corresponding table name in the ODI model.

6. In Display Name, enter the display name used for the import format.

  To add a source column:

1. On the Setup tab, under Register, select Source Adapter.

2. In Source Adapter, Select the Parameters tab.

3. From the Parameters task bar, select Add.

   Entry fields are displayed for the Parameter Name, Parameter Data Type, and Parameter Prompt columns.

4. In Parameter Name, enter the parameter name.

   For example, enter p_actual_flag. This is the name of the parameter in the ODI project.

5. In Parameter Data Type, select the data type of the parameter:

   • Char

   • Number

   • Date

6. In Parameter Prompt, enter the parameter prompt.

   For example, enter Balance Type in this row.

   Note:

   When a new parameter is added and you are in a multilanguage environment, then set the browser locale to the appropriate language and edit the prompts as needed in that language.

  To delete a parameter:

1. On the Setup tab, under Register, select Source Adapter.

2. In Source Adapter, select the Parameters tab.

3. On the Parameters task bar, select the parameter, and then click Delete.

4. Click OK.

  To add a drill through URL:

1. On the Setup tab, under Register, select Source Adapter.

2. In Source Adapter, select the Drill URL tab.

3. On the Drill URL task bar, select Add.

   Entry fields are displayed for the Drill URL Name, Drill URL, Request Method, and Drill URL Prompt columns.

4. In Drill URL Name, enter a user defined name for the drill through URL.

5. In Drill URL, enter the URL used for the drill through.

   Enter the URL without the server and port information. The URL must contain the parameter name and column name from the TDATASEG table enclosed in the symbol $.

   For example, enter: LEDGER_ID=$ATTR1$&GL_PERIOD=$ATTR2$.

   In the above example the value of ATTR1 is passed as a value for the LEDGER_ID parameter, and ATTR2 is passed as the value for the GL_PERIOD parameter. Parameters are separated by the “&” character.

   To specify the request-response between a client and server for the drill URL format, enter either:

   • GET—Form data is encoded into the URL. For example, specify: GET@http://www.oracle.com/.. If no method is specified, then GET is the assumed request-response.

   • POST—Form data is displayed in the message body. For example, specify: POST@http://www.oracle.com/.

   Note:

   A JavaScript specification can also be used for the drill-through. See Adding Drill Through using JavaScript.

6. In the Drill URL Prompt, enter a user-defined prompt for the drill-through prompt.

   For example, enter Default.

  To add a drill through using JavaScript:

1. On the Setup tab, under Register, select Source System.

   See Setting Up Source Systems.

2. Select the source system file for the JavaScript based drill through.

3. In the detail section, from Drill Through URL, enter #javascript.

4. Click Save.

5. On the Setup tab, under Scripts, select Script Editor.

6. On the Script Editor, click New.

7. From the Create Script Options window, in Script Type, select Drill.

   Note:

   The Technology drop-down is JavaScript because drill through scripts can only be created based on JavaScript.

8. In File Name, enter a name for the script.

9. Click OK.

10. In Target Application, select the target application for this drill through script.

11. Write the code for the custom in the Script Editor.

    Ensure the name of the JavaScript function is same as the file name.

    For example,

    function main($ATTR1$,$ATTR2$){

    var ledger_id = $ATTR2$;
    var currency = $ATTR1$;

    var resp_id = 300;
     if(ledger_id==1)
      resp_id = 100
    else if(ledger_id ==2)
      resp_id = 200

    alert('Currency:' + $ATTR1$);
    alert('ledger_id:' + ledger_id);

    var url = 'http://machinename.us.oracle.com:6362/OA_HTML/RF.jsp?function_id=1045073&CALLING_PAGE=FDM_DRILLDOWN&resp_appl_id=&resp_id=&SOB_ID=1&LED_ID='+ledger-id+'&fdm_per=Jan-03&fdmccid=13098&fdm_currency+'+currency+'fdm_balance_type=A

    alert('url:' + url);

    window.open(url);

    }

    

12. Click Save.

13. On the Setup tab, under Register, select Source Adapter.

    See Working with Source Adapters.

14. In Source Adapter, select the Drill URL tab.

15. On the Drill URL task bar, select Add.

    Entry fields are displayed for the Drill URL Name, Drill URL, Request Method, and Drill URL Prompt columns.

    

16. In Drill URL Name, enter a user defined name for the drill through URL.

17. In the Drill URL, enter the Function name of the drill through.

    The Function name should be same as the file name.

    For example, enter: main($ATTR1$,$ATTR2$).

18. In Drill URL Prompt, enter a user-defined prompt for the drill-through prompt.

19. Click Save.

    When you drill down from the workbench, a new window is launched with the specified URL.

  To delete a drill through URL:

1. On the Setup tab, under Register, select Source Adapter.

2. In Source Adapter, select the Drill URL tab.

3. From the Drill URL summary area, select the drill-through URL, and then click Delete.

4. In Delete Source Adapter Drill URL, click OK.