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.

If you are coming from 11i, there is slightly change in FA Period Closure process because of SLA.

Here are steps & procedures for performing period-end processing in Oracle Assets Release 12.

In FA, at period end, we require to run depreciation for depreciation books set up for the organization, and to Create accounting for Oracle General Ledger. Oracle Assets has only a single open depreciation period in each depreciation book.

1.Complete All Transactions for the Period Being Closed

You need to ensure that all transactions have been entered for the period being closed. Once a depreciation period in Oracle Assets has been closed, it cannot be re-opened. Check that no-one is entering transactions as Oracle Assets prevents transaction data entry while the Depreciation Run Process is running. You need to complet all transactions for Oracle Assets:

• Prepare and Post Mass Additions
• Complete Manual Additions
• Complete Adjustments
• Complete Retirements
• Complete Transfers
• Complete Reinstatements

2.Then if you required, you need to assign distribution lines to all assets.

If an asset has not been assigned to a distribution line, the period end Depreciation Process will not complete, and will not close the period. Take the advantage of running "Assets Not Assigned to Any Cost Centers Listing " report to determine which assets have not been assigned to a distribution line.

3.Run Calculate Gains and Losses

This is optional , the Calculate Gains and Losses program for retirements can be submitted prior to running depreciation. The Calculate Gains and Losses process is performed independently for each depreciation book.

4.Run the depreciation

In Release 11i when you ran depreciation you would automatically close the period whereas in Release 12 you can now run depreciation without closing the period.

5.Create accounting

Create Journal Entries (FAPOST) is replaced by Create Accounting – Assets process (FAACCPB)

6.RollBack Depreciation for adjustment

When you are trying to do adjustment on a particular asset, FA automatically rolls-back depreciation for that particular asset.This is one of the area where you will experience change if you are coming from other versions.

7.Once you are sure that all the balances are correct you need to run depreciation and close the period.

8.Create accounting

You need to run "create accounting" very similar as mention in step 5.

9.Post Asset Transaction in GL

You need to make sure the step 8 must be completed only if you done transfer and posting for the accounting entries to GL.

These steps are basically takes care of data movement , then next step for you to tie FA and GL.

For reconciliation of assets you need to take advantage of some of seeded and newly added report that will help business user to reconcile and closing the period.

10. Reconcile your Fixed Asset and GL

• Reconcile Assets to the GL Using Reports
  • Journal Entry Reserve Ledger - reconcile with the Account Analysis with Payables Details Report.
  • Tax Reserve Ledger Report
  • Account Reconciliation Reserve Ledger Report
• Balance Report
  • Cost Detail and Cost Summary Reports
  • CIP Detail and CIP Summary Reports
  • Reserve Detail and Reserve Summary Reports
  • Revaluation Reserve Detail and Revaluation Reserve Summary Reports
• GL Report
  • Journal - posted/Unposted
  • Account analysis

Once these report can tally, there is no way that your P & L report is not going to tally.

Suggested Reading

• Fixed Asset Transfer to GL
• Fixed Asset & SLA
• Release 12: 6 New and Changed Feature in "Oracle Assets"

If your business need to drill down the Reporting for your financial report like Balance sheet ,P & L or Cash Flow then you can explore these options in EBS :

1. Financial Analyzer
2. Report Manager
3. Summary Accounts online drill down
4. Third Party tools like GL WAND where you can run the report or multiple report through Excel and drill down, which will show both sides of the journal.

R12 "Drilldown" Vanilla Functionality

With this feature business user allowed to drill into report values using the Account Analysis and Drilldown feature once the FSG output is generated. This is exactly the same as available from the applications using the Account Inquiry form.

If drilldown from the report is required, the underline template should be drill-enabled while uploading to the server. What you need to do you can use template builder and enable this feature which comes within box.

Those who are still on R11i can achieve drilldown feature only if you having FRM.H plus Patch 5377946. You can find my details under report manager availability section in this pots.

Power of Report Manager

This is Framework in EBS for web based reporting of financial data generated by mostly Financial Statement Generator (FSG). You can submit and publish the following types of reports: FSG Reports, Ad Hoc FSG Reports, Standard Reports, and RX-Only Reports.

Therefore this tool coupled with end user for e-reporting need directly with the self service pages. Additionally report manager can provide you :

• Reporting need into multiple formats(Excel, PDF, html)
• You can manage from central secured report repository
• These are supported based out of MS-Word & MS-Excel based templates, which is one productive office tool used for finance department.
• You can customize the look and feel of report output
• Distribution based on expansion values and time frames
• Facilitates data comparison and trend detection
• Preview reports prior to mass distribution

Take a note :

1. Report Manager is the reporting processes and Web ADI is the data loading processes.
2. Report Manager is included in the ATG R12 Product Family Pack Patch.

Report Manager Architecture

Report Manager have other key components like:

• FSG Template Editor
• Repository Management
• Security Workbench : For both Flex field value as well as user to value security
  • Flex field Value Security
  • Users to Value Security

What can you see from above diagram is reports are published to a file system on the middle tier. Therefore you can choose to make your report available from the personal home page at the same time as you publish the report, or alternatively you can create a form function at a later stage to make the report accessible to users.

You can also apply some control if required When publishing reports by:

• Use Expansion Values and Time frames to group reports together
• Use Security to control which users can see a Published Report
• Select a date and time to make your published Report available for viewing
• Select Reviewers for the Report

Read the rest of this entry »

Balance Forward Billing is just a new name of "Consolidation Invoice billing" in Release 12, which provides enhanced billing options with a more complete and flexible solution.

Oracle R12 Vanilla Features of Balance Forward Billing

If you compare with R11i Consolidated Billing Invoice, there are some enhanced feature you can see.

• A balance forward bill includes all of a customer's transactions for the billing period and any balance carried forward from the previous billing period.
• A balance forward bill can have a daily, weekly, or monthly billing period depending on the balance forward billing cycle assigned to the payment term.

Additional feature you can get like

• You can also bill on specific days of the month. This way user can not only specify the day of the month for the billing date, or even multiple days like “every 15th and last day of month”. User can also elect to bill on a specific day of the week, such as every Friday.
• You can also choose to exclude weekends, in this case if user skip weekends when determining billing dates, so billing dates only fall on workdays

• A balance forward bill is consolidated at either the customer account or site level depending on the Bill Level value at the customer profile and account profile levels. You can change the Bill Level defaulted from the customer profile class at the account profile level. The Bill Level at the site profile level is a read-only field defaulted from the account profile level.
• A balance forward bill can be either detail or summary. Both the detail and summary formats present invoice totals. The detail format lists all line items.
• You can generate a balance forward bill in either Draft or Final formats similar to R11i.
• Bill Presentment Architecture (BPA) configured formats provide a more appealing layout that can be easily modified and this can be viewed the completed bill online
• In 11i, there are five consolidated bill programs. The new feature consolidates these programs into three.

Read the rest of this entry »

Quick notes for Dunning Letter in EBS R12.

• The AR Dunning Letters is obsolete in R12.
• The AR Collections Workbench is obsolete in Release 12.
• You will need to install the Oracle Advanced Collections application.
• The basic Collections functionality is available in Oracle Advanced Collections without any extra cost.
  • However, if you wish to use the more complex functionality in the Oracle Advanced Collections, you will need to pay for license cost.
• In R12 Advanced collections, you will now need to run Oracle Advanced Collections Dunning Plans instead.
• To using the Dunning Plan basic functionality you donot requires Oracle Advanced Collections license.
• The Dunning process in R12 Collections is based on Scoring. You can set it up so that a particular score is associated to a Dunning Letter Plan. Then only allow that one customer to get that score.
• Dunning Plans in Advanced Collections replace Dunning Letters in 11i AR , thus dunning Plans will need to be setup.
• Staged Dunning Letters does not exist in R12 Collections rather can be used the Standard Dunning Plans in R12 of Collections. However, for a more complex timing and use of Dunning letters you will want to setup the highly configurable Strategies and send your letters in this manner.
• Customer interactions and correspondence, transaction processing, and dunning activities are consider as basic functionality whereas scoring, collections strategies, enhanced payment and promise processing, automated promise tracking, and automated collector work assignment are consider as advance feature of product.
• In R12, dunning functionality is executed by XML Publisher.
• These are some of seeded template for Dunning in R12.

List of seeded Template (ref:source)

• It is anticipated that Dunning Letters can be delivered via e-mail, fax or print.
• IEX is application code 782 is product code for Advance Collections.
• Dunning Plans include aging bucket parameters for all data levels (customer, account, bill-to, transaction) in Oracle Advanced Collections. That mean A collections manager can configure dunning plans that look at the oldest aged invoice for each customer, along with the score, and have the system send different dunning letters to customers in each aging bucket.This was first Released 11i.IEX.H.
• A migration white paper and migration scripts will be provided to Oracle Receivables Workbench customers moving to Oracle Advanced Collections.

Metalink Reference Note:

• Note 389443.1:Migrating to Oracle Advanced Collections An Overview for Oracle Receivables
• Note:454908.1:Migrating to Oracle Advanced Collections: An Overview for Oracle Receivables Users
• Note:727659.1:How Do You Setup Dunning Plans Now That You've Installed R12 Advanced Collections?
• Note:557452.1: What Products need to be Licensed/Installed for Collections to Compile Properly?
• Note:726427.1 :Cannot Print/Email/Fax Dunning Letters in R12, Why?
• Note 289801.1 :About Oracle Advanced Collections Mini-pack 11i.IEX.H

MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.Out of Box functionality of MOAC, there is something called "Multi-Org Preferences".

What is "Multi-Org Preferences"?

Multi-Org Preferences allows you to control the list of operating units to which you have access.

Lets say you have around 20 OU's divided into three major Region (North America, Europe and APAC). Lets say within APAC region you are responsible for all 7 OU's within Region.

Read the rest of this entry »

As we know in R12 , the existing Multiorg architecture includes a new feature Multiple Organizations Access Control (MOAC). Lot of queries and question were asked by my readers, therefore this post completely focus on some of technical Insight because of architectural change.The minimum you should suppose to know is that Access Control feature has backward compatible. Technically means that there are no code or procedural changes if MOAC is not implemented (i.e. The user is assigned one operating unit for a responsibility).

Read the rest of this entry »

Background

Once the entries have been made and before any report are extracted from the accounts, a trail balance is drawn up.This is standard accounting practice. This is just what it says it is - a try at balancing the figure before the profit is worked out and the balance sheet drawn up. By rule of thumb,If the double entry is correct, ie all debit entry for every credit entry and viceversa, then the total of debit balance and total of the credit balances equal .

In release 12:

o 11i Trial Balance is known as the Open Account Balances Listing report in R12
o It runs based on the Open Account Balances Listing Definition that you define.
o You can define the Listing Definition at a Ledger or Ledger Set level

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".

Now , 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 operating units belonging to a given ledger or ledgers within a ledger set as shown below:

Similar Post

• Welcome to R12 Account Payable
• Month End Process -Useful Payable Reports
• Month End Process for Account Payable
• R12 : AP Trail Balance