In this post, I tried to explain the required and optional columns in the payables invoice import tables for importing PO Matched Invoices. Table: AP_INVOICE_INTERFACE Required Columns Column Name Validation INVOICE_ID Populated from AP_INVOICES_INTERFACE_S.NEXTVAL INVOICE_NUM Must be unique to the supplier PO_NUMBER An approved, not cancelled, not closed or final closed PO VENDOR_ID or […]
PURPOSE There are a variety of reasons for pending transactions. This paper will serve as a guide for troubleshooting and resolving pending transactions preventing an accounting period from being closed. VIEWING PENDING TRANSACTIONS You can view the number of pending transactions by navigating to the Inventory Accounting Periods form. Navigate > Cost > Accounting Close […]
Oracle E-Business Suite 12 Financials is a solution that provides out-of-the-box features to meet global financial reporting and tax requirements with one accounting, tax, banking, and payments model, and makes it easy to operate shared services across businesses and regions.we will start with recipes for creating Items. We will cover: — Creating Items Exploring Item attributes […]
An Item template is a set of attributes that enable the ‘quick’ creation of an Item. In this recipe, we will create an Item template that can be used to create many similar Items. We will copy from the Finished Good template to our new template called ACME Finished Good. Getting ready Log in to […]
Oracle Purchasing Tables po_requisition_headers_allpo_requisition_lines_allpo_req_distributions_allpo_headers_allpo_lines_allpo_distributions_allrcv_transactionspo_requisitions_interface_allpo_reschedule_interfacepo_headers_interfacepo_lines_interfacepo_distributions_interface po_vendorspo_vendor_sites_allpo_vendor_contacts Understanding the Matching Tables Payables uses several of Oracle Purchasing tables for matching. To implement matching in Payables, you need to load these tables with the data from your non-Oracle purchasing application. PO_HEADERS PO_LINES PO_LINE_LOCATIONS PO_DISTRIBUTIONS PO_DISTRIBUTIONS_AP_V (view of PO_DISTRIBUTIONS) PO_RELEASES (Blanket Purchase Orders) PO_LOOKUP_CODES AutoInstall automatically installs these […]
Recent Comments