Tuesday Sep 01, 2015

EBS Financials August 2015 Recommended Patch Collections (RPCs) just released!!

Oracle E-Business Suite Financials Development has just released August 2015 Recommended Patch Collections (RPCs) for the following products:
  • Assets
  • Cash Management
  • Collections
  • E-Business Tax
    • Calculation
    • Reports
  • Financials for India
  • iReceivables
  • Loans
  • Payables
    • Core
    • iSupplier
  • Payments
  • Receivables
  • Subledger Accounting
For details and the complete list of available RPCs for Oracle EBS Financials, please see Doc ID 954704.1, EBS: R12.1 Oracle Financials Recommended Patch Collection (RPC).

Friday Aug 21, 2015

New White Paper on Using Web ADI Spread Sheet in the Buyer Work Center Orders (BWC)

See this just released white paper for the BWC covering the following topics:

1.    Overview
2.    Limitations
3.    Prerequisites
4.    Demo Test Cases
       a.    Update existing PO lines, shipments, pay items, and distributions
       b.    Adding New Line to Exiting PO
5.    Technical changes
6.    Troubleshooting
7.    Known issues

Any questions? Start a discussion in the Procurement Community.

Thursday Aug 13, 2015

New Costing of Payment Reports Available for Oracle Payroll!

Previously, Oracle Payroll did not deliver any seeded reports that would show the Costing of Payment data.  But in R12.1 HRMS RUP8 and R12.2 HRMS RUP6 Oracle is delivering a set of Costing of Payment reports which aim at reporting payment costing details in the form of summary, details, or cost code level breakdown over a date range or specified costing process. 

This new functionality should be useful for detailed reporting of the Costing of Payment results, to assist in your reconciliation activities.

The following new reports are delivered:

Costing of Payment Summary Report – Consolidates costing data at payroll or GRE level

Costing of Payment Detail Report – Displays assignment level details of costing of each payment

Costing of Payment Breakdown Report – Consolidates costing data at cost code or account level

Details on the new reports can be found in the following documents:

Oracle Payroll Release Notes for Release 12.1 HRMS RUP8 (Doc ID 1989744.1)

Oracle Payroll Release Notes for R12.HR_PF.C.Delta.6 Release Update Pack (Doc ID 1992147.1)

If you have questions on the new reports, please log a new Service Request with the Oracle Payroll team.

Webcast: eAM Multi Asset Work Order

Webcast_icon.jpgWebcast: eAM Multi Asset Work Order

Date: August 20, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This one-hour advisor webcast is recommended for technical users, functional users to understand the 12.2.5 Asset Route Enhancement which helps to users to have multi asset Work Order.

Registration: eAM Multi Asset Work Order

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

Have you used R12: Master Data Fix Diagnostic to Validate Data Related to Purchase Orders and Requisitions?

Check out the Master Data Fix Diagnostic to Validate Data Related to Purchase Orders and Requisitions for Release 12!

This diagnostic will allow you to address many data integrity issues without requiring you to log a Service Request with support. The script produces an html output of known problems relating to the purchasing transactions created in the specified date range.  It additionally nicludes information on notes and/or data-fix patches, which may already be available to resolve the data issues.

Use it proactively to scan all transactions in the specified date range and head off potential issues. This script may be run in production safely at any time. No data is created, updated, or deleted.

Run this diagnostic prior to logging a Service Request when you suspect there is data corruption, or if you simply want to proactively verify the data integrity of your transactions.

For more information on Master Data Fix Diagnostic to Validate Data Related to Purchase Orders and Requisitions, please see Doc ID 1474734.1.

For a list of available Generic fixes, see Oracle Purchasing Generic Datafix Index Doc ID 1348821.1.

Wednesday Aug 12, 2015

Identifying Missing Application and Database Tier Patches for EBS 12.2

The EBS Technology Codelevel Checker (ETCC) utility provides two scripts you can run to help ensure you have the necessary database and middle tier bugfixes installed on your Oracle E-Business Suite Release 12.2 system.  Oracle strongly recommends the use of this utility to ensure that all required database and middle tier bugfixes have been installed.

ETCC can be downloaded via Patch 17537119 from My Oracle Support.  As well as installation instructions and basic commands, the README for this patch includes a number of usage scenarios and examples, so should be carefully reviewed before running ETCC.


Receivables: Important system options to review for Autoinvoice

Receivables lets you define several options for your invoices and use of Autoinvoice.  You can specify whether to purge the interface tables that you use for Autoinvoice, the maximum number of bytes to use, whether SQL Trace is active for Autoinvoice, and the grouping rule to use for revenue and credit transactions you create through Autoinvoice.

