🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

Sunday, November 15, 2015

Web ADI - Oracle Custom Web ADI Setups and Process for AP Invoice Interface























Introduction:
There are basically two ways to enter data into Oracle: by typing it into a user interface (Java Form or Web Page) or by taking a file and programmatically interfacing the data.  Web ADI falls into the second category in that it takes an Excel file and programmatically loads the data into Oracle.  If you find it easier to enter data into Excel than Oracle forms, you should look into using Web ADI.

Downloading a Web ADI
The first step in downloading a template is to locate the responsibility and menu that is linked to that template.  Some templates can be downloaded from the Desktop Integration menu and others must be downloaded from a specific responsibility.  For security, some templates are linked to specific responsibilities.  For example, we can download the GL Journals template from the Desktop Integration responsibility but we can’t download the Project Transaction Import template from the same responsibility.
To download a template you will use the following components: integrator, viewer, layout, and content. Based on how the menu is setup, some of these components may default for you.

Integrator
The integrator defines what data you will be uploading to Oracle.  Each integrator serves a specific purpose and cannot be used to enter other data.

Viewer
The viewer is the Microsoft program you will use to enter data into the template

Layout
The layout is how the data columns are organized on the template.  You have two main sections to a template: a header and lines.  The header information applies to all the lines when the data is uploaded to Oracle.

Content
The content is a text file that you can import into your template.  You can use this feature if you have an external system that outputs text file and you want to import that into the template.

Pre-Requisites

Ø  Enable the Profile Option

Ø  Enable the Macros options for Excel sheet

Ø  Required Database Objects Creation

Custom Web ADI Setups

Ø  Create Integrator

Ø  Create Interface

Ø  Create Content

Ø  Create Uploader

Ø  Create Importer

Ø  Create Layout

Ø  Define Mapping

Ø  Create Document

Ø  Change the Labels of fields

Ø  Assign LOV and hints to the columns

Ø  Add default value Columns

Ø  Defining the Form Function for Integrator

Ø  Assign Function to Custom Menu

Process the AP Invoice Custom Web ADI

Ø  Upload the data with Web ADI

Ø  Modify the Errored records and re upload

Ø  Verify the Created records from application and Backend



Pre-requisites for working on Development or use of WEBADIs

1.Check the value for profile option named BNE Allow No Security Rule and set the value to Yes


 












2. Enable the Macros options for your excel sheet
















Select Excel option to set the properties

 Click on Trust Centre -> Trust center Settings
















 Select Macro Settings -> Enable all macros and check the option Trust access to the VBA Project object model












Apply and save your settings

Assign responsibility Oracle WEBADI or Desktop Integrator to do the development of new WEBADIs


Database Objects Creation

Compile the below Custom table and Package in APPS schema

CREATE TABLE XXAA_APINV_IFACE_TBL

PACKAGE XXAA_APINV_IFACE_PKG

PROCEDURE XXAA_APINV_IFACE_LOAD_PRC

PROCEDURE XXAA_APINV_IFACE_IMPORT_PRC;

/

 

Integrator

1. Create Integrator

Navigation : Desktop Integration Manager Responsibility-> Create Integrator



 



























Integrator Name               : XXAA APINV Interface Integrator

Internal Name                   : XXAA_APINV_IFACE_INTEGRATOR

Application                         : Payables

Next



 


 















2. Create Interface

Interface Name                  : XXAA APINV Interface

Interface Type                    : API – Procedure

Package Name                   : XXAA_APINV_IFACE_PKG

Procedure/Funtion          : XXAA_APINV_IFACE_LOAD_PRC

API Returns                        : FND Message Code

Click on Apply button



 











Select the Interface and Click on Next button



 









































































3. Create Content

Content Name                   : XXAA APINV Interface Content

Content Type                     : Text File

Number of columns        : 9

Apply



 









 






Rename the display names as per csv header columns for better under standing

And provide the content parameter (download parameter) as Web ADI: Download "Text File" Parameters

 4. Create Uploader



 


 


 



























5. Create Importer

Select importer type as PL/SQL API

Importer Name                 : XXAA_APINV_IFACE



 






















Click on PL/SQL API Call plus button to add our custom procedure

  

Enter following information

API Type                              : PL/SQL Procedure

Package Name                   : XXAA_APINV_IFACE_PKG

Procedure Name               : XXAA_APINV_IFACE_IMPORT_PRC

API Returns                        : FND Message Code

Click on apply and then submit button



 

 

 


















































🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

2 comments:

Unknown said...

Thank you very much!

Anonymous said...

Thank you Raju for sharing valuable information

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect