Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Welcome to R12 Account Payable

Posted on February 22nd, 2007 by anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

As we learnt during Release 12, the E-Business Suite has couple of new products like Subledger Accounting, E-Business Tax thus significant changes have been observed in Account Payable data module as some of functionality is shared by some other products. Thus it is important to understand what is new. I would like to briefly outline the details of some of new changes and underlying impact on the objects. More details can be found in R12 release documents published by Oracle a month ago.

Let’s have a dissection view of R12 payable, with some of its core objects

Supplier

We have seen in 11i

  • Suppliers defined in AP.
  • Supplier contacts replicated for each supplier site.

Where as in R12

  • Supplier becomes as TCA Party.
  • Suppliers Sites as TCA Party Site for each distinct address.
  • Contacts for each supplier/address , it means Single supplier address and contact can be leveraged by multiple sites, for each OU
    • A single change to an address can be seen instantly by all OUs
    • No longer need to manually 'push' updates across OUs.This can be best understood by the figure below.

SuppliersContact

Then the question is what will happen if any one can come from existing financial products. The Impact from upgrade can summarize as:

1. When we upgrade supplier tables replaced with backward compatible views.

2. One party site for each distinct supplier site address

Country and address line1 are required, this is because creation of suppliers in Party in TCA data model would requires Country and address information, but it also understood if there is no country or address line 1 specified for a supplier site in cases when upgrades takes place, Payables derives the country based on the most frequently used operating unit of the Supplier's historical transactions.

3. Employee as suppliers: address NOT migrated to party site in TCA remains in Oracle HR for data security reasons.

As we know in 11i employees are part of internal supplier's record in order for Oracle Payables to create payments for their expense reports. Employees defined in Oracle Human Resources and associated with an Oracle Payables supplier record have existing party information. During the upgrade, Oracle Payables updates the existing party information to have a party usage of supplier but it does not migrate the employee address to the party site in TCA, they remain in Oracle Human Resources for data security reasons.

4. Utilize TCA Party relationships for franchise or subsidiary and its parent company.

Invoice

Till 11i version, we have seen invoices:

  • Had only distributions line.
  • Allocation of freight and special charges are captured at the distribution level only
  • Tax and payment and Project accounting Payment was captured through global Descriptive Flexfields.

But in R12,

1. Invoice Lines as a new additional line accommodated in Invoice data model.

12RInvoice

Because of introduction of invoice line there is significant improvement of data flow with n other oracle modules like

  • Fixed Asset - Asset Tracking
  • Business Tax - Tax line
  • Payment - Payment
  • SubLedger Accounting - Accounting

 

2. Allocate freight and special charges are captured to the lines on the invoice
3. Invoice distributions created at the maximum level of detail similar to 11i.
4. Core functionality

The impact with Upgrade can be summarized as:

1. One invoice line for every distribution in 11i
2. Sub Ledger Accounting requires that Payables transform the invoice distributions to be stored at the maximum level of detail
3. Global Descriptive Flexfields migrated to named columns.

          That's means functional testing is more required while upgrade takes place.

Banks and Bank Details

Now a days corporate treasury role has been greatly enhanced thus picking up a global bank as partner for all banking need is demand of time in global working model. The recent couple of years have seen drastic increase in acquisition and merger of company thus global working as well as global instance get popularity in ERP areana, and this is one of reason of the reason bank data model has been significant changes from 11 to 11i and 11i to R12.

Internal Bank Accounts
In 11i we have seen internal Banks defined in AP and that is shared by AP/AR/CE, Payroll and Treasury and they are bank accounts often replicated in multiple OUs

Where as in R12,

  • Bank and Branch become part of TCA Parties.
  • Internal Bank Account in Cash Management which is owned by a Legal Entity. Here the Operating units have granted usage rights.

Suppliers Bank Accounts
In 11i

  • Banks/Branches defined in AP
  • Bank accounts often replicated in multiple OUs Before

