Table Partitioning
Description: Every data should be stored in the database because the world can’t run without storing the data’s in the database. Machinery world should save data in a database for future reference and process so that…
Read MoreQuery for Supplier details with banks
Introduction This Post is about to Supplier details with banks query in oracle r12. Query for Supplier details with banks. SELECT aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier” ,accts.ext_bank_account_id “Payee_Bank_Account_Identifier”…
Read MoreGST TAX Details For EBS R12
Introduction This post is about to GST TAX Details query in EBS R12 select decode(substr(h.tax_rate_code,1,4),’SGST’,nvl(h.unround_tax_amt_tax_curr,0)) SGST_AMT , decode(substr(h.tax_rate_code,1,4),’CGST’,nvl(h.unround_tax_amt_tax_curr,0)) CGST_AMT , decode(substr(h.tax_rate_code,1,4),’SGST’,nvl(h.tax_rate_percentage,0)) SGST_RATE, decode(substr(h.tax_rate_code,1,4),’CGST’,nvl(h.tax_rate_percentage,0)) CGST_RATE, h.first_party_primary_reg_num GST_NUM, h.third_party_primary_reg_num CUSOMER_GST_NUM, h.ledger_id LEDGER_ID , h.trx_number INVOICE_NUM,(SELECT jra.reporting_code FROM jai_reporting_associations jra,…
Read MoreQuery for AR Transactions Header with GST
Introduction This Post is about to AR Transactions Header with GST Query. SELECT DISTINCT rcta.trx_number, rcta.ct_reference, lep.legal_entity_id, lep.NAME legal_entity, rcta.trx_date invoice_date, –Bill to location details hp.party_name bill_cust_name, hcs1.LOCATION bill_to_loc, RTRIM (hrl.address_line_1, ‘,’) Billadd1, RTRIM (hrl.address_line_2, ‘,’) Billadd2, RTRIM (hrl.address_line_3, ‘,’) Billadd3, RTRIM (hrl.loc_information15, ‘,’) Billadd4,…
Read MoreSteps 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 More