edu3fc4y ap

210
Oracle Accounts Payable Overview Copyright © Oracle, 2008. All rights reserved. Oracle Accounts Payable document.doc Effective Paradigm_effective Page 1 of 210 Rev Paradigm_revision

Upload: srinivasa-rao-asuru

Post on 25-Jul-2015

31 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: Edu3fc4y AP

Oracle Accounts Payable

Overview

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 1 of 176 Rev Paradigm_revision

Page 2: Edu3fc4y AP

Oracle Accounts Payable

System References

Distribution

Job Title*

Ownership

The Job Title [[email protected]?Subject= document.doc ] is responsible for ensuring that this document is necessary and that it reflects actual practice.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 2 of 176 Rev Paradigm_revision

Page 3: Edu3fc4y AP

Oracle Accounts Payable

Oracle Accounts Payable

Release 12 Migration Considerations

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 3 of 176 Rev Paradigm_revision

Page 4: Edu3fc4y AP

Objectives

Objectives

After completing this module, you should be able to:

• Describe and use the new features in Release 12 of Oracle Payables.

• Set up the new features in Release 12 of Oracle Payables.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 4 of 176 Rev Paradigm_revision

Page 5: Edu3fc4y AP

Practices 1, 2, and 3 Overview: Prerequisite Practices

Practices 1, 2, and 3 Overview:Prerequisite Practices

In order to perform practices later in this lab, you must first perform the following practices:

• Practice - Create a New Employee

• Practice - Create a New User

• Practice - Set Yourself Up As a Buyer

Practices 1, 2, and 3 Overview: Prerequisite Practices

Refer to Practice - Create a New Employee (Required) [LAB4181Y]

Refer to Practice - Create a New User [LAB4182Y]

Refer to Practice - Set Yourself Up As a Buyer [LAB4184Y]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 5 of 176 Rev Paradigm_revision

Page 6: Edu3fc4y AP

Agenda

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 6 of 176 Rev Paradigm_revision

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Page 7: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 7 of 176 Rev Paradigm_revision

Page 8: Edu3fc4y AP

Suppliers in the Trading Community Architecture (TCA)

Suppliers in the Trading Community Architecture (TCA)

The Trading Community Model:

• Is a highly flexible architecture

• Allows you to model real world entities in your trading community

• Allows you to accurately represent complex relationships among entities

• Is the core data model for trading partners used by Oracle E-Business Suite applications

Suppliers in the Trading Community Architecture (TCA)

By representing Suppliers as part of the trading community, you have access to TCA features, including:

• Data Librarian Function & Processes

• Integrated Enrichment Capabilities including D&B

• Address Validation

• Data Consistency

• Ease of Data Maintenance

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 8 of 176 Rev Paradigm_revision

Page 9: Edu3fc4y AP

TCA Security by Functional Areas

TCA Security by Functional Areas

Function Security

PayablesAttributes

PurchasingAttributes

ReceivablesAttributes

TCA Security by Functional Areas

A new user interface presents a clear distinction between the supplier’s company details and terms and controls for the trading relationship. Managing the attributes specific to particular functional areas such as Oracle Payables,

Purchasing and Receiving can be controlled with the use of Function Security.

• You can add new locations or relationships with additional operating units

• You can modify a quick update page with those values most often updated for faster maintenance

• Additional tax and legal registrations provide key information to meet reporting and compliance needs

The new supplier UI also includes a Survey section that provides administrators with access to the results of questionnaires that the supplier has been asked to complete, either during self-registration or as part of profile maintenance through iSupplier Portal. Purchasing Category assignments further designate the type of goods and services the supplier will provide.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 9 of 176 Rev Paradigm_revision

Page 10: Edu3fc4y AP

Payment Banks, Branches, and Accounts

Payment Banks, Branches, and Accounts

Bank Accounts are:

• Centrally defined

• Managed and secured

• Include the legal ownership and operating unit access for each bank account

Payment Banks, Branches, and Accounts

Banks and Bank Branches are represented in Oracle’s Trading Community Architecture and shared by other Oracle E-Business Suite applications.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 10 of 176 Rev Paradigm_revision

Page 11: Edu3fc4y AP

Supplier Bank Accounts

Supplier Bank Accounts

Enhancements to supplier bank accounts include:

• Removal of some processing restrictions

• Greater control and security

• The bank account is tied directly to the trading partner

• Notification when trying to inactivate a bank account that is associated with unpaid invoices or pay runs that are in process

Supplier Bank Accounts

The bank account is tied directly to the trading partner allowing one bank account definition to be leveraged by a ‘supplier’ trading partner and shared if the trading partner is also an employee or customer. This approach provides for easier and centralized maintenance and security of the bank account information

This definition is targeted directly towards ‘trading partner’ bank accounts leaving internal bank accounts out of the user interface. In other words, the supplier’s banking information is entered and assigned right in the Supplier Entry and Maintenance user interface.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 11 of 176 Rev Paradigm_revision

Page 12: Edu3fc4y AP

Collaboration with Suppliers to Resolve Disputes

Collaboration with Suppliers to Resolve Disputes

• Disputes are communicated and negotiations can be suggested to the Supplier

• Suppliers are able to:– Accept suggested changes

– Withdraw their invoice

– Submit a counter proposal

– Negotiate online via iSupplier Portal

• All changes and comments are tracked in Payables

Collaboration with Suppliers to Resolve Disputes

Holds on invoices that are a result of differences between the invoiced and planned amounts or quantity result in disputes that must be resolved. Invoices that have been approved by the owner of the purchasing transaction but rejected during the approval process may also be subject to disputes with the supplier.

Leveraging workflow notification, disputes are communicated and negotiations can be suggested to the Supplier. Suppliers are able to accept the suggested changes, withdraw their invoice, or submit their counter proposal. The negotiation continues until the issues are finally resolved. Suppliers can also negotiate online via iSupplier Portal. All changes and comments entered during the collaboration are tracked in Payables and can be viewed at any time.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 12 of 176 Rev Paradigm_revision

Page 13: Edu3fc4y AP

Invoice Requests

Invoice Requests

Invoice Requests are:

• Invoices entered by Suppliers via iSupplier Portal where a purchase order has not been obtained

• Are visible in Oracle Payables

• Are not paid or accounted until the invoice can be verified and approved

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 13 of 176 Rev Paradigm_revision

Page 14: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

• End user training for new UI

• Update supplier information with additional information

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 14 of 176 Rev Paradigm_revision

Page 15: Edu3fc4y AP

Practice 4 Overview: Creating a Supplier

Practice 4 Overview: Creating a Supplier

This practice covers the following topics:

• Creating a Supplier

Practice 4 Overview: Creating a Supplier

Refer to Practice - Creating a Supplier [LAB4185Y]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 15 of 176 Rev Paradigm_revision

Page 16: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 16 of 176 Rev Paradigm_revision

Page 17: Edu3fc4y AP

Deferred Recoverability

Deferred Recoverability

• Accounting process where tax recovery is reported when the invoice is paid

• Accrual (and therefore the settlement and/or reporting) of recoverable taxes is delayed due to special tax rules either enforced by the Tax Authority, or allowed with the agreement of the Tax Authority

Deferred Recoverability

Deferred Recoverability refers to an accounting process where tax recovery is reported when the invoice is paid. The accrual (and therefore the settlement and/or reporting) of recoverable taxes is delayed due to special tax rules either enforced by the Tax Authority, or allowed with the agreement of the Tax Authority.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 17 of 176 Rev Paradigm_revision

Page 18: Edu3fc4y AP

Deferred Recoverability Features

Deferred Recoverability Features

• Accurate reporting and accounting of pending recoverable tax amounts

• Automatic accrual of recoverable tax amounts upon payment

Deferred Recoverability Features

• Accurate reporting and accounting of pending recoverable tax amounts for the recoverable portion of the tax.

• When payment is made, whether fully or partially, the corresponding tax is automatically recorded as recoverable and reversed from the interim recoverable account.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 18 of 176 Rev Paradigm_revision

Page 19: Edu3fc4y AP

Deferred Recoverability Benefits

Deferred Recoverability Benefits

• Global Readiness– Adhere to international tax laws

• Streamlined Operations, Operational Excellence, and Lower Costs– Automatic accrual of recoverable tax amounts obviates

need for manual transfers after payment transactions

– Propensity for manual error is reduced

• Improved Fiscal Discipline– Accounts reflect transactions that have occurred

– Automated accounting reduces auditing time

Deferred Recoverability Benefits

This feature allows you to meet the challenge of adhering to local tax laws that require deferred recoverability whether you need this feature now or plan to expand into new, international markets in the future.

Streamlined operations and operational excellence both contribute to lower costs. Automatic accrual means less time spent accruing accounts manually, providing better control over accounting and reducing the propensity for manual errors.

Fiscal Discipline is improved as General Ledger accounts reflect transactions that have occurred and automated accounting reduces auditing time

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 19 of 176 Rev Paradigm_revision

Page 20: Edu3fc4y AP

Deferred Recoverability Process Part 1: Set Up and Invoice

Deferred Recoverability Process Part 1: Set Up and Invoice

Tax Engine

Tax Set Up

Process 1

E-Business Tax

Interim (deferred) Recoverable Tax

Accounts Payable Liability

X.XX X.XX

Non Recoverable Tax

X.XXExpense/Asset

X.XX

Invoice details

Tax (Includes Interim Recoverable

Tax Distribution Account)

Invoice Header

Invoice Lines

Invoice Distributions

Account

Subledger Accounting

Payables Invoice Entry

Deferred Recoverability Process Part 1: Set Up and Invoice

You must first configure E-Business Tax Service for deferred recoverability and optionally tailor the Subledger Accounting definition if needed for accounting.

• During Invoice Entry, Validation, and Import, Payables gathers information known as tax drivers that are entered on the invoice header and lines and passes that information to the new e-Business Tax module.

• Based on these tax drivers and additional information derived by e-Business Tax such as the supplier’s party tax profile and buyer’s and supplier’s tax registrations, the engine determines the applicable tax, returns both recoverable and non-recoverable amounts and, in the case of deferred recoverability, the interim tax General Ledger account for recoverable taxes.

• Payables displays the tax amount in a column on the Invoice Header and in the Summary region, creates the tax lines in the Lines tab, and records the Distributions including the interim recoverable tax account.

• When the Invoice is Accounted, the interim recoverable tax account is posted to General Ledger.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 20 of 176 Rev Paradigm_revision

Page 21: Edu3fc4y AP

Deferred Recoverability Process Part 2: Set Up and Payment

Deferred Recoverability Process Part 2: Set Up and Payment

InvoicesInvoicesTax Set Up

Process 2

Payables Payment E-Business Tax

Recoverable Tax

X.XX X.XX

Accounts Payable Liability

X.XX

Invoice details

Recoverable Tax Distribution Accounts

Invoices

Account

Payment Invoices with Deferred Recoverability ?

Calculate Recoverable Amounts, Record

Distributions

Optional Set Up

Cash Clearing

X.XX

Interim (deferred) Recoverable Tax

Subledger Accounting

Deferred Recoverability Process Part 2: Set Up and Payment

At payment time, Payables determines if the invoices being paid are subject to deferred recoverability. If so, Payables requests the distribution accounts for the recoverable tax from E-Business Tax.

Payables determines how much is recoverable based on how much of the invoice is paid, then records the amount and corresponding distribution account.

When the payment is accounted, the interim recoverable tax account is reversed and the recoverable tax is posted to General Ledger.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 21 of 176 Rev Paradigm_revision

Page 22: Edu3fc4y AP

Setup Taxes with Deferred Recoverability

Setup Taxes with Deferred Recoverability

DeferredTax Rate

DeferredTax Status

•Tax Expense

•Recoverable Tax

•Interim Tax (used for Accrual Based accounting only)

DeferredTax

DeferredRegime

Tax AccountsDefault Recovery Settlement

Allow Tax Recovery

Level

Setup Taxes with Deferred Recoverability

• Responsibility: Payables

• Navigation: Setup > Tax > E Business Tax Home > Task List > Task Configuration > [Tax Regime, Tax, Tax Status, Tax Rate] > Create > Controls and Defaults > Allow Tax Recovery

To enable taxes with deferred recoverability, enable the Allow Tax Recovery and the Default Recovery Settlement options at the Regime, Tax, Tax Status, or Tax Rate levels. Set the Default Recovery Settlement option to Deferred.

In addition, when you set up a Tax with deferred recoverability, ensure that you define the following Tax Accounts for that tax:

• Tax Expense

• Recoverable Tax

• Interim Tax (used only for Accrual Based accounting)

The default account for recoverable taxes in Subledger Accounting is Accounts Payable deferred. You can change this account if necessary.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 22 of 176 Rev Paradigm_revision

Page 23: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

Common Module Dependency:

• E-Business Tax– The e-Business Tax engine is responsible for calculating

tax amounts applicable to invoices.

– E-Business Tax configuration qualifies taxes with attributes to meet tax compliance requirements.

Common Module Interaction:

• Subledger Accounting: A general tool to configure accounting entries and provide accounting reports.

Implementation Considerations

E-Business Tax is a common module available with Oracle Financial Applications.

• The e-Business Tax engine is responsible for calculating tax amounts applicable to invoices.

• E Business Tax configuration qualifies taxes with attributes to meet tax compliance requirements

Subledger Accounting is also a common module available with Oracle Financial Applications. Subledger Accounting is not specific to this feature but a general tool to configure accounting entries and to provide accounting reports to meet your needs.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 23 of 176 Rev Paradigm_revision

Page 24: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payable

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 24 of 176 Rev Paradigm_revision

Page 25: Edu3fc4y AP

Enhanced Asset Tracking

Enhanced Asset Tracking

• Enhanced Asset Tracking– Item Description

– Manufacturer

– Model

– Serial Number

– Warranty Number

• Enhanced Mass Additions – Asset Book

– Asset Category

– IPV/ERV distributions

Enhanced Asset Tracking

R12 provides the ability to track attributes of an item, such as manufacturer, serial number, from Purchasing through Accounts Payable to Fixed Assets. This increases processing efficiency and eliminates manual updates in FA that may have been required in the past.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 25 of 176 Rev Paradigm_revision

Page 26: Edu3fc4y AP

Enhanced Asset Tracking Benefits

Enhanced Asset Tracking Benefits

• Increased efficiency and reduced costs– Asset information typically entered on a purchase order

can now flow seamlessly into Payables and Assets.

• Improved accuracy of information– The Create Mass Additions process can now be

submitted to select invoice distributions by specific Asset Book.

Enhanced Asset Tracking Benefits

Increased Efficiency and Reduced Costs

• Asset information typically entered on a purchase order, such as manufacturer, serial number, and model number, can now flow seamlessly into Payables and Assets.

Improved accuracy of information

• The Create Mass Additions process can now be submitted to select only those invoice distributions with a specific Asset Book, reducing the possibility of errors that need to be manually corrected.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 26 of 176 Rev Paradigm_revision

Page 27: Edu3fc4y AP

Enhanced Asset Tracking Process

Enhanced Asset Tracking Process

Enter Payables Invoice andmatch to Purchase Order or

Import Purchasing matched invoice

Optionally update asset informationon invoice line or distribution, including

asset book and asset category

PAYABLES PROCESS

Submit Create Mass Additions process to transfer assets to

Oracle Assets

Payables retains assetinformation such as:

manufacturer, serial number, asset book and category

Automated process

Enhanced Asset Tracking Process

• Enter or import a Payables Invoice and Match to Purchase Order.

• Payables retains the asset information.

• Optionally, update asset information on the invoice line or distribution.

• Submit the Create Mass Additions Process to transfer the Assets.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 27 of 176 Rev Paradigm_revision

Page 28: Edu3fc4y AP

Invoice Lines

Invoice Lines

Invoice Lines:

• Represent goods or services as lines with distributions tied to each line

• Facilitates the capture and transfer of pertinent information from Oracle Projects and Oracle Assets

