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 MoreCreating 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 MoreAudit 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 MoreOracle 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 MoreApex – 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 MoreQuery 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 MoreQuery 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 MoreGST 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 MoreQuery for Supplier details with banks
SELECT aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier” ,accts.ext_bank_account_id “Payee_Bank_Account_Identifier” ,bank.party_name “bank_name” ,branch.bank_branch_name “Branch_Name” ,accts.country_code “account_country_code” ,accts.bank_account_name “Account_Name” ,accts.bank_account_num “Account_Number”…
Read MoreCumulative Inventory Stock Position
This query fetches cumulative inventory stock position for a particular period. select :p_from_date fromdate,:p_to_date todate, msi.inventory_item_id, msi.segment1, msi.primary_uom_code uom, (select (sum(mmt.primary_quantity)) from…
Read More