Wednesday Jun 10, 2015

Take a look at the new release of Oracle E-Business Suite Plug-in

It’s now available for use with Oracle Enterprise Manager 12c.  Oracle E-Business Suite Plug-in is part of Oracle Enterprise Manager 12 Application Management Suite for Oracle E-Business Suite. Review this “Getting Started with Oracle Application Management Pack for EBS Release” Doc ID 1954099.1

Database Upgrade Reminder From to by July 2015

To raise awareness on the database upgrade from to by July 2015, please review the following development blog post as needed:

News for Oracle HRMS (Japanese) Users: 'My Number Act’

Are you wondering how Oracle HRMS (Japanese) will address the new 'My Number Act’?  Read on!

As per the new Japanese legislation, a new ID number system is required to be used in administrative procedures in Japan. The so-called ‘My Number Act’ is scheduled to be launched in January 2016. Japan will start assigning numbers to its citizens in October 2015.

This new ID number system will have some impact on Oracle's Japanese Human Resources and/or Payroll products, and we want you to be aware of how Oracle will address this legislative change. 

As such, Oracle Development has released a whitepaper:  E-Business Suite HRMS (Japan) My Number Act 2016 Position Statement (Doc ID 2016828.1).  Please go to My Oracle Support to read the document, so that you can be informed on how Oracle HRMS for Japan delivers these changes.

If you have any questions, please log a new Service Request with the Oracle HRMS (Japanese) team.

Tuesday Jun 09, 2015

Webcast: How to Understand and Resolve Mismatches Between APCC Reports and ASCP Data

Webcast_icon.jpgHow to Understand and Resolve Mismatches Between APCC Reports and ASCP Data

Date: June 11, 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 run reports in Advanced Planning Comman Center (APCC). This includes building ad-hoc reports using Answers, reviewing data on the APCC dashboards, and reconcilating data with Advanced Supply Chain Planning (ASCP). This webcast will cover running certain APCC reports, interpreting the output, and comparing with ASCP data. It will include technical troubleshooting tips, to reconcile data mismatches between both ASCP and APCC.

Topics will include:

  • Running Ad-hoc reports using Answers
  • Reviewing certain APCC dashboards
  • Comparing data from these dashboards/reports, to that shown in the ASCP Horizontal Plan and Planner's Workbench
  • How to identify data discrepancies between ASCP and APCC
  • Technical troubleshooting of data discrepancies between ASCP and APCC

Details & Registration

Monday Jun 08, 2015

Webcast: Demantra Certification Part II - Preparing for Retake

Webcast_icon.jpgDemantra Certification Part II - Preparing for Retake

Date: June 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 all users of Demantra who would like to achieve the Demantra 7 Certification. We will cover the results of the study path that I took to prepare for a certification test retake.

Topics will include:

  • Worksheet Manipulation
  • Create Construction Estimates
  • KPIs
  • Configure Topics
  • Level Manipulation
  • Work Flow

Details & Registration

Important Update on the March 2015 12.1.3 Procurement Rollup Patch

If you haven't heard there is a new replacement for 12.1.3 March 2015 Patch 19602627:R12.PRC_PF.B in Patch 21198991:R12.PRC_PF.B.  For details and complete patching instructions see Note 1468883.1.

Questions or concerns?  Reply here.

Friday Jun 05, 2015

Move Order On Down The Road!

Is it the end of the month and you are frightened about what you are going to find in your Pending Transactions form? You hesitate to check, but you click “Find” in Pending Transactions, and again there are weird “Allocated” move order lines that seem to happily just sit there. Didn't this happen last month? … Why, why, why won't these move orders resubmit from Pending Transactions!?!? The Inventory Social Media Team is again here with helpful tips to resolve pesky period close stoppers.

For Allocated Move Orders that don't seem to process, we recommend to bookmark note, How to Check the Move Order Status of Pending Transactions (Allocations) Show in Pending Transactions Form (Doc ID 1370430.1). Using Warehouse Management Systems (WMS)? Doc ID 1370430.1 has also got you covered.

Doc ID 1370430.1 will help you find and process Allocated Move Orders. Sometimes you see move order lines in a status 'Allocated' that cannot be processed in the Pending Transactions form. This is situation normal. Processing manual move order lines are as simple as clicking the “Transact” button in Transact Move Orders form.

You'll also see that there are rare examples that are not so ideal. There can be corrupted move order lines related to Closed or Cancelled Move Orders which require different actions. Doc ID 1370430.1 will guide you on how to proceed when data is corrupted, like when move order status is Closed, Cancelled, or Cancelled by Source.

