Description: To implement Role-based Authorization in Oracle APEX Application, in version 5. Application Item: USER_ROLE Table: ROLE_ACCESS_CONTROL The purpose of this table is to store the privileges on Regions, Buttons, and Items for…
Read MoreDescription: 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 MoreIntroduction 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 MoreDescription: 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 MoreIntroduction This Post is about to oracle forms-Dynamic Message Tool Tip in oracle EBS-R12 Multiple tooltip message in single text field Step 1:- Create canvas and Using the below…
Read MoreDescription: 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 MoreDescription: 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 MoreIntroduction 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 MoreIntroduction 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 MoreDescription 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 More