Friday Feb 05, 2016

Mobile Apps and MSCA – A Tale Of Two Products

Have you heard the terms Mobile Applications (Apps) and Mobile Supply Chain Applications (MSCA)? Confused? Let's try to add some clarity.

Technology brings us great benefits, but for some people benefits are not obvious until they are explained or demonstrated. To do this well often requires specialized, discipline-specific vocabulary (the word “ray” means something different to an astronomer [think gamma ray, ray of sunlight] than it does to a marine biologist [manta ray? sting ray?])

The “Oracle discipline” is no exception - In Inventory we work with two different Products with the term "Mobile" in their names; Mobile Apps and Mobile Supply Chain Apps. People have been known to casually refer to either one as “the Mobile”, which obviously can cause some confusion. We recommend an excellent document to clear up the confusion: What Is The Difference Bewteen Mobile Applications and Mobile Supply Chain Applications (MSCA)? (Doc ID 2103922.1)

Mobile Apps

Mobile Apps


Whether you're a Mobile Apps User, a MSCA User, or both, it's important to know the distinction between the Product names. Hopefully Doc ID 2103922.1 helps clear things up, and happy mobiling!

Wednesday Feb 03, 2016

HRMS UK: Final Tax Year End / Start of Year/ RTI Patch released

On completion of this year's UK Early Adopter Programme, the following patch is now available for download via My Oracle Support:

R12.1 – 21507293:R12.PAY.B - HRGlobal

This patch provides the changes required for completing processing for the UK 2015/16 Tax Year, and the legislative updates effective from 6th April 2016. This patch also includes Real Time Information changes for the tax year beginning on 6th April 2016. 

It delivers the following changes:

  • Autumn Statement Changes – rates and thresholds for PAYE, NI, statutory payments
  • Student Loan Changes
  • Student Loan EDI Submission Changes
  • P46 Car EDI Changes
  • Direct Earnings Attachment Changes
  • Scottish Earnings Arrestments Changes
  • Real Time Information Changes:
    • Employer Payment Summary (EPS)
    • Full Payment Summary (FPS)
    • Earlier Year Updates (EYU)
  • P60 Reports Changes
  • Scottish Rate of Income Tax Changes
  • National Insurance Changes

Please note that this patch includes changes required as a result of the early adopter program and therefore supersedes the early adopter patch released near the beginning of January. 

Post Install Steps need to be run after patch installation. The patch Readme has important installation, setup instructions and guidelines.

Please refer to the following MOS document for further details:

Document 2072952.1(UK legislative Changes for end of tax year 2015/16, the start of tax year 2016/17 and the Real Time Information changes effective from April 2016)

Thursday Jan 28, 2016

The Oracle Mexico Payroll End of Year 2015 Phase 1 patches have been released and are now available on My Oracle Support!

The Oracle Mexico Payroll End of Year 2015 Phase 1 patches have been released
and are now available on My Oracle Support!


- Social Security Quota calculation has been made configurable based on IDW value.

- SUA Interface Extract has been modified to comply with SUA version 3.4.4 requirements.

- BBVA-Bancomer Direct Deposit Interface has been updated to support 108 character layout.

- ‘Overtime and Holidays Worked’ secondary classification has been split into two separate classifications.

- Information Declaration Report (DIM) has been modified to comply with DIM version 3.3.10 requirements.

- New minimum wage rate effective January 1st, 2016.

- The state tax components have been updated for: Chihuahua, Hidalgo, Puebla, Queretaro, San Luis Potosi and Veracruz states.

Patch numbers:

Please see the patch readme’s on My Oracle Support for full patch install instructions and functional information:

Please log a Service request with the Oracle HRMS Mexico product for further assistance with these patches.

Tuesday Jan 26, 2016

Reconciling Receivables to General Ledger

What is AR to GL Reconciliation Report?

  • Compares the Account Balances process from Receivables to General Ledger
  • Highlights Journal Sources where Discrepancies Exist
  • Report will show differences between Account Balances only if item did not successfully process to General Ledger
  • Pulls information from the XLA tables to General Ledger during the Import Process of Create Accounting or Submit Accounting from Receivables
