Uploading ILDT Files to Integration Repository

After validation is completed and iLDT files are generated, the integration administrator can upload the generated iLDT files to the Integration Repository using the FNDLOAD command. The custom interfaces can be displayed in the repository and exposed to all users.

Manual Steps for Uploading the iLDT File

Perform the following steps to upload the iLDT file to the Integration Repository:

  1. Log in to the Oracle E-Business Suite Release 12 instance.

  2. Set the Oracle E-Business Suite application environment.

    From the Oracle E-Business Suite APPS_BASE, establish the run file system APPL_TOP environment by running the EBSapps.env script.

  3. Use the following command to upload the iLDT file:

    $FND_TOP/bin/FNDLOAD <APPS username> 0 Y UPLOAD $fnd/patch/115/import/wfirep.lct <ildt file>

    ORACLE Password:

    Examples of uploading iLDT files for custom PL/SQL APIs and custom composites of BPEL type:

  4. Pay attention to any error messages in the generated log file. Error messages mostly would be due to incorrect database connect string or incorrect lct file.

    Look for string "Concurrent request completed successfully" to determine whether the iLDT file was correctly uploaded.

  5. For Business Service Object only - submit a concurrent program called FNDIRLOAD which loads all the iLDT files related to Business Service Object interfaces present on various product tops of the instances.

    Note: Ensure that FNDIRLOAD concurrent program is associated with the user who will execute the concurrent request.

    For example, if it will be run by a user with the system administrator responsibility, FNDIRLOAD should be listed as part of the requests for System Administrator Reports group in the Request Groups window.

    If you cannot find FNDIRLOAD from the name list, use the following steps to register it with the system administrator responsibility.

    1. Log in to Oracle E-Business Suite with the System Administrator responsibility. Select System Administrator > Security > Responsibility > Define from the navigation menu.

    2. In the Responsibilities window, locate 'System Administrator' as the value in the Responsibility Name field through a search.

      Ensure 'System Administrator Reports' is selected as the Request Group Name.

      Save the change and close the window.

    3. Select System Administrator > Security > Responsibility > Requests from the navigation menu.

      In the Request Group window, locate 'System Administrator Reports' as the value in the Group field through a search.

      In the Requests region, add FNDIRLOAD program to the list and save your entry.

    In the Parameters window, enter an appropriate value for APPLTOP_ID.

    Note: To obtain the APPLTOP_ID parameter value, your system administrator can execute the following query:

    SELECT max(appl_TOP_id)
FROM ad_appl_tops
WHERE active_flag = 'Y'

    Click Submit to execute the request.

    Examine the request log file to see if any issues occur while executing the concurrent request.

Once these annotated source files have been successfully uploaded, they will appear in the Integration Repository based on the interface types they belong to. The administrator can perform administrative tasks on these custom integration interfaces.

If the upload is for an updated version of iLDT file, after the upload the administrator needs to perform the following additional tasks to ensure successful invocation of the updated API included in the file: