Thursday Sep 03, 2015

Webcast: Service Parts Planning 12.2.5 Features, Part 1

Webcast_icon.jpgService Parts Planning 12.2.5 Features, Part 1

Date: September 10, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour advisor webcast is recommended for functional users, implementation partners, consultants, and support people who would like to understand and learn the new functional features in Service Parts Planning.

This webcast will cover 3 new enhancements introduced in Service Parts Planning.

  • Fair-share Enhancements
  • Cross-Docking Support
  • Enhancements to Reschedule Exceptions

Details & Registration:  Service Parts Planning 12.2.5 Features, Part 1 on September 10, 2015

Webcast: Data Quality Management (DQM) Search & Match Deep Dive

Data Quality Management (DQM) Search & Match Deep Dive

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

This one-hour session will build on the Understanding Trading Community Architecture (TCA) Customer Entities & User Interface webcast and is recommended for technical and functional users who want to have a better understanding of the Data Quality Management (DQM) feature in TCA and how it works when performing searches or preventing duplicate customer-related data. We will also cover troubleshooting common DQM issues.

Topics will include:

  • DQM Overview & Setup
  • Creating custom attributes & transformations
  • How Match Rules work
  • DQM Synchronization
  • Troubleshooting common issues

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 16-Sep-15: Data Quality Management (DQM) Search & Match Deep Dive

Wednesday Sep 02, 2015

Getting Jave Errors when Loading Certificates in Oracle Exchange and iProcurement Punchout?

The following error can occur when trying to upload certificates with Oracle Exchange and iProcurement.  

Error Code: 100 Unexpected Error
java.lang.RuntimeException: HTTPSURL Init Failure: subject key, Unknown key spec.
      at<init>( Received fatal alert: handshake_failure (no cipher suites in common)

This occurs because SHA 256RSA (also known as SHA-2 or SHA2)  are inadvertently loaded to the Exchange certificate bundle file and they are not supported.

So how can these certificates be identified and what can be done about it?  See Doc ID 1999543.1 for all you need to know!

EBS AP, AR and EBTax Setup/Data Integrity Analyzer (Doc ID 1529429.1)

Formerly known EBTax setup and Data Integrity Analyzer is now heavily enhanced and renamed as "EBS AP, AR and EBTax Setup/Data Integrity Analyzer"

This Analyzer is a self-service health-check script that identify known problems relating to the EB Tax Setup , Payables Setup, Invoice Checks and Tax Reporting issues of AP and AR you have along with information on notes and/or data-fix patches which may already be available to resolve the issues. This script will check the transactions (if you specify) for any data issues for which Generic Data Fix (GDF) patches are available. It can also scan for additional known issues for which a GDF patch is not yet available (Non-GDF). It will not fix the data but simply report on what corruption exists and point you to the notes and/or patches that will allow you to fix the data.


  • Transaction ID: (Optional) You can pass it blank if you do't want to see the Data corruptions which can affect the Tax Reporting. If you want to see the Tax Reporting related Data corruption for a specific transaction you need to pass the Transaction ID (Invoice ID for Payables or Customer_Trx_ID for Receivables)
  • Application ID: (Optional) If you don't pass Invoice_ID or Customer_Trx_ID as Transaction ID then you need to keep it blank as well. If you have provided the Invoice_ID of Payables as Transaction ID then provide Application Id as 200. In case you have passed Customer Trx ID as Transaction ID you need to provide the Application Id as 222
  • Maximum Rows: (Default of 99999) A number value to indicate the maximum number of transactions to display for any particular data validation. Use this number to control the potential size of the output file if there are validations which return many instances.
  • Debug mode: (Default of No) A yes or no value to indicate if detailed debug information should be printed to the process log file. This can be enabled when there are issues running the process itself in order to assist support in troubleshooting the report process.
  Reminder: Either you need to provide value for both Transaction ID and Application ID or 

Keep both Blank while running the Analyzer.


Running the Analyzer

  • Case-I No parameter passed. The Analyzer output will show the Tax Setup and Payables Setup related issues. The title will be EBS Payables and EB Tax Setup/Data Integrity Analyzer Report


  • Case-II Payables Invoice Id and Payables Application Id are passed The Analyzer output will show the Tax Setup,Payables Setup, Payables Invoice Checks and Payables Tax Reporting Issues. The title will be EBS Payables and EB Tax Setup including AP Transaction Level Data Integrity Analyzer Report

  • Case-III Receivables Transaction Id and Receivables Application Id are passed The Analyzer output will show the Tax Setup, Payables Setup along with Receivables Tax Reporting Issues. The title will be EBS Payables and EB Tax Setup including AR Transaction Level Data Integrity Analyzer Report

 Along with EBTax setup checks and Tax Reporting issues the new version (200.4 and above) consists of Payables Setup Checks which address the following known issues.     

  • Payment Document and Supplier Bank Account Issues
  • Supplier/Party Setup Issues
  • Financials Options in Payables Setup Issues

Moreover the Analyzer also identifies Invoice Functional behavior under section Invoice Checks

For more details on how to run the Analyzer please refer to Metalink Doc ID 1529429.1

Webcast: Oracle Demantra Release, Part 1

Webcast_icon.jpgOracle Demantra Release, Part 1

Date: September 9, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour advisor webcast is recommended for technical users, functional users, and professionals looking to advance and expand their Demantra knowledge notably in Demanatra features. The training is intended to be based on the Demo and will be covered in 2 Parts.

The following topics to be covered in 2 sessions:

Part 1 on September 9, 2015:
  • DM Workflow Recoverability - DM Global Instance Support
  • DM Security Enhancements (Better SSL Support)
Part 2 on October 14, 2015:
  • IO Receive Intermittency Flag from DM
  • DM Collect EBS Data Above Site Level
  • Alta UI Uptake - Demantra

Details & Registration:  Oracle Demantra Release, Part 1 on September 9, 2015

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!

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