[Read More]

Thursday Jan 21, 2016

Add An Idea And Get Your ER's Moving

Back in our November 2014 post, we posted our first Blog on the the Enhancement Request (ER) process move to Community Ideas. We thought it might be time to revisit this important subject.

As a refresher, the Idea process has replaced the old ER Process. In the new Idea process, you no longer need to create a Service Request (SR) with the corresponding Product group for an ER, you create your own Idea directly in the Product community. Then you and anyone in the Community can vote on and/or discuss your Idea.

Benefits of the new process? You have the ability to create, manage, and vote on your own Idea. You can discuss and expand on your Idea in threads with other Community Users (which includes Oracle Development and EBS Product Management). You can see the progress that your Idea is making through votes and discussion threads. You can view, vote on, and discuss all other existing Idea's. You can filter Ideas by many different options, including 'Delivered' Ideas. And best of all, you can easily monitor where your Idea stands.

How does it work? To get to existing Ideas, go to the Logistics or Inventory Items (APC/PLM/PIM) Communities, navigate: Content > Ideas (tab). To create an Idea, click on: Create an idea.

You can create an Idea with any information that suits you. We suggest that you be as detailed as possible and provide your product release, screenshots or video's (if applicable), define your business process (including industry benefits), feature gaps, and the overall benefits of the Idea. Remember, this is your opportunity to provide information on why you would like your Idea implemented and how it would benefit others. Your stumping for votes.

The new Idea ability in Communities is the quickest way to get your ideas directly in front of Oracle Development. Top voted ideas float to the top and certainly draw more attention. As always, Oracle puts you, the Customer, in the forefront. Moving ER's to Communities Ideas now gives you the power over your ER's. Please help us in tracking features that are important to you. Also, for more information on ER's to Communities, see note Oracle E-Business Suite Product Enhancement Request to My Oracle Support Community FAQ (Doc ID 1584210.1).

January 2016 Updates to AD and TXK for EBS 12.2

Announcement: January 2016 Updates to AD and TXK for EBS 12.2 -

Wednesday Jan 20, 2016

New Enhanced Payroll Analyzer is Available! Check it out ...

We recently made some changes to the EBS Payroll Analyzer.
A new version of Payroll Analyzer is available for customers to download.
Please see this document  EBS Payroll Analyzer (Doc ID 1631780.1) for the analyzer and instructions on install.

Some of the enhancements include:

  •     Better sectioning
  •     A Retropay setup section which analyses Retropay setup and processing issues
  •     A forms personalization area within the generic section
  •     A files version section

Analyzers are designed by Support to proactively assist you to better diagnose and maintain your Oracle Application environments. 

An easy way to keep up with the various updates to all analyzers by implementing the Analyzer Bundle.
E-Business Suite Support Analyzer Bundle Menu Tool (Doc ID 1939637.1)

We welcome and encourage you to share your feedback via the feedback link in the My Oracle Support Payroll Community.
Your feedback shapes the content of existing Analyzers and drives creation of new Analyzers.

Tuesday Jan 19, 2016

Advisor Webcast - Oracle Learning Management (OLM) Content Server Setup on WebLogic Server

Signup to attend an Advisor Webcast regarding Oracle Learning Management (OLM) Content Server Setup on WebLogic Server

Discover everything you always wanted to know on how to deploy and configure the OLM Content Server on the WebLogic Server.

Topics that will be discussed are:
  •     Technical Content Server installation on Oracle WebLogic Server
  •     Functional user Content Server setup
  •     SCORM adapter setup
  •     Java and Non-Java adapters setup
  •     Basic troubleshooting tips

The schedule is:

  •     Tuesday , February 23, 2016 08:00 AM (US Pacific Time)
  •     Tuesday , February 23, 2016 11:00 AM (US Eastern Time)
  •     Tuesday , February 23, 2016 05:00 PM (Central European Time)
  •     Tuesday , February 23, 2016 09:30 PM (India Standard Time)

