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

Thursday Jul 23, 2015

Troubleshooting the Closing of Work Orders in EAM and WIP

New whitepaper!  The following topics are discussed in detail.

A brief overview about closing work orders. 

How to close work orders in EAM and WIP. This section looks at the different methods for closing work orders in EAM and WIP.

What happens when a work order is closed.  Looking at the differences in EAM and WIP in terms of closing work orders. This discusses the tables that  are updated and looks at variances in EAM and WIP and the GL postings that take place when a work order is closed.  It explains the different processes for both EAM and WIP.

Troubleshooting the closing of work orders. This section looks at the issues faced when closing work orders and how to resolve these issues.  There is an existing white paper for this : White Paper: Understanding Discrete Job Closure Process Doc ID 1902476.1. However this document is mainly around WIP and does not look at the differences between EAM and WIP. Also, the paper does not cover all the different methods of closing work orders in EAM and WIP. 

Download the Troubleshooting the Closing of Work Orders in EAM and WIP white paper from Doc ID 2035692.1.

Tuesday Jul 21, 2015

Oracle E-Business Suite Releases 11i & 12 Critical Patch Update

Have you looked at the Oracle E-Business Suite Releases 11i & 12 Critical Patch Update Knowledge Document for July 2015?  Check out Doc ID: 2013117.1

This Critical Patch Update (CPU) Knowledge Document lists patches that address security vulnerabilities in Oracle E-Business Suite Releases 11i and 12 (12.2, 12.1, and 12.0). It also provides conflict resolution information for other Oracle products used with Oracle E-Business Suite, plus references to related My Oracle Support Knowledge Documents.

Have you Discovered the Power of the iProcurement Change Request Analyzer?

Get solutions when you have documents stuck due to pending Change Request issues or you receive Change Request errors.   Available from Doc ID 1917475.1 go directly to errors by clicking on the buttons with the Red Dots. Or scroll through the entire output to review recommendations and warnings.

Find links to solutions for the errors found as shown in the user friendly output below.

Need more information?  Click here to post your question.

Monday Jul 20, 2015

Keep Those Sales Orders Flowing

To continue our series on transactions processing, we have some questions for you.

• Are you a power user looking to have a seamless Inventory month end closing?
• Does it seem like every month there is a crisis in your organization because the end users are unable to close the period?
• Have you ever wondered what tools are there to help you troubleshoot stuck sales order transactions?

If the answer is yes to any of these questions, we've got a great training document for you. See, R12 Inventory Sales Order Flow and Troubleshooting (Doc ID 1100764.1).

This document uses different media including a recorded demo to walk an Oracle user through the month end closing process for Inventory Organizations.

The focus of the presentation is to empower any user and/or techno/functional resource about the different options available to identify and correct sales order transactions that are stuck in the Transactions Open Interface.

The presentation will also show you the flow of the My Oracle Support (MOS): Guided Resolution that is offered as you log Service Requests.

Doc ID 1100764.1 is another tool to help keep your transactions processing. As usual, keep tuned in to the Inventory Blog and we will continue to assist in ending your month end headaches.

How to run the new XML version of the APList Invoice Data Collection Diagnostic

There is now an XML version of the Payables APList, which is an alternative to the Invoice Data Diagnostic in the diagnostic pack. 

Why it is needed?

The Diagnostic version (HTML based) is limited on size and cannot bring back all the data needed to resolve issues.  By using the XML version the size limitation is removed.

The XML version offers some significant advantages over the HTML version in the diagnostics:

  • The XML contains more data available to Oracle Support: versions, more setup tables, profile options, etc.
  • Support can apply various XSL templates to the XML to make it easy to read and specific to the issue at hand
  • Removes size constraints and all the data can be retrieved without making the HTML impossible to open
  • Can be run as a concurrent request rather than having to use the diagnostic responsibility
  • Can be run via SQL*Plus or any other SQL Utility
  • Can be run for multiple invoices at a time
  • Support tools can use XML to automatically diagnose certain issues

While the XML version can take a couple more minutes to run it reduces the need for other diagnostics.

When to use it?

This version can be used when requested by Support, or anytime an invoice data diagnostic is requested.

How to run it?

The script can be ran several ways depending on your preference:

  • Run directly from SQL*Plus (or a comparable tool)
  • Run via the concurrent manager SRS window
  • Run via an option on the Tools menu in the Invoice Workbench

How can I find out more?

Please review Doc ID 1677861.1 - How to use the XML version of the Payables APList [VIDEO] which contains videos teaching how to use all the methods to help you fully understand how to use this new tool.

What if I still have questions?

Post your question on the AP community thread and we will be happy to answer them.

Thursday Jul 16, 2015

July 2015 WEBCAST – BI Publisher Overview

Webcast_icon.jpgBI Publisher Overview

When: Tuesday July 28, 2015 at 18:00 UK / 19:00 CET / 10:00 AM Pacific / 13:00 Mountain

This one-hour advisor webcast is recommended for functional users with a technical background, technical users, system administrators, Database Administrators, etc. who are looking for an overview about the BI Publisher Product available for the E-Business Suite. 

Topics will include:

  •  BI Publisher Overview
  • Administration
  • Troubleshooting
  • Q & A

Details & Registration : DocID 2020652.1

If you have any question about the schedules or if you have a suggestion for an Advisor Webcast to be planned in future, please send an E-Mail to Ruediger Ziegler.

Thursday Jul 09, 2015

Webcast: How to Reconcile Certain ATP Date Calculations (ODS vs. PDS)

Webcast_icon.jpgHow to Reconcile Certain ATP Date Calculations (ODS vs. PDS)

Date: July 16, 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 both functional and technical users who frequently may need to investigate the accuracy of promise dates provided to customers (via ATP/GOP). This includes reviewing the supply/demand picture for a given item. This webcast will cover the review of the availability and ATP Details, how to interpret the ATP calculations, and comparison of ATP results based on certain GOP setups, as well other means of checking availability (besides ATP). It will include technical troubleshooting tips, on how to debug discrepancies of atp dates, and how to use the appropriate diagnostics to generate debug outputs that may be requested by Oracle Support.

Topics will include:

  • Identifying the most common availability checkpoints used by ATP/GOP (such as the Sales Order form and ATP Inquiry form)
  • Comparing the availability between different ATP checkpoints
  • Comparing the availability between different ATP methods (collected data vs. planning output)
  • Comparing the availability between other availability methods (such as the Inventory Supply/Demand form)
  • Debugging discrepancies of ATP dates
  • Generating the appropriate debug files requested by Oracle Support

Details & Registration

Wednesday Jul 08, 2015

Does the Approval Analyzer show "Authentication failed" in the Output?

An issue has been reported for some customers that after running the Procurement Approval Analyzer and saving the html output, the output file shows: 

"Authentication failed."

The cause of this issue is linked to the Temp ID given to the report output.  The source data for the page becomes cached, so is no longer valid.  This invalid state fails the page source data build, so when going to save the page data, there is no source data present to generate the saved file.  The way this is prevented is to force a page rebuild each time, so the cached state does not occur.

So what is the solution?

For Firefox: enter the following string into the URL location box in the Firefox browser


Click through warning dialog box
•  Search for "browser.cache.check_doc_frequency"
•  Change the value to "1"
•  Exit the browser session window to save

For Internet Explorer:

•  In the IE Browser go to "Tools" => "Internet Options"
•  Select the "General" tab => "Browsing History" => "Settings"
•  Set "Check for newer versions of Stored Pages" to "Every time I visit the webpage"
•  Exit Tools section to save setting change

Still have questions?  Click here to post your question.

New to the Procurement Accounting Space - Introducing the EBS iProcurement Change Request Analyzer!

Newly released in the Procurement Accounting space is the EBS iProcurement Change Request Analyzer for Release 12!

The single document provides all the information needed to troubleshoot the problem with the change request process.

The analyzer scans your iProcurement footprint, configuration, environment, and transactional data.   For areas of concern, the output will provide recommendations to prevent future issues and point to existing solutions for uncovered problems.  Most existing solutions can be implemented without logging a Service Request.

Checks include:

  • Lists existing change requests associated to the document and the workflow processes involved
  • Provides change order tolerances, related archive tables and data collection
  • Document Validations include:
    • Supervisor Hierarchy and Approver List Validations
    • PO with Pending Changes that are In Process
    • Purchase Orders that are not Open/Approved or Shipment Level Open
    • Non-Catalog Requisition Prices Change
    • Purchase Order is Partially Received or Billed
    • Requisition is on a Complex Purchase Order
    • Requisitions with pending Receiving transaction
    • Allow Price Override is not checked
    • Accrue on receipt flag is Y
    • Purchase Order Shipments do not correspond to the same requisition line

Simply run the analyzer as a SQL script or as a concurrent request, by following EBS iProcurement Change Request Analyzer, Doc ID 1917475.1

Previous suggestions and feedback were used to develop the analyzer.  Now you have the ability to drive us in your direction.  Post your comments to improve the usefulness of this tool in your environment by adding a reply here.

Try this analyzer before logging  a Service Request when you are experiencing change request issues.

Tuesday Jul 07, 2015

Webcast: Subledger Accounting (SLA) Features within Cost Management

Webcast_icon.jpg Subledger Accounting (SLA) Features within Cost Management

Date: July 14, 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, system administrators, and database administrators who want to learn more about the Subledger Accounting (SLA) features in Cost Management.

Topics will include:

  • SLA Flow and Troubleshooting
  • Key Tables
  • Diagnostics and Reports
  • Flow Demostation INV -> SLA -> GL

Details & Registration

Monday Jul 06, 2015

Need Help with PO Output for Communication Issues?

See our data collection for everything you need to know:

 Doc ID
 Title  Purpose
1535771.1 POXPOPDF: PO Output for Communication Collection of Known Code Issues and Patch Fixes Divided into Releases from through12.2 see supports list of recommended patching.
1532387.1 Frequently Asked Questions POXPOPDF: PO Output for Communication Visit the FAQ which provides answers to questions ranging from  basic setup to attachment issues to customization tips and tricks, and more!
1377764.1 Troubleshooting Assistant: Oracle Purchasing PO Output for Communication / Supplier Notification Issues Use the assistant by selecting your symptoms and be guided to supported solutions.
1375082.1 Master Troubleshooting Guide for POXPOPDF: PO Output for Communication Providing targeted steps for troubleshooting, try these before logging a Service Request.

 Still have questions?  Start a discussion in the Procurement Community.

EB Tax Analyzer enhanced to capture Tax Reporting issues !!

Hi All,

EBTax Analyzer (Doc ID 1529429.1) is now enhanced to capture the Tax Reporting issues for both Payables and Receivables along with existing EB Tax Setup issues.

The Analyzer has been enhanced to provide two additional Optional parameters

1. Transaction Id

2. Application Id

If user wants to run it for a particular Payables Invoice , Transaction Id should be the Payables Invoice_id and Application Id needs to be put as 200

For Receivables Invoice, Transaction Id should be the Customer_Trx_Id and Application Id needs to be put as 222

This enhancement has been included in Version 200.3

The Identification queries and solutions are verified by EB Tax Development Team.

You can refer to the following sections of Doc ID 1316316.1 to check the issues which are included in EB Tax Analyzer for Tax Reporting Enhancement.

Sections which are included for Tax Reporting issues:

· S  Section 32: OFFSET_TAX_RATE_CODE is wrongly populated in ZX_Lines

· S  Section 34:  The HQ Establishment Registration Number populated with NULL or incorrect value on Tax Lines

· S  Section 36: The VAT REGISTRATION NUMBER is Null for the following Customers and Customer Sites

· S  Section 37: The tax information(Tax Link ID) populated with NULL values on Receipt Application Distributions

· S  Section 38: The tax information(Tax Link ID) populated with NULL values on Adjustment Distributions

· S  Section 39: The tax information (Tax Reference IDS) populated with NULL on Accounting Tax Distributions for Payable Invoices

· S  Section 40: The Accounting Tax Distributions not created for Payable Invoices

· S  Section 41: The tax information (Tax Reference IDS) populated with NULL on Accounting Tax Distributions for Receivable Invoices

· S  Section 42: The Accounting Tax Distributions not created for Receivable Invoices

· S  Section 43: The Receivable Invoices with COMPLETED status are appearing with INCOMPLETE status on Tax tables

· S  Section 44: The Third Party Account and Account Site information on Tax Data not matching with Receivable Invoices

For more Details please go through the Doc ID 1529429.1 and download the sample Output files to see how they  differ based on the Input Parameters.

Best Regards,


Friday Jul 03, 2015

New ORAchk Version Released

The new ORAchk release is now available to download.

New Features in ORAchk

Auto update ORAchk when newer version is available

New in this release, if ORAchk is older than 120 days and a newer version is not available locally it will check to see if a newer version is available on My Oracle Support and automatically download and upgrade.

Download of latest version directly from My Oracle Support can also be specifically triggered with “./orachk –download”.

If ORAchk is running in automated mode the daemon will automatically upgrade from local location defined by RAT_UPGRADE_LOC just before the next scheduled run. Email notification will be sent about the upgrade then ORAchk will continue with the scheduled run using the upgraded version, all without requiring you to restart the ORAchk daemon.

Expanded Oracle Product Support

ORAchk now brings wider and deeper support throughout the Oracle product stack, with newly added support for the following product areas:

  • Enterprise Manager OMS
  • E-Business Suite Oracle Fixed Assets
  • E-Business Suite Oracle Human Resources
  • E-Business Suite Oracle Receivables
  • Siebel CRM Application

See Document 1268927.2 for further details of the new product support.

Over 60 New Health Checks

This release of ORAchk adds new checks for some of the most impactful problems seen to Oracle Customer Support specifically in the areas of:

  • Systems hardware settings to optimize encryption performance for the Database and E-Business Suite.
  • Solaris & Siebel CRM Object Manager to ensure page sizes are set appropriately for Siebel CRM to handle large numbers of users.
  • Database optimization of memory and resource related configurations and Application Continuity checks.
  • Enterprise Manager OMS High impact problems that cause functional failure or difficulty with patching or upgrade.
  • E-Business Suite Receivables detection of non-validated Receivables Accounting Definitions, which might prevent the Create Accounting process from functioning.
  • E-Business Suite Fixed Assets checks for any books with an errored or incomplete depreciation run, to allow for resolution prior to month end close.
  • E-Business Suite Human Resources verification of Setup Business Group configuration.
  • Siebel Applications verification of the database configuration for stability, best practices and performance optimization.

For more details and to download the latest release of ORAchk see Document 1268927.2


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



« July 2015