• Enables line level approval and matching between an invoice line and a purchase order shipment pay item

Invoice Lines

Oracle Payables incorporates Invoice Lines into the invoice model. Adding Invoice Lines is a key architectural change, which enables Oracle Payables to better model the paper or electronic business document yet maintain key features that exist at the invoice distributions level.

Merged into the current invoice transaction business flows, Invoice Lines support the representation of the goods or services as well as tax, freight, and other charges as lines with distributions tied to each line. Additional fields record attributes such as serial numbers and item descriptions.

This feature offers the ability for line level approval and matching between an invoice line and a purchase order shipment pay item, or receipt. Furthermore, it facilitates the capture and transfer of additional, pertinent information to and from Oracle Projects and Oracle Assets.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 28 of 176 Rev Paradigm_revision

Page 29: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

Do the enhanced asset tracking features require re-evaluation of asset tracking policies?

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 29 of 176 Rev Paradigm_revision

Page 30: Edu3fc4y AP

Practice 5 Overview: Matching to Purchase Order

Practice 5 Overview: Matching to Purchase Order

This practice covers the following topics:

• Matching to Purchase Order

Practice 5 Overview: Matching to Purchase Order

Refer to Practice - Matching to Purchase Order [LAB4186Y]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 30 of 176 Rev Paradigm_revision

Page 31: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 31 of 176 Rev Paradigm_revision

Page 32: Edu3fc4y AP

Payment Requests Key Concepts

Payment Requests Key Concepts

Payment Request

• A request for payment to Oracle Payables without requiring a supplier, purchase order or standard invoice– Oracle Loans: Loan Funding Disbursement

– Oracle Receivables: non-credit card Customer Refund Requests

Payee

• Designated party to which the payment will be made

• A payee can be a supplier, borrower, or customer

Payment Requests Key Concepts

Payment Request: A request for payment without requiring a supplier, purchase order or standard invoice.

• In Release 12, Oracle Loans uses this feature for Loan Funding Disbursement and Oracle Receivables for non-credit card Refund Requests.

Payee: The party on the payment request to which payment will be made. This definition also applies to supplier invoices. The result is that the payee can be a supplier, borrower, or a customer.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 32 of 176 Rev Paradigm_revision

Page 33: Edu3fc4y AP

Payment Requests Description

Payment Requests Description

Receivables

Loans

Payment Request

Account payables department approves

request

submits

If requires approval, PayablesLaunches Workflow

Payables applies holds, if necessary Pay

No approval required

Payment Requests

You can use Payables to disburse funds to a party (a payee) who is not defined as a trading partner in your supplier master. E-Business Suite products, such as Oracle Receivables and Oracle Loans, can submit disbursement requests to Payables, where you can disburse the funds and manage the payment process using the payment management features that are available in Payables. When a disbursement request is submitted to Payables, it is recorded as a payment request.

Using payment requests you can:

• Approve payment requests using the Invoice Approval Workflow

• Account for payment requests, through Payables' integration with Oracle Subledger Accounting

• Calculate and manage tax, through Payables' integration with Oracle E-Business Tax

• Pay and report on payment requests

You can submit a payment request from another application, for example, from Receivables to pay a customer for an On Account Credit Memo, or from Loans to disburse funds for a loan, and Payables will verify, account, tax, and approve the payment request. You can

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 33 of 176 Rev Paradigm_revision

Page 34: Edu3fc4y AP

track the progress of the payment request in the originating application. Once the payment request is approved, you can report and audit the payment request in Payables.

You can only submit a payment request from other applications; you cannot enter a payment request for a payee directly in Payables.

The payment request process is as follows:

1. Submit a request to disburse funds from another application, such as Receivables or Loans. Note that you cannot submit a payment request in Payables.

2. Payables automatically creates a payment request, in real-time.

3. Once the payment request is created, you can search for it just as you would search for an invoice. Enter Payment Request in the Type field and enter the payee name in the Trading Partner field. Note that because the payee is not a supplier, do not enter a Supplier Number.

4. If the payment request requires approval, use the Invoice Approval Workflow to approve payment requests.

5. Payables applies holds to the payment request if there are any exceptions.

6. Once the holds are released and the payment request is approved, it can be paid as a single payment or as part of a payment batch. Once the payment request is paid, your auditors can view the request to disburse funds in the originating application and the payment request in Payables.

Once you enter a payment request, you cannot delete the payment request or update the payment request fields. If necessary, you can cancel the payment request or void the payment, just as you would for an invoice. Payables notifies the originating application to respond to these actions.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 34 of 176 Rev Paradigm_revision

Page 35: Edu3fc4y AP

Payment Requests Benefits

Payment Requests Benefits

• Benefits for Payables managers– Ensures the Integrity of Supplier Master

— Do not complicate Supplier Master with non-supplier payees

– Provides Payables transparency— Provides visibility and control over items for payment

processing

• Benefits for other E-Business Suite products– Leverages the Payables product for all payment needs

– Leaves the required knowledge base in Payables without complicating your business model or employee structure

– Provides visibility into the current status

Payment Requests Benefits

For Payables:

• Ensures that your Supplier Master stays clean.

• By centralizing disbursements requests for your company in Payables, it empowers the Payables Manager with visibility and control over the items selected for payment processing plus comprehensive liability and payment reporting.

Other E-Business Suite products:

• Can leverage what Payables already offers from an Oracle Financials product to the trained personnel on your Payables team.

• Have visibility to the current, detailed status of their request.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 35 of 176 Rev Paradigm_revision

Page 36: Edu3fc4y AP

Payment Requests Process

Payment Requests Process

Report

Oracle Receivables

E-Business Suite Product

Receipts

On Account Credit Memos

VerifyAccount

TaxApprove

Payables

Payment Request

Payment Request IDOracle Loans

Loans

Payment Request

PaymentPayment Request Status

Payment Requests Process

The Receipts, Credit Memo’s and Loans are handled outside of Payables The Payment Request is submitted to Payables where Payables Verifies, Accounts, Taxes and Approves, depending on the requesting product’s requirements. During Payables processing the requesting products are kept up to date. Once any exceptions have been handled and the payment request is approved, Payment takes place, allowing reporting and auditing of the payment request process.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 36 of 176 Rev Paradigm_revision

Page 37: Edu3fc4y AP

Oracle Receivables – Refund Example

Vision Corporation

Payables

ApprovePayment Manager

Manages items to be paid

Payment Transacted to Payee

Customer Receives Payment $5000.00

ABC Company

Purchases: 3 Copy Machines

Returns 1 Copy Machine for Refund

Vision Corporation Receivables

Manages Receivables Transactions for return

Initiates Payables Request $5000.00

View Status if needed

Vision Corporation

Ship

Return

Refund

Pay

Payment Request for $350,000

Payment Request for

$5000

Oracle Receivables – Refund Example

Oracle Receivables – Refund Example

Here is an example of the business processes surrounding a Refund Request from Oracle Receivables. ABC Company has purchased and paid for 3 Copy Machines. They then decide to return one and ask for a refund.

Within Vision Corporation, the Order Management system manages the return and submits a credit memo to Receivables. Vision Corporation’s Receivables staff verifies that the initial payment was made and that, due to the credit memo, they must initiate a Payment Request to their Payables Department.

Next, the Payment Request is submitted for approval, leveraging Oracle Payables Invoice Approval Workflow. The Payables staff may also manage any specific Payables’ attribute verification issues they may need for successful payment processing. Once the Payment Request is approved and there are no holds, the payment manager has control over all items to be paid including the Payment Request. Once paid, the customer receives the refund.

Note: The Vision Corporation Receivables Analyst can view the Refund Status Window at any time.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 37 of 176 Rev Paradigm_revision

Page 38: Edu3fc4y AP

Funds Disbursement Process- Loans

Payment Manager

Visibility to all Payables’ Liabilities

Manages items to be paid

Reports to Upper Management

Funds Disbursement Process- Loans

IGNF Foods

Requests a Loan for350,000 from Vision Loans

Vision Loans

Application Processing

Risk Management

Approvals

Fund

Vision Loans Payables

Payment Request

for $350,000

Loan Funded

Sends Borrower Payment

Funds Disbursement Process- Loans

IGNF Foods requests a loan from Vision Loans for $350,000. The loan agent handles the Application Processing, Manage Risk, and follows through with the necessary approvals for the loan. Once the loan is approved, the loan agent can request that the loan be funded, which immediately creates a payment request to Payables. The payment manager has visibility into the payable liabilities, and manages the items to be paid, and has the information available to provide key updates to upper management as needed. If there are no holds, the payment request is paid to the borrower and the loan considered funded. Oracle Loans has its own approval process and does not require Payables invoice approval. Also, tax calculation is not required for loan disbursements.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 38 of 176 Rev Paradigm_revision

Page 39: Edu3fc4y AP

Payment Request – Additional Payables Actions

Payment Request – Additional Payables Actions

Void

Oracle Receivables

E-Business Suite Product

Receipts

On Account Credit Memos Cancel

Payables

Payment Request Cancelled

Oracle Loans

Loans

Payment Request

PaymentPayment Voided

Payment Request – Additional Payables Actions

Payables users may need to void the payment and cancel the payment request.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 39 of 176 Rev Paradigm_revision

Page 40: Edu3fc4y AP

Payment Requests: Synchronizing Between Products

Payment Requests: Synchronizing Between Products

• Payables provides the ability for requesting E-Business Suite products to respond to actions taken on the payment request. These actions include:– Canceling the payment request

– Voiding the payment

• To ensure that the Payment Request details remain the in sync between Payables and the requesting E-Business Suite product, Payables prevents:– Deletion the Payment Request

– Update to many fields

Payment Requests: Synchronizing Between Products

Payables provides the ability for requesting E-Business Suite products to respond to actions taken on the Payment Request. These actions include:

• Canceling the payment request and/or

• Voiding the payment

Payables also prevents deletion of the payment request and any update to many fields.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 40 of 176 Rev Paradigm_revision

Page 41: Edu3fc4y AP

Payment Requests Reporting

Payment Requests Reporting

Includes Payment Requests for forecasting cash needs

Cash Requirement Report

Modified to include Payment Requests in revaluating balances

Open Items Revaluation Report

Expanded to include Payment Requests on Hold

Invoice On Hold Report

Expanded to include Payment Requests by sequential voucher number

Invoice Audit Listing By Voucher Number

Modified to show payment requests in the approval workflow process

Invoice Approval Status Report

Includes Payment Requests in Aging Report

Invoice Aging Report

ChangeReport Name

Payment Requests Reporting

The reports shown have been updated to include Payment Requests providing the needed visibility to all your payable liabilities.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 41 of 176 Rev Paradigm_revision

Page 42: Edu3fc4y AP

Payment Requests Optional Setup

Payment Requests Optional Setup

Oracle Payments Oracle PaymentsApprovals

Management

Payment Method Controls

Payment Method Defaulting Rules

Payment Instruction and Report Formats

Payment Attribute Validations

Payment Process Profiles

Disbursement Options

Payables Options:Enable Invoice Approval Workflow

Approval RulesAP Invoice Approval

Payment Requests Optional Setup

• Responsibility: Payables

• Navigation: (N) Setup: Options > Payables Options : (T) Approval

For Payables or Payments, there is no specific setup to utilize the Payment Requests feature, however these are some setups that you can do that will add value to your Payment Request Business Flows.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 42 of 176 Rev Paradigm_revision

Page 43: Edu3fc4y AP

Payment Requests Miscellaneous Set up

Payment Requests Miscellaneous Set up

• Document Sequencing - Payment Request Category

• Payables and Financial Options

Payment Requests Miscellaneous Set up

If the Sequential Numbering profile is set to Partially Used or Always Used, Payables defaults the “Payment Request” Document Category to the payment request. Ensure that you have assigned a sequence to the document category.

Depending on the extent of information provided by the E-Business Suite product submitting the Payment Request, Payables may default attributes from the Payables and Financials Options setups. These attributes include: Liability GL Account, Payment Terms, Pay Group, and Terms Date Basis.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 43 of 176 Rev Paradigm_revision

Page 44: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

Interactions with:

• Oracle Payables & Payments

• Oracle XML Publisher

• Oracle Approvals Management / Workflow (Optional)

• Oracle Loans; Oracle Receivables

Implementation Considerations

The Payment Requests feature interacts with the other eBusiness Suite products shown.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 44 of 176 Rev Paradigm_revision

Page 45: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 45 of 176 Rev Paradigm_revision

Page 46: Edu3fc4y AP

Payment Method Controls and Enhanced Payment Information

Payment Method Controls and Enhanced Payment Information

• Enhanced Payment Method Controls

• Expanded Payment Attribute Availability and Defaulting

• Configurable Payment Attribute Validation

• Extensive Format and Reporting Capabilities

Payment Method Controls and Enhanced Payment Information

Enhanced Payment Method Controls allow users to control the availability of payment methods by Legal Entity, Operating Unit, Transaction Type, and Foreign or Domestic Currency and Locations.

Invoices now include additional payment attributes that can default from the payee or be entered directly by Payables users on the invoice.

To further compliment the attribute availability, you can configure attribute validation for items on the invoice and payee to ensure seamless payment processing or in-house check printing and add data integrity to your reports.

We have provided extensive format and reporting capabilities giving you the ability to meet your remittance and payment report needs by leveraging XML Publisher.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 46 of 176 Rev Paradigm_revision

Page 47: Edu3fc4y AP

Key Concepts

Key Concepts

• Document Payable: A document to be paid by the deploying company (Payer)

• Payee: The person or organization that is being paid

• Payment Process Request: The process of requesting the payment processing for a group of invoices

• Payment Instruction: Formatted payment information that is either transmitted to a financial institution for payment or used in-house to print check documents

Key Concepts

• Document Payable: A scheduled payment on the invoices in Oracle Payables.

• Payee: The person or organization that will be paid. For example, the supplier, employee, borrower, or even the customer to whom the payment is made out to.

• Payment Process Request: A way to group invoices for payment, then request payment processing for those invoices. This may sometimes be referred to as Payment Batches or Pay Runs.

• Payment Instruction: The formatted payment information that is either transmitted to a financial institution for payment or used in-house to print check documents.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 47 of 176 Rev Paradigm_revision

Page 48: Edu3fc4y AP

Key Concepts

Key Concepts

• Payment Process Profile: Usage and grouping rules, bank assignments, payment instructions and reporting, and connectivity for electronic filing

• Oracle Payments: E-Business Suite module leveraged to group invoices into payments, create instructions, and print or communicate with the bank

Key Concepts

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Process Profiles

Each Payment Profile controls:

• When the profile is used based on lists of operating units, payment methods, banks, and currencies

• How the documents should be grouped into payments

• How the payments should be grouped into payment instructions

• Which formats should the payment instructions and reports use

• Which transmission protocol should be used to transmit the payment file

Oracle Payments

Oracle Payments is an E-Business Suite module Payables uses to group invoices into payments, create instructions, and print or communicate with the bank.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 48 of 176 Rev Paradigm_revision

Page 49: Edu3fc4y AP

Key Concepts

Key Concepts

• Payment Method: Document payable attribute that indicates how the payer is going to make the payment

• The Payment Method, Banking Relationships, and Reporting Requirements drive Payment Method -Based Payment Processing including: – Payment attribute validations executed on the invoice to

catch errors early

– Payment attribute validation at payment time based on your processing choices to catch errors before they go out the door

– Data rich payment instructions and reporting

Key Concepts

Payment Method is an attribute on the document payable that indicates how the payer is going to make the payment. However, it is also the basis for determining what payment choices to offer and, based on payment instruction and reporting needs, the payment attributes required to make that process successful.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 49 of 176 Rev Paradigm_revision

Page 50: Edu3fc4y AP

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Banking Relationships

Vision Operations

Payment Method Choices

Attributes to communicate to bank

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

When evaluating payment method policies, first look at the payment method choices your banks offer and the information they require.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 50 of 176 Rev Paradigm_revision

