Oracle provides the ability to enter manual sub-ledger journals via a button on the SLA Journal Inquiry pages.

A manual subledger journal entry is not associated with a transaction or document of a subledger application. If you are considering using the manual SLA journal feature to represent accounting in legacy systems, you can take the advantage of API which allows you to import such transactions into SLA rather than into the GL directly (via the GL interface).

You can use the API XLA_JOURNAL_ENTRIES_PUB_PKG and any of these functions:

• Create_Journal_Entry_Header: This is used creates a new subledger journal entry header
• Update_Journal_Entry_Header: This is used to modifies an existing manual subledger journal entry header, if journal entry is not Final and GL_DATE used must belong to a valid accounting period.
• Delete_Journal_Entry:This deletes all information of a subledger journal entry including journal entry header and journal entry line
• Create_Journal_Entry_Line:This is used to Create the JE line
• Update_Journal_Entry_Line :This is used to Delete the JE line
• Delete_Journal_Entry_Line :This is used to Delete the JE line
• Complete_Journal_Entry: This is used to completes a subledger journal entry
• Reverse_Journal_Entry : This is used to reverse the entry.

These API's you can find more on Oracle Financial Services Accounting Hub Implementation Guide Release 12 Part No. B14420-01

You don't need to have an FSAH License to be able to use those APIs.

Do you know, In Release 12.1 Trade Management is now a suite of four products as below in a new product family called Oracle Channel Revenue Management that manages financially oriented channel processes.

1. Accounts Receivable Deduction Settlement
2. Advanced Rebates and Point of Sale Management
3. Price Protection [This is new product in R12.1]
4. Supplier Ship and Debit [This is new product in R12.1]

Adding these Products in Line of your Business will help you to :

• Decrease in Deductions DSO and improved visibility into all processes
• Improved Margins through process automation and accuracy with an integrated solution
• Increased productivity through automation of traditional spreadsheet managed processes
• Reduced revenue leakage

Typically these products are best suited for industry like High Tech, Life Sciences/HealthCare, Wholesale/Retail, that application are best suited if you are considering for "Invoice to Settlement" Business flow.

Lets have a brief introduction for these family products.

ACCOUNTS RECEIVABLE DEDUCTIONS SETTLEMENT

This provides a central repository of all claims and deductions to claim analysts, giving them easy access to the information they need to resolve claims quickly, and to give management full visibility into outstanding claims and deductions. It integrates resolution of deductions and claims with receivable systems and accounts payable and validates that the correct general ledger accounts are assigned. Properly approved claims automatically spawn payments and credits in Oracle Payables and Oracle Receivables.

Some of key functionality for this products are :

• Dispute/deduction handling
• Rebates Settlement
• Promotional Payments View
• Complete AR processing that means you get high visibility into aging buckets and total amounts outstanding
• Lockbox integration additional you have customer reason code mapping
• Auto-write offs
• Mass Settlements

This application is have Integration with Accounts Receivables, Accounts Payable, Order Management, General Ledger, Channel Rebate and POS Management ,Tax Engine and Oracle Collection.

Those who have high transactional volume of invoicing and disputes and currently using Oracle Financials and Order Management take take advantage of this products. This also help in order to meet your compliance regulations

ORACLE CHANNEL REBATE AND POINT-OF-SALE (POS)

Oracle Channel Rebate and Point-of-Sale Management provides functionality above and beyond that provided by Oracle Advanced Pricing for pricing scenarios including net accruals, retroactive pricing, complex volume pricing agreements, supplier ship and debit and the ability to update the correct general ledger accounts for all pricing situations including discounts. This is the only system in Oracle today that provides the correct accounting procedures for price reductions given on invoices. It also controls pricing in multi-tiered distribution.

This system addresses four critical areas related to the effective processing, POS data load, data validation & cleansing, dispute handling and Claims settlement.

ORACLE PRICE PROTECTION

Oracle Price Protection is a new module in Release 12.1 that provides distributors the ability to adjust and control their inventory valuations, purchasing costs and sales pricing based on pricing changes received from vendors. Price Protection automates the price protection processes when a vendor changes the price of a product and adjusts the GL records systematically.

