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 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 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: The custom lookup parameters can be passed to the below API’s to insert data into Oracle standard tables fnd_lookup_values and fnd_lookup_types *fnd_lookup_types_pkg.insert_row *fnd_lookup_values_pkg.insert_row Sample script with description to upload…
Read More