Page 51: Edu3fc4y AP

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Banking Relationships

Vision Operations

Reporting Requirements

Legal EntityOperating UnitTransaction TypeForeign or Domestic CurrencyForeign or Domestic LocationReporting Requirements

Payment Method Choices

Attributes to communicate to bank

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Next, evaluate your internal organization and business processes. You have the ability to control the availability of payment methods based on:

• Legal Entity

• Operating Unit

• Transaction Types such as customer refunds verses supplier payments

• Foreign or Domestic Currencies

• Foreign or Domestic Locations

Also evaluate any reporting needs to understand what is required based on the payment method and perhaps other indicators such as foreign or domestic.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 51 of 176 Rev Paradigm_revision

Page 52: Edu3fc4y AP

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Banking Relationships

Vision Operations

Reporting Requirements

Payee Relationship

Legal EntityOperating UnitTransaction TypeForeign or Domestic CurrencyForeign or Domestic LocationReporting Requirements

Payee PreferencesPayment Reconciliation to Open Debt

Payment Method Choices

Attributes to communicate to bank

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Determine if you will allow payee’s to have their own payment method preferences. For example, you may offer employee expense reports to be paid using the preferred payment method of the employee but for supplier invoices for a particular operating unit, you expect checks to be printed only.

Evaluate other preferences you may offer such as payment delivery options, bank charge bearer, and settlement priority. Evaluate what information your payee’s may require to successfully apply your payments to their open receivables.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 52 of 176 Rev Paradigm_revision

Page 53: Edu3fc4y AP

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Invoice

Payment

Banking Relationships

Vision Operations

Payment Method Policy

Payee Payment Attributes

Payment Processing Configuration

Reporting Information and Styles

Reporting Requirements

Payee Relationship

Payment Information

Evaluate Payment Choices – Reporting and Payment Instruction Requirements

Based on your evaluation:

1. Define your payment method policy including usage rules and your payee payment preferences control.

2. Enter other payment related attributes for your Payees.

3. Review the formatting requirements for printing in-house checks or transmitting electronic instructions. Create Payment Process Profiles to bring the Reporting Requirements, Banking Relationships, and Payee needs together when processing your Payments.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 53 of 176 Rev Paradigm_revision

Page 54: Edu3fc4y AP

Enhanced Payment Method Controls Description

Enhanced Payment Method Controls Description

• Users can create new Payment Methods as needed

• A Policy can be defined for the Payment Method usage based on:– Oracle Application

– Legal Entity

– Operating Unit

– Transaction Type

– Foreign or Domestic Currency

– Foreign or Domestic Location

Enhanced Payment Method Controls Description

With this feature, payment methods expand from the simple lookup for check, EFT and WIRE to a controlled policy based on offerings by your bank, your internal organization and business processes, and any reporting you may need internally or externally to government offices or suppliers.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 54 of 176 Rev Paradigm_revision

Page 55: Edu3fc4y AP

Enhanced Payment Method Controls Benefits

Enhanced Payment Method Controls Benefits

• Provide the ability to set up multiple Payment Methods to meet specific business requirements

• Controlled availability of Payment Methods

Enhanced Payment Method Controls Benefits

This feature provides the ability to configure your own Payment Method policies as and when you need providing flexibility, adaptability and controlled availability.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 55 of 176 Rev Paradigm_revision

Page 56: Edu3fc4y AP

Enhanced Payment Method Controls Process – Enter Payables Document

Enhanced Payment Method Controls Process –Enter Payables Document

• iSupplier Portal• Import

Supplier

Payables Analyst

Employee: Decentralized Invoice Entry

• Payables Requests

• Quick Invoice• Invoice Workbench• Recurring Invoices

• Pay On Receipt Import• Payment Requests• Expense Reports

Enhanced Payment Method Controls Process – Enter Payables Document

There are many ways to create invoices in Payables whether your supplier is sending an EDI or XML file or entering it via Oracle iSupplier Portal, your Payables’ analysts are entering them, or they are imported from another Oracle E-Business Suite application. Your payment method controls will be followed based on key elements on the invoice itself. These include:

• The E-Business Suite Application

• Operating Unit

• Legal Entity

• Type

• Trading Partner

• Supplier Site

• Invoice Currency

• Functional Currency

Note that all Invoice Types are considered as having the Payables Document Payment Processing Transaction Type with the exception of Expense Reports and Payment Requests. The Product will always be Payables with the exception of Payment Requests where we process on behalf of the calling product such as Oracle Loans and Receivables.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 56 of 176 Rev Paradigm_revision

Page 57: Edu3fc4y AP

Enhanced Payment Method Controls Process – Enter Payables Document

Enhanced Payment Method Controls Process –Enter Payables Document

• Payment Method defaults based on your configuration.

• The attributes on invoices meet requirements to default the payment method via the Defaulting Rules.

• The Disbursement System Options allow for the Payee’s default to override.

• You can define a default payment method for the Supplier Site (for example, “Check”)

• If you need to override the default, the List of Values displays the Payment Methods that meetthe Usage Rules defined for the Payment

Methods.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 57 of 176 Rev Paradigm_revision

Page 58: Edu3fc4y AP

Expanded Payment Attribute Availability and Defaulting - Definition

Expanded Payment Attribute Availability and Defaulting - Definition

Payment attributes are items on the document payable that play a role in:

• Successful payment processing of a document payable

• Reporting requirements

• Payee payment and remittance

Expanded Payment Attribute Availability and Defaulting – Definition

Payment Attributes are items on the document payable that play a role in:

• The successful payment processing of a document payable

• Meeting requirements for internal reporting

• Payee payment and remittance

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 58 of 176 Rev Paradigm_revision

Page 59: Edu3fc4y AP

Expanded Payment Attribute Availability and Defaulting Description

Expanded Payment Attribute Availability and Defaulting Description

• Global Descriptive Flexfields (GDFs) for payment and remittance processing are now available as fields on the invoice

• Payee Payment Processing Preferences for Defaulting

• Bills Payable (Promissory Notes, Future Dated Payments) defined for the Payee

Expanded Payment Attribute Availability and Defaulting - Description

In previous releases of Oracle Payables, many of the payment attributes were part of localizations and involved defining Global Descriptive Flex Fields on the Supplier Site, Supplier Bank Account, or on the Invoice. Many of these attributes have been shifted to specific fields within Payables.

You can assign payment processing values to the Payee such as payment and remittance advice delivery instructions.

The payment processing attributes can also be used with a payment method marked for Bills Payable when creating payments with a future maturity date.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 59 of 176 Rev Paradigm_revision

Page 60: Edu3fc4y AP

Expanded Payment Attribute Availability and Defaulting - Benefits

Expanded Payment Attribute Availability and Defaulting - Benefits

• Enhance supplier/payee relationships

• Minimize data entry

• Facilitate payee’s reconciliation of payments and open debts

• Satisfy reporting requirements

Expanded Payment Attribute Availability and Defaulting – Benefits

The benefits include the ability to:

• Enhance your supplier relationships by capturing and utilizing payee payment preferences.

• Minimize time consuming data-entry with Payment Attribute Defaulting.

• Payee’s reconciliation of payment and open debt is facilitated by unique remittance identifier and remittance messages.

• You can meet the reporting requirements of your country or company by utilizing payment attributes such as Payment Reason and Payment Reason Comments.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 60 of 176 Rev Paradigm_revision

Page 61: Edu3fc4y AP

Expanded Payment Attribute Availability and Defaulting – Enter Payables Document

Expanded Payment Attribute Availability and Defaulting – Enter Payables Document

• iSupplier Portal• Import

Supplier

Payables Analyst

Employee: Decentralized Invoice Entry

• Payables Requests

• Quick Invoice• Invoice Workbench• Recurring Invoices

• Pay On Receipt Import• Payment Requests• Expense Reports

Expanded Payment Attribute Availability and Defaulting – Enter Payables Document

The payment attributes defined for the Payee default onto the invoices created in Payables no matter where the invoices are entered. As mentioned, Payment Attributes are pulled from the invoices being paid and the Payee during payment processing and reporting. Since there are so many ways for invoices to be entered, the defaulting of payment attributes lessens the data entry burden and risk of missing information.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 61 of 176 Rev Paradigm_revision

Page 62: Edu3fc4y AP

Expanded Payment Attribute Availability and Defaulting - Payment Attributes Defaulting

Expanded Payment Attribute Availability and Defaulting - Payment Attributes Defaulting

• For Payables users, the Invoice Workbench is accessed through the folder form technology.

• The Payment Method, Remit To Bank Account Number and Name, and Remittance Messages are used to default to the Scheduled Payments.

• Users can enter the Unique Remittance Identifier and Check Digit per invoice and Remittance Messages per scheduled payment.

Expanded Payment Attribute Availability and Defaulting - Payment Attributes Defaulting

• For Payables users, the Invoice Workbench is accessed through the folder form technology; you can tailor the UI for updating defaulted values or entering them.

• The Payment Method, Remit To Bank Account Number and Name, and Remittance Messages do appear on the Invoice Header, however, these are used to default to the Scheduled Payments.

- The Payment Method Defaults from Defaulting Rules or Payee

• Users can enter the Unique Remittance Identifier and Check Digit per invoice and Remittance Messages per scheduled payment which can be used to help suppliers reconcile the payments with their open receivables if provided on the remittance advice.

• Payment Attributes default from Supplier Payment Details setup.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 62 of 176 Rev Paradigm_revision

Page 63: Edu3fc4y AP

Expanded Payment Attribute Availability and Defaulting - UI

Expanded Payment Attribute Availability and Defaulting - UI

• Quick Invoices: The Quick Invoices UI also has the same capabilities as Payment Attributes Defaulting

• Payment Attributes for Recurring Invoices default under the Payment Tab. The Payment Tab values are transferred to the subsequent invoices that are created.

Expanded Payment Attribute Availability and Defaulting – UI

• Responsibility: Payables

• Navigation: Invoices : Entry > Quick Invoices

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 63 of 176 Rev Paradigm_revision

Page 64: Edu3fc4y AP

Practice 6 Overview: Entering Quick Invoices

Practice 6 Overview: Entering Quick Invoices

This practice covers the following topics:

• Entering Quick Invoices

Practice 6 Overview: Entering Quick Invoices

Refer to Practice - Entering Quick Invoices [LAB4187Y]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 64 of 176 Rev Paradigm_revision

Page 65: Edu3fc4y AP

Configurable Payment Attribute Validation Description

Configurable Payment Attribute Validation Description

• Enhanced Invoice Entry Validation – Configure validation on the Payment Method to meet your

business needs

– Analyze and resolve validation issues upfront at invoice-entry time

• Enhanced Payment Processing Validation– Configure validation on the Payment Format and

Payment Process Profile to meet your business needs

– Payment Manager can analyze and resolve validation exceptions or Automatically remove the Invoices to resolve issues while keeping payment processing streamlined

Configurable Payment Attribute Validation Description

Enhanced Invoice Entry verification is achieved by specifying validations on the Payment Method. Any issues will result in invoices being put on Scheduled Payment holds. This gives Payables personnel the ability to analyze and resolve validation failures at invoice-entry time.

Enhanced Payment Processing validation is achieved by specifying validations on the Payment Instruction Format assigned to the Payment Process Profile.

The Payables staff member that manages the payment process can specify what they would like to happen to the pay run if validation exceptions for invoice attributes or payment attributes are found during payment processing, then resolve those issues.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 65 of 176 Rev Paradigm_revision

Page 66: Edu3fc4y AP

Configurable Payment Attribute Validation Benefits

Configurable Payment Attribute Validation Benefits

• Increased Payment Process Efficiency - On time Payments

• Reduce Problem/Resolution Costs– Reduce Check Stock Waste

– Catch Errors before send the file to the bank

Configurable Payment Attribute Validation Benefits

• Both upstream Invoice Entry and downstream Payment Processing validations increase payment process efficiency by notifying users of problems at key processing points.

• The flexible validation model reduces the effort and cost required to resolve problems and to catch issues before there is wasted check stock or fees charged by your bank.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 66 of 176 Rev Paradigm_revision

Page 67: Edu3fc4y AP

Configurable Payment Attribute Validation Invoice: Scheduled Payment Holds

Configurable Payment Attribute Validation Invoice: Scheduled Payment Holds

Find and resolve payment related issues upfront during Invoice entry: Payment Method Validation

• General Tab: Scheduled Payment Holds

• Scheduled Payments Tab: Hold Details

Configurable Payment Attribute Validation Invoice: Scheduled Payment Holds

Example: A Payables analyst enters an invoice for the supplier “Universal Paper Company”, and the Payment Method “Payables Direct Deposit” defaults.

• The Payment Method definition can have a validation that requires the Payment Reason entry. However, if the Supplier setup does not have the value for Payment Reason, it will not default on the invoice.

• If the Payables analyst forgets to choose a value from the list of values, when the invoice is saved, it is put on Scheduled Payment Hold with the Hold Reason “Payment reason is required”

• The user must resolve the issue and remove the hold.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 67 of 176 Rev Paradigm_revision

Page 68: Edu3fc4y AP

Configurable Payment Attribute Validation Invoice: Invoice on Hold Report

Configurable Payment Attribute Validation Invoice: Invoice on Hold Report

• The Invoice on Hold report is a tool to identify and analyze all the invoice holds including scheduled payment holds.

• The Invoices on Hold Report lists:– Payment schedule holds for payment method validation

– Invoice entry status

– Imported invoice status

Configurable Payment Attribute Validation Invoice: Invoice on Hold Report

• This report can be used to help catch errors from Payables data entry or for Imported Invoices.

• Operating Unit, Hold Name, Trading Partner, Entered Date range, Due or Discount date range are some of the parameters you can enter to select invoices.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 68 of 176 Rev Paradigm_revision

Page 69: Edu3fc4y AP

Practice 7 Overview: Running Hold Reports

Practice 7 Overview: Running Hold Reports

This practice covers the following topics:

• Running Hold Reports

Practice 7 Overview: Running Hold Reports

Refer to: Practice - Running Hold Reports [LAB4188Y]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 69 of 176 Rev Paradigm_revision

Page 70: Edu3fc4y AP

Configurable Payment Attribute Validation Payment: Payment Processing Choices

Configurable Payment Attribute Validation Payment: Payment Processing Choices

• During the payment process, determine what should happen if validation errors occur.

• Separately, determine how you would like payment level validation issues to be handled.

• The Payment Template User Interface is used when scheduling Payment Process Requests and can be used when submitting an “on demand” pay run allowing you to override the template value when you submit.

Configurable Payment Attribute Validation Payment: Payment Processing Choices

• Responsibility: Payables

• Navigation: Payments : Entry > Payments Manager > (T) Templates > (B) Create

During the payment process, determine what should happen if validation errors occur. The first choice is if there are document validation errors. There are four options here:

• Stop the Process For Review allowing you to review the issue and determine if you can correct it or would like to manually remove the invoices with issues.

• Reject Only Documents with errors – this will allow invoices that do not have errors to continue in the payment process.

• Reject All Documents for the Payee when a document fails – this will reject all the documents for the Payee as soon as one invoice fails letting the invoices for other Payees that did not fail validation continue in the payment process.

• Reject all the Documents in the Payment Process Request, in which case, the payment process will stop and the payment process request will be cancelled.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 70 of 176 Rev Paradigm_revision

Page 71: Edu3fc4y AP

Separately, determine how you would like payment level validation issues to be handled.

• Stop the Process For Review allowing you to review the issue and determine if you can correct it or would like to manually remove the invoices with issues.

• Reject Only the Payments with errors allowing others to continue.

• Reject all Payments in the payment process request, where, just as in the document case, the entire payment process request will be stopped and cancelled.

One thing to note here is a special case when Payment Time Withholding is enabled – due to withholding thresholds, if validation errors occur, Payables will automatically stop the payment process and cancel the payment process request.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 71 of 176 Rev Paradigm_revision

Page 72: Edu3fc4y AP