Pending move order transactions do not need to be mysterious. Use Doc ID 1370430.1 and don't let Move Order Allocations roadblock your period close ever again.

Have you applied the March 2015 12.1.3 Procurement RUP? Or have you seen a problem with the Action History of Requisitions being Deleted?

We have been notified by Procurement Development that there is critical issue where upon deletion of an incomplete Requisition the action history of all requisitions are deleted.  This occurred because of Patch  19289104:R12.ICX.B which has since been set to obsolete, but was already included in the March 2015 RUP.

There has also been an additional symptom seen where a single requisition action history is getting deleted on edit by the approver.

 If you have applied either Patch 19289104:R12.ICX.B or the March 2015 Procurement Rollup Patch (RUP) 19602627:R12.PRC_PF.B in order to prevent this problem, please perform the following:

1. Download Patch 19686669:R12.ICX.B 'This patch resolves the issue of deleted incomplete requisition history in po_action_history table' and Patch 20042118:R12.ICX.B 'This patch resolves the issue of ORA-06512 IN WORKFLOW WHEN USING EDIT REQUISITION'.   Be sure to follow the readmes for any important patching steps.

2. Ensure that you have taken a backup of your system before applying the recommended patches.

3. Apply the patch in a test environment and confirm the following file versions:

patch/115/sql  ICXVUTLB.pls  120.18.12010000.14     
patch/115/sql  ICXVUTLS.pls  120.14.12010000.4     
java/por/req/server  120.9.12010000.15  
patch/115/manualsteps/ad_apply_patch.xml 120.3.12000000.2     
patch/115/sql/PORUTILB.pls 120.20.12000000.41   
patch/115/sql/PORUTILB.pls 120.69.12020000.53   
patch/115/sql/PORUTILB.pls 120.132             
patch/115/sql/PORUTILB.pls 120.28.12010000.62

4. Clear the cache on the server.

a. Responsibility: Functional Administrator
b. Click the Core Services tab.
c. Click the Caching Framework subtab.
d. Click the Global Configuration link on the left side of the page.
e. Click the Clear All Cache button, then click "Yes" to confirm the deletion of the java cache on the server.  Allow this to complete.
f. Log out of the applications.

5. Bounce the iAS/OC4J processes on the applications middle tier(s) in order for the code changes to take effect.

6. Migrate the solution to other environments where 19602627:R12.PRC_PF.B has been applied.

If you have any questions/concerns reply here

Wednesday Jun 03, 2015

Oracle Receivables Proactive Best Practices: Tool Summaries & Troubleshooting Assistants

Webcast_icon.jpgOracle Receivables Proactive Best Practices: Tool Summaries & Troubleshooting Assistants

Date: June 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 and technical Oracle Receivables (AR) users who want to utilize all of the Proactive resources/tools at their disposal to quickly find solutions to commonly encountered issues. We will review the use and benefits of a number of AR Proactive tools, including: Guided Resolutions, Automation, AutoInvoice & AutoAccounting Analyzers, What's New Advisors, Information Centers and more. Where appropriate, we will also look at sample use cases.

Topics will include:

  • Guided Resolutions
  • Automated Troubleshooting Flow
  • Analyzers
  • Additional Instrumental Assistants

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 10-Jun-15: Oracle Receivables Proactive Best Practices: Tool Summaries & Troubleshooting Assistants

Friday May 29, 2015

Depreciation Calculation Considerations in Fixed Assets

There are many variables that can affect the depreciation calculation for an asset.  Some of the basic variables include: 

  • Cost Financial Inquiry
  • Depreciation method
  • Date Placed in Service (DPIS)
  • Prorate convention
  • Prorate date

You can view these variables for an asset via the Financial Inquiry form and make changes to these via the Asset Workbench / Books form.

Additional factors in the calculation of depreciation for an asset include:

  • Specifics of the depreciation method
  • Depreciation calendar
  • Depreciate when placed in service flag
  • Dividing depreciation evenly or by days
  • Other specifics of the prorate convention
  • Prorate calendar

Some of the factors that seem to cause more confusion than others surround the allocation (divide evenly or by days) setting on the Book Controls form and the the prorate information.

If the book is set to divide depreciation evenly, the annual depreciation for the assets will be divided evenly over the number of periods in the fiscal year.  If the book is set to divide daily, the annual depreciation will be divided based on the number of days of the periods in the fiscal year, with the amount of depreciation varying in each period.  For sample calculations of depreciation using "Divide Depreciation By Days" (the less common scenario), review the Depreciation Methods White Paper found in Fixed Assets Depreciation Methods and Calculations With Examples (Doc ID 1179655.1).  There are a number of examples using different parameters, starting on page 25.  Look for those that use "Depreciation Allocation" = "Daily."

