Register PL SQL stored procedure in Oracle Apps: You have a PL/SQL procedure in your database and you want the user to be able to execute it from Oracle Apps front end. To do so, we have to register the procedure in Oracle Apps. Now let’s see how to do that. Steps to register a […]
The below are the steps involved in the Drop Ship Cycle: Before you create an order, you have to perform some setups in order to drop ship, which are listed in the below mentioned article “Drop Ship Setups”: Drop Ship Setups 1. Create Sale Order 2. Book Sales Order 3. Check Status 4. Progress Sales […]
About Attachments: Attachment in Oracle Application What is attachment in oracle application? The attachments feature in oracle application enables users to link unstructured data, such as images, word-processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations as operation instructions. Where to find an […]
SOA Applications communicate with Database using DB Adapter. When SOA composites are deployed in weblogic server, they require Outbound connection pool to communicate with Database. A JDBC Data Source with Database connection details should be associated to connection pool. JNDI Name used for creating connection pool should match the value entered for database connection when […]
The below script can be used to auto approve notifications through database procedure. Write your business logic with in the below procedure ,register it as a concurrent program and schedule it as needed to run periodically. The same script can also be used in custom forms, custom or third party applications to respond to notifications from backend procedure.
Steps for handling multiple layouts in XML. After developing the Report definition file (.rdf) we have to add one more parameter like follows. This parameter value should be assigned to Place holder column(CP ) like follows We can assign Parameter value either after parameter form or before report Triggers. In this we assigned in Before […]
This script will display all the responsibilities for a given Username.
This script can be used to get the below quantities. 1. On-hand Quantity 2. Available to Reserve 3. Quantity Reserved 4. Quantity Suggested 5. Available to Transact 6. Available to Reserve You can also get the On-hand quantities from the table mtl_onhand_quantities GET ON-HAND QUANTITIES API GET ON-HAND QUANTITIES FROM TABLE
Retainage Release Invoices in Oracle AP: Retainage means retaining certain amount of money with us without paying the supplier in full. The retained amount is released or paid to the supplier when all the terms of the agreement have been met or all the work is completed. Pre-requisites: 1. Retainage Account setup: Navigation: Payables Responsibility […]
Favorites in Oracle Apps Home Page You can add forms that you use frequently to your favorites in Home page. By clicking on it will directly take you to the respective form instead of traversing through all the menu options to get to a form. Add to Favorites in Home Page: Go to Home Page> […]