Practice 8 Overview: Create a Payment Process Request Template

Practice 8 Overview: Create a Payment Process Request Template

This practice covers the following topics:

• Creating a Payment Process Request Template

Practice 8 Overview: Create a Payment Process Request Template

Refer to: Practice - Creating a Payment Process Request Template [LAB4189Y]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 72 of 176 Rev Paradigm_revision

Page 73: Edu3fc4y AP

Configurable Payment Attribute Validation Payment: Payment Processing Choices

Configurable Payment Attribute Validation Payment: Payment Processing Choices

• The Payables Payment Manager Home Page displays Payment Process Requests that Require Actions, including validation errors

• The Pending Actions area displays payment process requests with validation errors

• Based on the Payment Process Request Status, you are directed to the correct UI to manage the action by clicking on the Start Action icon

Configurable Payment Attribute Validation Payment: Payment Processing Choices

Should validation errors occur, the results are shown directly on the Payment Manager Home Page. The Pending Actions area displays payment process requests with validation errors where the user chooses to Stop the Process for Review. Based on the Payment Process Request Status, you are directed to the correct UI to manage the action by clicking on the Start Action icon.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 73 of 176 Rev Paradigm_revision

Page 74: Edu3fc4y AP

Configurable Payment Attribute Validation Payment: Payment Processing Choices

Configurable Payment Attribute Validation Payment: Payment Processing Choices

Use the Payables Payment Process Requests Tab to display rejected or manually removed scheduled payments (invoices.) In addition, you can:

• View the last 10 Payment Process Requests, which are automatically displayed

• Show Request Details to see payment instruction details

• Search/ See Current Status

• Navigate directly to the Action Page if Required

• Cancel Requests

Configurable Payment Attribute Validation Payment: Payment Processing Choices

• Responsibility: Payables

• Navigation: Payments Manager > (T) Payment Process Requests

Navigate to the Payables Payment Process Requests Page to create, monitor, and query payment requests.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 74 of 176 Rev Paradigm_revision

Page 75: Edu3fc4y AP

Practice 9 Overview: Creating a Payment Process Request

Practice 9 Overview: Creating a Payment Process Request

This practice covers the following topics:

• Creating a Payment Process Request

Practice 9 Overview: Creating a Payment Process Request

Refer to: Practice - Creating a Payment Process Request [LAB418AY]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 75 of 176 Rev Paradigm_revision

Page 76: Edu3fc4y AP

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting - Benefits

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting - Benefits

• Reduce Reaction Time to Changing Banking Relationships - Flexible, Adaptable Payment Instruction Formats

• Facilitate Payee’s reconciliation of payments and open debts

• Satisfy Reporting Requirements

Expanded Payment Attribute Availability Payment Instructions Formats and Reporting - Benefits

The benefits include:

• Reducing the reaction time to changing banking relationships with easily configurable payment instruction formats

• Have the flexibility to provide Payee’s with the information they can best use to apply payments to open receivables.

• Manage the reporting requirements of your country or company and easily adapt to changing requirements.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 76 of 176 Rev Paradigm_revision

Page 77: Edu3fc4y AP

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting

Access the following setup pages from the Payment Administrator page:

• XML Publisher Format Templates

• Formats

• Payment Process ProfilesXML Publisher

Templates

Formats

Payment Process Profiles

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting

• Responsibility: Payables

• Navigation: Setup:Payment > Payment Administrator > Shared Setup > Formats

The first step is to manage the XML Publisher items where you can create and register formatting templates and assign data extracts to payment instructions and reports. Choose the Go To Task Icon for XML Publisher Format Templates.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 77 of 176 Rev Paradigm_revision

Page 78: Edu3fc4y AP

Payment Instruction Formats and Reporting XML Publisher Templates

Payment Instruction Formats and Reporting XML Publisher Templates

• The Payment Instruction Register Template includes the Unique Remittance Identifier

• To create a different report layout or include different data elements, create your new version and register it via this XML Publisher page

XML PublisherTemplates

Formats

Payment Process Profiles

Payment Instruction Formats and Reporting XML Publisher Templates

• Responsibility: Payables

• Navigation: Setup:Payment > Payment Administrator > Shared Setup > Formats > Search area

Search on the “Payments” application and Funds Disbursement data types to view “out of the box” templates. To view the template layout, drill down from the Name link, then click on Download.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 78 of 176 Rev Paradigm_revision

Page 79: Edu3fc4y AP

Payment Instruction Formats & Reporting XML Publisher Templates

Payment Instruction Formats & Reporting XML Publisher Templates

XML PublisherTemplates

Formats

Payment Process Profiles

Payment Instruction Formats & Reporting XML Publisher Templates

This example is a template used to send an electronic file to the bank. Obviously a more technical version of a layout, however, you will see payment attributes available such as Payment Reason, Payment Reason Comments, Bank Charge Bearer, and Settlement Priority. XML Publisher allows you to manage changes or new templates easily and quickly, even for layouts that are following the electronic media spec for your bank or payment processing system.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 79 of 176 Rev Paradigm_revision

Page 80: Edu3fc4y AP

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting

• The Formats page ties the XML Publisher Template to the Payment Disbursement Remittance Formats and Reports.

• There are many types of formats available:– Payment Instructions

– Payment Instruction Accompanying Letter

– Positive Pay File

– Regulatory Reporting

– Payment Instruction Register

– Separate Remittance Advice, which can later be assigned to the Payment ProcessProfile

XML PublisherTemplates

Formats

Payment Process Profiles

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting

You can also tie payment attribute validations to the Payment Instructions that will be used during the payment processing.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 80 of 176 Rev Paradigm_revision

Page 81: Edu3fc4y AP

Formats & Reporting Payment Process

Formats & Reporting Payment Process

• Specify Usage Rules: Payment Methods ties the Payment Method to Payment Process Profiles

• The Payment Process Profile is where you tie in your list of Payment Methods that can use this profile.

XML PublisherTemplates

Formats

Payment Process Profiles

Formats & Reporting Payment Process

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Process Profiles

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 81 of 176 Rev Paradigm_revision

Page 82: Edu3fc4y AP

Formats and Reporting Payment Process

Formats and Reporting Payment Process

• Specify Payment Creation Grouping Rules on the Payment Creation tab

• Optionally Group by Document Payment Attributes

• The payment attributes on your invoices can be used as grouping rules when “building or assembling” each payment– This may be required to meet your bank’s

format needs or for your reports

XML PublisherTemplates

Formats

Payment Process Profiles

Formats and Reporting Payment Process

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Process Profiles > (B) Create > (T) Payment Creation

Note that the tab does not appear until after you have saved the profile and chosen (B) Save and Add Details.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 82 of 176 Rev Paradigm_revision

Page 83: Edu3fc4y AP

Formats & Reporting Payment Process

Formats & Reporting Payment Process

Use the Payment Process Profiles screen to specify Payment Instruction Grouping Rules, including by Payment Attributes such as:

• Payment Reason

• Bills Payable Payment Methods

XML PublisherTemplates

Formats

Payment Process Profiles

Formats & Reporting Payment Process

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Process Profiles > (B) Create > (T) Payment Instruction Creation (Note that the tab does not appear until after you have saved the profile and chosen (B) Save and Add Details)

On the Payment Instruction Creation tab, you follow-up with rules on how the built payments should be grouped into Payment Instructions. In other words, one Payment Process Request can result in more than one Payment Instruction file but note that each payment instruction will be formatted.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 83 of 176 Rev Paradigm_revision

Page 84: Edu3fc4y AP

Formats and Reporting Payment Process

Formats and Reporting Payment Process

• The Payment Instruction Format is assigned on the Payment Instruction Format tab

• You can assign:– The Payment Instruction

– Accompanying Letter format

XML PublisherTemplates

Formats

Payment Process Profiles

Formats & Reporting Payment Process

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Process Profiles > (B) Create > (T) Payment Instruction Format

Note that the tab does not appear until after you have saved the profile and chosen (B) Save and Add Details

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 84 of 176 Rev Paradigm_revision

Page 85: Edu3fc4y AP

Formats & Reporting Payment Process

Formats & Reporting Payment Process

Use the Reporting Tab to assign the formats for the:

• Payment Instruction Register

• Positive Pay File

• Separate Remittance Advice

XML PublisherTemplates

Formats

Payment Process Profiles

Formats & Reporting Payment Process

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Process Profiles > (B) Create > (T) Reporting

Note that the tab does not appear until after you have saved the profile and chosen (B) Save and Add Details

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 85 of 176 Rev Paradigm_revision

Page 86: Edu3fc4y AP

Setup Payment Method Controls and Enhanced Payment

Setup Payment Method Controls and Enhanced Payment

• Configurable Payment Attribute Validation– View available validations

– Payment methods

– Payment process format

– Payment process profile

• Expanded Payment Method – Instruction formats and reporting

– Controls

– Defaulting

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 86 of 176 Rev Paradigm_revision

Page 87: Edu3fc4y AP

Configurable Payment Attribute Validation Setup

Configurable Payment Attribute Validation Setup

• View Validations– Payment Method

– Payment Instruction Format

– Payment Process Profile

Payment Method

Payment InstructionFormat

SETUP

Payment Process Profile

Configurable Payment Attribute Validation Setup

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Methods (H) Validations

Payment Instruction Formats are used to assign the output format but also where you associate validations to be evaluated during payment processing. Then to the Payment Process Profile where the payment method and payment instruction format are defined together to be used at payment time.

You can View preconfigured Validation Options – it is not a setup step, however, you can evaluate what is available to you.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 87 of 176 Rev Paradigm_revision

Page 88: Edu3fc4y AP

Configurable Payment Attribute Validation Setup Consideration

Configurable Payment Attribute Validation Setup Consideration

When determining how to configure Payment Attribute Validation, consider the Three Models:

• One Method, One Payment Process Profile (one Payment Instruction Format – one set of reports)

• One Method, Many Payment Process Profiles (each with one Payment Instruction Format – one set of reports)

• Many Methods, One Payment Process Profile (one Payment Instruction Format – one set of reports)

Configurable Payment Attribute Validation Setup Consideration

On the previous slide, the steps are sequential. However when considering your payment method and formatting definitions, evaluate all three together. There are three models you can consider.

• The first is One Payment Method to One Payment Process Profile – in other words, one payment method – one payment instruction format and one set of reports. In this case, you can determine how much validation you would like up front on your invoices or later at payment time equally based on your Payables’ staffing.

• The second model, “One Payment Method to many Payment Process Profiles” , needs to be reviewed based on the collective Payment Instruction and reporting needs. This model means that the actual Payment Process Profile will not be determined until payment time. Based on the differences between the “back end” formats, you can determine just how much can be validated upfront on the invoices.

• The third model is “Many Payment Methods to One Payment Process Profile”. In this model, you can again determine how much validation you would like upfront on your invoices or later at payment time equally based on your Payables’ staffing since you can assign format validation per payment method.

All setup options for validation are available via the Payment Administrator menu.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 88 of 176 Rev Paradigm_revision

Page 89: Edu3fc4y AP

Configurable Payment Attribute Validation Setup: View Available Validations

Configurable Payment Attribute ValidationSetup: View Available Validations

• Validations can be assigned to Payment Methods and Payment Instruction Formats.

• Validation Points indicate when the validation can occur and controls the list of values on Payment Methods and Formats.

• Validation Points are:– Document

– Payment

– Payment Instruction

Payment Process Profile

Payment Method

Payment Format

Configurable Payment Attribute Validation Setup: View Available Validations

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Methods > (H) Validations >(B) Go in Search area

Payment Methods may be assigned Document level validations and Document, Payment, & Payment Instruction validations may be assigned to the Payment Instruction Format.

There are many country specific validations that are considered Pre-defined validations, then there are Rule based validations that allow you to configure the meaning when it comes to defining Payment Methods and Formats.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 89 of 176 Rev Paradigm_revision

Page 90: Edu3fc4y AP

Configurable Payment Attribute Validation Setup – Payment Methods

Configurable Payment Attribute Validation Setup – Payment Methods

Direct Deposit Payment Method

• In the validations area, assign pre-defined validations or configure your own.

• When configuring your own validations, choose a Field Name from the list of values.

• Based on the field name, assign a validation name. – For example, you can specify that the

Payee’s bank account is required and can be only integers and that a Payment Reason is required. Payment Process

Profile

Payment Method

Payment Format

Configurable Payment Attribute Validation Setup – Payment Methods

In the validations area, assign pre-defined validations or configure your own. When configuring your own, choose a Field Name from the list of values. Based on the field name, assign a validation name. For example, you can specify that the Payee’s bank account is required and can be only integers and that a Payment Reason is required.

Ensure the Integrity of your Reporting and Formatting by Verifying Information upfront on the Invoice.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 90 of 176 Rev Paradigm_revision

Page 91: Edu3fc4y AP

Configurable Payment Attribute Validation Setup: Payment Process Format

Configurable Payment Attribute Validation Setup: Payment Process Format

Payment Instruction Formats:

• Pre-defined Validations for your use

• User-defined Validations provide flexibility

• Optionally Use User-defined Validations to Supplement Pre-defined Validations

Payment Process Profile

Payment Method

Payment Format

Configurable Payment Attribute Validation Setup: Payment Process Format

Assign or configure your validations to be used at Payment Time for your Payment Instructions. Since Payment Instructions can include many payment methods, optionally assign the payment time validations per payment method. Include pre-defined or user–defined validations or supplement pre-defined validations with your own user-defined options.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 91 of 176 Rev Paradigm_revision

Page 92: Edu3fc4y AP

Configurable Payment Attribute Validation Setup: Payment Process Profile

Configurable Payment Attribute Validation Setup: Payment Process Profile

Payment Process Profiles include:

• The type of processing (electronic or in-house printing)

• Use controls based on a list of payment methods, bank accounts, first party legal entities, and currencies

• Payment instruction and reporting formats

• Payment system configuration

• Payment creation rules

Payment Process Profile

Payment Method

Payment Format

Configurable Payment Attribute Validation Setup: Payment Process Profile

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Process Profiles

Each Payment Process Profile is a cornerstone for your payment instruction and reporting needs for the documents that will be paid using it. A Profile includes the type of processing (electronic or in-house printing), use controls based on a list of payment methods, bank accounts, first party legal entities, and currencies. It also contains payment system configuration and payment creation rules.

• Specify Usage Rules: Payment Methods

• Tie the Payment Method to the Payment Process Profiles

• Each single payment or Pay Run must have a Payment Process Profile.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 92 of 176 Rev Paradigm_revision

Page 93: Edu3fc4y AP

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting Setup

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting Setup

• Use “Out of the Box” Payment Instruction Formats and Reports or Configure XML Templates

• Assign to your Payment Process Profiles

XML Publisher Templates

Payment Formats

Payment Process Profiles

SETUP

Expanded Payment Attribute Availability Payment Instruction Formats and Reporting Setup

Release 12 leverages XML Publisher for layouts and report types such as text or PDF. The XML Publisher Templates are then assigned to Formats for payment instructions and reports. The formats are assigned to your Payment Process Profiles.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 93 of 176 Rev Paradigm_revision

Page 94: Edu3fc4y AP

Enhanced Payment Method Controls Setup

Enhanced Payment Method Controls Setup

• Define Payment Methods

• Define Payment Method Defaulting Rules

• Specify Payment Method defaulting mechanism

• Assign Payment Methods to the Payee

Payee Payment Method Assignment

SETUP

Payment MethodDefaulting Rules

Payment Methods

Disbursement System Options

Enhanced Payment Method Controls Setup

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Payment Methods

There are seeded items already provided for your use, so all setup steps shown are optional.

• Payment Methods. There are some payment methods automatically available. These include Check, EFT, and Wire. You can update these payment methods or enter new payment methods to meet your demands.

• Payment Method Defaulting Rule. These let you create a set of rules to default Payment Methods centrally, based on something other than individual payees.