More specifically, this product:

• Generates and tracks price-protection claims for both on-hand product inventory and customer product inventory
• Updates inbound prices lists and purchasing systems with new prices
• Updates costing and financial systems to reflect new prices and its execution can be done by
  • Providing consolidated view of inventory across WMS and TM (Channel inventory)
  • Calculating accruals and generate debit claims for vendors
  • Calculating accruals and issue credits for customers
  • Integrating with Oracle Costing to adjust Cost of Goods and Services (COGS)
  • Integrating with Oracle Purchasing to adjust inbound price list and purchase orders
  • Integrating with Oracle Pricing to update inbound price list with new price
  • Integrating with Oracle Financials to handle deferred revenue recognition

Price Protection leverages Oracle Fusion Middleware and has service-oriented architecture to allow for rapid deployment into heterogeneous environments. Price Protection is designed to work out-of-the-box with Oracle E-Business Suite

This product is Integrates with Procurement, Warehouse / Inventory, Costing, General Ledger, Accounts Payable, Accounts Receivable.

This new products is targeted for Wholesalers/distributors specially for High Tech customers. This application is having dependency and perquisite of first two application discussed above.

ORACLE SUPPLIER SHIP & DEBIT

Oracle Supplier Ship and Debit is a new module in Release 12.1 and a new flow introduced that enables Distributors to more quickly and intelligently respond to market conditions by automating special price requests to Vendors, in order to close more sales and increase profitability. Distributors are able to reduce the cost of managing the special pricing process as the execution and the more tedious claiming process are completely automated thereby providing greater visibility.

This products sound similar to Wholesalers/distributors specially for High Tech customers. This application is having dependency and perquisite of first two application discussed above.Supplier Ship & Debit application have Dependencies and perquisite with AR Deduction Settlement and Channel Rebate & Point of Sale Management application.

Thanks to reader Ganesh, you pointing this functionality availability in EBS.Last time I observed this lacking functionality while one client migrated from SAP to oracle.

Good news for those having Oracle R12.1.1 , they can utilize this new functionality where a new attribute in the supplier form enabled them link the payee of supplier A to the payee for supplier B(alternate payee). Then after Payable department can enter an invoice you go to the Remit-To columns and set them to the alternate payee.

You need to update the supplier and create a relationship with the alternate supplier in the suppliers form. When new invoices are entered these remit to supplier fields at the invoice header default if just one relationship exists or can be selected from LOV if multiple exist. It appears that if there were multiple relationships this can be changed after validation but prior to accounting.

Check it out for more details at metalink #949183.1

Reference Post

• http://www.oracleappshub.com/account-payable/why-alternative-payee-is-missing-in-oracle-payablepayment/

Oracle Supplier Data Hub is part of a full suite of Master Data Management (MDM) tools unifies and shares critical information about an organization's supply base. It does this by enabling customers to centralize all supplier information from heterogeneous systems and thus creates a single view of supplier information that can be leveraged across all functional departments.

Oracle Supplier Hub feature :

Oracle Supplier Hub can be broadly categorize into five major coverage area as per fig 1.

1. Consolidate - Data Import Management, Source System , Cross Reference
2. Cleanse - Matching, D & B Data Enrichment
   • Various Functionality Coverage are
     • Supplier Registration DQM and D&B
     • Supplier attribute classification
     • Merge, validate duplicates. Similar supplier names are checked.
   • Integrated with D&B out of box. Import data in real-time or batch mode
3. Master - Supplier Classification & Relationship
4. Share - Publication and Synchronization, Web Services, Security. This is also called as called OSN Integration.
5. Govern -Classification Management, Hierarchy Management and Task Management

Typically data administrator functionalities are available from Supplier Data Librarian Super User application responsibility where the data librarian functionalities are available from Supplier Data Librarian application responsibility.

Take a note profile option POS:SM: Supplier Data Hub Configuration with a value Standalone at site level if you are deploying Supplier Hub as a centralized standalone MDM solution OR configure the profile option with a value Integrated EBS if you are deploying Supplier Hub as an Add-on for E-Business Suite to an existing EBS R12.1 application Installation after you purchase the application licenses.

