You are browsing the archive for oracle apps.

AP Invoice Workbench Overview


  • 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

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’



Oracle Apps Modules List


Oracle Apps is a short name for Oracle Applications. There are many other names that are in use for Oracle Apps, some of them are

  • Oracle Applications
  • Oracle ERP
  • Oracle eBusiness Suite
  • Oracle Fusion Applications

Oracle Apps is ERP system developed by Oracle Corporation.

It consists many modules, often grouped into product families. Oracle apps ERP is in use since 30+ years, initially started with oracle financials and expanded to manufacturing, logistics, supply chain planning, product life cycle management & customer relationship management. Industry specific modules are also available for Healthcare, Aerospace, Life Sciences, High Tech industries.

Oracle Apps product families and related module offerings:

Application Administration

  • i Setups
  • Alerts
  • Trading Community Architecture


  • e-commerce gateway
  • Workflow
  • XML gateway
  • Report Manager
  • Web Applications Desktop Integrator

Marketing and Sales

  • Marketing
  • Trade Management
  • TeleSales
  • Field Sales
  • Sales for Handhelds
  • Quoting
  • Partner Management
  • Proposals
  • Incentive Compensation
  • Price Protection
  • Contracts
  • Sales Contracts
  • Sales offline
  • Territory Manager
  • Web Analytics and Administration

Order Management


Supply Chain Planning



  • Work In Process
  • Bills Of Material
  • Engineering
  • Quality
  • Manufacturing Execution Systems
  • Manufacturing Operations Center
  • Landed Cost Management
  • Enterprise Asset Management
  • Costing
  • Flow Manufacturing
  • Manufacturing – Subcontracting
  • Shop Floor Management
  • Process Manufacturing Cost Management
  • Process Manufacturing Process Planning
  • Process Manufacturing Process Execution
  • Process Manufacturing Product Development
  • Process Manufacturing Quality Management
  • Process Manufacturing Regulatory Management
  • Process Manufacturing System Administration
  • Capacity
  • Manufacturing Scheduling
  • Master Scheduling/MRP and Supply Chain Planning


  • TeleService
  • Service Contracts
  • Field Service
  • Depot Repair
  • iSupport
  • Install Base
  • Service Contracts
  • Advanced Scheduler
  • Knowledge Management
  • Mobile Field Service
  • Spares Management


  • Project Costing
  • Project Resource Management
  • Project Collaboration
  • Project Management
  • Project Portfolio Analysis
  • Project Contracts
  • Project Billing

Real Estate Management

  • Property Manager

Product Life cycle Management


  • Accounts Payables
  • Accounts Receivables
  • General Ledger
  • Advanced Collections
  • Internet Expenses
  • iReceivables
  • Treasury
  • Internal Controls Manager
  • Financial Consolidation Hub
  • Financial Services Accounting Hub
  • Accounts Receivable Deductions Settlement
  • Chaannel Rebate and Point of sale management
  • Revenue Management
  • Supplier Ship and Debit
  • Assets
  • iAssets
  • Cash Management
  • Treasury
  • Bill Presentment
  • Credit Management
  • Advanced Global Intercompany
  • Public Sector Budgetting
  • Public Sector Financials
  • U.S. Federal Financials
  • E-Business Tax
  • Lease and Finance
  • Enterprise Performance Foundation
  • Performance Management

Human Resources

  • Human Resources
  • Self-Service Human Resources
  • Advanced Benefits
  • iRecruitment
  • Payroll
  • Time and Labor
  • HR Intelligence
  • Succession Planning
  • Labor Distribution

Learning Management

  • Learning Management (formerly Training Administration)
  • iLearning

Customer Data Management

  • Customer Data Librarian
  • Customer Data Hub

Product Information Management

  • Product Information Management Data Librarian
  • Product Information Management Data Hub

Interaction Center Technology

  • Advanced Inbound Telephony
  • Advanced Outbound Telephony
  • Scripting
  • eMail Center


  • CRL Financial Management
  • Asset Tracking
  • Telco Provisioning
  • Number Portability
  • Telecommunications Billing Integrator

Public Sector/University

  • Student System
  • Financial Aid
  • Student Recruiting
  • Personal Portfolio
  • Grants
  • Loans

Financial Services

  • Regulatory Capital Manager
  • Profitability Manager
  • Transfer Pricing
  • Transfer Pricing Online
  • Budgeting and Planning
  • Risk Manager
  • Financial Data Manager
  • Financial Services Provisioning
  • Lease Management


  • Adverse Event Reporting System
  • Clinical
  • Remote Data Capture
  • Thesaurus Management System
  • Clinical TrialMinder
  • Clinical SiteMinder
  • Life Sciences Data Hub
  • Healthcare Transaction Base

High Tech

  • Shop Floor Management
  • Supply Chain Planning Connector for RosettaNet

Aerospace, Defense and Transportation

  • Complex Maintenance, Repair, and Overhaul

Defaulting Rules Setup


Form Application: Oracle Order Management
Form Name:  OEXDEFWK
Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/ont/12.0.0/forms/US/OEXDEFWK.fmx

Entering a sales order is involved with many clicks to enter data, by setting up defaulting rules time to enter sales order can be dramatically increasing by specifying the rules to default. Defaulting rules can be setup for order header & Order lines. For each attribute (field) on the screen can be defaulted based on the order. Conditional templates when these defaults rules should be applied also can be specified.

Defaulting Rules Setup - Oracle Order Management
Entering a sales order is involved with many clicks to enter data, by setting up defaulting rules time to enter sales order can be dramatically increasing by specifying the rules to default.
For detailed tutorial on how to setup Defaulting Rules in Oracle Order Management visit us at


Navigation: Login to Oracle Apps -> Select Order Management responsibility -> Setup

  • Navigate to  Setup -> Rules -> Defaulting
  • Query the entity name eg. order header, order line
  • Click on Defaulting template to setup the applicable rules
  • Select the attribute
  • Click on Defaulting rules to setup the defaulting sequence

Save the changes