• Disbursement System Options. These allow you to specify whether the Payment Methods should default from Defaulting Rules only or take the default payment method from the Payee. Disbursement Options can be defined at the enterprise level, legal entity, business group or for specific Operating Units.

• Payee Preferences. Controls assigned to an individual payee. Since you can create defaulting rules centrally, assigning Payment Methods to individual payees is optional.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 94 of 176 Rev Paradigm_revision

Page 95: Edu3fc4y AP

Expanded Payment Attribute Availability and Defaulting - Setup

Expanded Payment Attribute Availability and Defaulting - Setup

• Define Delivery Channels, Payment Reasons, and Bank Instruction Codes

• Define Payee Payment Attributes

• Tailor Invoice Entry UI with Oracle Folder Forms

Delivery Channels, Payment Reasons,

Bank Instruction Codes

Payee Payment Attributes

SETUP

Folders

Expanded Payment Attribute Availability and Defaulting – Setup

• Responsibility: Payables

• Navigation: Setup : Payment > Payment Administrator > Funds Disbursement Setup > Codes

The first set of setups include the Delivery Channels, Payment Reason, and Bank Instruction Codes. These provide a list of values for your Payee definition and in the document payable.

Next define the attributes on the Payee – these are used for defaulting purposes during invoice entry and import or during payment processing.

Tailor the Payables Invoice Workbench or Quick Invoices forms using Oracle Folder Form technology if desired. Predetermine the folders or let users tailor the look to meet their individual data entry style or task.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 95 of 176 Rev Paradigm_revision

Page 96: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

• Oracle Payables & Payments

• XML Publisher

Implementation Considerations

This feature has been provided by Oracle Payables in partnership with Oracle Payments, a new module provided with Oracle Financials. XML Publisher, another module available with Oracle Financials, is leveraged for the solution formats.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 96 of 176 Rev Paradigm_revision

Page 97: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 97 of 176 Rev Paradigm_revision

Page 98: Edu3fc4y AP

Self Assessed Tax Description

Self Assessed Tax Description

• Self assessed taxes are taxes which need to be reported but are not a liability to the supplier

• The purchaser is responsible for calculating and remitting the tax

Self-Assed Tax - Description

Self Assessed tax differs from regular taxes in one way: as a purchaser, you are responsible for reporting and paying the tax and the supplier is not.

This was also known as USE TAX in previous releases.

For example: You receive an invoice for $1000 which is due to be paid to the supplier. Tax A for 10% was not charged on the invoice however, as the purchaser, you recognize that you are responsible to pay tax A. You would self-assess Tax A for the $100 and include it in your filings to the corresponding tax authority.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 98 of 176 Rev Paradigm_revision

Page 99: Edu3fc4y AP

Self Assessed Tax Features

Self Assessed Tax Features

• Predefined or manual determination of Self Assessed Tax

• Determine recoverable & non-recoverable portions of self assessed tax amounts

• Reporting and accounting for Self Assessed Tax amounts

• Reporting and accounting for Self Assessed Tax Liabilities

Self Assessed Tax Features

• The flexibility to have self assessed tax automatically assessed (based on tax setup) or to manually mark the calculated tax as self assessed during invoice entry.

• An ability to have recoverable and non-recoverable portions of self assessed tax amounts based on your invoice details.

• The ability to report and account detailed recoverable and non-recoverable self assessed tax AND the corresponding Self Assessed Tax Liabilities when the transaction is accounted.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 99 of 176 Rev Paradigm_revision

Page 100: Edu3fc4y AP

Self Assessed Tax Benefits

Self Assessed Tax Benefits

• Improved Fiscal Discipline– Maintain an audit trail for the tax amounts and the

invoices they tie to

– More granular and accurate accounting

• Improved Operational Excellence– Reduced propensity for human error

Self Assessed Tax Benefits

Improved Fiscal Discipline

• Automatic reporting and accrual helps maintain an audit trail for the tax amounts and the invoices they tie to.

• Separate liability accounts for self assessed taxes translate to more granular and accurate accounting.

Improved Operational Excellence

• By automating previously manual processes and providing functionality available during invoice entry, the propensity for human error or delayed information is reduced.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 100 of 176 Rev Paradigm_revision

Page 101: Edu3fc4y AP

Self Assessed Tax Predetermined Process

Self Assessed Tax Predetermined Process

Payables Invoice E-Business Tax

Invoice Header

Tax Engine

Configuration

Invoice Lines

Non Recoverable tax

Recoverable Tax

X.XX

Self Assessed Liabilities

X.XX X.XX

Tax SummaryTax (Self

Assessed)

Invoice details

Stored Accounting Information

Subledger Accounting

Self Assessed Tax Predetermined Process

• During Invoice Entry, Validation, and Import, Payables gathers information known as “tax drivers’ entered on the invoice header and lines and passes that information to the new E-Business Tax module.

• Based on these tax drivers and additional information derived by E-Business Tax such as the supplier’s party tax profile and buyer’s and supplier’s tax registrations, the engine determines if any self assessed tax is applicable to the invoice.

• The self assessed tax will be passed back to Payables along with the recoverable and non-recoverable tax amounts and the General Ledger Accounts for the recoverable tax and self assessed liability.

• Payables displays the self assessed tax amount in a column on the Invoice header in the Invoice Workbench. Payables will also derive the accounts for the non-recoverable portion of the self assessed tax then store all accounts to be used later when the invoice is accounted.

• When the Invoice is Accounted, the self assessed tax and corresponding self assessed tax liabilities will be accounted along with the rest of the invoice.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 101 of 176 Rev Paradigm_revision

Page 102: Edu3fc4y AP

Self Assessed Tax Process – 1. Predetermined

Self Assessed Tax Process – 1. Predetermined

• Set up

• Invoice

• Tax calculation

• Accounting

• Reporting

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax Process – 1. Predetermined

Predetermined self assessed tax calculation example: (That is, cases where self assessed taxes are calculated by the application automatically). This will include setup, invoicing, tax calculation, accounting, and reporting.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 102 of 176 Rev Paradigm_revision

Page 103: Edu3fc4y AP

Self Assessed Tax: Predetermined Process – Invoice Entry

Self Assessed Tax: Predetermined Process –Invoice Entry

• Use the Payables’ Invoice Workbench to enter invoice header and lines information

• Many tax drivers default onto the transaction, however, Payables users can also update or enter these values

• The lines region displays some of the new columns added to help derive tax, including: – Ship To location

– Product Type

– Primary Intended Use

– Business Category

– Product Fiscal Classification

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax: Predetermined Process – Invoice Entry

• Responsibility: Payables

• Navigation: Invoices : Entry > Invoices

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 103 of 176 Rev Paradigm_revision

Page 104: Edu3fc4y AP

Self Assessed Tax: Predetermined Process – Calculate Tax

Self Assessed Tax: Predetermined Process –Calculate Tax

• To view the calculated tax, click the “Calculate Tax” button on the Lines tab

• The E-Business Tax Service engine calculates tax based on it’s configuration, including determining if the tax should be selfassessed

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax: Predetermined Process – Invoice Entry

• Responsibility: Payables

• Navigation: Invoices : Entry > Invoices > (T) Lines > (B) Calculate Tax

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 104 of 176 Rev Paradigm_revision

Page 105: Edu3fc4y AP

Self Assessed Tax: Predetermined Process – Calculate Tax Example

Self Assessed Tax: Predetermined Process – Calculate Tax Example

Report

Set up

Invoice

Calculate tax

Account

Vision Invoice

Invoice Amount = $1000

Self Assessed Tax Amount = $50

Suppliers Invoice

Subtotal = $1000

Tax = $0

Total = $1000

Self Assessed Tax: Predetermined Process – Calculate Tax Example

Here we see the self assessed tax amount returned by E-Business Tax ($50.00). We also see that this has no impact on the supplier’s invoice details. The tax for the Supplier’s invoice is $0 and the amount due to the supplier is $1000.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 105 of 176 Rev Paradigm_revision

Page 106: Edu3fc4y AP

Self Assessed Tax: Predetermined Process – Calculate Tax

Self Assessed Tax: Predetermined Process –Calculate Tax

On the Lines tab, you can click the Tax Details button to view tax details such as:

• Tax Regime Code

• Tax

• Jurisdiction

• Tax Status

• Rate Name

• Rate

• Tax Amount

• Whether the tax is self assessed

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax: Predetermined Process – Calculate Tax

The Tax Lines Summary window provides further information about the summarized tax.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 106 of 176 Rev Paradigm_revision

Page 107: Edu3fc4y AP

Self Assessed Tax Process – Account

Self Assessed Tax Process – Account

• After validating and accounting the invoice, view the accounting by choosing Reports – View Accounting from the menu bar

• Personalize the View to meet your needs

• Leverage Subledger Accounting to tailor journal & journal line descriptions and account derivation rules

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax Process – Account

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 107 of 176 Rev Paradigm_revision

Page 108: Edu3fc4y AP

Self Assessed Tax Process – Account

Self Assessed Tax Process – Account

• You can customize what is displayed on the Subledger Journal Entry Lines page

• You can also configure Subledger Accounting for account derivation and journal & journal line descriptions

• Self assessed rows are not shown in the Invoice Workbench Distributions Window because they are not represented on the supplier’s invoice

Report

Set up

Invoice

Calculate tax

Account

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 108 of 176 Rev Paradigm_revision

Page 109: Edu3fc4y AP

Self Assessed Tax Setup – Reporting Choices

Self Assessed Tax Setup – Reporting Choices

Subledger Accounting:

• Provides reports for your accounting activity

• Reports use XML Publisher, giving you the flexibility to configure the layout and report type at any time

• Reports include:– Account Analysis Report

– Open Account Balance Listing report

• Gives you flexibility to configure:– XML Publisher Report Layout

– XML Publisher Report Type

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax Setup – Reporting Choices

Subledger Accounting provides many reports for your accounting activity including your self assessed tax liability. These reports use XML Publisher, giving you the flexibility to configure the layout and report type at any time.

Report types include Account Analysis Report and the Open Account Balance Listing report. The Open Account Balance Listing report is primarily used for the Payables Liability, however, you can leverage it for any account you would like to have for transactional and accounting detailed data. There are two configurable portions to the Open Account Balance Listing report: the XML Publisher Layout and the Definition.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 109 of 176 Rev Paradigm_revision

Page 110: Edu3fc4y AP

Self Assessed Tax Setup – Reporting Choices

Self Assessed Tax Setup – Reporting Choices

• To create a definition for the Open Account Balance Listing report , navigate to the Setup – Subledger Accounting – Open Accounting Balances Listing Definitions– You can optionally create a definition for

yourself assessed tax liability account

• You have the flexibility to configure OpenAccount Balances Listing: Report Definition

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax Setup – Reporting Choices

• Responsibility: Payables

• Navigation: Setup : Accounting Setups : Subledger Accounting Setup > Open Account Balances Listing Definitions

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 110 of 176 Rev Paradigm_revision

Page 111: Edu3fc4y AP

Self Assessed Tax Process – Report

Self Assessed Tax Process – Report

Account Analysis Report

Open Account Balance Listing Report

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax Process – Report

Here are two examples of the reports, each using a configured XML Template.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 111 of 176 Rev Paradigm_revision

Page 112: Edu3fc4y AP

Self Assessed Tax Manual Determination Process

Self Assessed Tax Manual Determination Process

Payables Invoice E-Business Tax

Invoice Header

Tax Engine

Configuration

Invoice Lines

Non Recoverable tax

Recoverable Tax

X.XX

Self Assessed Liabilities

X.XX X.XX

Tax Summary

Invoice details

Stored Accounting Information

Tax (Self Assessed)

Tax (Payable to Supplier)

Subledger Accounting

Self Assessed Tax Manual Determination Process

• This slide illustrates the process for an invoice where the calculated tax returned by the E-Business Tax engine is expected to be paid to the supplier and the Payables’ user updates the it as Self Assessed instead.

• Just like the first example, Payables gathers tax drivers entered on the invoice header and lines and passes that information to the E-Business Tax module.

• Based on these tax drivers and additional information derived by E-Business Tax, the engine calculates the tax that is expected to be paid to the supplier (in other words: Non-self assessed taxes)

• From the Tax Summary Window, the Payables user marks the tax as self assessed. E-Business Tax updates their records and returns the tax details to Payables.

• Payables stores the GL Accounts, displays the self assessed tax amount in a column on the Invoice header and the validated invoice is ready for accounting.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 112 of 176 Rev Paradigm_revision

Page 113: Edu3fc4y AP

Self Assessed Tax Process – 2. Manual Determination

Self Assessed Tax Process – 2. Manual Determination

• Set Up

• Invoice

• Tax Calculation

• Manual Tax Update

• Accounting and Accrual

• Reporting

Report

Set up

Invoice

Calculate tax

Account

Manual Update

Self Assessed Tax Process – 2. Manual Determination

The flexibility to manually mark tax as self assessed, if allowed by your tax department, can be done when the circumstances arise. The Accounting and Reporting are the same as our previous example so that won’t be covered again.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 113 of 176 Rev Paradigm_revision

Page 114: Edu3fc4y AP

Self Assessed Tax: Manual Determination Set Up - E-Business Tax Controls

Self Assessed Tax: Manual Determination Set Up - E-Business Tax Controls

• You can set Configuration Owner Tax Options

• Tax Managers determine if they would like to allow tax to be updated or not. The “Allow Override for Calculated Tax Lines” can be set for the configuration owner and application event class or on a particular Tax

• Other Controls and Defaults you set include:– Allow Override and Entry of Inclusive Tax

Lines

– Allow Entry of Manual Tax Lines

– Allow Mass Creation of Jurisdictions

Report

Set up

Invoice

Calculate tax

Account

Manual Update

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 114 of 176 Rev Paradigm_revision

Page 115: Edu3fc4y AP

Self Assessed Tax: Manual Determination Process – Invoice Entry

Self Assessed Tax: Manual Determination Process – Invoice Entry

• Use the Payables’ Invoice Workbench to enter invoice header and lines information

• Many tax drivers default onto the transaction, however, Payables users can also update or enter these values

• The lines region displays some of the new columns added to help derive tax, including: – Ship To location

– Product Type

– Primary Intended Use

– Business Category

– Product Fiscal Classification Report

Set up

Invoice

Calculate tax

Account

Manual Update

Self Assessed Tax: Manual Determination Process – Invoice Entry

This step is the same process for the Payables Analyst in the first example where the invoice header and line details are entered.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 115 of 176 Rev Paradigm_revision

Page 116: Edu3fc4y AP

Self Assessed Tax: Manual Determination Process – Calculate Tax

Self Assessed Tax: Manual Determination Process – Calculate Tax

• To view the calculated tax immediately, click the “Calculate Tax” button on the Lines tab

• The E-Business Tax Service engine calculates tax based on it’s configuration

Report

Set up

Invoice

Calculate tax

Account

Manual Update

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 116 of 176 Rev Paradigm_revision

Page 117: Edu3fc4y AP

Self Assessed Tax: Manual Determination Process – Calculate Tax Example

Self Assessed Tax: Manual Determination Process – Calculate Tax Example

Report

Set up

Invoice

Calculate tax

Account

Manual Update

Invoice Header

Invoice Amount = $1000

Tax Amount = $50

Suppliers Invoice

(Line 1) Item Type= $1000

(Line 2) Tax Type = $50

Total Gross = $1050

Total Net = $1050

Tax = $0

Total = $1000

Supplier’s Tax initially calculated for $50. Invoice lines do not total the Invoice

header amount

Self Assessed Tax: Manual Determination Process – Calculate Tax Example

In this example, E-Business Tax has returned a $50.00 tax summary line; that is, the calculated tax was not automatically set as self assessed. The total tax has been “classified” as the tax we are expecting to pay the supplier on the invoice header. Note that the Invoice Amount is only for $1,000.00. In other words, the supplier’s invoice did not include the $50.00 tax.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 117 of 176 Rev Paradigm_revision

Page 118: Edu3fc4y AP