From R12.1.2 to R12.1.3

Oracle Supplier Hub was first added in EBS in R12.1.2. With recent version 12.1.3, there is slight enhancements as below:

• Tasks and Notes , Contact points and Party Relationship
• Bulk Import & Spreadsheet Import
• Smart Search , Enable party as supplier , Supplier Creation De-duplication
• Supplier Data Publications and supplier Profile Report

Supplier Hub and TCA

Oracle Supplier Hub is built on top of Oracle Trading Community Architecture (TCA) of Oracle E-Business suite and leverage TCA implementations features like Data Quality, Batch Management, Source System Management, Adapters, Classifications, Relationships/Hierarchies, Tasks/Notes (available via Customer Data Hub (CDH)).

If you refer back to TCA and CDH documentations for the various profile options and implementations that are applicable at the party level for the functionalities exposed from Supplier Hub navigations.

You can take advantage of TCA DQM APIs to identify the potential duplicate Supplier parties in Supplier Master.

Customers can implement and use Supplier Lifecycle Management (SLM) to streamline the supplier relationship management processes through the trading lifecycle.

License Requirement

Supplier HUB Data requires a separate license. Those who already using isupplier can requires a separate license

It is a new module introduced in Oracle Applications release 12.1.2, and it allows integration with other systems besides Oracle Applications.

Option 1: Oracle Supplier Life cycle Management can be deployed on an existing E-Business suite R12.1 application instance.
Oracle Supplier Hub Add-on for E-Business Suite which has the same features that of Oracle Supplier Hub can be deployed on an existing E-Business suite R12.1 application instance.

Option 2: Customers who want to deploy a standalone Supplier master data management system can implement Oracle Supplier Hub using Oracle E-Business suite R12.1 platform. They can implement Oracle Supplier Life cycle Management along with Oracle Supplier Hub or as a standalone E-Business Suite application like any other E-Business Suite application in a new instance.

Announced early this week Oracle E-Business Suite 12.1.3 is now available for download.

R12.1.3 is a purly a maintenance patch (RUP) and can only be installed on top of an existing EBS 12.1 environment. which combines error corrections, statutory/regulatory updates, and functionality enhancements into a consolidated, suite-wide patch set.

On the Finance, Procurement and HRMS there is the usual small changes here and there, additional changes for different countries. Compare to 12.1.1 and 12.1.2 had a lot more functionality that we would be interested in all.

Refrence

• Oracle E-Business Suite Release 12.1.3 Release Update Pack (Patch 9239090)
• Oracle E-Business Suite Release 12.1.3 Readme (Note 1080973.1)
• Oracle E-Business Suite Release 12.1.3: Release Content Documents (Note 561580.1)

Of interest to reader will keep updated with some new features in upcoming post.

Those who are implementing Oracle EBS suite in Asia Pacific may have some local statutory Tax Requirement requirement. If have localization take a note some of GST specific report been moved to E Business Tax in R12.

• Korean Tax Reporting
  • Setup Change, which is mostly for Withholding:
    • First one Profile Option Name Change From ‘GL: Set of Books Name’ To ‘GL: Ledger Name’
    • Korean Company Information defined as HR Locations – and associated to HR Organization in 11i will be upgraded to Legal Entity model in R12
    • To define new company information or modify upgraded definitions, users must access the new Legal Entity Configurator flow
      Business Locations – and respective Tax Registration Numbers which are not legal addresses can still be defined as HR Locations for reporting purposes
  • VAT Tax Report -Korean VAT report and extract have been classified as Business reports, therefore the parameter Reporting Level will have two display values: ‘Ledger’ and ‘Operating Unit’ and no longer display ‘Legal Entity’ like in 11i. This report can be extract under Oracle E-Business Tax responsibility.
