Open Concurrent Request Output File and Log file on button click in Custom Form in Oracle Apps R12

In order to open concurrent request output or log file in browser by clicking on button in Custom Oracle form we need to do the following steps to achieve this:

1] Open custom form in Form Builder and click on Attached Libraries. Then click on + add button.

2] Add FNDCONC.pll library file. This library file is available in the $AU_TOP/../resource folder.

3] Now open the FNDCONC.pll library file from Resource folder in Oracle Form Builder. Inside FNDCONC.pll library there are standard program units defined by oracle.

4] In order to open submitted request output file by clicking on Button we need to use procedure report defined in EDITOR_PKG.

Syntax - EDITOR_PKG.report (req_id number, save_output_flag varchar2);
            where, req_id is request id of submitted request
                         save_output_flag is to indicate whether output file to be saved or not.

5] To open submitted request log file by clicking on Button we need to use procedure request_log defined in EDITOR_PKG.

Syntax - EDITOR_PKG .request_log(req_id number);
            where, req_id is request id of submitted request.

6] Now call the above two procedures on button’s WHEN-BUTTON-PRESSED trigger to open concurrent request log/output file.

7] Save and compile the form on server, and check the request output and log file by clicking button on custom form.

Supplier Interface in Oracle Apps R12

There are three interface tables in oracle apps Supplier Interface.

1] AP_SUPPILERS_INT
2] AP_SUPPLIER_SITES_INT
3] AP_SUP_SITE_CONTACTS_INT

Supplier Interface Programs:

1]  Supplier Open Interface Import
2]  Supplier Sites Open Interface Import
3]  Supplier Site Contacts Open Interface Import

1] AP_SUPPLIERS_INT

This is the Open interface table for Supplier used to store Supplier header information. The columns mapped to corresponding AP_SUPPLIERS table.

‘Supplier Open Interface Import’ request is used to import Supplier Header Information into Oracle.

Mandatory Columns:
            VENDOR_INTERFACE_ID  è AP_SUPPLIERS_INT_S.NEXTVAL [ Unique Identifier]
            VENDOR_NAME                 è Supplier Name

Other Important Columns:
            VENDOR_TYPE_LOOKUP_CODE è Supplier Type [e.g. Company etc]
            SUMMARY_FLAG                           è Key Flexfield Summary Flag
            ENABLED_FLAG                            è Key Flexfield Enable flag
            NUM_1099                                         è Tax identification number
            INVOICE_CURRENCY_CODE     è Invoice Currency Identifier
            TERMS_ID                                        è Payment Terms Identifier
            SEGMENT1                                      è Vendor Number

2] AP_SUPPLIER_SITES_INT

This is the Open interface table to import supplier sites information. The columns mapped to corresponding AP_SUPPLIER_SITES_ALL table.

‘Supplier Sites Open Interface Import’ request is used to import Supplier site Information into Oracle.

Mandatory Columns:
            VENDOR_SITE_INTERFACE_ID   è AP_SUPPLIER_SITES_INT_S.NEXTVAL [Unique Identifier]
            VENDOR_SITE_CODE                  è Supplier Site Name
            VENDOR_ID                                                è Vendor ID created in AP_SUPPLIERS table after submission of Supplier Open Interface Import request.

Other Important Columns:
            ADDRESS_LINE1                è First Line of Address
            ADDRESS_LINE2                è Second Line of Address
            ADDRESS_LINE3                è Third line of Address
            CITY                                       è City Name
            STATE                                   è State Name
            COUNTRY                            è Country Name
            ZIP                                          è Postal Code
            PHONE                                  è Phone Number
            FAX                                        è Fax Number
            EMAIL_ADDRESS              è Supplier Site URL
            PURCHASING_SITE_FLAGè To indicate purchasing allow from this site [Y/N]
            RFQ_ONLY_SITE_FLAG   è To indicate quotations allow from this site [Y/N]
            PAY_SITE_FLAG                è To indicate payable invoice allow for this site [Y/N]
            INVOICE_CURRENCY_CODEè Invoice Currency Identifier
            TERMS_ID                            è Payment Terms ID

3] AP_SUP_SITE_CONTACT_INT:

This is Open interface table for supplier site contacts. The columns mapped to corresponding AP_SUPPLIER_CONTACTS table.

Supplier Site Contacts Open Interface Import’ request is used to import Supplier site Contacts Information into Oracle.

Mandatory Columns:
            VENDOR_CONTACT_INTERFACE_ID è AP_SUP_SITE_CONTACT_INT_S.NEXTVAL [Unique Identifier]
            VENDOR_SITE_CODE                           è Supplier Site Code

Other Important Columns:
            VENDOR_ID                                        è Vendor_ID created in AP_SUPPLIERS table after submission of Supplier Open Interface Import request.
            VENDOR_SITE_ID                 è Vendor_Site_ID created in AP_SUPPLIER_SITES_ALL table after submission of Supplier Sites Open Interface Import request.
            PREFIX                                     è Title e.g. [Mr, Mrs, Doctor etc]
            FIRST_NAME                           è Contact First Name
            MIDDLE_NAME                      è Contact Middle Name
            LAST_NAME                                        è Contact Last Name
            AREA_CODE                                        è Area Code of Contact phone number
            PHONE                                      è Contact phone number
            FAX_AREA_CODE                  è Area Code of Contact facsimile number
            FAX                                            è Contact facsimile number     

Validation during Supplier Import using interface:

1] AP_SUPPLIER_INT.VENDOR_NAME
            Validation for duplicate Supplier Name in AP_SUPPLIERS table.

2] AP_SUPPLIER_INT.VENDOR_TYPE_LOOKUP_CODE
            Validations for valid Supplier Type in PO_LOOKUP_CODES table for LOOK_TYPE as ‘VENDOR TYPE’.

3] AP_SUPPLIER_INT.SEGMENT1
            Validation for duplicate Supplier Number in AP_SUPPLIERS table.

4] AP_SUPPLIER_SITES_INT.VENDOR_SITE_CODE
            Validation for duplicate Supplier Site Name in AP_SUPPLIER_SITES table.

5] AP_SUPPLIER_SITES_INT.COUNTRY
            Validation for country code in FND_TERRITORIES_VL table.

AP_SUPPLIER_INT_REJECTIONS table contains suppliers, sites, contacts rejections information.