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
https://drive.google.com/file/d/1DFUBTxqcApGE7TDJDqBJuX64wqePSOLk
💡 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:
Thank you very much!
Thank you Raju for sharing valuable information
Post a Comment