Balance Forward Billing (BFB)
Balance Forward Billing (BFB) In EBS R11i we call it as consolidated billing In EBS R12 Balance forward billing In fusion Balance forward billing (BFT) we can used for…
Read MoreReceivables Auto Invoice Import Failed with DUPLICATE INVOICE Error Message
Receivables Auto Invoice Import Failed with DUPLICATE INVOICE Error Message Introduction:- Oracle Fusion Cloud Applications 23B (11.13.23.04.0) Information in this document applies to any oracle fusion platform. Cause of…
Read MoreAR Invoice Image Upload Using SOAP Request – Oracle Fusion
This blog contains sample payload to upload an image file in AR invoice attachments in Oracle Fusion Applications. During fusion implementation, we might come across a client requirement to upload…
Read MoreAR Aging 4 Bucket with project details – FUSION
WITH FUNCTION get_outstanding_amount ( p_payment_schedule_id IN NUMBER, p_as_of_date IN DATE, p_invoice_type …
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 MoreAR Transactions and Tax Query – India Localization
SELECT TO_CHAR (trx_date, ‘DD-MON-YYYY’) ar_posting_date, TO_CHAR (jatt.excise_invoice_date, ‘DD-MON-YYYY’) excise_invoice_date, rcta.trx_number ar_trx_number, flv.meaning document_type, jatt.excise_invoice_no, hca.account_number cust_bill_to, hp.party_name cust_name,…
Read More