• Singapore Tax Requirement
  • Taxes Setup Changes:
    • Singaporean Company Information which was defined as HR Locations in 11i is now upgraded to Legal Entity model in R12
    • To define new company information or modify upgraded definitions, users must access the new Legal Entity Configurator flow
    • Singapore Input and Output tax codes definition will be upgraded to Oracle E-Business Tax model
    • To define new Singapore taxes or modify upgraded ones, users must access the new Regime to Rates flow
    • Supplier Exchange Rate will be stored as part of line determination factor in eBTax model
    • User will need to enter Supplier Exchange Rate through eBTax UI.
    • Gain/Loss Report, GST F5 Report will select supplier exchange rate from eBTax model
  • Reports Changes
    • GST F5 Report
    • Input Taxes Gain/Loss Report
• Taiwanese Tax Reporting, the only change is these are moved into xml Publisher.
  • Input Tax Report
  • Payables Sales/Purchase Return and Discount Certificate
  • Purchase Return and Discount Report
  • Output VAT Report
  • Receivables Zero-Rate Tax Report
  • Receivables Government Uniform Invoice Report
  • Sales Return and Discount Report
  • Pro-Forma 401 Report
• India Localizations

Oracle Financials for India previously was referred to as India Localization and was a product outside the Oracle E Business Suite.

From Release 12 onwards Oracle Financials for India will be part of the Oracle E Business Suite as a standard product.

Fig 1 below outlines the period end dependency for Oracle Payables, Oracle Purchasing, Oracle Inventory, Oracle Receivables, Oracle Assets, Oracle Order Management, Oracle Projects and Oracle General Ledger (Release 12).

Fig 1: Period Close dependecy among the modules

If you are coming from 11i then you might see beacuse of SLA there would be additional steps you need to perform.Fig 2 will be a quick compare of steps between two versions.

Fig 2: Process and flow changes between two versions

In almost all modules the period end process consist of 5-6 major activity as:

1. Completing the Transactions
2. Creating Accounting
3. Followed by Reconcile Transactions
4. Post to GL
5. Reconcile Accounting
6. Close Period

You can check some of closure process & checklist from previous post :

• Period Close Processing Checklist -> R12 General Ledger
• Period Close Processing Checklist -> R12 Receivables
• Period Close Processing Checklist -> R12 Payables
• Period Close Processing Checklist -> R12 Cash Management
• R12 :FA Close process

New Products in Release 12.1

1.Product Name : Oracle Landed Cost Management (LCM)

The new product Oracle Landed Cost Management (LCM) gives organizations financial visibility into their extended supply chain costs, including
transportation and handling fees, insurance, duties and taxes therefore this product is being integrates with logistics, procurement, and financial applications to provide a comprehensive landed cost tracking solution.

Just who are new to ERP, landed cost is sum of Purchase cost , Freight Cost,Octroi , Labor charges involved in loading and unloading and GST /VAT Taxes.

Landed cost = Purchase Price + Freight Charges + Octroi + Labor charges for loading and unloading + Taxes.

Oracle LCM is integrated out of the box with Oracle EBS

• Oracle Procurement
• Oracle Inventory
• Oracle Cost Management
• Oracle Payables
• Oracle Advanced Pricing
• Oracle Transportation Management

Details for Reference

Oracle notes :Oracle Landed Cost Management | Data sheet

Channel Revenue Management

2. Product Name : Oracle Supplier Ship & Debit

This application automate all agreements, tracking, accounting journal entries and chargeback’s to vendors manual processes for timely claims processing.

Oracle notes :Oracle Supplier Ship & Debit | Data sheet

This Product is being integrates with the following finance modules:

3. Product Name : Oracle Price Protection

Channel Revenue Management product enabling orchestration and automation of supplier price changes.With this timely claims processing through automated integrations to through various Oracle Products..

Oracle Price Protection is integrated out of the box with Oracle EBS

• Procurement
• Warehouse / Inventory
• Costing
• General Ledger
• Accounts Payable
• Accounts Receivable

Details for Reference

Oracle notes :Oracle Price Protection | Data sheet

Already Available

4. Product Name : Oracle Site Hub

As a part of Oracle MDM This Product is going to cater some of industry like retail banking, telecom and even manufacturing which they need to maintain and manage many locations.

Therefore Oracle Product Site Hub is a repository for site specific data that will be leveraged during the life cycle of a site including analytics, such as market planning, competitive analysis, site selection, project management, location management, facilities management to closure. Site Hub allows for master site records, centralized data storage, data quality management and integration of services.

