Thursday Jul 02, 2015

Self-Evaluation for High Volume Order Import (HVOP)

Development has updated the White Paper - Self-Evaluation for High Volume Order Import (HVOP)

The main changes are for Tax and Configurations support.  For Tax changes, under the ‘Tax Support’ information to section ‘What import actions does your business require’.  And for Configurations support, under ‘Configurations Support’ to section ‘What types of items are imported’.

You can access the white paper via the master White Paper Note, Doc ID 113492.1.

General Ledger Balances Corruption - Causes, Suggestions, Solutions

Finding correct and accurate balances in General Ledger(GL) at the end of each period and year is one of the main targets for the functional applications users and accounting departments. The GL balances are considered base for reporting purposes and also important to reveal the results and current position of the company based on the accomplishments and changes reflected by the accounts through balances. It is important to be able to rely on the trial balance reports.

What if the balances get corrupted? 

In the last months our Developers worked close with General Ledger Support team and reviewed all the balances corruption cases reported by customers, preparing a complex document to reflect their findings: 

  • Potential Causes identified
  • Solutions for each potential cause that could lead to corruption
  • Suggestions to prevent such corruptions from happening

Do review this document we have prepared for you - it will help prevent potential corruptions, allowing the users to focus on period closure activities and report on the balances without delays: 

General Ledger Balances Corruption - Causes, Solutions and Suggestions. (Doc ID 1995324.1

Wednesday Jul 01, 2015

Revaluation in Fixed Assets

Oracle Assets allows you to periodically adjust the value of your assets due to inflation or deflation, according to rates you enter.  This process is known as revaluation.  The rules for revaluation often differ from country to country.  Oracle Assets has the flexibility to handle your specific requirements.

Revalue assets to adjust the value of your capitalized assets in a highly inflationary economy.  You can revalue all categories in a book, all assets in a category, or individual assets.  You can revalue all assets using the Mass Revaluation process.  The Mass Revaluation process does not use price indexes to revalue assets.

Reval Flow Oracle Assets multiplies the asset cost by the revaluation rate you enter in the Mass Revaluations window to determine the adjustment to the asset cost. 

Revaluations are not processed for:

  • Fully retired assets
  • Assets with pending retirements

Since Oracle Assets does not Mass Copy revaluations, when you perform a revaluation in your corporate book, also perform it in each tax book associated with that corporate book.

To process revaluations, revaluation accounts and revaluation rules must be set up.  The default revaluation rules that are set up for a book can be overridden when creating a revaluation definition in the Mass Revaluations window.

You will need to consider whether or not to revalue accumulated depreciation.  You can revalue fully reserved assets that are depreciating under a life-based method.  If you choose to revalue fully reserved assets, you would need to enter a life extension factor to extend the asset life.  To revalue a retired asset, you would need to first reinstate it.  You can also revalue CIP assets, but only for a tax book.  A ceiling can be set to prevent revaluation above the fair market value.

To assist in these, and other revaluation considerations and setups, there is a new white paper available.  In addition to setup steps, this white paper provides the steps for performing revaluations as well as sample calculations for different scenarios.  You can review the document to understand how different book control settings might affect the revaluation calculations.  What might be expected if you decide to revalue accumulated depreciation?  Or, perhaps you only want to revalue year-to-date (YTD) depreciation?  Or, what might the revaluation amounts look like if you amortize the revaluation reserve?

The Revaluation in Oracle Assets White Paper can be found in Doc ID 2018027.1.

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:

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