Steps to Controller Extension in OAF Page
Description: To extend the OA Framework page, you have 2 options, extend the VO or extend/create the controller. Extending a VO is on a global level, and you pick this…
Read MoreQuery for AR Transactions Line with GST
Introduction this query is used for AR Transactions Line with GST Query. Query for AR Transactions Line with GST. SELECT h.trx_uom, h.trx_line_quantity, h.unit_price, h.line_amt, h.first_party_primary_reg_num gst_num, h.third_party_primary_reg_num cusomer_gst_num, b.line_number, b.description, b.uom_code, b.quantity_invoiced, b.unit_selling_price…
Read MoreForms Data Loader Automation Script with Playback option New
Description: Oracle Forms supports record and playback feature. This feature is available in every version of Oracle Forms. When we run Oracle Forms in record mode, it will record…
Read MoreQuery to Link PO, AP, GL, TAX RATE & XLA
Description: A database query can be either a select query or an action query. A select query is a data retrieval query, while an action query asks for additional operations on the data, such as insertion, updating, or deletion.…
Read MoreQuery to Link PO, AP, GL, ZX, CE, RCV & XLA
Description: In database management systems, query by example (QBE) refers to a method of forming queries in which the database program displays a new record with a space for each field. You can then enter…
Read MoreAudit Trail Enabling for Employee Tables
Introduction This Post is About to Audit Trail Enabling For Employee Table Enable Audit Trail Profile Navigation: System Administrator à Profile à System Now enter AuditTrail:Activate in Profile and click on Find. Make sure it is…
Read MoreCreating DFF in a Custom Form
Introduction This Post Is To Creating DFF in a Custom Form. QUERY TO CREATE DFF IN CUSTOMER FORM. 1. Go to Application Developer -> Flex Fields -> Descriptive -> Register…
Read MoreCreate, Update Organization API
Description This blog describes the technical information required for creating an Inventory organization and their classification using API. In order to create Inventory organization we can use three API which…
Read MoreOracle HRMS – Create Employee API
Description: This blog describes the process and technical information required for creating new employee using API. In any business organization employee should there to do the work, so Oracle provide…
Read MoreQuery of 11i to R12 Table Changes
Description: In this article, I am going to cover minimum database object level changes done by Oracle in the upgrade like object obsolete, package level changes, API changes. Accounts Payable…
Read More