There will be a question and answer time at the end of the webcast, and the session will be recorded for later viewing if you cannot attend.

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 23-Feb-2016: Oracle Learning Management (OLM) Content Server Setup on WebLogic Server

Monday Jan 18, 2016

Oracle Time and Labor (OTL) Mobile Time Card Configuration & Usage Advisor Webcast

Oracle Time and Labor (OTL) now delivers mobile timecard entry.

Join us for an Oracle Time and Labor (OTL)

Mobile Time Card Configuration & Usage Advisor Webcast

Tuesday , February 09, 2016 08:00 AM (US Pacific Time), 11:00 AM (US Eastern Time), 05:00 PM (Central European Time), 09:30 PM (India Standard Time) 

During this one-hour webcast we will learn how to configure and use this handy, time-saving new functionality.
This Advisor Webcast is recommended for technical & functional users who will be integrating OTL Time Entry with Oracle Mobile applications.

Topics Include:

  • Mobile Framework Configuration
  • OTL setup configuration
  • Configuration of Timecard Application
  • TimeEntry using the Smartphone App

Details & Registration: Doc ID 1455369.1

Saturday Jan 16, 2016

Attention: US & Canadian E-Buisness Payroll Customers

End of Year 2015 Phase 3 Statutory Update Patch has Been Released!

The End of Year 2015 Phase 3**  patch includes:

  • End of Year 2015 Phase 1
  • End of Year 2015 Phase 2
  • Year Begin 2016 statutory updates

Please also note that the End of Year 2015 Phase 3 patch requires the post install steps of running the data installer and hrglobal.drv.  Be sure to carefully read ALL the readme's before beginning to install these patches to ensure successful processing!

As a reminder, the Mexico Payroll Year Begin 2016 patches were released separately on December 28th, 2015, and that release was announced in a separate Payroll World notification. 

** Note: The Release 11i End of Year Phase 3 patch is only available to those customers who purchased continuing legislative support for the US and/or Canadian HRMS localization. Further, the Release 11i Year Begin 2016 update is not included in the End of Year 2015 Phase 3 patch. As a reminder, it is only available in a separate patch. There is an FAQ available for all E-Business Suite customers which contains critical information as to when regulatory/statutory support ends on Release 11i (as well as 12.0 and 12.1) plus other details that can help US and Canadian Payroll customers with planning upgrade activities. Please see Section C. Lifetime Support Policy: Coverage for Applications for further details.

Thursday Jan 14, 2016

Affordable Care Act (ACA) Reporting Phase 2 Patch has been released for 12.2.x

Affordable Care Act (ACA) Reporting Phase 2 Patch Update

                 For Release 12.2.x - Patch 22141344:R12.BEN.C

"ACA Phase 2" delivers the ability to archive, generate and print the actual Forms 1095-C for employee recipients.

The ACA Reporting Phase 2 Patch 22141344:R12.BEN.C, is currently available for download from My Oracle Support for Release 12.1 customers using Standard or Advanced Benefits.

  • Release 12.2 customers must be on Release 12.2 HRMS RUP2 or later in order to apply this patch.
  • Before applying the ACA Reporting Phase 2 patch, the 2015 ACA Reporting Phase 1 Patch 21162146:R12.BEN.C must also be applied.

Patch Highlights:

  • Additional Setup for ACA (optional)
  • New Concurrent Programs to archive and print the necessary Employee 1095-C data as well as the ability to purge the archived data, if needed.
  • New View Employee Archive Data Page

For complete details on what has been delivered, please consult the functional readme in My Oracle Support:

More information on the Affordable Care Act can found on My Oracle Support in

Document 2007993.2 – Information Center: Oracle HRMS (US) – Affordable Care Act (All Application Versions).

Tuesday Jan 12, 2016

Unplanned Depreciation in Fixed Assets

Unplanned depreciation is used in Fixed Assets to handle unusual accounting situations in which the net book value (NBV) and accumulated depreciation amounts for an asset need to be adjusted without affecting the asset cost.

