AP Invoice Workbench Overview

November 5, 2012 in Business Processes


  • Form Application: Accounts Payables
  • Form Name: APXIWALL
  • Form Description: Accounts Payables Invoice Workbench
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/ap/12.0.0/forms/US/APXIWALL.fmx

AP Invoice Workbench Actions:
Invoice workbench is a one stop screen where multiple invoice actions can be performed. Some of the common actions

  • Invoice Entry
  • Invoice Corrections/Update
  • View Invoice
  • Invoice Holds and Removal
  • Invoice Match
  • Invoice Validation
  • Invoice Approval
  • Create Invoice accounting
  • Invoice Payments

Invoice Entry: For detailed tutorial on how to create invoice entry visit  http://oracleappscommunity.com/oracle/blog/9296/ap-invoices-manual-entry/

Invoice Match: Invoice Matching is a step in AP invoice processing where a invoice is matched to corresponding purchase Order.

  • Navigate to AP Invoice workbench
  • Query and open a Invoice
  • Click on ‘MATCH’
  • Enter the purchase order or other search criteria to query
  • Click ‘FIND’
  • Output screen shows all purchase order lines
  • Select the lines to match
  • Click ‘MATCH’


Invoice Validation: Invoice validation is done after AP invoice is matched with purchase order.

  • Navigate to AP invoice work bench
  • Click on ‘Actions’
  • Check ‘Validate’
  • Click ‘OK’
  • Verify the status
  • Invoice status shows ‘VERIFIED’ if all predefined conditions are met.


Invoice Approval: based on setups some invoice may need to be approved before processing for payments.

  • Navigate to AP invoice work bench
  • Click on ‘Actions’
  • Check ‘Force Approval’ or ‘Initiate Approval’
  • Click ‘OK’
  • Verify the status
  • Invoice Approval status shows ‘APPROVED’ or ‘Manually Approved’

Create invoice Accounting: Once Invoice approved, accounting entries can be made.

  • Navigate to AP invoice work bench
  • Click on ‘Actions’
  • Select ‘Create Accounting’, select ‘Draft’, ‘Final’ or ‘Final post’.
  • Click ‘OK’
  • Navigate to ‘TOOLS’ -> View Accounting Entries to verify.

Invoice payment: Once Invoice is ready for payment, payment can be generated or scheduled for a later date based on payment terms.

  • Navigate to AP invoice work bench
  • Click on ‘Actions’
  • Select ‘Pay in Full’
  • Click ‘OK’
  • Payments window opens up
  • Enter the payment date
  • Enter bank a/c details
  • Enter payment method
  • Click on ‘Actions’
  • Select ‘Create Accounting’ and ‘Print Remittance Advice’
  • Click ‘OK’



AP Invoices Manual Entry

November 4, 2012 in Business Processes

  • Form Application: Accounts Payables
  • Form Name: APXIWALL
  • Form Description: Enter Accounts Payables Invoices manually
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/ap/12.0.0/forms/US/APXIWALL.fmx

Suppliers once goods are shipped they will send the invoice, this is called accounts payable invoice.

AP invoices can be entered manually, through API or through EDI.

Navigation:  Accounts Payables Responsibility -> Invoices -> Entry -> Invoices

  • Enter the operating Unit
  • Enter type of Invoice
  • Enter Purchase Order (PO) number if it is for a PO
  • Enter Supplier Name in Trading Partner
  • Enter Invoice Date
  • Enter Invoice Number
  • Enter Invoice amount

Then click on ‘LINES’ tab to enter Invoice lines information. Only in R12 you can enter Invoice lines, in older versions you can only enter Invoice header and distributions.

  • Enter Line Number
  • Enter Invoice line type (eg. Item)
  • Enter Invoice line amount
  • Enter distribution account, by default you can select this from a predefined account alias, however this can be manually changed.
  • Enter description

Click on DISTRIBUTIONS for the invoice line. Distributions allow to split the line amount to multiple distribution (GL) accounts.

Save the record. Now a new AP invoice is created in the system.

Oracle Advanced Supply Chain Planning Overview

October 29, 2012 in Oracle Supply Chain Planning

Oracle Advanced Supply Chain Planning (ASCP) is the main planning engine Oracle is offering, it has advanced features than the traditional MRP module. Its plans the supply (POs, Requisitions, work orders) based on demand (forecasts, sales orders).

ASCP functional features:

  • Global Planning engine: ASCP can plan one inventory organization or all inventory organizations, it can consider all inter-plant supply/demand in one process.
  • Mixed modes of manufacturing: ASCP can support discrete, process, project & flow manufacturing in one plan.
  • Detail planning: ASCP can do short-term detail planning as well long term aggregate planning in one shot.
  • Constraint based planning: Traditional MRP is unconstrained, it plans for the future and raises exceptions if there are any constraints. Constraint based planning can be done by either capacity as a constraint or meeting demand is an constraint.
  • Optimzed Planning: Based on buisness rules setup, ASCP can plan the the output to optimize the criteria given by users.
  • Multiple versions of Oracle: The planning instance support multiple source ERP instances which are running on a different versions of Oracle (R10.7, R11, R12).
  • Plan Simulations: Planners can simulate the changes and review impact without actually making the necessary changes.

Data Collections: Data collections are set of programs that collect the base data (items, boms, routings, onhands, sales orders, purchase orders etc) from source ERP instance into planning instance to perform the supply chain planning.