Webadi Template in Oracle EBS (Oracle Apps) or Oracle r12
Making Custom Webadi Layout in Oracle Apps
Before making the Custom Webadi, we require to get it why indeed webadi needed.
So here is the answer,
Oracle Web ADI is being utilized by the Conclusion Clients in the Oracle E-Business Suite to perform a few of their day-to-day information section errands in the commonly utilized Microsoft desktop applications like Exceed expectations and transfer the information to EBS.
To make the custom WebADI, We require two responsibilities.
Desktop Integration Manager(lets you creating/Managing Integrator and parameters)
Desktop Integrator(lets you make Archive, format, Mapping, Setup alternatives etc.,)
Now we are considering How to do that utilizing the route in application.
there are taking after steps:-
Step 1: Make database table: We utilize this table to stack the information by utilizing Web ADI template.
Table Script:
CREATE TABLE xxcust_stage_table
(
project_number VARCHAR2(50)
,task_number VARCHAR2(50)
,description VARCHAR2(50)
);
Step 2. Make Bundle: We utilize this bundle to do the validations some time recently uploading the information to the custom table.
Package Specification:
CREATE OR Supplant Bundle xxcust_webadi_demo_pkg
AS
/*
* Designer :
* Client/Project :
* Database :
* Date :
* Depiction : This bundle contains the rationale for Web ADI upload
* Issue :
* Form Control:
* Creator Adaptation Date Change
* ------- ------- -------- -------
*/
Method xxcust_webadi_stg (
icproject_number VARCHAR2
,ictask_number VARCHAR2
,icdescription VARCHAR2
);
END;
/
Package Body:
CREATE OR Supplant Bundle BODY APPS.xxcust_webadi_demo_pkg
AS
/*
* Engineer :
* Client/Project :
* Database :
* Date :
* Depiction : This bundle contains the rationale for webadi upload
* Issue :
* Adaptation Control:
* Authour Form Date Change
* ------- ------- -------- -------
*/
Method project_validation (
p_project_number VARCHAR2
,p_proj_valid OUT NUMBER
)
IS
BEGIN
SELECT Check (1)
INTO p_proj_valid
FROM pa_projects_all pa
WHERE pa.segment1 = p_project_number
AND pa.project_status_code = 'APPROVED';
Conclusion project_validation;
Method task_validation (
p_task_number xxcust_stage_table.task_number%TYPE
,p_project_number xxcust_stage_table.project_number%TYPE
,p_task_valid OUT NUMBER
)
IS
BEGIN
SELECT Number (1)
INTO p_task_valid
FROM pa_tasks pt
,pa_projects_all ppa
WHERE pt.project_id = ppa.project_id
AND pt.task_number = p_task_number
AND pt.chargeable_flag = 'Y'
AND ( pt.completion_date IS NULL
OR pt.completion_date > TO_DATE (sysdate, 'dd/mm/yyyy'))
AND ppa.segment1 = p_project_number;
Conclusion task_validation;
Method xxcust_webadi_stg (
icproject_number xxcust_stage_table.project_number%TYPE
,ictask_number xxcust_stage_table.task_number%TYPE
,icdescription xxcust_stage_table.description%TYPE
)
IS
l_projnumber NUMBER DEFAULT 0;
l_tasknumber NUMBER DEFAULT 0;
l_exptype NUMBER DEFAULT 0;
l_vatcode NUMBER DEFAULT 0;
l_gl_code NUMBER DEFAULT 0;
l_trans_date_valid CHAR;
l_trans_pa_date_valid CHAR;
l_exp_message VARCHAR2 (2000) DEFAULT NULL;
l_app_id NUMBER;
e_invalid EXCEPTION;
l_valid CHAR;
BEGIN
project_validation (icproject_number,l_projnumber);
IF l_projnumber = 0
THEN
l_exp_message := 'Project Number does not exist';
Conclusion IF;
task_validation (ictask_number
,icproject_number
,l_tasknumber
);
IF l_tasknumber = 0
THEN
l_exp_message:='Receiver Assignment Number does not exist';
Conclusion IF;
IF l_exp_message IS NOT NULL
THEN
RAISE e_invalid;
ELSE
Embed INTO xxcust_stage_table
(project_number
,task_number
,description
)
VALUES (
icproject_number
,ictask_number
,icdescription
);
Conclusion IF;
EXCEPTION
WHEN e_invalid
THEN
raise_application_error (-20002, l_exp_message);
WHEN OTHERS
THEN
raise_application_error (-20000, SQLCODE || ':' || SQLERRM);
Conclusion;
END;
/
Step 3.Create an integrator:
Navigate to -->Desktop Integration Chief - > Make Integrator
Step 1 :
Click on Make Integrator. Underneath page will open and enter the required points of interest and select the checkbox ‘Display in Make Records Page’ and press on the Following Button
Integrator Title: Custom Webadi Test Template
Internal Title: XXCUST_WEBADI_TEMPLATE
Application: Projects
Step2:
Kindly enter xxcust_webadi_demo_pkg as the Interface Title.
Interface Sort: Choose an API Strategy from the list of options.
Title of Package: xxcust_webadi_demo_pkg(Title the package as specified in step 2)
Name of Procedure: xxcust_webadi_stg(Select the package's major method title, xxcust_webadi_demo_pkg.)
API Output: Choose FND Message Code from the available options. This will help the error message in the Webadi template to appear.
When you click the Apply button, the page below will load.
When you select the radio button that is highlighted above, the page below will open.
Click the pencil button and fill in the information to create a list of values for the Webadi column.
Validation Sort: Table
Id column: segment1(column name)
Meaning: segment1(column name)
Validation Substance: pa_projects_all(table name)
Lov Sort : Pop up List
Save the subtle elements and press on Next
Step 3: tap on Another, select the From layout from list of values after that Press on make button at that point Tap on Next.
Step 4: At last tap on Yield, your Custom integrator is prepared now.
Step 5.Create the Layout.
Navigate to Desktop Integrator --> Characterize Layout
Select Integrator title from the drop down list, press on Go button, press on Make-> Enter Format Title and tap on Another -> press on Another -> press on Apply -> presently your Integrator Format is made effectively :).
Now to download the webadi template:-
navigation: Desktop Integrator --> Make Document
Step 1: select the Integrator title from drop down list and press on Another -> press on Next
-> press button Make Record -> Tap on Open -> Tap on Permit and hold up till the underneath Webadi layout makes -> Webadi Format with List of Values
**Web ADI Template in Oracle EBS (Oracle Apps) or Oracle R12** Ah, Web ADI! The superhero tool of Oracle EBS (Oracle Apps) or Oracle R12 that swoops in to rescue us from the tedious task of manual data entry. But wait, who's this sidekick? It's the Web ADI Template! Together, they form an unbeatable duo that makes data upload a breeze. So, grab your cape, and let's dive into the world of Web ADI Templates with a dash of humor and step-by-step guidance!
### What is a Web ADI Template?
Think of a Web ADI Template as the blueprint for your Oracle Applications data upload.
It's like a recipe card that tells Web ADI what ingredients (data) to mix (upload) and in what order.
Having the right template is like having the secret sauce to a successful data upload - and who doesn't love a good secret sauce?
Oracle Apps -> Responsibility -> Web ADI -> Create Document
### Creating a Web ADI Template
Creating a Web ADI Template is as easy as pie... or should I say, as easy as uploading pie data into Oracle!
- **Navigate to Web ADI**
- Go to `Oracle Apps` -> Choose your `Responsibility` -> Navigate to `Web ADI` -> `Create Document`.
Oracle Apps -> Responsibility -> Web ADI -> Create Document
- **Select Template Settings**
- Choose the desired `Template Type` and `Data Source` for your document.
- Customize settings like `Upload Options` and `Data Validation` as needed.
Template Type -> Data Source -> Upload Options -> Data Validation
- **Define Template Layout**
- Add `Rows` and `Columns` to define the layout of your template.
- Include necessary `Fields` and set their `Properties`.
Rows -> Columns -> Fields -> Properties
- **Save and Download**
- Save your template and download it to your computer.
- Open the downloaded file to start entering data.
Save -> Download -> Open File
### Real-Time Examples:
1. **Creating Purchase Order Template**
To create a Purchase Order template:
Web ADI -> Template Type: Purchase Order -> Data Source: PO Info -> Save
2. **Creating Employee Data Template**
To create an Employee Data template:
Web ADI -> Template Type: Employee Data -> Data Source: HR Info -> Save
3. **Creating Inventory Update Template**
To create an Inventory Update template:
Web ADI -> Template Type: Inventory Update -> Data Source: Inventory Info -> Save
4. **Creating Sales Data Template**
To create a Sales Data template:
Web ADI -> Template Type: Sales Data -> Data Source: Sales Info -> Save
5. **Creating Expense Report Template**
To create an Expense Report template:
Web ADI -> Template Type: Expense Report -> Data Source: Expense Info -> Save
6. **Creating Project Budget Template**
To create a Project Budget template:
Web ADI -> Template Type: Project Budget -> Data Source: Project Info -> Save
7. **Creating Vendor Data Template**
To create a Vendor Data template:
Web ADI -> Template Type: Vendor Data -> Data Source: Vendor Info -> Save
8. **Creating Customer Data Template**
To create a Customer Data template:
Web ADI -> Template Type: Customer Data -> Data Source: Customer Info -> Save
9. **Creating Payroll Template**
To create a Payroll template:
Web ADI -> Template Type: Payroll -> Data Source: Payroll Info -> Save
10. **Creating Asset Management Template**
To create an Asset Management template:
Web ADI -> Template Type: Asset Management -> Data Source: Asset Info -> Save
### Conclusion
Web ADI Templates are the unsung heroes that simplify data uploads in Oracle EBS or Oracle R12.
By following the step-by-step instructions and real-time examples provided in this blog, beginners can create and customize Web ADI Templates with ease.
Remember, a well-crafted Web ADI Template is the key to unlocking the full potential of Oracle Applications. So, go ahead and create your masterpiece!
Before making the Custom Webadi, we require to get it why indeed webadi needed.
So here is the answer,
Oracle Web ADI is being utilized by the Conclusion Clients in the Oracle E-Business Suite to perform a few of their day-to-day information section errands in the commonly utilized Microsoft desktop applications like Exceed expectations and transfer the information to EBS.
To make the custom WebADI, We require two responsibilities.
Desktop Integration Manager(lets you creating/Managing Integrator and parameters)
Desktop Integrator(lets you make Archive, format, Mapping, Setup alternatives etc.,)
Now we are considering How to do that utilizing the route in application.
there are taking after steps:-
Step 1: Make database table: We utilize this table to stack the information by utilizing Web ADI template.
Table Script:
CREATE TABLE xxcust_stage_table
(
project_number VARCHAR2(50)
,task_number VARCHAR2(50)
,description VARCHAR2(50)
);
Step 2. Make Bundle: We utilize this bundle to do the validations some time recently uploading the information to the custom table.
Package Specification:
CREATE OR Supplant Bundle xxcust_webadi_demo_pkg
AS
/*
* Designer :
* Client/Project :
* Database :
* Date :
* Depiction : This bundle contains the rationale for Web ADI upload
* Issue :
* Form Control:
* Creator Adaptation Date Change
* ------- ------- -------- -------
*/
Method xxcust_webadi_stg (
icproject_number VARCHAR2
,ictask_number VARCHAR2
,icdescription VARCHAR2
);
END;
/
Package Body:
CREATE OR Supplant Bundle BODY APPS.xxcust_webadi_demo_pkg
AS
/*
* Engineer :
* Client/Project :
* Database :
* Date :
* Depiction : This bundle contains the rationale for webadi upload
* Issue :
* Adaptation Control:
* Authour Form Date Change
* ------- ------- -------- -------
*/
Method project_validation (
p_project_number VARCHAR2
,p_proj_valid OUT NUMBER
)
IS
BEGIN
SELECT Check (1)
INTO p_proj_valid
FROM pa_projects_all pa
WHERE pa.segment1 = p_project_number
AND pa.project_status_code = 'APPROVED';
Conclusion project_validation;
Method task_validation (
p_task_number xxcust_stage_table.task_number%TYPE
,p_project_number xxcust_stage_table.project_number%TYPE
,p_task_valid OUT NUMBER
)
IS
BEGIN
SELECT Number (1)
INTO p_task_valid
FROM pa_tasks pt
,pa_projects_all ppa
WHERE pt.project_id = ppa.project_id
AND pt.task_number = p_task_number
AND pt.chargeable_flag = 'Y'
AND ( pt.completion_date IS NULL
OR pt.completion_date > TO_DATE (sysdate, 'dd/mm/yyyy'))
AND ppa.segment1 = p_project_number;
Conclusion task_validation;
Method xxcust_webadi_stg (
icproject_number xxcust_stage_table.project_number%TYPE
,ictask_number xxcust_stage_table.task_number%TYPE
,icdescription xxcust_stage_table.description%TYPE
)
IS
l_projnumber NUMBER DEFAULT 0;
l_tasknumber NUMBER DEFAULT 0;
l_exptype NUMBER DEFAULT 0;
l_vatcode NUMBER DEFAULT 0;
l_gl_code NUMBER DEFAULT 0;
l_trans_date_valid CHAR;
l_trans_pa_date_valid CHAR;
l_exp_message VARCHAR2 (2000) DEFAULT NULL;
l_app_id NUMBER;
e_invalid EXCEPTION;
l_valid CHAR;
BEGIN
project_validation (icproject_number,l_projnumber);
IF l_projnumber = 0
THEN
l_exp_message := 'Project Number does not exist';
Conclusion IF;
task_validation (ictask_number
,icproject_number
,l_tasknumber
);
IF l_tasknumber = 0
THEN
l_exp_message:='Receiver Assignment Number does not exist';
Conclusion IF;
IF l_exp_message IS NOT NULL
THEN
RAISE e_invalid;
ELSE
Embed INTO xxcust_stage_table
(project_number
,task_number
,description
)
VALUES (
icproject_number
,ictask_number
,icdescription
);
Conclusion IF;
EXCEPTION
WHEN e_invalid
THEN
raise_application_error (-20002, l_exp_message);
WHEN OTHERS
THEN
raise_application_error (-20000, SQLCODE || ':' || SQLERRM);
Conclusion;
END;
/
Step 3.Create an integrator:
Navigate to -->Desktop Integration Chief - > Make Integrator
Step 1 :
Click on Make Integrator. Underneath page will open and enter the required points of interest and select the checkbox ‘Display in Make Records Page’ and press on the Following Button
Integrator Title: Custom Webadi Test Template
Internal Title: XXCUST_WEBADI_TEMPLATE
Application: Projects
Step2:
Kindly enter xxcust_webadi_demo_pkg as the Interface Title.
Interface Sort: Choose an API Strategy from the list of options.
Title of Package: xxcust_webadi_demo_pkg(Title the package as specified in step 2)
Name of Procedure: xxcust_webadi_stg(Select the package's major method title, xxcust_webadi_demo_pkg.)
API Output: Choose FND Message Code from the available options. This will help the error message in the Webadi template to appear.
When you click the Apply button, the page below will load.
When you select the radio button that is highlighted above, the page below will open.
Click the pencil button and fill in the information to create a list of values for the Webadi column.
Validation Sort: Table
Id column: segment1(column name)
Meaning: segment1(column name)
Validation Substance: pa_projects_all(table name)
Lov Sort : Pop up List
Save the subtle elements and press on Next
Step 3: tap on Another, select the From layout from list of values after that Press on make button at that point Tap on Next.
Step 4: At last tap on Yield, your Custom integrator is prepared now.
Step 5.Create the Layout.
Navigate to Desktop Integrator --> Characterize Layout
Select Integrator title from the drop down list, press on Go button, press on Make-> Enter Format Title and tap on Another -> press on Another -> press on Apply -> presently your Integrator Format is made effectively :).
Now to download the webadi template:-
navigation: Desktop Integrator --> Make Document
Step 1: select the Integrator title from drop down list and press on Another -> press on Next
-> press button Make Record -> Tap on Open -> Tap on Permit and hold up till the underneath Webadi layout makes -> Webadi Format with List of Values
**Web ADI Template in Oracle EBS (Oracle Apps) or Oracle R12** Ah, Web ADI! The superhero tool of Oracle EBS (Oracle Apps) or Oracle R12 that swoops in to rescue us from the tedious task of manual data entry. But wait, who's this sidekick? It's the Web ADI Template! Together, they form an unbeatable duo that makes data upload a breeze. So, grab your cape, and let's dive into the world of Web ADI Templates with a dash of humor and step-by-step guidance!
### What is a Web ADI Template?
Think of a Web ADI Template as the blueprint for your Oracle Applications data upload.
It's like a recipe card that tells Web ADI what ingredients (data) to mix (upload) and in what order.
Having the right template is like having the secret sauce to a successful data upload - and who doesn't love a good secret sauce?
Oracle Apps -> Responsibility -> Web ADI -> Create Document
### Creating a Web ADI Template
Creating a Web ADI Template is as easy as pie... or should I say, as easy as uploading pie data into Oracle!
- **Navigate to Web ADI**
- Go to `Oracle Apps` -> Choose your `Responsibility` -> Navigate to `Web ADI` -> `Create Document`.
Oracle Apps -> Responsibility -> Web ADI -> Create Document
- **Select Template Settings**
- Choose the desired `Template Type` and `Data Source` for your document.
- Customize settings like `Upload Options` and `Data Validation` as needed.
Template Type -> Data Source -> Upload Options -> Data Validation
- **Define Template Layout**
- Add `Rows` and `Columns` to define the layout of your template.
- Include necessary `Fields` and set their `Properties`.
Rows -> Columns -> Fields -> Properties
- **Save and Download**
- Save your template and download it to your computer.
- Open the downloaded file to start entering data.
Save -> Download -> Open File
### Real-Time Examples:
1. **Creating Purchase Order Template**
To create a Purchase Order template:
Web ADI -> Template Type: Purchase Order -> Data Source: PO Info -> Save
2. **Creating Employee Data Template**
To create an Employee Data template:
Web ADI -> Template Type: Employee Data -> Data Source: HR Info -> Save
3. **Creating Inventory Update Template**
To create an Inventory Update template:
Web ADI -> Template Type: Inventory Update -> Data Source: Inventory Info -> Save
4. **Creating Sales Data Template**
To create a Sales Data template:
Web ADI -> Template Type: Sales Data -> Data Source: Sales Info -> Save
5. **Creating Expense Report Template**
To create an Expense Report template:
Web ADI -> Template Type: Expense Report -> Data Source: Expense Info -> Save
6. **Creating Project Budget Template**
To create a Project Budget template:
Web ADI -> Template Type: Project Budget -> Data Source: Project Info -> Save
7. **Creating Vendor Data Template**
To create a Vendor Data template:
Web ADI -> Template Type: Vendor Data -> Data Source: Vendor Info -> Save
8. **Creating Customer Data Template**
To create a Customer Data template:
Web ADI -> Template Type: Customer Data -> Data Source: Customer Info -> Save
9. **Creating Payroll Template**
To create a Payroll template:
Web ADI -> Template Type: Payroll -> Data Source: Payroll Info -> Save
10. **Creating Asset Management Template**
To create an Asset Management template:
Web ADI -> Template Type: Asset Management -> Data Source: Asset Info -> Save
### Conclusion
Web ADI Templates are the unsung heroes that simplify data uploads in Oracle EBS or Oracle R12.
By following the step-by-step instructions and real-time examples provided in this blog, beginners can create and customize Web ADI Templates with ease.
Remember, a well-crafted Web ADI Template is the key to unlocking the full potential of Oracle Applications. So, go ahead and create your masterpiece!
No comments:
We encourage respectful comments.
Did this article help you? Let us know in the comments!
What questions do you have about this topic?
We'd love to hear your suggestions for future content.
Please Share this article with your friends and see what they think!