The System Options form has four sub tabs: Accounting, Trans and Customers, Claims and Miscellaneous

Responsibility: Receivables Manager
Navigation: Setup > System > System Options

The tab with the Autoinvoice options is the Trans and Customers tab.

  • Since Autoinvoice processes bulk data through an open interface table, its is not necessary to retain the data in the interface table once the transactions have been generated in Receivables.  By checking Purge Interface Tables checkbox in the System Options form, you are allowing Autoinvoice to clean up after itself once it has completed processing.
  • Setting your Max Memory (in bytes) is also important for Autoinvoice, the recommended setup is 3MB (3145728 bytes).
  •  Log File Message Level is recommended at 0 (zero).  Setting the log file message level to 0 provides the least detailed debug message but still includes errors and warning messages.  After you have completed and tested Autoinvoice for the first time you should need only minimal messages in the log file.  You can change the log file message level to 3 or above only when you want to troubleshoot Autoinvoice.
  • Enter the grouping rule that was setup in Receivables > Setup > Transactions > Autoinvoice > Grouping Rules. Autoinvoice uses grouping rules to group invoices, credit memos and debit memos. Grouping rules contain various transaction attributes (columns in RA_INTERFACE_LINES_ALL table) that must be identical across several interface records if the intention was for it to create one transaction. 

Excellent Resources for Autoinvoice:

DocID 1067402.1  Autoinvoice Setup for Release 12: A Case Study Using a Simple Script
DocID  1137414.2 Information Center: Overview of Autoinvoice in Oracle Receivables (AR) 11.5 and later

Monday Aug 10, 2015

Webcast: Oracle Product Hub Web Services - Setup, Use, and Troubleshooting

Webcast_icon.jpgWebcast: Oracle Product Hub Web Services - Setup, Use and Troubleshooting

Date: August 19th, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 5:00 pm CET, 8:30pm IST

This one-hour advisor webcast is recommended for Oracle Product Hub users who are implementing web services from Oracle Product Hub. Oracle Product Hub provides the following ODI based web services:

  • Item web service (includes structure service)
  • Item catalog category web service
  • Value set web service
  • Attribute group web service (from 12.2 only)

Topics will include:

  • How web services work
  • Setup and test of web services
  • Troubleshooting web services issues

Details & Registration: Doc ID 1290983.1

Friday Aug 07, 2015

Overview of Physical Inventory in Oracle Assets

Physical inventory is a critical business process through which a successful enterprise periodically inspects its assets to protect its large capital investments and to comply with auditing requirements.  Physical inventory is the process of ensuring that the assets a company has listed in its production system match the assets it actually has in inventory.  It also ensures that capital assets recorded in the Fixed Assets Accounting and Control System physically exist, determines if unrecorded or improperly recorded transactions have occurred, and identifies any excess, defective or obsolete assets on hand.  An effective inventory results in an accurate accounting of capital assets, and indicates the reliability of the system of accountability for the acquisition, use, and disposal of those assets.

How this works in Oracle Assets:flowchart

Oracle Assets is a worldwide best practice tool which automates the physical inventory process to minimize administrative costs.  The Physical Inventory feature in Oracle Assets assists you in comparing and reconciling your physical inventory data with the data loaded in Oracle Applications.  This flow chart gives an overall picture of how physical inventory functionality works in Oracle Assets. 

The standard steps are:

  1. Collect the actual asset details like asset tag number, asset number, units, etc. owned by each department.  This is normally done by the physical inspection of the assets owned by each department.
  2. The second step would be to load the physical inventory details / actual asset details collected through the physical inspection into the FA_INV_INTERFACE table.
  3. Run the physical inventory Comparison Report which compares the actual asset details with the data loaded in the FA_INV_INTERFACE table.
  4. View the comparison details which will provide the details of assets which are different and the assets which match between the application and the physical inventory.
  5. Take the necessary actions to match the data in the application to the actual data.

A detailed discussion of the physical inventory functionality in Oracle Assets, the required setups, the different ways physical inventory details can be loaded to the interface table (FA_INV_INTERFACE), and how reconciliation happens can all be found in the document:   Physical Inventory Overview in Oracle Fixed Assets (Doc ID 2003290.1)

With credit to Vaishali Karanth, Oracle Assets.

What's The High Cost Of Not Patching?

As you know, everything in the E-Business Suite is interconnected. One Product connection very important to Inventory is the Oracle Cost Management. Our friends in Costing have just released their latest Consolidated Patch 21449070:R12.BOM.C. For more information, see note, Oracle Cost Management Recommended Patch Collection (RPC) Priority Patches (Doc ID 1213663.1).