R12

  • Suppliers, Banks and Branches are defined as Parties in TCA
  • Supplier (party's) payment information and all payment instruments (Bank Accounts, Credit Cards) moved into Oracle Payments.

The typical data model for bank can be summarized as:

R12BankDataModel

Impact of Upgrade

1. With Upgrade banks and branches migrated to TCA parties
2. Banks merged if the following attributes are all the same:

  • a. Bank Number
    b. Institution type
    c. Country
    d. Bank admin email
    e. Bank name alt
    f. Tax payer ID
    g. Tax reference number
    h. Description, Effective dates

3. Bank accounts, bank account uses are migrated into cash management.
4. Transactions are stamped with the bank account uses identifiers as part of the upgrade

 Integration with Oracle E-Business Tax

In 11i

  • Oracle standard functionality was based out of User which determines tax by assigning Tax Codes at line level of invoice and Tax rules was controlled at underline code.
  • There was global descriptive flex fields were captured for country-specific tax attributes.
  • More importanta most of the setup performed at OU level.

In R12

  • A new module eBusinessTax determines tax based on facts about each transaction, this is reason why Oracle has introduced additional line information at invoice level.
  • The module "ebusiness Tax" set and configure Tax rules which can be viewed
  • Tax attributes collected in fields on key entities
  • Configure tax rules once per regime and share with your legal entities

Impact of Upgrade
1. Payables Tax setup, Tax Code defaulting rules defined per OU are migrated to eBusiness Tax.
2. OUs migrated to tax content owner in R12
3. Tax information in tax codes are transformed to Regime-Rate flow.
4. E-Business Tax takes information from the AP invoice lines and creates summary and detail tax lines in the E-Business Tax repository.

Multi Org Access Control

MOAC is new enhancement to the Multiple Organizations feature of Oracle Applications.

This feature enables user to access data from one or many Operating Units while within a set given responsibility. Due to this change, all processing and some Reporting in Oracle Payables is available across Operating Units from a single Applications responsibility. Hence you can isolate your transaction data by Operating unit for security and local level compliance while still enabling shared Service centre processing.Data security is maintained using the Multiple Organizations Security Profile, defined in Oracle HRMS, which specifies a list of operating units and determines the data access privileges for a user.

Impact of Upgrade
R12 Upgrade does not automatically create security profiles, thus is important if any one want to use Multiple Organizations Access Control, the first things is to define security profiles, then link them to respective responsibilities or users.

Reference: Details can be found more on R12 RCD documents, from Oracle site.

Related Posts

Posted in Oracle Payable, R12 | 28 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
28 Responses
  1. Suresh Kumar E Says:

    Hello sir,

    can you tell me the R12 upgrade impact in Inventory, Purchasing and Order Management.

  2. Benny Says:

    Hi Anand,

    U have done a good job, thankyou for the valuable info.

    cheers,
    Ben

  3. Highlights:Release 12 Financials Says:

    […] Welcome to R12 Account Payable […]

  4. Shiva Prasad Bollempally Says:

    Hi Anand,
    Thanks for your valuable information regarding AP in 12i to that of 11i.

    Regards,
    Shiva

  5. Amjad Says:

    Hi Anand,

    Thanks for u r valuable information regarding R12.

    Regards,
    Amjad.

  6. Usman Says:

    Simply Awesome!

  7. Really useful Says:

    Thanks a lot!

  8. Ram Ganesh Says:

    Hi

    the article on Payables in R12 was useful.

    With Best Regards
    Ram Ganesh.B

  9. R12 : AP Trail Balance Says:

    […] Welcome to R12 Account Payable […]

  10. S MuthukrishnaN Says:

    Hi,

    It was very useful for me. Thanks.

  11. Jilbil Says:

    Ta thats a great stuff mate

    Cheers
    Jilbil

  12. Saritha Says:

    Hello Anand,
    Want to say thank you for putting together such informational site.

    This topic of R12 AP is very informative. However if you could include enhanced features of “Payments”, also will be more helpful.

    thanks again and kudos to your knowledge

  13. Sanjit Anand Says:

    Thanks Saritha,

    I will try to put some information for r12 Payment, if times permits.

    Regards
    sanjit

  14. sanjeev Says:

    Hi,

    It was very useful for me.

    Cheers,
    Sanjeev

  15. karthiyayini Says:

    Hi Anand,
    It is a valuable and useful information.

  16. Highlights:Release 12 Oracle EBS Financials | OracleApps Epicenter Says:

    […] Welcome to R12 Account Payable […]

  17. Soorya Says:

    What does the branch type such as ABA, PFC, SWIFT, CHIPS mean?

  18. DAYANANDA Says:

    Sir you have done a good job, thankyou for the valuable information

  19. R12 Supplier Bank - Techno Functional Guide | OracleApps Epicenter Says:

    […] Welcome to R12 Account Payable […]

  20. Sudha Says:

    Anand,
    It is very useful docuement. Appreciate if you can give us details like what will be changes in tables..

  21. Sabon Says:

    Dear Anand
    Helpful topic……….

  22. Mary Says:

    Hi,

    Thank for compilling info in one good place.

    Can share details regarding the billing extension in oracle projects?

  23. Manish gautam Says:

    What is R-12 and how the R-12 is helpful in invetory and purchase module

  24. Karthik Says:

    Hi
    I need P2P and O2C flow along with Screens.

  25. Puneet Pareek Says:

    Amazing Stuff Dude !! Love the explanation !!

  26. Ganesh Says:

    Very Nice article Thanks …

  27. veera Says:

    It was very useful for me. Thanks

  28. sachin Says:

    Hi,

    Can u send GL,AP &AR configration screen shot with test cases?

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.