Self Assessed Tax: Manual Determination Process – Calculate Tax Example

Self Assessed Tax: Manual Determination Process – Calculate Tax Example

Report

Set up

Invoice

Calculate tax

Account

Manual Update

Invoice Header

Invoice Amount = $1000

Self Assessed Tax Amount = $50

Suppliers Invoice

(Line 1) Item Type= $1000

Total Gross = $1000

Total Net = $1000

Self Assessed Tax: Manual Determination Process – Calculate Tax Example

The Tax Lines Summary window (accessed by clicking the Tax Details button) displays further information about the summarized tax. For example, you can determine if the calculated tax has been marked as self assessed tax.

You can mark the tax row as self assessed by checking the corresponding checkbox and clicking the [OK] button.

In this example, we have selected the Self Assessed Tax option. Now we see that the header level view of the total tax displays the $50.00 as self assessed, and the $50.00 tax line has been removed.

Note: The Account and Report flows are the same as covered in the first example, and are not repeated here.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 118 of 176 Rev Paradigm_revision

Page 119: Edu3fc4y AP

Setup Self Asessed Tax

Setup Self Asessed Tax

• First party tax

• Supplier party tax

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 119 of 176 Rev Paradigm_revision

Page 120: Edu3fc4y AP

Self Assessed Tax: Predetermined Set Up First Party, Party Tax Profile

Self Assessed Tax: Predetermined Set Up First Party, Party Tax Profile

You have the flexibility to configure First Party Establishments for Self Assessed Taxes at the following levels:

• Registration, Regime

• Registration, Regime, Tax

• Registration, Regime, Tax, Tax Jurisdiction

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax: Predetermined Set Up – First Party, Party Tax Profile

To enable the application to automatically assess self assessed taxes for the First Party or for certain Third Party Suppliers, you need to first set up the Party Tax Profile. The Party Tax Profile is party specific, tax related information that can be associated to 1st and 3rd parties. It includes information such as defaults, tax registrations, classifications and tax reporting codes.

Using the Tax Managers responsibility, navigate to the Parties, Party Tax Profiles page. Search based on the Party Type of First Party Legal Establishment and the desired party name.

You have the flexibility to configure First Party Establishments for Self Assessed Taxes at the following levels based on your needs:

• Registration, Regime

• Registration, Regime, Tax

• Registration, Regime, Tax, Tax Jurisdiction

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 120 of 176 Rev Paradigm_revision

Page 121: Edu3fc4y AP

Self Assessed Tax: Predetermined Set Up – First Party, Party Tax Profile

Self Assessed Tax: Predetermined Set Up – First Party, Party Tax Profile

• Enable Self Assessment on the Party Tax Profiles tab

• By checking the Set for Self Assessment/Reverse Charge option at a particular level, E-Business Tax returns applicable taxes for supplier invoices that fall within the level– For example, if you enable this option at the

Registration – Regime level, all invoices to be taxed within that regime will be considered Self Assessed tax

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax: Predetermined Set Up – First Party, Party Tax Profile

• Responsibility: Payables

• Navigation: Setup : Tax > E-Business Tax Home > Create Party Tax Profiles

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 121 of 176 Rev Paradigm_revision

Page 122: Edu3fc4y AP

Self Assessed Tax: Predetermined Set Up – Supplier Party Tax Profile

Self Assessed Tax: Predetermined Set Up –Supplier Party Tax Profile

You can also set up a particular supplier’s Party Tax Profile by doing either of the following:

• Use the Tax Managers responsibility to query a Third Party

• Navigate to the Tax Details page from the Supplier (Entry) pages from the Payables Responsibility

Report

Set up

Invoice

Calculate tax

Account

Self Assessed Tax: Predetermined Set Up – Supplier Party Tax Profile

The difference between the previous slide and this, is that if set up as shown here, self assessed taxes will only be assessed for this supplier according to the level it is set:

• Registration, Regime level

• Registration, Regime, Tax level

• Registration, Regime, Tax, Tax Jurisdiction level

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 122 of 176 Rev Paradigm_revision

Page 123: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

Common Module Dependency:

• E-Business Tax– The e Business Tax engine is responsible for calculating

tax amounts applicable to invoices

– Also assists in automatically identifying taxes as self assessed and allows setting options for manual determination

Common Module Interaction:

• Subledger Accounting– Subledger Accounting is not specific to this

feature but a general tool to configure accounting entries and to provide accounting reports to meet your needs

Implementation Considerations

E-Business Tax is a common module available with Oracle Financial Applications.

• The E-Business Tax engine is responsible for calculating tax amounts applicable to invoices.

• It also assists in automatically identifying taxes as self assessed and allows setting options for manual determination.

Subledger Accounting is also a common module available with Oracle Financial Applications.

• Subledger Accounting is not specific to this feature but a general tool to configure accounting entries and to provide accounting reports to meet your needs.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 123 of 176 Rev Paradigm_revision

Page 124: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 124 of 176 Rev Paradigm_revision

Page 125: Edu3fc4y AP

Oracle Payables For Complex Contract Terms

Oracle Payables For Complex Contract Terms

• An integrated solution to automate acquisition of complex services from Source through Payment.

• Complex Service Contracts are characterized by:– High dollar value projects

– Long lead time delivery schedules

– Progress payments based on work completion

– Advances and progress based financing options

– Retainage options

• Commodities / Industries of Interest– Professional Services

– Engineering and Construction

– Aerospace and Defense

Oracle Payables For Complex Contract Terms

These contracts tend to have high dollar values, often running into several millions of dollars. They also tend to be long lead time contracts, sometimes extending over multiple years. They include payment terms characterized by progress payments, financing with advances or based on completed work, and may provide for retainage options. The area of target for this release are fixed-priced contracts which include lump sum, rate based, and milestone driven progress.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 125 of 176 Rev Paradigm_revision

Page 126: Edu3fc4y AP

Oracle Payables for Complex Contract Terms Benefits

Oracle Payables for Complex Contract Terms Benefits

• Strengthened financial discipline and corporate governance– Ensuring billing compliance with the terms negotiated on

the contract

– Automating retainage and financing recoupment

– Verifying invoices fall within tolerance policies

– Providing workflow approval processing, history, and controls

• Improved visibility into business, financial, and compliance performance – Real-time update of the purchase order,

adherence to budgetary controls, accounting and tax reporting provide transparency

Oracle Payables for Complex Contract Terms Benefits

We are continuing our efforts to reduce the cost of compliance for such corporate governance rulings as Sarbanes-Oxley and similar rulings found in other geographic areas. By automating retainage and financing recoupment, tolerance checking, and self billing options for approved work, there is less to worry about when auditing these functions. Workflow processing for approval and holds resolution provide a means of representing your processing procedures in the Payables application. Again, an auditing win particularly with complete approval and holds resolution history visible from the Invoice Workbench.

Real-time update of the purchase order, adherence to budgetary controls through funds checking and encumbrance accounting, accounting and tax reporting provide important business intelligence and transparency into your business.

Automating many items in the invoice area also reduces the cost of invoice processing and the opportunity for errors which may result in overpaying your suppliers.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 126 of 176 Rev Paradigm_revision

Page 127: Edu3fc4y AP

Complex Contract Terms Key Concepts

Complex Contract Terms Key Concepts

• Progress Payment Schedule– Represents a schedule of services and work with

associated payments

• Progress Payments– Payments for progress made on a Progress Payment

Schedule

• Pay Item– Refers to a specific work/service component of the

Progress Payment Schedule, and its associated payment amount

Complex Contract Terms Key Concepts

• A Progress Payment Schedule is an industry term that represents a schedule of services and work components required to complete a complex services contract. Each of these service components is typically associated with payments. Specifically in the Construction Industry, the Progress Payment Schedule is also referred to as the Schedule of Values.

• Progress Payments are payments released for work partially or fully completed on a Progress Payment Schedule.

• Pay Items refers to a specific work or service component of the Progress Payment Schedule. It describes the work or service that needs to be completed, and the payment amount associated with that work or service. So a Progress Payment Schedule basically consists of several pay items. Pay Items can be of different types – they can be based on rate of work or service being delivered, or based on a lump sum amount for a service, or they can even be based on a event or milestone on the contract

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 127 of 176 Rev Paradigm_revision

Page 128: Edu3fc4y AP

Complex Contract Terms Key Concepts

Complex Contract Terms Key Concepts

• Progress Payment Rate– Used on Cost Reimbursement Contract. Represents the

rate at which costs incurred by the Contractor are reimbursed

• Contract Financing– Typically used in Public Sector Contracts. Contract

financing is paid based on work performed or cost to date. If the contractually specified performance or cost milestones are met, financing is given to aid in the completion of subsequent work

Complex Contract Terms Key Concepts

• Progress Payment Rate - a payment term used on cost reimbursement contracts. On these contracts progress payments released to the Contractor are based on the costs incurred by the contractor during the execution of the contract. The progress payment rate is used on these contracts to compute the reimbursement amount based on the cost incurred by a contractor. The Progress Payment Rate is usually negotiated between the Buying Organization and the Contractor.

• Financing is often used on Public Sector Contracts. Contract financing is paid based on work performed or cost to date. If the contractually specified performance or cost milestones are met, financing is given to aid in the completion of subsequent work prior to the delivery of the contract line item.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 128 of 176 Rev Paradigm_revision

Page 129: Edu3fc4y AP

Oracle Procurement to Payables: High Level Business Flow

Oracle Procurement to Payables: High Level Business Flow

Request for Service

Advance Payment

TrackProgress

ProcessPayment

Author Contract

Source

Requests for Services can originate from multiple sources:

– Facilities Manager

– Project Manager

– Field Engineer

– Architect

Requests for Services can originate from multiple sources:

– Facilities Manager

– Project Manager

– Field Engineer

– Architect

Oracle Procurement to Payables: High Level Business Flow

In order to fully understand the story for Oracle Payables, we’ll first talk about the high-level business flow for the procurement of complex services.

Procurement for complex services often starts off from a request for services, and this can originate from one of several sources – Project Managers in charge of a construction project, engineers in the field, or even architects.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 129 of 176 Rev Paradigm_revision

Page 130: Edu3fc4y AP

Oracle Procurement to Payables: High Level Business Flow

Oracle Procurement to Payables: High Level Business Flow

Request for Service

Advance Payment

TrackProgress

ProcessPayment

Author Contract

Source

Invite Suppliers to Sourcing Event

Negotiate with Suppliers on:

– Complex Payment Terms

– Progress Payment Schedule

– Clauses & Deliverables

Invite Suppliers to Sourcing Event

Negotiate with Suppliers on:

– Complex Payment Terms

– Progress Payment Schedule

– Clauses & Deliverables

Oracle Procurement to Payables: High Level Business Flow

If the Service Requests have high dollar values, and involve services that require longer lead times to be fulfilled, buying organizations can determine that fulfilling the request will need sourcing and negotiation activity. The sourcing event and negotiation include determining the complex payment requirements.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 130 of 176 Rev Paradigm_revision

Page 131: Edu3fc4y AP

Oracle Procurement to Payables: High Level Business Flow

Oracle Procurement to Payables: High Level Business Flow

Request for Service

Advance Payment

TrackProgress

ProcessPayment

Author Contract

Source

– Award Contract to best Supplier

– Supplier and Contracting Officersign off on Contract

– Award Contract to best Supplier

– Supplier and Contracting Officersign off on Contract

Oracle Procurement to Payables: High Level Business Flow

Once negotiation is complete, the best party is awarded the contract. The complex payment terms and the progress payment schedule now become a part of the contract and the contract is now ready for execution.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 131 of 176 Rev Paradigm_revision

Page 132: Edu3fc4y AP

Oracle Procurement to Payables: High Level Business Flow

Oracle Procurement to Payables: High Level Business Flow

Request for Service

Advance Payment

TrackProgress

ProcessPayment

Author Contract

Source

– Supplier requests the advance if provided for on the contract

– The advance amount is paid tothe supplier

– Supplier requests the advance if provided for on the contract

– The advance amount is paid tothe supplier

Oracle Procurement to Payables: High Level Business Flow

If there are provisions on the contract for advance financing, the supplier can request payment before work starts.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 132 of 176 Rev Paradigm_revision

Page 133: Edu3fc4y AP

Oracle Procurement to Payables: High Level Business Flow

Oracle Procurement to Payables: High Level Business Flow

Request for Service

Advance Payment

TrackProgress

ProcessPayment

Author Contract

Source

– Contractor reports progress

– Progress is certified by Facilities Manager, and/or Project Manager

– Contractor reports progress

– Progress is certified by Facilities Manager, and/or Project Manager

Oracle Procurement to Payables: High Level Business Flow

The contractor now performs work on the progress payment schedule and periodically reports progress and requests payment either in the form of a Work Confirmation or an Invoice. These documents state the amount of work completed on different components of the progress payment schedule, and usually need to be approved by designated individuals like Engineers, Project Managers or Architects on the client’s side before any payment can be released.

Once the work confirmation is approved, the contract is updated with the progress made. If the work is accrued, this information is also updated on the Project which allows the Project Manager to view actuals and commitments for this specific portion of work along with the rest of the work against the Project.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 133 of 176 Rev Paradigm_revision

Page 134: Edu3fc4y AP

Oracle Procurement to Payables: High Level Business Flow

Oracle Procurement to Payables: High Level Business Flow

Request for Service

Advance Payment

TrackProgress

ProcessPayment

Author Contract

Source– Contractor submits Invoice for Progress

Payments and Contract Financing

– Retainage is applied

– Financing is recouped

– Payment is released

– Contractor submits Invoice for Progress Payments and Contract Financing

– Retainage is applied

– Financing is recouped

– Payment is released

Oracle Procurement to Payables: High Level Business Flow

Once an invoice is received or generated, the Complex Payment Terms specified on the contract are used to calculate the payment due to the contractor. Previous financing payments, if any, can be recouped, and applicable retainage can be withheld before a payment is made to the contractor.

Alternatively, if the contractor’s invoice is for contract financing payments, these can be released and tracked as such on the contract so that they can be recouped subsequently from invoices for services deliveries.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 134 of 176 Rev Paradigm_revision

Page 135: Edu3fc4y AP

Integrated Products: High Level Business Flow

Integrated Products: High Level Business Flow

Negotiate

TrackProgress

Invoice /Payments

Budget /Deliverables

Request for Services

RetainageRelease

CostCollection

OracleProjects

Procurement for Complex

Services

Control

Advanced Procurement

Oracle Payables

Integrated Products: High Level Business Flow

This slide shows the products that are integrated to form the complex services procurement solution – Oracle Projects, Oracle Payables, and Oracle Advanced Procurement which includes Oracle iProcurement, Oracle Sourcing, Oracle iSupplier Portal, and Oracle Procurement Contracts. All these products integrate seamlessly to provide a complete solution.

Oracle Projects can be used to manage the overall Project, it’s Tasks, as well as monitor the commitments and actuals throughout the complex procurement cycle along side other project costs and work progress. Service Requests can be created from the deliverables of the individual tasks, and in Oracle Sourcing these can be negotiated, sourced and awarded to a Contract in Oracle Purchasing. Oracle Purchasing and Oracle iSupplier Portal provide the capability to specify complex payment terms, execute on the contract, and report and track progress against the Progress Payment Schedule. Oracle Payables provides the functionality to record invoices using the complex payment terms and process payments for the contract.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 135 of 176 Rev Paradigm_revision

Page 136: Edu3fc4y AP

Oracle e-Business Tax Setup: Tax Configuration

Oracle e-Business Tax Setup: Tax Configuration

Prepayment Application Tax Handling

• Prepayment Application Tax Treatment: Select Recalculate or Prorate option for the Applied Amount Handling field

Oracle e-Business Tax Setup: Tax Configuration

If you do plan on taxing the Advance or Contract Financing Prepayment and want to “reverse” the tax when you recoup, you can then determine your recoupment tax treatment: either recalculate based on today’s rates or prorate the prepaid tax based on the recoupment amount.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 136 of 176 Rev Paradigm_revision

