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 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 MoreProject Expenditure Extraction Query
This query fetches all the expenses incurred on a project,and also captures the debit and credit account transaction wise that will help in reconcilation of data with GL. SELECT ei.expenditure_id,…
Read MoreAP Invoice Interface Errors & Fix
INVALID DISTRIBUTION ACCT DUPLICATE LINE NUMBER ZX_IMP_TAX_RATE_AMT_MISMATCH NO EXCHANGE RATE INVALID ASSIGNMENT INVALID DISTRIBUTION ACCT …
Read MoreSupplier Information including GST
The below query fetches all the supplier information including GST Info select (select name from hr_operating_units where organization_id=jpr.org_id) Operating_unit, APS.VENDOR_NAME supplier_name, APSA.…
Read More