11.5.7 Payables New Features

1
11.5.7 Payables New Features

• Steve Bradley
• OASIS Consulting Group

2
Introduction

• Oracle has worked out most of the initial bugs in
  11i. Now they are rolling out some really nice
  features that make the move to 11.5.7 worthwhile
• My current project is upgrading a 10.7 Character
  and SC client to 11.5.7/8

3
NACHA Payment Format

• Finally!!! It has taken Oracle over 10 years to
  come up with this commonly requested feature.
• In 11.5.7 you can now use direct deposit for
  vendor/employee payments.
• We have taken this format and back ported it to
  10.7. This is not Oracle supported but can be
  done easily.

4
E-mail Remittance Advice

• You can have Oracle Payables send the
  notification of payment via e-mail by including
  an e-mail address in the vendor site Payments
  region
• Notify employees of direct deposit payments of
  expense reports
• The E-mail Remittance Advice includes appropriate
  payment information for all invoices on each
  payment
• It is automatic upon confirmation of payment
  batches or Quick payments

5
Enhanced Key Indicators Report

• This report can now be run on individual Payables
  users or the full department.

6
Employee Update Program

• This was included in 11.5.5 but is worth a
  mention here.
• Updates the Payables supplier record for any
  employee information changed in HR or from the
  Enter Person form
• This program is run when you import expense
  reports or it can be run as needed

7
Enhanced Suppliers Report

• The old New Supplier Site Listing has been
  eliminated by combining it with the Suppliers
  Report
• New selection criteria have been added so you can
  select by income tax reportable or maintenance
  performed by a specific person
• New data in the report includes remittance bank
  account, TIN, income tax type and payment method

8
Approval Manager

• This is so new, Oracle Sales did not know about
  it and will not be able to demo it until late
  November
• There is very little activity for this topic on
  the list servers
• It is the future direction of approval routing
  for all workflows

9
Approval Manager (cont.)

• Currently available for
• Invoice Approval
• Expense Report Approval
• Purchase Requisition Approval

10
Approval Manager (cont.)

• It is a highly sophisticated method of selecting
  the correct approval routing for documents
• Supports complex rules including
• Pre-approval and post approval review groups
• Designated approvers for temporary absences
• Approval routings for
• specific documents
• departments
• other items you may want to define

11
Invoice Approval

• Uses Approval Manager to route invoices for
  payment approval
• Invoice header and at least one distribution line
  must be entered
• Entry of the Requestor of the product or
  service becomes the seed data for the approval
  process

12
Invoice Approval (cont.)

• If Invoice Approval is invoked almost all
  invoices must be processed by the Invoice
  Approval Workflow
• Exceptions
• Imported Expense Reports
• Recurring invoices where template indicates no
  approval
• PO Matched (can be configured to omit)

13
Effective Exchange Rate Calculation

• This is nice if you know the foreign currency and
  functional currency amounts for an invoice but
  not the exchange rate.
• Enter both of these and Oracle will calculate the
  exchange rate for you.

14
Unclaimed Property Report

• This report can be used to satisfy the escheat
  laws. It lists all uncleared Payables payments.

15
Payment Batch Scheduling

• Define payment batch sets (including multiple
  accounts) and schedule them for regular payment
  intervals.
• The scheduling routine will change the pay
  through dates, exchange rate date and payment
  dates as needed.

16
Automatic Bank Transmission

• Workflow is used in this feature to transmit bank
  payment data and receive payment confirmations.
• By combining this with the NACHA payment format,
  payment batch scheduling and e-mail notification
  you can automate the whole payment process for
  electronic payments.

17
Primary Pay Site

• If a supplier has more than one site you can now
  specify one of them as the Primary Pay Site.
• The Primary Pay Site will then be the default
  site displayed for invoice entry (as if it were
  the only site for the supplier).

18
Still Not Fixed

• Laser check printing
• Oracles new solution still requires custom
  code for logos, signatures and MICR line
• Also suggests using Evergreen solution
• Invoice and Payment Currency not the same
• You still cannot enter a French Franc (EURO now)
  invoice and pay it in USD. You can enter a French
  Franc invoice and pay it in EURO.

19
11.5.7 GL New Features

• Steve Bradley
• OASIS Consulting Group

20
FSG Report Set Enhancements

• Multiple users can view and submit FSG report
  sets at the same time.
• Prior versions locked the report set when it was
  in use.
• Additionally, a history of report set submissions
  is now maintained so ADI users do not need to
  resubmit reports sets to publish them in ADI

21
Hierarchical Security Support

• Hierarchy security relates to security assigned
  to Parents of child segment values.
• The children inherit the security assigned to the
  parent.
• This means you can assign security to the Owners
  Equity parent and have it affect all children of
  that parent.

22
FSG Hierarchical Security Support

• This is a companion feature to Hierarchical
  Security
• It provides the functionality for FSG reports to
  exclude child data that is secured at the parent
  level
• The security is assigned to the users by
  responsibility.

23
Enhanced Compatibility

• Now you can perform the following in multiple
  sets of books at the same time (in parallel).
• Budget Upload
• Translation
• Open/Close Periods
• Posting

24
Enhanced MassAllocation Performance

• The performance has been enhanced for formulas
  that process large numbers of child segments.

25
Account Hierarchy Manager

• This is in effect a web version of the ADI
  Account Hierarchy Editor.
• It does not require the installation of any
  client software at the PC level

26
Segment Value Security for Journals Reports

• All of the journal listing reports have been
  modified to exclude data in compliance with
  Flexfield security assigned to their
  responsibility.

27
Journal Import Adjusting Period Support

• Prior to this enhancement, imported journals
  (including ADI) could only use non-adjustment
  periods.
• Now Period Name and Accounting Date will be used.
  
• In cases of conflicting periods from these values
  the Accounting Date will typically be used.

28
Journal Import Currency End Date Bypass

• This feature permits the import of journals using
  expired currency codes.
• It does require the creation of a custom profile
  option for its use.

29
11.5.7 New GL AP Features

• Questions will be addressed
• in Breakout Session
• Steve Bradley
• OASIS Consulting Group, Inc.
• sbradley_at_sprynet.com
• [phone]