There are some rules for using unplanned depreciation.  These include:

  • You cannot allocate unplanned depreciation amounts to specific distributions, as you can in a distribution set.
  • You cannot make expensed adjustments to assets for which you have previously entered unplanned depreciation and have since amortized the amount.Calculator
  • You can apply unplanned depreciation to assets using flat rate or units of production methods, in addition to straight line methods.
  • You cannot perform a mass change or prior period retirement for assets that have unplanned depreciation.
  • If you have run preliminary depreciation and then enter unplanned depreciation, the unplanned transaction functions as a rollback event.  Therefore, you cannot use unplanned depreciation as a negative adjustment of depreciation in the period of addition.
  • Unplanned depreciation can only be entered if you are using a table based or flat rate method.  For an asset using some other type of method, you will have to change the method first.

To enter an unplanned depreciation, navigate to the Asset Workbench:

1.  Select the asset for which you want to enter unplanned depreciation and click the Books button.

2.  In the Books window, enter a book.

3.  Enter a reason for the unplanned depreciation in the Comments field as needed.

4.  When you navigate to the Depreciation zone, you will see that the amounts will pop up. Click the Unplanned Depreciation button.

5.  In the Unplanned Depreciation window, select the unplanned depreciation type.

6.  Enter the unplanned amount as a positive or negative currency.

7.  Enter the unplanned depreciation expense account.

8.  Select the Amortize From Current Period check box. Leave this box clear if you want to amortize the remaining net book value in a subsequent period.  [The value of this check box overrides the value of the Amortize Adjustments check box in the Books window.]

9.  Click Done to save your work.

For additional information, view the document:  Unplanned Depreciation In Oracle Assets (Doc ID 114298.1).

Monday Jan 11, 2016

Budgetary Control Setup and Funds Inquiry Diagnostic Available!

General Ledger incorporated many features and tools to create, maintain and track budgets, supporting also a variety of budgeting methods that facilitate specific reporting. Planning and implementing budgeting setup according to the business requirements need to be done very carefully; mapping such business needs on the available features may sometimes require more dedicated time and multiple setup reviews until completion.

Incorrect setup for budgeting may lead to: 

  • overspending budgets
  • overstated funds available which may determine incorrect business decisions
  • incorrect reporting on funds
  • bad accruals created in the system

Finding the setup cause for such undesired consequences was many times difficult even for the most experienced users. It just got Simple!

A new General Ledger Budgetary Control Setup and Funds Inquiry Diagnostic is now available to centralize setups and availability of funds!

Budget Diagnostic Sample

What's available inside?

  • budget and organization setup
  • budget organization account ranges
  • summary templates setup and associated summary accounts
  • detail code combinations associated to summary accounts
  • budgetary control group setup
  • funds inquiry/availability
  • calendar definition for the year

This will definitely save some time, download it now!

R12: General Ledger Budgetary Control Setup and Funds Availability/Inquiry Diagnostic (Doc ID 2079451.1)

comes just in time for new year budgeting setup and changes overview!

Thursday Jan 07, 2016

Too Many Decimals? Round And Round

Occasionally, Inventory Support runs into confusion over how the E-Business Suite (EBS) handles decimal places for transaction quantities. An example is that the Work In Process (WIP) Product allows 6 decimals places versus the Inventory Product, which allows 5 decimal places. This is a known limitation that the applications handle by rounding quantities.

In a normal Inventory transaction, the rounding is taken care of immediately, so rounding does not usually cause confusion. If for example, you entered a quantity .000006 in a Miscellaneous Receipt, then the system will round the quantity to .00001. The system rounds using the "ROUND" function to 5 decimals. As a result, 1 through 4 will round down and 5 thru 9 will round up. If for example we try to receive .000004, this would round down to 0 which is not a valid transaction quantity and would raise an error.

Here is an example in Inventory where the application rounds down. The user had entered the Quantity of .000004 (six decimal places) and received the following message:

Here is an example where the system rounds down to 0 and raises an error:

