Wednesday Jul 01, 2015

iSetup? Use It Even Inside The Same Instance!

Oracle iSetup tool is a convenient solution to manage setups and parameters, moving setup configurations between instances as required by the business. This saves the time of rebuilding similar setups on different instances for various E-Business Suite modules ( Oracle Applications Library, General Ledger, HRMS, Payroll, Workflow and more).


Questions have been raised - is iSetup able to copy data even inside the same instance? The answer is: Yes!

Check this for more details: Can iSetup Be Used to Copy Data Inside the Same Instance? (Doc ID 2016589.1

For General Ledger you may copy setups related to:

  • Accounting Calendars
  • Budgeting
  • Chart of Accounts
  • Code Combinations
  • Currencies and Rates
  • Data Access Sets
  • ....and more!
Don't waste more time with rebuilding your setups, use iSetup now!

Tuesday Jun 30, 2015

Using Translation and Plan to Upgrade? Don't Miss This!

Translation is the process that converts balances from functional currency to foreign currencies, covering various reporting requirements. It is possible to translate

  • Actual Balances
  • Budget Balances 
  • Average Balances - if enabled for the ledger 

Once deciding to upgrade from Release11i to Release12, you need to consider the designed changes in the process as described in this document:

R12 Upgrade: Changes to Expect in R12 as Against Release 11i (Doc ID 1443965.1

  • Period End Rates and Period Average Rates no longer exist in R12 
  • Balances Maintained as Separate Reporting Ledger

If you are using Translation in your 11i instance, please visit this important guide we created for you in order to avoid known Post-upgrade Translation problems: 

 Pre-Upgrade Steps To Avoid Post Upgrade Issues Related to Translation (Doc ID 2000905.1)

 It provides step-by-step guidance to review any potential issues and recommended patching for your R12 instance once the upgrade is complete. 

Don't miss this one! 

Monday Jun 29, 2015

Continue Your Work In Process!

In the June 5th post, we discussed "Move Order On Down The Road!" about Pending Transactions related to move orders. Two of many other common Pending Transaction types is a Work In Process (WIP) Completion or a WIP Issue transaction. Pending WIP Completion and Issue transactions can be tricky if you have processing issues. In Support we have seen examples where WIP Completion or Issue transactions have been duplicated, hence creating duplicate WIP Pending Transactions that either won't process or create duplicate Material Transactions historical records. Particularly if the WIP Pending Transactions won't process, they could prevent period close, making them highly visible during month end processing. Don't fret; again The Inventory Social Media Team is here to guide you to a solution.

If you process a lot of WIP Completion and WIP Issue transactions, and you want to check for duplicates, a great place to start diagnosing is note, Duplicate Pending (MMTT) WIP : How To Verify If Pending WIP Completion And Issue Transactions In MMTT Are Duplicates Or Not (Before Resubmitting Or Deleting) (Doc ID 1073279.1).

Doc ID 1073279.1 contains identification sql scripts, root cause analysis, and solution suggestions if you determine you have WIP duplicates. We would also suggest Doc ID 333572.1, which contains an attached Word document which provides details on how to review pending work order transactions; Diagnosing WIP Related Transaction and Data Issues (Doc ID 333572.1).

Duplicate WIP Completion or WIP Issue pending transactions can be tricky, but with the right tools you can turn a period close tsunami into a smooth sailing.

Thursday Jun 25, 2015

Just Released! Version 200.2 of the iProcurement Item Analyzer

What's new in version 200.2?

We've added additional profiles to the iProcurement Specific Profile Options section:
   - POR : Amount Based Services Line Type
   - POR : Goods Line Type
   - POR : Rate Based Services Line Type

New Patch Checks are included along with a check is now made for custom packages.  Additionally we have added the Procurement Code level section for 12.0.x, 12.1.x, 12.2.x and some code changes for EBS Framework version 3.0.25.

Download it today at Doc ID 1586248.1!

Do you have additional questions or feedback?  Well post them here.

Wednesday Jun 24, 2015

Webcast: Work In Process Scrap - Costing Overview

Webcast_icon.jpgWork In Process Scrap - Costing Overview

Date: June 24, 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, consultants etc, who would want to know how the Work in Process (WIP) Scrap transactions are generated and the corresponding accounting values are calculated under various set ups in WIP Costing.

Topics will include:

  • Introduction
  • Setups
  • Scrap value calculations – Average Costing
  • Scrap value calculations – Standard Costing

Details & Registration

Friday Jun 19, 2015

What's New - Content in Receivables (AR) and Related Products

Receivables has created 'What's New in Receivables' DocID 1944310.1 that centers around all latest information going on Receivables and Receivables-related products.  This tool is updated DAILY and will display all notes that are available to MyOracleSupport users.  Make sure you bookmark this document for a direct route into the latest and most up-to-date knowledge for Receivables and related products.

 Highlights include:

  • General Information
    • Direct link to Oracle Social media pages
    • Direct Link to your documentation for your product release version
    • Broken down by sub-components
  • Last 30 Days
    • Includes NEW notes, created within the last 30 days
    • Product specific
    • Broken down by sub-components
  • All Related Content - Last 2 Years
    • Content that is still relevant and has been reviewed by subject matter experts for accuracy and continued relevance
    • Product specific
    • Broken down by sub-components
  • Other Related Products
    • Includes direct links to What’s New pages in all products under the specific support ‘umbrella.’ 
    • All of these products will have ‘Receivables’ listed in this tab, as the anchor to all the product links.

The following is a list of the products that currently have these advisors for your convenience:

RECEIVABLES  (DocID 1944310.1)



(DocID 1989946.1)



E-BUSINESS TAX (EBTAX) (DocID 1957687.1)

EDI / XML GATEWAY – (810 Outbound) (DocID 1959400.1)




ORACLE LOANS (DocID 1958331.1)





Tuesday Jun 16, 2015

Webcast: Outside Processing (OSP) for OPM in 12.2.4

Webcast_icon.jpgOutside Processing (OSP) for OPM in 12.2.4

Date: June 23, 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 and functional users who are interested on knowing what will be the model of new functionality introduced in 12.2.5; Integrated Outside processing for Production batches.

Topics will include:

  • Outsourcing at Operation / Step Level 
  • Business flow /System Flow
  • Setup / Demo
  • Future features

Details & Registration

R12.1 Statutory Patch Released for Australia Oracle Payroll

Attention Australia Oracle Payroll customers:  Statutory updates effective from 01-JUL-2015 for Australia legislation have been released in the R12.1 Patch 21238399:R12.PER.B.          

This patch includes:
     • HELP tax scale changes (includes late change)
     • SFSS tax scale changes (includes late change)
     • PAYG Tax table changes (these are no longer changed with update)
     • Senior Australian Tax Rate Changes (these are no longer changed with update)
     • FBT gross up rate changes for Payment Summary from 1 April 2016
     • ETP threshold changes (CPI)
     • Super threshold changes (CPI)
     • Lump Sum E reportable amount increase to $1,200
     • ETP whole of Income Cap definition
     • Changes to TFN electronic lodgement file including the introduction of TSL (Trade Support Loan). This is an extension of HELP.

This patch will also include new functionality around non taxation of termination payments on death and reporting of employee’s with TFN all 1’s and 28 days has expired.

Please refer to the functional readme for details:  README FOR PATCH 21238399:R12.PER.B - STATUTORY UPDATES EFFECTIVE 1 July 2015 (Doc ID 2017621.1).  Also make sure to refer to the technical readme in the patch download for important patch installation instructions.

Note:  The 12.2 patch will be released as soon as possible.

Please also refer to the note: 2015 Important Messages for Australia Oracle Payroll Customers Summary (Doc ID 1999390.1)

If you have any questions or issues on this legislative patch, please log a new Service Request with Oracle HRMS (Australia) Payroll support.

Thursday Jun 11, 2015

Webcast: eAM GIS Integration Options

Webcast_icon.jpgeAM GIS Integration Options

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 technical users, functional users, system administrators elaborating the various GIS integration option available for 12.2.4+ customers with EAM. This is applicable both for Discrete assets and Linear Assets The session would first touch upon the out of box Map Use cases provided by EAM and the integration ways to achieve the same based on the GIS system customer is using.

Topics will include:

  • EAM Map Use Cases
  • GIS Integration Options
  • ESRI
  • Oracle Spatial
  • Custom GIS
  • Map Tool bar

Details & Registration

Wednesday Jun 10, 2015

New version 200.5 of the 12.1.3 Procurement Approval Analyzer Just Released!

Like a fine wine we keep getting better over time! Download the new version 200.5 of the 12.1.3 Procurement Approval Analyzer today here.

Improvements include:

1. Bug fix for the request ending up in warning
2. Change of wfstat signatures that were defined backwards - results should be the same as before
3. Added the following signatures to the DX summary: APP_HIER_CHECK1, APP_HIER_CHECK2, APP_HIER_CHECK3, APP_HIER_CHECK4, APP_HIER_CHECK5, APP_HIER_CHECK6

Need more information?  Reply here.

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


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