Description: The purpose of this component is to restrict the copy option from the user level of apex page. SCENARIO : Consider in our apex application we are providing any confidential message or data that should not be copied by the user level;…
Read MoreDescription: This function calls a PL/SQL on-demand process defined on page or application level. It’s a wrapper of the jQuery.ajax function and supports all the setting the jQuery function provides but…
Read MoreDescription: 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 More