For prorates, the prorate calendar determines the number of prorate periods in your fiscal year.  The depreciation program uses the prorate calendar to determine the prorate period, which is used to determine the annual depreciation amount.  The prorate convention is used to determine how much depreciation to take in the first and last years of the asset's life.  Together with the date placed in service (DPIS), the prorate convention helps to determine the prorate date.  For example, if you use a prorate convention with a defined period of 1-JUN-2015 to 30-JUN-2015 and a corresponding prorate date of 30-JUN-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the current month of June.  If the prorate convention, instead, is set to a defined period of 1-JUN-2015 to 30-JUN-2015 with a prorate date of 01-JUL-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the following month of July.  Thus, the prorate date is tied to the DPIS, but the DPIS might not be when the asset starts depreciating.  Examples of varying prorate setups can be found in the white paper in The Wonderful World of Prorate Conventions White Paper (Doc ID 115323.1) 

Thursday May 28, 2015

Webcast: Oracle Learning Management - Content Server Setup

Oracle HCM Advisor Webcast Program - June 2015

What:   Oracle Learning Management (OLM) Content Sever Setup

When:  Wednesday June 3, 2015 at 08:00 UK / 09:00 CET / 12:30 India / 17:00 Australia

This one-hour advisor webcast is recommended for functional users with a technical background, technical users, system administrators, Database Administrators, etc. who are planning to integrate the OLM Content Server in an E-Business Suite  Environment. 

Topics Included:

    Installation of web server
   Configuration of Content Server
   Setup from Learning Administrator
   Q & A

Details & Registration:  OLM Content Server Setup (DocID 2002215.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

Outside Processing with Oracle Process Manufacturing

New white paper explains the capabilities of Outside Processing  provided by Oracle Process Manufacturing Product.

 This document aims to explain the following in detail

  • Changes in forms as part of Outside Process Manufacturing
  • System Setup
  • Recipe
  • Creation of Automatic Requisitions
  • Synchronization of batch and Purchase Orders

 To learn more about this process, refer to Doc ID 1986184.1 Oracle Process Manufacturing Outside Processing - Operation / Batch.

Tuesday May 26, 2015

Transactions Resources, Resources, and More Resources

Do you import transactions into EBS Inventory using the Transactions Open Interface functionality? Inventory Support offers many resources to assist in resolving any issues that may occur. One resource the Inventory Social Media team recommends is the diagnostic in note, R12.0.6+ : Inventory Open Interface Transactions Transaction Data Test (Doc ID 732248.1). Want to see all R12 EBS diagnostics? Check out Doc ID 1083807.1. Still on 11i? Check out all the EBS diagnostics in Doc ID 179661.1.

Want more assistance than just a diagnostic? The Inventory Social Media Team is especially excited about the Analyzers being created across Oracle Support and EBS Products that offer warnings, recommendations, and solutions for your data and/or Product set-up. Check out note, Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1).

Existing Analyzers are currently being reformatted into our new and improved standards, so keep a look out for formatting improvements to existing Analyzers, and new Analyzer offerings. By the way, the Inventory Social Media team is particularly proud of the Inventory Analyzer (Doc ID 1499475.1) which has been previously discussed in this blog. So, be sure to use the many Support resources, and let's get those interface transactions processed!

New White Paper on using Forecasting with EAM

We are pleased to announce a new white paper to provide an overview of how Forecasting is used in Enterprise Asset Management. It will show the setups required and discuss the process flow for Forecasting.   The white paper has the following topics:

  • Overview of Forecasting
  • Setups required for Forecasting
  • Process flow using some examples
  • Meter rules and date rules
  • Useful additional information

To download and read the new white paper refer to Doc ID 2012761.1 Use of Forecasting in Enterprise Asset Management.

Thursday May 21, 2015

Receiving Errors When Validating Invoices? APP-PO-14144: PO_ACTIONS-065 CLOSE_AUTO

Are you getting this symptom when attempting to validate invoices?

APP-PO-14144: PO_ACTIONS-065: subroutine CLOSE_AUTO() returned error

Check out these two references:

Doc ID 1987958.1 Attempting to Validate Invoices: APP-PO-14144: PO_ACTIONS-065

Doc ID 1966826.1 Validate Invoice: APP-PO-14144: PO_ACTIONS-065: Subroutine CLOSE_AUTO() returned error

 Need more information?   Post your question in the Procurement Community here.


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



« August 2015