Organizations with many locations, whether manufacturing plants around the world or a mix of stores, kiosks, ATMs, offices and/or distribution centers around the country, need a repository for location data to assist them with these business requirements.

• Single HTML interface
  • Create, manage, search and map sites
  • Create and group user-defined attributes
  • Assign sites to hierarchies, clusters, maintenance orgs and inventory orgs
  • Create parties and relationships, e.g. competitors and partners, in Trading Community Architecture (TCA)
  • Create a property in Property Manager
  • Create an inventory organization from an existing inventory organization
  • Create maintainable assets based on a site asset template in a maintenance organization (eAM)
  • Google Maps and web services
  • Leveraging Oracle Database, Oracle Spatial, and Oracle Trading Community Architecture

Major Benefits of this Product is you can enhance operational efficiency in site opening, closing or maintenance and improves decision making .

Oracle notes : Oracle Site Hub | Data sheet

5. Product Name : Oracle PIM for Retail

This Product is used fir single view of product information that can be leveraged across all departments so retail side you can manage sell-side as well buy-side product catalog.This application consolidate, manage and synchronize all product information with other source systems and trading partners.

There is two major advantage with this product

• Improves speed of New Product Introduction
• Decreases cost of collaboration with partners and suppliers

Oracle notes :Oracle PIM for Retail | Data sheet

6. Product Name : Oracle Advanced Planning Command Center

This is the new application built on top of Oracle Advanced Planning that maximizes the value of your planning information by increasing accessibility and strengthening business orientation.

This is coupled with a role based analytical UI (with concepts such as business scenario management) and the automation of planning processes

Oracle notes :Oracle Advanced Planning Command Center | Data sheet

7. Product Name : Oracle Demand Signal Repository

A separately deployable application designed to maintain a consolidated view of demand information between the OEM and Retailer to facilitate the transition to demand driven .

Oracle Demand Signal Repository captures, cleanses and harmonizes large volumes of external demand data to give users insight to consumer and supply chain behavior.

Oracle notes :Oracle Demand Signal Repository | Data sheet

8. Product Name : Oracle Service Parts Planning

This is the new application within Oracle Advanced Planning designed to support the increasing importance of after-market service through the management of service parts.

This Combines extensive and purpose-built service parts planning capabilities, all fully integrated with the rest of Oracle Advanced Planning and
the associated execution systems.

Oracle notes :Oracle Service Parts Planning | Data sheet

9. Product Name : Oracle Manufacturing Operations Center

Oracle notes :Oracle Manufacturing Operations Center | Data sheet

As requested by some of reader , Here are steps and checklist for R12 AR Month End Close and Reconciliation.

1. Complete All Transactions for the Period Being Closed

2. Complete and review your unapplied receipts

3. Reconcile Receipts to Bank Statement Activity for the Period

Read the rest of this entry »

Herewith providing the generic period close process for Cash managment for R12.

1.Make sure you have Loaded & reconciled all bank statements for month

• You must verified Auto-Reconciliation Execution Report

2.If there any , resolve all exceptions

3.Create miscellaneous transactions

This step existed in Release 11i but the difference is that in Release 12 when you create the miscellaneous transactions in AR, the accounting is done by SLA.

4. Resolve unreconciled lines

A Note on Transactions Available for Reconciliation Report

Take advantage of this report.This report shows all transactions available for reconciliation for a specific bank account. It lists detailed transaction information for your Available Receipts, AvailablePayments, and Available Journal Entries for reconciliation.

Detailed information includes the Customer, Supplier, Transaction Date, Payment Method, Transaction Number, Currency, and Amount. It also lists detailed information for statement lines that are available for reconciliation against other statement lines.

5.Reconcile to General Ledger

A Note on General Ledger Reconciliation Report

Use this report to reconcile the General Ledger cash account to a bank statement balance.

This report lists a balance and an adjusted balance for the bank statement. It also lists a separate adjustment amount for un-reconciled receipts, payments, and journal entries, as well as bank errors.

This Report will show

Hopefully these steps will be helpful for doing Closure for CE.