Oracle Application Blog

Vendor Ledger Report Query

SELECT flag,   vendor_num,   vendor_name,   vendor_site_id,   vendor_site_code,   state_code,   project_code,   transaction_type,   transaction_num,   doc_category_name,   document_num,   po_number,   transaction_date,   gl_date,   status,   description,   currency,   SUM(entered_dr) entered_dr,   SUM(entered_cr) entered_cr,   SUM(accounted_dr) accounted_dr,   SUM(accounted_cr) accounted_cr FROM   (SELECT 1 flag,…

Read More

Form Personalization to modify the LOV of a Field

Aim : To Change the LOV of the “Tax Category” field in the “Enter transation India Localization” form. Navigation: AR Super User > India Local Receivables > Transactions > Transactions (Localized) Double…

Read More

Basics for Custom Form Development

The below are the steps to follow to develop a basic Custom form in EBS. Download the Resource folder from the server and place in local directory. Right Click on…

Read More

Creating DFF in a Custom Form

1. Go to Application Developer -> Flex Fields -> Descriptive -> Register Enter all the details and click on Columns. Enable the columns and save. 2. Now go to Segments menu. Search…

Read More

Audit Trail Enabling for Employee Tables

Enable Audit Trail ProfileNavigation: System Administrator à Profile à System Now enter AuditTrail:Activate in Profile and click on Find. Make sure it is enabled (Yes) at Site Level Enable Audit For Schema Navigation: System…

Read More

Oracle Forms – Dynamic Message Tool Tip

Multiple tooltip message in single text field Step 1:- Create canvas and Using below script. Below screen shot for reference. Step 2 Create Text_field and Using below script. Below screen…

Read More

Apex – Load Data from Json File to Table

     This blog provides an example of loading data from Json file into Table          Sample Json:- {   “department”: {     “department_number”: 10,     “department_name”: “ACCOUNTING”,…

Read More

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 rate, DECODE (b.quantity_invoiced * b.unit_selling_price,NULL, b.extended_amount,b.quantity_invoiced * b.unit_selling_price) totamt,…

Read More

Query for AR Transactions Header with GST

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,               …

Read More

GST TAX Details For 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, jai_item_templ_hdr jit WHERE jra.entity_id = jit.template_hdr_id…

Read More