Entries by Oracle ERP Apps Guide

, , , , ,

I/C AP & AR Invoice from SO

Select a.order_number Sales_Order, d.trx_number IC_AR_INVOICE, e.INVOICE_NUM IC_AP_INVOICE, g.segment1 PO_NUMBER,b.ordered_item, b.invoice_interface_status_code, b.invoiced_quantity, b.flow_status_codeFrom apps. oe_order_headers_all a,     apps. oe_order_lines_all b,     apps. HR_ALL_ORGANIZATION_UNITS c,     apps. RA_CUSTOMER_TRX_ALL d,     apps. AP_INVOICES_ALL e,     apps. OE_DROP_SHIP_SOURCES f,     apps. PO_HEADERS_ALL gWhereb.header_id = a.header_id AND f.LINE_ID = b.line_idAND d.org_id=c.organization_idAND a.order_number=’10090178′ //SO numberAND c.name LIKE ‘XXX%UK%’ //Operating unitAND d.ct_reference= to_char(a.order_number)AND e.INVOICE_NUM = d.trx_numberAND f.po_header_id=g.po_header_id

/by
, , , , ,

Reason for invoices rejected by Payables Open Interface Import

Below simple code can be used to check reason for invoices rejected by  Payables Open Interface Import.Select aii.Invoice_num , air.PARENT_TABLE, air.REJECT_LOOKUP_CODE, air.parent_idFrom apps. AP_INTERFACE_REJECTIONS air,apps. AP_INVOICE_LINES_INTERFACE aili,apps. AP_INVOICES_INTERFACE aiiWHere aii.invoice_id=aili.invoice_idAND  aili.invoice_id=air.parent_idAND aii.Invoice_num = ‘Invoice Number’

/by
, , , ,

Important Account Receivables Tables

RA_CUSTOMER_TRX_ALL  Table Or View: Table Important columns:  CUSTOMER_TRX_ID BATCH_SOURCE_ID TRX_NUMBER Description:  Header-level information about invoices, debit memos, chargebacks, commitments and credit memos. RA_CUSTOMER_TRX_LINES_ALL   Table Or View: View Important columns:  CUSTOMER_TRX_IDCUSTOMER_TRX_LINE_IDLINE_TYPE : Line, TAX or FreightLINE_NUMBERINVENTORY_ITEM_IDQUANTITY_ORDEREDQUANTITY_CREDITEDQUANTITY_INVOICEDUNIT_STANDARD_PRICEUNIT_SELLING_PRICESALES_ORDERSALES_ORDER_REVISIONSALES_ORDER_LINETAX_EXEMPT_FLAGSALES_TAX_IDWAREHOUSE_IDORG_ID : Organization identifier Description:  RA_CUSTOMER_TRX_LINES_ALL contians the line level information of invoices (header informations are stored in RA_CUSTOMER_TRX_ALL).This view contains information […]

/by
, , , ,

Important Account Payables Tables -Part 2

AP_INTERFACE_REJECTIONS Table Or View:  Table Important columns:  PARENT_TABLE : Reference to table in which the rejection occurred (AP_INVOICES_INTERFACE or AP_INVOICE_LINES_INTERFACE)PARENT_ID NUMBER : Reference to invoice or invoice line identifier which was rejected (INVOICE_ID or INVOICE_LINE_ID)REJECT_LOOKUP_CODE : Invoice rejection reason Description:  AP_INTERFACE_REJECTIONS stores information about invoice data from the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables which could not […]

/by