Franklin Dean
Oracle Web Application Desktop Integrator (WebADI) is a self-service Oracle application that can be accessed using a browser. It is a tool that brings Oracle E-Business Suite functionality to a spreadsheet, where familiar data entry and modelling techniques can be used to complete Oracle E-Business Suite tasks. WebADI can be used to create an advance shipment notice (ASN) using supplier 'Allied Manufacturing' in three steps. It can also be used to update the purchase order in the Buyer Work Center. WebADI software does not need to be installed on individual client machines, and processing takes place on the server.
| Characteristics | Values |
|---|---|
| Definition | Web Applications Desktop Integrator (WebADI) is a self-service Oracle application accessed using a browser. |
| Software Installation | The WebADI software does not need to be installed on individual client machines. |
| Processing | Processing takes place on the server rather than on individual client PCs. |
| Document Generation | Web ADI generates Microsoft Excel or Word documents on your desktop, and uploads the data you have selected to upload. |
| Document Appearance | The appearance of the spreadsheet or word processing document is determined by configurable layouts. |
| Layout Customization | System administrators can restrict the fields that end users work within the spreadsheet, and can create different layouts for different users. Experienced users can also create their own layouts to include just the fields they need to work with. |
| Integrator | This is the definition that stores the information about the action the user wishes to perform. For example, downloading specific data to a spreadsheet for viewing or to modify and upload back to the database. |
| API | API or Application Programming Interface is the pl/sql interface by which data is validated and uploaded into Oracle HRMS. |
| View | A view is an object by which you can query data on a table or tables. If the action you are intending to perform involves downloading data, you must associate a view with the integrator. |
| Setup | Setting up Oracle Purchasing involves creating users and defining purchasing responsibilities, setting profile options and adding responsibilities to users, defining departments, jobs, positions, and employees, associating employees with users, defining buyers, and financial and purchasing options, and defining document security, approval hierarchies, and controlling purchasing periods. |
| Overall Goal | The overall goal is to discuss the purchasing process and how to integrate it with other Oracle modules. |
Explore related products
What You'll Learn
Setting up Oracle Purchasing
Step 1: Create Users and Define Responsibilities
The first step is to create user accounts and assign specific purchasing responsibilities to each user. This involves setting up a super user with administrative privileges and any additional users who will be involved in the purchasing process.
Step 2: Configure Profile Options and Responsibilities
The next step is to set up profile options for each user, including preferences and access rights. This may include defining the purchasing responsibilities of each user, such as buyer, financial approver, or purchasing agent.
Step 3: Organize Departments, Jobs, Positions, and Employees
This step involves structuring the organization by defining departments, jobs or roles, and employee positions. It helps establish a clear hierarchy and facilitates associating employees with specific roles and departments.
Step 4: Associate Employees with Users and Define Buyers
Here, you will link employee records with the corresponding user accounts. Additionally, you will identify and define the buyers within the organization, specifying their roles and responsibilities in the purchasing process.
Step 5: Define Document Security, Approval Hierarchies, and Purchasing Periods
This step focuses on securing documents by setting access controls. It also involves establishing a clear approval chain for purchases and defining the time frames or periods within which purchasing activities will occur.
Step 6: Set Up Accounting Code Combinations
You need to establish accounting code combinations for your Purchasing installation. This involves configuring the chart of accounts and setting up accounting periods.
Step 7: Define Human Resources Key Flexfields
This step may be optional, depending on whether you have already installed Oracle Human Resource Management Systems. It involves setting up HR-related data fields, such as employee information and organizational structures.
Step 8: Define Units-of-Measure Classes and Conversions
Here, you will establish standard units of measure and define conversions between different units. This is particularly useful when dealing with international suppliers or when specific measurements are required for purchasing decisions.
Step 9: Define Freight Carriers and Ship Methods
If you want to specify freight carriers on purchase orders, this step is crucial. It involves identifying preferred or required freight carriers and defining the shipping methods they should use.
Step 10: Set Up Printers
Finally, while not mandatory, setting up printers can be useful during the configuration process if you need to print any setup-related documents or reports.
These steps provide a comprehensive guide to setting up Oracle Purchasing, ensuring that the application is tailored to your organization's specific requirements.
Reselling Your Wedding Gown: Best Places to Try
You may want to see also
Explore related products
Using Web ADI for Purchase Order (PO) Creation
Unfortunately, I cannot find sufficient information to create a detailed, instructive answer on using Web ADI for Purchase Order (PO) Creation. Is there anything else I can help you with?
Arches for a Wedding: Creative Ways to Use Garden Arches
You may want to see also
Explore related products
Creating an advance shipment notice (ASN)
Oracle's Web Applications Desktop Integrator (WebADI) is a self-service application that can be accessed using a browser. It does not require installation on individual machines as the processing takes place on the server. WebADI allows users to generate Microsoft Excel or Word documents and upload selected data.
- Select the purchase order on the 'Shipments' tab and add it to a new shipment notice.
- Enter shipment line details and header information, such as the ASN number, shipment date, time, identification number, packing slip data, freight information, item detail, purchase order number, and returnable container information.
- Submit the ASN and process the receipt using the ASN number entered on the 'Receipts' tab.
Once the ASN is successfully validated, it can be used in the Receipts window to create receipts, reducing data entry time. Suppliers can also send ASNs with billing information, which will automatically generate an invoice for the shipment upon validation.
It is important to note that ASNs are transmitted from external suppliers only and cannot be used for internal sales orders sourced from inventory and generated by internal requisitions.
Unleashing WEDO: Mastering Distance Sensor Functionality
You may want to see also
Explore related products
Using Web ADI to update the purchase order
Oracle Purchasing enables buyers to add or modify Buyer Work Center purchase order lines, schedules, pay items, and distributions using the Oracle Web Applications Desktop Integrator (Web ADI) integration with Microsoft Excel. The Buyer's Work Center streamlines the purchase order and long-term agreement creation and management processes. Buyers can enter shipment and distribution information at the line level, and the purchase order flow simplifies data entry.
To update a standard purchase order using Web ADI in the Buyer Work Center, you can follow the steps outlined in the Oracle Purchasing User's Guide. First, import the purchase order data. Then, you can check the status of the import online using the 'View Excel Import Status' action. If there are any errors, you can view the details by clicking on the 'Details' link and then correct the errors and repeat the upload using Web ADI.
The Web ADI can also be used to create a new or add to an existing standard purchase order. For example, you can draft buyer auctions or sourcing RFQs, review or change your purchase order immediately after creation, split one requisition line into several requisition lines, replace one requisition line with one or more items from the catalog or favorites list, updating source information, and consolidate multiple requisition lines into single purchase order lines.
Additionally, Web ADI can be used to create an advance shipment notice (ASN). This involves selecting the purchase order on the 'Shipments' tab and adding it to a new shipment notice, entering shipment line details and header information like the ASN number, and submitting the ASN and processing the receipt using the ASN number entered on the 'Receipts' tab.
Using Adwords to Boost Your Wedding Photography Business
You may want to see also
Explore related products
Web ADI for Oracle Marketing
Web Application Desktop Integrator, or Web ADI, is a tool that brings Oracle E-Business Suite functionality to a spreadsheet, where familiar data entry and modelling techniques can be used to complete Oracle E-Business Suite tasks. In the context of Oracle Marketing, Web ADI is used to set up campaign activities from the Campaign Workbench. When a marketing department needs to work with a large number of campaign activities that are part of a bigger marketing plan, marketers can use the spreadsheet interface provided by Web ADI. This worksheet provides a quick and simple way to create and update multiple campaign activities within and across campaigns.
The campaign activity data can be exported into seeded Web ADI layouts and can be easily accessed externally for analysis. A Web ADI layout is a combination of a spreadsheet interface consisting of a set of logically grouped columns and the mapping of attributes from each of these columns to the appropriate column in the underlying data store. Some of these logical groups of columns include advertisement activities, direct marketing activities, and web activities.
Marketing administrators can customize Web ADI layouts for marketing use. For example, they can create different layouts with different sets of columns for different types of marketing activities. Administrators can also modify or delete Web ADI layouts. It is important to note that seeded Web ADI layouts should not be modified or deleted. Web ADI security is based on the access permissions to the application that the logged-in user has. Marketing administrators with full access privileges can create and update activities and access all the activity data in the system. For marketers and marketing managers, certain restrictions must be applied to Web ADI layouts, such as access restrictions based on team security and OCM security definitions.
Web ADI can be used in various scenarios to create campaign activities. For example, a marketing manager can use a spreadsheet to enter details for multiple campaign activities, including associated Click Through Tracking URL definition details. These details can then be imported into the Campaign Workbench of Oracle Marketing. In another scenario, a marketing manager can use Web ADI to plan and advertise a new "Consulting Solutions Software Application".
Please, No Phones: Our Wedding Wish
You may want to see also
Frequently asked questions
Oracle Web ADI (Web Application Desktop Integrator) is a self-service Oracle application accessed using a browser. It brings Oracle E-Business Suite functionality to a spreadsheet, where familiar data entry and modelling techniques can be used to complete Oracle E-Business Suite tasks.
Web ADI automatically imports data into your Web ADI spreadsheets from the Oracle E-Business Suite or from a text file. This feature is useful when migrating data from a legacy system to the Oracle E-Business Suite. All data in the spreadsheet can be validated against Oracle E-Business Suite business rules before it is uploaded.
The basic setup includes 18 steps, such as creating users and defining purchasing responsibilities, setting profile options and adding responsibilities to users, defining departments, jobs, positions, and employees, and defining document security, approval hierarchies, and controlling purchasing periods.
Oracle Web ADI can be used to create an advance shipment notice (ASN) using supplier 'Allied Manufacturing'. It can also be used to update the standard purchase order in the Buyer Work Center. Additionally, Oracle Marketing uses Web ADI support to set up campaign activities from the Campaign Workbench.
As an administrator, you can customise Web ADI layouts for marketing use and modify or delete Web ADI layouts. You can use the layout functionality to determine what fields appear in your spreadsheet, where they appear, and if they contain default values. These definitions can be saved, reused, and modified as needed.