By the way, if you're interested in how to find Inventory and/or other EBS Products recommended patches, a really helpful resource is note, How to Find E-Business Suite Recommended Patches (Doc ID 1400757.1).

We know your heard it from us before, but again we can't stress it enough: Patching is the easiest way to avoid known issues. So apply recommended patches and keep your Costs processing!

Thursday Aug 06, 2015

Webcast: Release from Advanced Supply Chain Planning (ASCP) to Oracle Process Manufacturing (OPM)

Webcast_icon.jpgWebcast: Release from Advanced Supply Chain Planning (ASCP) to Oracle Process Manufacturing (OPM)

Date: August 13, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This one-hour advisor webcast is recommended for technical users, functional users, system administrators, Database Administrators, etc. who want to learn about the options available and to analyze issue with the release of Advanced Supply Chain Planning Planned Orders for make items to create Batches (or FPOs) in Oracle Process Manufacturing, Process Execution.

Registration: Release from Advanced Supply Chain Planning (ASCP) to Oracle Process Manufacturing (OPM)

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

Tuesday Aug 04, 2015

Webcast: Unprocessed Subledger Analyzer for Cost Management

Webcast_icon.jpgWebcast: Unprocessed Subledger Analyzer for Cost Management

Date: August 11, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This advisor webcast is recommended for technical users, functional users of Cost Management module and who would want to know how to use the Unprocessed Subledger Analyzer output and use the same for processing the stuck SLA transactions in Cost Management module.

Registration: Unprocessed Subledger Analyzer for Cost Management

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

Sunday Aug 02, 2015

Procurement Analyzers

Have you discovered the E-Business Suite Product Based Support Analyzers? From Doc ID 1545562.1 scroll down to the Procurement section and see these valuable offerings.  Each analyzer is specialized to help you diagnose issues before logging a Service Request, click on ACT for direct access.  What makes analyzers special is they not only provide you with errors found, but provide solutions as well. The analyzers are safe to run in Production and can be setup as a concurrent requests so all your users can access the valuable output.  Check them out today!

As new analyzers are created we will add them to Doc ID 1545562.1 so don't forget to bookmark the document!

Thursday Jul 30, 2015

BOM Calendar - Is Your MRP Bucket Half Full?

Oracle Master Resource Planning (MRP) uses ‘bucketing’ to help keep control of forecasts for demand for a particular product. The forecasts estimate future demand for items using any combination of historical, statistical, and intuitive forecasting techniques.

The forecasts can be gathered together in Time Buckets. You can forecast with daily buckets in the short term, weekly buckets in the midterm, and periodic buckets in the longer term.

Do you you need to manage your buckets in Calendar Months? What if you expect a bucket to ‘end-date’ on March 31 – but if March 31 is a Wednesday, and the Workday Calendar for “March” runs until Friday April 2? Then requirements from April 1 and 2 will be included in the “March” bucket. Some customers and users want to more closely link the BOM Workday Calendar to the common Calendar in use around the world.

If you would like to manage your buckets in Calendar months, we invite you to vote on Idea 'MRP Bucketing Should Happen For The Monthly BOM Calendar' in the EBS Logistics Communities.

You can also review note, It Is Not Possible To Setup Calendar For Monthly Bucketing (Doc ID 2027380.1).

If you'd like more information on using EBS Communities for Enhancement Requests (Ideas), see note, Oracle E-Business Suite Product Enhancement Request to My Oracle Support Community FAQ (Doc ID 1584210.1).

The power to request enhancements is in your hands, so don't forget to vote if you'd like MRP bucketing to happen for a monthly BOM Calendar.

Webcast: Setup & Troubleshooting Dunning Plans in Oracle Advanced Collections

Webcast_icon.jpgSetup & Troubleshooting Dunning Plans in Oracle Advanced Collections

Date: August 11, 2015 at 11:00 am ET, 8:00 am PT, 4:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour Advisor Webcast is recommended for Advanced Collections users who would like to learn more about how to setup and troubleshoot Dunning Plans in Advanced Collections. Learn how to set Dunning Plans up, the difference between Staged and Overdue Methods, and come away with troubleshooting steps to resolve your dunning issues.

Topics will include:

  • How to setup Dunning Plans
  • Staged versus Overdue Methods
  • Troubleshooting Dunning Plans

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 11-Aug-15: Setup & Troubleshooting Dunning Plans in Oracle Advanced Collections


Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« September 2015