Page 137: Edu3fc4y AP

Business Flow: Payables Distinction

Business Flow: Payables Distinction

Request for Service

TrackProgress ERS

Author Contract

Source

Procurement Process

Advance Payment

ProcessPayment

Payables Process

Business Flow: Payables Distinction

This slide represents the same flow discussed earlier but from the different perspective of providing a distinction between the Procurement processing and the Payables processing.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 137 of 176 Rev Paradigm_revision

Page 138: Edu3fc4y AP

Contract Delivery Invoicing

Contract Delivery Invoicing

Request for Service

TrackProgress ERS

Author Contract

Source

Procurement Process

Advance Payment

ProcessPayment

Payables Process

• iSupplier Portal• Import

Supplier

Payables Analyst

Employee: Decentralized Invoice Entry

• Payables Requests

• Quick Invoice• Invoice Workbench

Pay on receipt import

Contract Delivery Invoicing

Delivery invoices can be submitted using same entry points covered previously including self billing with the Pay On Receipt feature.

The delivery invoice will also have the financing automatically recouped.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 138 of 176 Rev Paradigm_revision

Page 139: Edu3fc4y AP

Invoice Workbench: Contract Delivery Invoices

Invoice Workbench: Contract Delivery Invoices

Invoice Workbench: Contract Delivery Invoices

When viewing distributions, tailor the columns using the folder window to create a view that meet your requirements. This slide shows the Prepayment Number to illustrate the different prepayment invoices that are now recouped on this invoice.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 139 of 176 Rev Paradigm_revision

Page 140: Edu3fc4y AP

Oracle Payables: Ensure Billing Compliance

Oracle Payables: Ensure Billing Compliance

• Ensuring billing compliance with the terms negotiated on the contract– Automating retainage and financing recoupment

– Real-time update of the purchase order

• Ensuring billing compliance when comparing billed verses planned– Holds resolution process to manage issues when they

does not

– Verifying invoices fall within your tolerance policies

Oracle Payables: Ensure Billing Compliance

We have already covered how Payables adapts to the type contract being billed against and automates retainage and recoupment. We noted that the PO is always updated immediately when billing activity occurs enabling real time information. We will now touch upon managing tolerances and holds.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 140 of 176 Rev Paradigm_revision

Page 141: Edu3fc4y AP

Oracle Payables: Tolerances and Holds

Oracle Payables: Tolerances and Holds

Services Tolerance Template

• Payables uses the combination of PO Line Type and Pay Item Line Type to determine which tolerance template to use.

• Fixed Price Services: Lump Sum Pay Items = Amount Based Tolerance Checking

• Fixed Price Services: Rate Based Pay Items = Quantity Based Tolerance Checking

Oracle Payables: Tolerances and Holds

• Fixed Price Services: Lump Sum Pay Items = Amount Based Tolerance Checking

- For Fixed Price PO lines, use the Services template assigned to the supplier site when the Pay Items are Lump Sum.

• Fixed Price Services: Rate Based Pay Items = Quantity Based Tolerance Checking

- For Fixed Price PO lines, use the Goods template assigned to the supplier site when the Pay Items are Rate based. While the template is called Goods, it represents Quantity Based matches.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 141 of 176 Rev Paradigm_revision

Page 142: Edu3fc4y AP

Oracle Payables: Tolerances and Holds

Oracle Payables: Tolerances and Holds

Milestone Pay Items have Zero Tolerance

• Quantity Based – Quantity must be a whole quantity –Price and Amount exact

• Amount Based – Amount must be exact

Oracle Payables: Tolerances and Holds

Milestone Pay Items are unique. They represent a specific point in the contract and any tolerance is not acceptable. In other words, milestone pay items are not compared with a tolerance template.

• Payables will place a Milestone hold for Goods if the price and amount are not exact or if the quantity billed is over the quantity ordered. The bill cannot be for a partial quantity such as .5. Payables will allow for less, whole quantities to be billed, however, the price and amount must be exact or a hold will be placed.

• For Fixed Price Services, the amount must be exact – anything less or more will have a hold placed.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 142 of 176 Rev Paradigm_revision

Page 143: Edu3fc4y AP

Oracle Payables: Holds Notification Options

Oracle Payables: Holds Notification Options

Holds Resolution Workflow

• This feature enables you to release any hold that can be manually released.

• You can:– Enable Hold Notification per Hold

– Set Notify and Reminder Days

– Add instructions to appear on the workflow notification

• Includes two options:– Release the hold

– Acknowledge the issue

Oracle Payables: Holds Notification Options

• Payables has introduced a new Holds Resolution Workflow in R12. This feature enables you to release any hold that can be manually released.

• The Notify After days allows a period of time to see if the hold on the invoice resolves itself. For example, a Quantity Received hold may resolve itself when a receipt is recorded.

• The workflow notification includes two options – release the hold; acknowledge the issue.

• By choosing acknowledge, the person being notified is expected to take some action such as enter a change to the PO for a Price hold. The Remind After Days will send a reminder to this person if the hold is still on the invoice after they first acknowledged the issue.

• The Hold Instructions entered here will appear on the notification to provide instructions to the person being notified.

• This history of any actions that are done through this workflow are updated and available for viewing from Payables’ Invoice Workbench, Tools.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 143 of 176 Rev Paradigm_revision

Page 144: Edu3fc4y AP

Practices 10 and 11 Overview: Placing and Releasing Holds

Practices 10 and 11 Overview: Placing and Releasing Holds

This practice covers the following topics:

• Place a Hold on an Invoice

• Practice - Release Holds

Practices 10 and 11 Overview: Placing and Releasing Holds

Refer to Practice - Place a Hold on an Invoice [LAB418DY]

Refer to Practice - Practice - Release Holds [LAB418EY]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 144 of 176 Rev Paradigm_revision

Page 145: Edu3fc4y AP

Oracle Payables for Complex Contract Terms Benefits

Oracle Payables for Complex Contract Terms Benefits

• Strengthening financial discipline and corporate governance while reducing compliance costs by:– Ensuring billing compliance with the terms negotiated on

the contract

– Automating retainage and financing recoupment

– Verifying invoices fall within your tolerance policies

– Providing workflow approval processing, history, and controls

• Improved Transparency into your business, financial, and compliance performance – Real-time update of the purchase order,

adherence to budgetary controls, accounting and tax reporting provide transparency

Oracle Payables for Complex Contract Terms Benefits

Reduce the cost of compliance for such corporate governance rulings as Sarbanes-Oxley and similar rulings found in other geographic areas. By automating retainage and financing recoupment, tolerance checking, and self billing options for approved work, there is less to worry about when auditing these functions. Workflow processing for approval and holds resolution provide a means of representing your processing procedures in the Payables application. Again, an auditing win particularly with complete approval and holds resolution history visible from the Invoice Workbench.

Real-time update of the purchase order, adherence to budgetary controls through funds checking and encumbrance accounting, accounting and tax reporting provide important business intelligence and transparency into your business.

Automating many items in the invoice area also reduces the cost of invoice processing and the opportunity for errors which may result in overpaying your suppliers.

Suppliers, Project Managers, Spend Managers, Buyers, Auditors, Accounting and Tax Staff, Payables Analysts and Payables Managers, stock holders and executive management are some of the key stakeholders who will benefit from streamlined processes, reduced costs for purchases and projects, minimized risks, and seamless collaboration.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 145 of 176 Rev Paradigm_revision

Page 146: Edu3fc4y AP

Oracle Procurement to Payables: Setup Overview

Oracle Procurement to Payables: Setup Overview

Approval Rules

Tax Configuration

Set key profile options

Supplier Attributes

Document Style

Payables Options

Invoice Tolerance Templates

Change Order

Tolerances

Financial Options

E-Business TaxApprovals

ManagementPayables

SystemAdministrator

Purchasing

Oracle Procurement to Payables: Setup Overview

The setup for this solution set falls into 5 main areas:

1. System Administrator: Profile Options

2. Purchasing: includes Document Styles which are required and Change Order Tolerances

3. Payables: has some options in Payables Options and invoice tolerance policies. Payables requires a setup in Financial Options and both Purchasing and Payables have items when defining the supplier

4. Oracle Approval Management Module approval rules allow configurability for approving work confirmations, invoices, and resolving invoice holds

5. Oracle e-Business Tax Module offers solutions for your global tax needs.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 146 of 176 Rev Paradigm_revision

Page 147: Edu3fc4y AP

Oracle Procurement Setup

Oracle Procurement Setup

• Profile Option: POR: Amount Based Services Line Type = Fixed Price Services– Responsibility: Purchasing

– Navigation: Setup:Purchasing > Document Styles

• The Purchase Order Document style defines the basic document rules of the Complex Work Purchase Order

• You can setup specific document styles for the purchase of goods and have a separate document style for the purchase of services

Oracle Procurement Setup

• Responsibility: Purchasing

• Navigation: Setup:Purchasing > Document Styles

The profile option POR: Amount Based Services Line Type specifies how services are to be quantified and ordered on the transaction document. In order to use the Complex Services functionality, the value for this profile option should be set to ‘Fixed Price Services’, which means that services will be ordered as an amount. You can find this setup via the System Administrator responsibility under System Profiles.

The Purchase Order Document style is key. It defines the basic document rules of the Complex Work Purchase Order. A Document Style builds additional functionality on the Document Type and provides the user the flexibility to tailor purchasing transaction documents like Orders and Agreements by exposing or suppressing specific features such as line types and complex payment term details.

Document Styles allow control regarding which commodities are purchased on the order. You can setup specific document styles for the purchase of goods and have a separate document style for the purchase of services.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 147 of 176 Rev Paradigm_revision

Page 148: Edu3fc4y AP

Styles also allow flexibility to use Progress Payments, Contract Financing and Advances, and Retainage on a contract.

There is also a checkbox that allows the Progress Payment Schedule to be treated as Contract Financing. This feature allows every payment released for work performed on the progress payment schedule to be treated as a financing payment that can be recouped from payments for deliveries on the contract.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 148 of 176 Rev Paradigm_revision

Page 149: Edu3fc4y AP

Payables Setup: Financial Options

Payables Setup: Financial Options

• Setting up Retainage Account for the Operating Unit.– Responsibility: Payables

– Navigation: Setup:Options > Financial Options

• You can define one retainage account for the Operating Unit

• The retainage distribution account on the invoice is used in the seeded accounting setup in Subledger Accounting.

Payables Setup: Financial Options

• Responsibility: Payables

• Navigation: Setup:Options > Financial Options

You can define one retainage account for the Operating Unit which Payables uses to record the distribution account on progress invoices and subsequent retainage release invoices for funds withheld from suppliers doing business with the organization. The retainage distribution account on the invoice is used in the seeded accounting setup in Subledger Accounting.

Historically the prepayment account entered here would default to the supplier site and be used when creating prepayments for the supplier. However, the new Advances and Contract Financing prepayments introduced with this solution will use the distribution account on the Purchase Order and not the supplier site.

If you plan on using encumbrance – review the Encumbrance options for Purchasing in the Encumbrance tab. For Payables, Encumbrance options are defined in Subledger Accounting.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 149 of 176 Rev Paradigm_revision

Page 150: Edu3fc4y AP

Payables Setup – Payables Options

Payables Setup – Payables Options

• Payables Option settings– Responsibility: Payables

– Navigation: Setup:Options > Payables Options

• Payables Option settings are not specific to this feature, however you may want to evaluate the Approval, Invoice, and Account tab options

• Use the Payables Options window to enable Payables Invoice Approval

Payables Setup – Payables Options

• Responsibility: Payables

• Navigation: Setup:Options > Payables Options

Use the Payables Options window to enable Payables Invoice Approval. This is used in conjunction with the Approval Management setup, discussed later in this presentation.

• Invoices Tab: Note the settlement days in particular. Settlement days provide you with an option to consider payment clearing days when recouping your prepayments. For example, even though you have approved and paid a prepayment advance, you may want to add additional settlement days before the advance can be recouped.

• Accounting Tab, the prepayment account setting is only used as a Subledger account derivation rule – in other words, you will see this option used when you View Accounting.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 150 of 176 Rev Paradigm_revision

Page 151: Edu3fc4y AP

Payables Setup: Invoice Tolerances

Payables Setup: Invoice Tolerances

• Global Tolerance Policies Set up

• New “Service” type provides central control over tolerance policies for both Goods and Services

• You can define both percentage–based and amount–based tolerances

• You can define many tolerance templates for goods or services and then assign the most appropriate templates to the supplier sites

Payables Setup: Invoice Tolerances

• Responsibility: Payables

• Navigation: Setup:Options > Payables Options > (T) Invoice

Use the Invoice Tolerances Template, Service Type to define the matching tolerances policy for variances between the amount being invoiced and the amount planned on the Services Procurement Contract or the work to date represented by the approved work confirmations. You can define both percentage–based and amount–based tolerances. While it states Services, this is really for all amount based matching. Define Goods Tolerance templates for quantity based purchases. You can define many tolerance templates for goods or services and then assign the most appropriate templates to the supplier sites. This allows you to manage your tolerances values centrally yet assign your policies at the trading partner location.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 151 of 176 Rev Paradigm_revision

Page 152: Edu3fc4y AP

Shared Setup: Supplier Terms & Controls

Shared Setup: Supplier Terms & Controls

Supplier Terms & Control Set Up

• Tax Details: Tax registrations and options

• Receiving: Match Approval Level

• Purchasing: Self Billing Settings

• Invoice Management: Match Option, Retainage Rate

Shared Setup: Supplier Terms & Controls

• Responsibility: Payables

• Navigation: Supply Base > Suppliers

Set up suppliers in the Suppliers page to record information about individuals and companies from whom you purchase goods and services.

Tax registrations and profiles are defined for the supplier and the buying Organization can specify Payables accounting defaults, the Invoice Match Option, Match Approval Level, and Retainage Rate to default on the purchase order, Self Billing options, and the Tolerance Templates just mentioned on the previous slide.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 152 of 176 Rev Paradigm_revision

Page 153: Edu3fc4y AP

Oracle Approvals Management Setup Approval Rules

Oracle Approvals Management SetupApproval Rules

Approval Processing Setup

• Oracle Approvals Management is a common module that allows you to configure rules which determine approvers for business transactions or activities

• New Transaction Types in Release 12:– Work Confirmation transaction type

– Payables Holds Resolution transaction type

– Payables Invoice Approval transaction type

Oracle Approvals Management Setup: Approval Rules

• Responsibility: Payables

• Navigation: Setup:Invoice > Approval Workflow

Oracle Approvals Management is a common module that provides users the ability to configure rules which determine the approvers within the enterprise for business transactions or activities. In other words, a software application representation of your approval policies. The Work Confirmation and Payables Holds Resolution transaction types are new in Release 12.

• The Work Confirmation transaction type allows rule configuration for determining the most appropriate person to evaluate, certify and approve the work confirmation. This could be a field engineer, a project manager or even an architect.

• The Payables Holds Resolution transaction type allows rule configuration for determining the most appropriate person to research and resolve invoice holds.

• The Payables Invoice Approval transaction type has been enhanced to support line level and document level approvals plus optional rules which allows you to forgo invoice approval if the invoice is matched to a purchase order.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 153 of 176 Rev Paradigm_revision

Page 154: Edu3fc4y AP

Oracle eBusiness Tax Setup: Tax Configuration

Oracle eBusiness Tax Setup: Tax Configuration

• Standard Invoices:– Tax on Progress To-Date (Net of retainage)

– Tax on Final Delivery

• Prepayments– Tax on Advance (Yes or No)

– Tax on Progress Treated as Financing (Yes or No)

– Prepayment Application Tax Treatment

• Retainage Release:– Tax on retained amounts ready to be released

• First Party and Third Party Tax Profiles and Registrations

Oracle eBusiness Tax Setup: Tax Configuration

• Responsibility: Payables