In WIP, the examples can be more complicated. The WIP forms often will help the user avoid issues. For example, you would not be able to issue .000004 because it would round to 0 in inventory. The WIP Completion and Issue forms should stop the user from entering this quantity. The user though could enter .000005 and greater as this rounds up to .00001, not zero. If we build a job for .000006. We assemble the job and look at the Inventory transactions. In Inventory, we see the assembly quantity .000006 rounded to .00001.

Would you like to see this changed? You have the power by voting in the long standing Idea (Enhancement Request) where you can discuss and vote on an enhancement:

Rounding is something you may want to be aware of in EBS. You can find more information in documents:
Inventory and Work in Process Round Decimal Quantities Differently (Doc ID 793356.1)
What is the Restriction of Decimal Precision for Receiving Forms in 11.5.10 and R12? (Doc ID 736699.1)

Wednesday Jan 06, 2016

Integration of Oracle Property Manager with Other Applications

Oracle Property Manager provides an integrated solution with other Oracle Applications. It integrates with other applications such as General Ledger, Oracle Payables, Oracle Receivables etc. Here is a glimpse of other sub ledgers which are integrated with Oracle Property Manager.

1. Oracle General Ledger:- Property Manager  retrieves few setup related information like  chart of account, accounting period types, accounting calendar, ledger, subledger accounting options etc  from General Ledger. Also the normalized accounting entries are transferred from Property Manager to general ledger via Oracle Subledger Accounting module.

2. Oracle Subledger Accounting:- Oracle Property Manager predefines certain setups in Oracle Subledger Accounting like accounting events and event types, sources, account derivation rules etc and these setups will be used when the create accounting program is run in Property Manager.

In addition to that you can transfer normalization-related accounting information from Oracle Property Manager to Oracle Subledger Accounting. Oracle Subledger Accounting creates the appropriate journal entries and transfers them to Oracle General Ledger.

3. Oracle Human Resources (HRMS):- The employee information which we use in Oracle Property Manager while managing office space and allocating locations to employees, are retrieved from HRMS.

Also in HRMS module we can define a hierarchy of organizations to represent the structure of the company. Once you have created the required organizations, you can classify one or more as operating units. In Oracle Property Manager, operating units are used to partition data. Users create all leases, agreements, contacts, locations, and space assignments for a specific operating unit.

4. Oracle Payables :- The owner of the property your organization intends to lease (the landlord) must be set up as a supplier in Oracle Payables and this supplier information will be used while creating a expense lease in Property Manager. Also Property manager uses the other information’s like payment term, distribution set etc which are setup in payables.

Once the leases are created and payments are approved, their invoice information is send to Accounts Payables for invoice creation and for payment processing.

5. Oracle Receivables :- In Property Manager, while creating a revenue lease few information which we use like customers, transaction source, transaction types, grouping rules, payment terms etc are retrieved from Oracle Receivables module.

Also once the Revenue leases are created and finalized, billing lines are approved and transferred to Receivables for invoice creation and further the accounting of invoices is sent to General ledger.

In addition to above, Oracle Property Manager module also integrates with Oracle E-Business Tax, Oracle Projects and Oracle Enterprise Asset Management.

The tax rates which we define in Oracle E-Business Tax appear in the tax input classification or tax output classification LOVs on the term details window. Users can thus associate the appropriate tax rates with lease terms.

You can assign projects which are defined in Oracle Projects module to a location in Oracle Property Manager. By linking locations to projects, your organization can track where project team members are located and the exact costs of space assignment.

The integration between Oracle Property Manager and Oracle Enterprise Asset Management (eAM) enables eAM assets to correspond with locations defined in Oracle Property Manager. Using the Export Locations to Enterprise Asset Management concurrent program we can export location data to Oracle Enterprise Asset Management.

Oracle Property Manager also uses an open interface to integrate with CAD and CAFM applications. This integration enables you to manipulate and view information about your space definition and usage in either a forms-based or CAFM environment, synchronizing data across applications as required.

For more details on integration of Property manager with Other subledgers, refer the Property Manager implementation guide.


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



« February 2016