Create Oracle BI Publisher Report
Create Oracle BI Publisher Report create-oracle-bi-publisher-report
Read MoreLedger Open Balance Script
select gl.name ledgername, gjb.name “Journal Batch Name”, gjh.name “Journal Name”, gjh.je_source “Journal Source”, gjh.je_category “Journal Category Name”, gcc.concatenated_segments accountdisplayvalue, SUM(NVL(GJL.ACCOUNTED_DR,0)) DebitAmount, SUM(NVL(GJL.ACCOUNTED_CR,0)) CreditAmount, SUM(NVL(GJL.ACCOUNTED_DR,0)-NVL(GJL.ACCOUNTED_CR,0)) BALANCE, gl.currency_code currencycode,gjh.posted_date transdate,gjh.default_effective_Date,gjh.period_name from gl_je_headers…
Read MoreVendor Open Balance Script
select aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,’N’,’UN-PAID’,’P’,’Partial Paid’,’Y’,’PAID’) PAYMENT_STATUS_FLAG , aia.invoice_date, aps.vendor_name, apss.vendor_site_code, aila.line_number, aia.invoice_amount, aila.amount line_amount, pha.segment1 po_number, aila.line_type_lookup_code, apt.name Term_name, gcc.concatenated_segments distributed_code_combinations, aca.check_number, aipa.amount payment_amount, apsa.amount_remaining, aipa.invoice_payment_type, hou.name operating_unit, gl.name ledger_name…
Read MoreAR Customer Ledger with Unpaid Invoices
AR Customer Ledger with Unpaid Invoices SELECT arps.org_id, hou.NAME company, rctl.customer_trx_id, TO_CHAR (arps.trx_date, ‘MON-RRRR’) fiscal_year_month, arps.trx_number invoice_number, arps.trx_date invoice_date, arps.customer_id, NVL (arps.amount_due_original, 0) total_invoice_amount, NVL (arps.tax_original, 0) total_tax_amount, NVL (quantity_invoiced,…
Read MoreGST Query for Payables
GST Query for Payables SELECT jeh.period_name period_name, gll.NAME ledger_name, a.concatenated_segments accounting_string, jeh.doc_sequence_value doc_num, gstl.user_je_source_name je_source, gctl.user_je_category_name je_category, jeb.NAME batch_name, jeb.description batch_desc, jeh.NAME je_name, jeh.description je_desc, jel.description line_desc, NULL h_desc,…
Read MoreUTL file for AR invoice Outbound to EBS
UTL file for AR invoice Outbound to EBS CREATE OR REPLACE PROCEDURE APPS.xx_mintifi_sales_inv_ext ( p_from_date IN DATE, p_to_date IN DATE, p_org_id IN NUMBER ) AS x_id UTL_FILE.file_type; x_file…
Read MoreOutbound Interface using PL/SQL
Outbound Interface using PL/SQL Follow the steps PLSQL Stored Procedure (utl_file Method) to design the Outbound Interface in Oracle Apps PROCEDURE XX_PAYMENT_EXTRACT(p_err_message OUT VARCHAR2, p_err_code OUT NUMBER) is CURSOR…
Read MoreFBDI Upload Data from EBS
FBDI Upload Data from EBS supplier-invoice-mapping doyensys_ebs_fusion_integration_fbdi_v2
Read MoreSteps to create BIP reports in oracle fusion
steps-for-creating-bip-reports-in-fusion Oracle Fusion has divided the Oracle Reporting system in 2 Parts. BIP (Business intelligence publisher) BIP :- BIP is the customize reporting tool. Oracle Fusion has provided BIP to…
Read MoreFBDI for Journals from EBS
The following steps have to be created in fusion before extracting data from EBS instance: BU Legal Entity Assign legal entity with BU Ledger Assign Legal Entity with Ledger…
Read More