• Navigation: Setup:Tax > E-Business Tax Home

Oracle eBusiness Tax is a new infrastructure for tax knowledge management and delivery using a global system architecture that is configurable and scalable for adding country specific tax content. As the single point solution for managing transaction-based tax, Oracle e-Business Tax uniformly delivers tax services to all Oracle E-Business Suite business flows through one application interface.

Note that if you are already using Oracle in 11i – all tax setup will already be available for you when you upgrade to R12.

Standard invoices for progress and deliveries are taxed. You can configure how you would like prepayments and prepayment recoupment to be taxed. Retainage Release is taxed based on the original invoice's tax drivers.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 154 of 176 Rev Paradigm_revision

Page 155: Edu3fc4y AP

Prepayments: Tax Configuration Example

Prepayments: Tax Configuration Example

1. Pick your Tax Regime & Tax

2. Create a Tax Rule for All Transactions

3. Add a Line Class condition: P2P Advance; P2P Contract Financing

4. Assign a Tax Rate for when the condition is True

Prepayments: Tax Configuration Example

To configure specific tax treatment for advances and contract financing, use the new features offered by Oracle e-Business tax based on their Regime to Rate flow. For example, you may want to tax Contract Financing prepayments but not Advances. In this case, you can create a tax rule which will look specifically for line classes of P2P Advance or P2P Contract Financing to assign a specific tax rate.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 155 of 176 Rev Paradigm_revision

Page 156: Edu3fc4y AP

Practice 12 Overview: Setting Up US Sales Tax

Practice 12 Overview: Setting Up US Sales Tax

This practice covers the following topics:

• Creating a Tax Regime

• Creating a Tax

• Creating a Tax Status

• Creating a Tax Rate

• Creating a Tax Jurisdiction

• Set Tax Status as Default Status

• Ensure Tax Rate is Set as Default Rate

• Define Tax Rules

• Enable Tax for Transactions

Practice 12 Overview: Setting Up US Sales Tax

Refer to Practice – Setting Up U Sales Tax [LAB3FEAY]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 156 of 176 Rev Paradigm_revision

Page 157: Edu3fc4y AP

Practice 13 Overview: Entering an Invoice with US Sales Tax Lines

Practice 13 Overview: Entering an Invoice with US Sales Tax Lines

This practice covers the following topics:

• Entering an Invoice with US Sales Tax Lines

Practice 13 Overview: Entering an Invoice with US Sales Tax Lines

Refer to: Practice - Entering an Invoice with US Sales Tax Lines [LAB418CY]

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 157 of 176 Rev Paradigm_revision

Page 158: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

Required

• Payables

• Purchasing

• Services Procurement

• Supporting Modules: Workflow and Approvals Management

Optional Products

• Oracle Sourcing

• Oracle Procurement Contracts

• Oracle iSupplier Portal

• Oracle iProcurement

• Oracle Projects

Implementation Considerations

Payables, Purchasing, and Services Procurement are required for this feature. With Payables, you will have Oracle Financials supporting modules including e-Business Tax and Subledger Accounting. Approvals Management is required to approve work confirmations and optional depending on if you will leverage Payables Invoice Approval feature – however using Payables Invoice Approval feature is recommended.

Additional Procurement and Projects products participated in this solution set and you can choose your product combination based on your needs.

• Oracle Sourcing (Optional)

- Negotiate with Suppliers on Payment Terms and Payment Schedule

• Oracle Procurement Contracts (Optional)

- Use Clauses & deliverables on Contract

• Oracle iSupplier Portal (Optional)

- Track execution of Contract

- Create & Submit Work Confirmation

- Create & Submit Invoices for Progress Payments, Advances & Financing

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 158 of 176 Rev Paradigm_revision

Page 159: Edu3fc4y AP

• Oracle iProcurement (Optional)

- Create Service Requests

• Oracle Projects (Optional)

- Create requisitions for complex work.

- Track commitments and actuals against other project work

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 159 of 176 Rev Paradigm_revision

Page 160: Edu3fc4y AP

Agenda

Agenda

• Supplier Related Enhancements

• Deferred Recoverability

• Enhanced Asset Tracking

• Payment Requests

• Payment Method Controls And Enhanced Payment Information

• Self Assessed Tax

• Oracle Payables for Complex Contract Terms

• Multi-Org Access Control in Payables

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 160 of 176 Rev Paradigm_revision

Page 161: Edu3fc4y AP

Multi-Org Access Control in Payables Description

Multi-Org Access Control in Payables Description

• Multi-Org Access Control (MOAC) enables cross organizational processing and reporting on Operating Units in subledgers.

• For example, you can select invoices across operating units for payment processing within a single pay run.

• A security profile determines a user’s set of accessible Operating Units.

• Enhanced Multi-Org Reporting

• Run several Payables reports at ledger or ledger set level

Multi-Org Access Control in Payables Description

MOAC is an enhancement to the Multiple Organizations feature of Oracle Applications. MOAC allows a user to access data from one or many Operating Units while within a given responsibility. In prior releases, each responsibility was linked to one and only one Operating Unit.

Data security is maintained using security profiles that are defined for a list of operating units and determine the data access privileges for a user.

Multi-Org Access Control also provides a basis for use to expand the scope of some of our standard reports. Reports such as the Posted Payments Register now run for a ledger and include transaction data for all OUs that are part of that ledger.

• There is now an exposed OU field for all transactions and setup data that is not shared across operating units, like Payables Options.

• On data entry, OU will be derived by the system, when possible. For example, if a user enters a PO default invoice, the supplier site will determine the OU.

• A user can submit concurrent programs for all operating units or one operating unit. To submit a concurrent program for all operating units, leave the Operating Unit parameter

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 161 of 176 Rev Paradigm_revision

Page 162: Edu3fc4y AP

blank. Oracle Payables will process data for that user’s set of accessible Operating Units, as determined by their Multi-Org Security Profile, defined in Oracle HRMS.

• The following Payables reports can now be run across multiple OUs: Posted Invoice Register, Posted Payments Register, and the Open Account Balances Listing (formerly known as the Trial Balance). When a user submits one of these reports, they can select a ledger or ledger set in the Ledger/Ledger Set parameter. Oracle Payables will include data for all Operating Units for which the user has access, as determined by their Multi-Org Security Profile, belonging to that Ledger/Ledger Set. All other Payables Standard Reports now have an OU parameter that is mandatory and will set the context for that run of the report.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 162 of 176 Rev Paradigm_revision

Page 163: Edu3fc4y AP

Multi-Org Access Control in Payables Description

Multi-Org Access Control in Payables Description

• MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.

• Possible tasks include:– Invoice Processing

– Payment Processing

– Run Reports, such as Posted Invoice and Payment Registers, Open Account Balance Listing

– Run Concurrent Programs, such as Validation and Invoice Import

– Close Periods

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 163 of 176 Rev Paradigm_revision

Page 164: Edu3fc4y AP

Multi-Org Access Control in Payables Benefits

Multi-Org Access Control in Payables Benefits

• Increase Efficiency– Shared Service Center employees can be more efficient

because they can process transactions for multiple Operating Units.

• Reduce Costs– Reporting costs are reduced since users can submit

standard reports for multiple OUs as well as submit certain reports that gather data from multiple OUs.

• Improve Timeliness and Accuracy of Information– MOAC adds to the timeliness and accuracy of

information by providing a consolidated view of data across Operating Units, eliminating the need for manual aggregation.

Multi-Org Access Control in Payables Benefits

Multi-Org Access Control enables companies that have implemented a Shared Services operating model to efficiently process business transactions by allowing them to access, process, and report on data for an unlimited number of operating units within a single applications responsibility. This increases the productivity of Shared Service Centers, as users and processes no longer have to switch applications responsibilities when processing transactions for multiple operating units at a time.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 164 of 176 Rev Paradigm_revision

Page 165: Edu3fc4y AP

Multi-Org Access Control Process

Multi-Org Access Control Process

OpenPayables setup form

orPayables transaction form

Enter data foroperating unit and

proceed to next task

PAYABLES PROCESS

Submit Concurrent Program Or

Standard Report

Applicationchecks

access privilege

Automated process

Multi-Org Access Control Setup and Process

The MOAC setup steps referenced above pertain to general Multi-Org Access Control setup, not specifically MOAC in Payables. Do this setup once and all applications will be setup for MOAC.

Payables Process includes:

• Setting up processing options, like Financials and Payables Options

• Entering transaction data like Invoices and Payments. Many setup items are not specific to an operating unit, like Payment Terms. You can define Payment Terms once then specify which particular Payment Term is the default for a given Operating Unit and Supplier Site in the new Suppliers Invoice Management form.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 165 of 176 Rev Paradigm_revision

Page 166: Edu3fc4y AP

Multi-Org Access Control Process, Invoice Entry

Multi-Org Access Control Process, Invoice Entry

• There is now an OU field on the Invoice Workbench

• Select an Operating Unit, or enter another field, such as PO or Supplier Site, from which the system will default the OU

• The application automatically provides the operating unit of new (uncommitted) invoices during entry.

Multi-Org Access Control Process, Invoice Entry

• Responsibility: Payables

• Navigation: Invoices:Entry > Invoices

On the Invoice Workbench, you can select an Operating Unit, or enter another field, such as PO or Supplier Site, from which the system will default an OU. Your list of available OUs is determined by your multi-org security profile defined in Oracle HR and associated to their responsibility through the MO Security Profile profile option.

The application automatically provides the operating unit of new (uncommitted) invoices during entry. The following are methods by which the operating unit is derived:

• Default Operating Unit from “MO: Default Operating Unit” Profile Option

• Default Operating Unit from Invoice Batch Header

- When entering invoice batches, users have the option of establishing a default operating unit for the invoices entered in the batch. This can be overridden at the invoice level as with any other value (Payment Method, for example) entered in the Invoice Batches window.

• Derive Operating Unit from Transaction Attributes

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 166 of 176 Rev Paradigm_revision

Page 167: Edu3fc4y AP

- Oracle Payables will derive the operating unit of an invoice based on certain user entered attributes. If the user chooses a PO (via PO Default or QuickMatch features) or supplier site when the Operating Unit field is empty, the Operating Unit corresponding to the selected value will be populated onto the invoice.

• Set Operating Unit from Single Operating Unit Security Profile

- When a user’s security profile contains only one operating unit, it can be said that the user’s operating unit context has been “set” to this operating unit. This value is automatically defaulted to all new invoices and it cannot be overridden.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 167 of 176 Rev Paradigm_revision

Page 168: Edu3fc4y AP

Multi-Org Access Control Process, Payment Templates

Multi-Org Access Control Process, Payment Templates

• There is a new Payment Process Request Template

• Use to submit a “Payment Batch”

• Select invoices for payment regardless of their OU by selecting the All option in the Operating Units region.

• You also have the ability to specify a list of OUs.– As in the invoice workbench, the list of OUs you can

specify is determined by your security profile.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 168 of 176 Rev Paradigm_revision

Page 169: Edu3fc4y AP

Multi-Org Access Control Process, Controlling Payables Periods

Multi-Org Access Control Process, Controlling Payables Periods

• On the Control Payables Periods form, with Multi-Org Access Control you can close periods for all Operating Units in a given Ledger.

• Each Payables accounting calendar is associated with one ledger and its accounting calendar, defined in GL.

• You can now access the Control Payables Periods window for all ledgers that correspond to the operating units that you have access to, as determined by your security profile.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 169 of 176 Rev Paradigm_revision

Page 170: Edu3fc4y AP

Multi-Org Access Control Process, Submitting Concurrent Request

Multi-Org Access Control Process, Submitting Concurrent Request

• There is a new OU parameter that you will when you submit a concurrent request in R12

• When submitting the Invoice Validation routine, if you leave the OU parameter null, the routine will process data for multiple operating units in a single run.

• Oracle Payables will process data for your set of accessible Operating Units, as determined by you Multi-Org Security Profile, defined in Oracle HRMS.

Multi-Org Access Control Process, Submitting Concurrent Request

Details on Open Interface Import: Payables Open Interface Import is a concurrent process that validates and imports invoice records from external applications.  Leave the OU parameter blank to have the system import any record having an org_id identifier and ignore those without it. Specify an operating unit to have the system import any records belonging to that operating unit, as well as any records having no org_id identifier, placing them in this operating unit.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 170 of 176 Rev Paradigm_revision

Page 171: Edu3fc4y AP

Multi-Org Access Control Process, Submitting Standard Report

Multi-Org Access Control Process, Submitting Standard Report

• Submit the Payables Posted Invoice Register or Payables Posted Payments Register for a Ledger or Ledger Set.

• Oracle Payables includes data for all Operating Units that you have access to, as determined by your Multi-Org Security Profile, belonging to that Ledger/Ledger Set.

• All other Payables Standard Reports now have an OU parameter that is mandatory and will set the context for that run of the report.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 171 of 176 Rev Paradigm_revision

Page 172: Edu3fc4y AP

Multi-Org Access Control Process, Open Account Balances Listing Report

Multi-Org Access Control Process, Open Account Balances Listing Report

• Trial Balance is known as the Open Account Balances Listing report

• It runs based on the Open Account Balances Listing Definition that you define

• You can define the Listing Definition at a Ledger or Ledger Set level

Multi-Org Access Control Process, Open Account Balances Listing Report

In Release 12, the Trial Balance is known as the Open Account Balances Listing report. It runs based on the Open Account Balances Listing Definition that you define then select as a parameter when you submit the Open Account Balances Listing report.

As a prerequisite, you must run the Open Account Balances Data Manager and select the Open Account Balances Listing Definition in the parameter labeled “Trial Balance Definition”. You can define the Listing Definition at a Ledger or Ledger Set level such that when you run the report, you can view open liability balances for all operating units belonging to a given ledger or ledgers within a ledger set.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 172 of 176 Rev Paradigm_revision

Page 173: Edu3fc4y AP

Multi-Org Access Control Setup

Multi-Org Access Control Setup

Define security profile &assign operating units

Run Security List Maintenance

Assign security profile to

responsibility or user

GENERAL MOAC SETUP

Automated process

Multi-Org Access Control Setup and Process

The MOAC setup steps referenced above pertain to general Multi-Org Access Control setup, not specifically MOAC in Payables. Do this setup once and all applications will be setup for MOAC.

Payables Process includes:

• Setting up processing options, like Financials and Payables Options

• Entering transaction data like Invoices and Payments. Many setup items are not specific to an operating unit, like Payment Terms. You can define Payment Terms once then specify which particular Payment Term is the default for a given Operating Unit and Supplier Site in the new Suppliers Invoice Management form.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 173 of 176 Rev Paradigm_revision

Page 174: Edu3fc4y AP

Multi-Org Access Control Payables Setup

Multi-Org Access Control Payables Setup

Use the Payables Options form to set up:

• Payables Options

• Financials Options

• Supplier Sites – Payment Details

– Invoice Management

– Accounting Options

– Etc.

• Withholding

• Tax Codes and Details

Multi-Org Access Control Payables Setup

• Responsibility: Payables

• Navigation: Setup:Options > User Operating Unit Preferences

The Payables Options form is an example of one of the Payables setup forms that now requires you to specify an Operating Unit. You can select from a list of operating units for which you have access, as determined by your Multi-Org Security Profile. The other setup forms that require OU include:

• Financials Options

• Withholding Tax Codes and Details

• Supplier Sites

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 174 of 176 Rev Paradigm_revision

Page 175: Edu3fc4y AP

Implementation Considerations

Implementation Considerations

Integration with Procurement products may require setup and use.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 175 of 176 Rev Paradigm_revision

Page 176: Edu3fc4y AP

Summary

Summary

In this topic, you should have learned how to:

• Describe and use the new features in Release 12 of Oracle Payables.

• Set up the new features in Release 12 of Oracle Payables.

Copyright © Oracle, 2008. All rights reserved.

Oracle Accounts Payable document.docEffective Paradigm_effective Page 176 of 176 Rev Paradigm_revision