Monday May 02, 2016

The Little Known Factors that could affect Recognizing Revenue

You may have business or legal requirements that dictate how you can account for the revenue associated to the invoice.  Perhaps you recognize the revenue in full once the invoice is paid, or for invoices associated with a service spread out over multiple months, you may need to recognize the revenue only when the service has been provided.

Scheduling when Revenue is accounted for, is all handled by Revenue Recognition feature.  Revenue Recognition is an engine that will created GL distributions for your invoices reflecting the revenue schedule you defined.

Revenue Recognition is run as a batch process either as a stand-alone or automatically when you invoke transfer of accounting to the General Ledger.  The process will pick up all invoices with rules that have not yet been processed.  For each of these invoices, it will review the Invoicing and Accounting rules associated and create the necessary GL distributions it creates is how invoices in Receivables get posted to the General Ledger.

When Revenue Recognition encounters errors while processing transactions, it will report these transactions as Unprocessed or Partially Processed.  Here are five things that could affect Revenue Recognition:

[Read More]

Thursday Apr 28, 2016

Webcast:12.2.5 New Features in Discrete MES

Webcast_icon.jpg12.2.5 New Features in Discrete MES

Date: May 5, 2016 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 MES and discrete manufacturing functional users who have a basic knowledge of Discrete Manufactruing modules like WIP & MES. This session is basically to appraise users with new features introduced in discrete MES in 12.2.5 release.

Topics will include:

  • List of New Features Introduced in 12.2.5
  • Basic Differences between Components availability program in 12.2.4 and 12.2.5
  • TAB_UI Enhancement

Details & Registration

HRMS UK: RTI Adress Validation

Customers should review and apply the following patches which can cause issues when submitting files to HMRC relating to validation of addresses.


This issue occurs if the user has any invalid characters in address lines and the FPS process is submitted with Parameter "Include Address Details" set to "Always". In this scenario address validation is not happening as expected and the FPS EDI file is generated without reporting any error message for invalid address.

As stated in our earlier communication, after the release of Tax year patch 22669294:R12.PAY.B for release R12.1 some additional bug fixes have been released for RTI.

Please review the following MOS for further details:

  • Note ID 1324671.1  EBS UK Payroll : Real Time Information (RTI) White Paper and Patch Information

This whitepaper provides the list of issues reported for RTI along with the corresponding patch numbers that deliverthe fix.  It is updated with any fixes released for RTI and should be monitored regularly to ensure you are aware of any patches which should be applied.

We are currently working to provide the following consolidated patches to deliver all RTI changes.  These should be available around the middle of next week and will include all the RTI fixes listed against note 1324671.1.

Wednesday Apr 27, 2016

Affordable Care Act: What's Just Over the Horizon?

For most, the last couple of months has been a hectic time!  With the distribution of the 1094/5-C forms completed, now is the time to prepare for filing your 1095-C data with the Internal Revenue Service (IRS).

The following 2 steps need to be taken by every E-Business Standard or Advanced Benefits customer (who will be using Oracle to file their 1095-C data with the IRS):

Step 1: Register to use IRS e-Services Tools
Step 2: Apply for their Information Return Transmitter Control Code - TCC

The best place for you to learn more information about these two (2) steps is from the IRS itself -  it's important to go out to the IRS Site Affordable Care Act Information Returns (AIR) Program and review the section titled 'Here’s what you need to know to get started with AIR' .

Registering and applying for your TCC code could potentially take a bit of time, so it is important to get started on these activities as soon as possible.

Additionally, there are 2 important things that EBS Benefits Development want you to be aware of,  they are:

  1. Oracle - EBS Benefits will only be supporting electronic (not paper) filing
  2. Oracle - EBS Benefits will be supporting the UI channel not A2A

As always, know that you can find EBS Benefits collateral, specific to the Affordable Care Act on My Oracle Support (MOS):

or be directed there from:

Stay tuned for further updates coming in the next few weeks concerning Oracle's delivery plans for: 

  • Support for customers needing to perform the communications test with the IRS AIR System, and
  • ACA Reporting Phase III patch to accommodate the electronic 1094/5-C filing with the IRS

Product Hub: Business Events Vs Business Rules

Oracle Product Hub provides a variety of features for users to implement. Sometimes, there is more than one way to achieve the same end. In such cases, its always an informed business choice that makes the best solution. For instance:
  • Business Events are integrated to a specific business flows for additional processing or validations. For ex: Post Item Create, Post Item Update, Post Attribute Change, Pre-Attribute Change, Post Item Approved etc.
  • Business Rules are triggered on Item Creation and Item Updates. You could use business rules to assign certain values to attributes (OR) perform validations on attributes assigned by users.
Want to know more about the comparison? Review document: Product Hub: When to use Business Events Vs Business Rules? (Doc ID 2131499.1)

Also, don't miss our upcoming Webcast on May 18th 2016: Managing Performance in Oracle Product Hub - Search (Advanced / Simple) and Business Rules

And as always, continue to stay up-to-date on the latest Inventory, PIM, and WMS Webcasts using Doc ID 1290983.1.

Tuesday Apr 26, 2016

Webcast: Information Discovery Extensions for Process Manufacturing

Webcast_icon.jpgInformation Discovery Extensions for Process Manufacturing

Date: May 3, 2016 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 users and technical users who are looking for the deeper understanding and best practices of the Process Manufacturing Information Discovery extensions. This session will highlight the features and capabilities of Batch and Quality dashboards of the Process Manufacturing Information Discovery.

Topics will include:

  • Feature Overview of Batch Information Discovery
  • Feature Overview of Quality Information Discovery

Details & Registration

E-Business Suite on Oracle Cloud

Part 1: Running Oracle E-Business Suite on Oracle Cloud

You can now run Oracle E-Business Suite on Oracle Cloud.  EBS customers can take advantage of rapid environment provisioning, elastic infrastructure that scales up on demand, and a pay-as-you-go model to reduce capital expenditures.

EBS customers have the option of deploying their EBS 12.1.3 and 12.2 environments on the Oracle Compute Cloud Service, and optionally in combination with the Oracle Database Cloud Service (DBCS), or the Exadata Cloud Service.

Part 2: Oracle E-Business Suite on Cloud FAQ

Running Oracle E-Business Suite on Oracle Cloud is simple, but it doesn't take too much effort to come up with several great questions about this new set of options.  We have published a document that answers those questions:
     •    Oracle E-Business Suite on Oracle Cloud Frequently Asked Questions
This document is being updated regularly, so it's worth checking it periodically.  The latest version covers the common questions.

For comments, please use the links above to post them.

Modules in Property Manager

Property Manager helps to maintain all aspects of managing properties like maintaining lease related information, recording the lease agreements, calculating of lease rent, any additional rent, common area maintenance and other charges to be paid by the Lessee.

Property Manager distributes these functions to different modules like Main Lease, Rent increase, Variable Rent, Rent recoveries and operating expense. These modules record information needed to calculate these amounts which are finally charged to the lessee via the Main lease.

Main Lease :- module records the details of the lease agreement and records the agreed periodic lease rental and initial deposits etc. Once the other modules have calculated additional lease rent, common area maintenance, operating expense and other charges, they are also added to the Main lease.

Rent Increase :- module calculates an increase in Lease rental by a percentage or index values per year. The best example is a home rental agreement where the landlord increases the rent by a set percentage say a 10% increase in rent every year the tenancy is continued. This rent increase is calculated on the base lease rent and added as a separate term into the lease.

Variable Rent :- module calculates additional rent based on additional usage of the property. For example if a tenant uses the property more that the regular 8 hours a day or produced more unit than a certain number, he will be charged additional rent based on this additional usage. Slabs of volumes can be set as shown in the example below:-

Units 10000 to 50000 charge 10% additional rent on base rent.

Units 50001 to 100000 charge 15% additional rent on base rent.

Units 100001 to 150000 charge 20% additional rent on base rent.

The addition rent thus calculated is added as a separate term into the lease.

Rent recoveries :- module calculates, apportions and reconciles Common area Maintenance expense. Common area maintenance costs are incurred in the operation, management, and maintenance of the common area of a facility. CAM expenses can include administration, security expenses, parking areas, seasonal decorations, landscaping, snow and trash removal. The best example would be a shopping mall where the tenant pays rent for the shop he leases but also gets charged a proportionate agreed charge for the common area that his customers use like escalators, rest room, water facilities, sitting areas etc. The addition rent thus calculated is added as a separate term into the lease.

Operating Expense :- Module helps to maintain agreement as how a tenant pays his prorate share of operating expense. These are expenses that the landlord incurs in maintaining the property and they pass some or all of it to their tenants. And the agreements records the payments to be made to the landlord based on yearly estimated expenses, reconciles them to actual expense, and make adjustments.

With credit to Anshu Malhotra, Oracle Support

Monday Apr 25, 2016

Oracle Transportation Management Upgraded Doc and Analyzer Released

Oracle Transportation Management Version 6.4.1 Supplemental Installation Guide (Doc ID 2097102.1) version 2 is now available. The section Resetting the NodeManager Password in the whitepaper has been updated.

Also updated is the EBS Oracle Transportation Management (OTM) Analysis and Performance Monitoring Analyzer (Doc ID 1579683.1) to Version 200.3. 

It contains a new section Completed Scheduled Processes with '-create NewProcess false'.

And the report will now print up to 200 lines, requirement to enter the number of desired lines has been removed.

Please refer to its' document to download the new version: ASCP Performance Analyzer script for Performance Monitoring (11.5.X and R12) (Doc ID 1579683.1)

Thursday Apr 21, 2016

APAC HRMS Mandatory Patches

APAC HRMS Mandatory Patches for 12.1 and 12.2 Released!

Are you running payroll in any of the following Asia Pacific (APAC) counties?  If so, please note the release of mandatory legislative updates for these countries for both EBS HRMS 12.1 and 12.2.

  • Australia                                  
  • China 
  • Hong Kong 
  • India 
  • Japan
  • Republic of Korea
  • Singapore
  • New Zealand

The following documents provide information for mandatory legislative patches required by EBS 12.1 and 12.2 HRMS customers for the APAC countries

Highlights of these documents include:

Australia Documentation addressing Superstream changes effective 01-JUL-2015, Year End 2015-2016  and Statutory Updates effective 01-JUL-2016
China Statutory Updates effective 01-JAN-2016; Tax on Enterprise Annuity Employer Contributions, and Preventing Tax Payable When Under One Yuan
Hong   Kong Statutory Minimum Wage Rate Changes Effective 01-May-2015; 2015-2016 Year End Processing and Statutory Updates effective 01-APR-2016
India 2014-2015 Year End Processing and Statutory Updates effective 01-APR-2015
Japan 2015 Year End Processing and Statutory Updates effective 01-Jan-2016
Korea 2015 Year End Processing and Statutory Updates effective 01-Jan-2016
New Zealand Statutory Updates effective 01- APR- 2016; Termination Rate Changes, effective 01-APR-2016
Singapore 2015 Year End Processing and Statutory Updates effective 01-Jan-2016; IRAS Specifications for YA 2016

The updates provide the latest HRGlobal Patch and delivers the latest Legislative HRMS Seed Data.  Be compliant now!

If you have any questions, please log an SR with the Oracle Support Team!

Tuesday Apr 19, 2016

What Are the Available BSO Web Service Methods Available for Purchasing in 12.2.5?

What Are the Available BSO Web Service Methods Available for Purchasing in 12.2.5?

Review (Doc ID 2120274.1)

The following is a list taken from the Integrated Repository showing the available BSO web service objects available in 12.2.5 (or 12.2.4 where patch 19684688 has been applied).

Service Description
createPurchaseOrder This Service Method Creates a Purchase Order with the data provided in the input object PurchaseOrder.

For Create PO, DocumentSubType, StyleId and OrgId are mandatory attributes.


This Service Method takes the Order Number and Organization Name as the input and retrieves the complete Purchase Order details.


This Service Method Updates an existing Purchase Order document as per the data provided in the input object PurchaseOrder.

- For Update PO, DocumentNumber and OrgId, or PoHeaderId are mandatory, to identify the PO to be updated.

- When updating Lines, either provide PoLineId or LineNum to set the context. The same applies to other entities as well.

- To add new Line, either leave LineNum as null, or provide a new LineNum. The same applies to other entities as well.

- For Schedules, Pay Items and Price Breaks, use entity PoLineLocations.

- For BPA Item Attributes, use entities PoAttrVals and PoAttrValuesTLP.

- For Complex PO Pay Item, PaymentType value is mandatory for both create and update scenarios. Possible values are ADVANCE, DELIVERY, LUMPSUM, MILESTONE, RATE.

- Provide only values of attributes to be updated, along with context attributes (discussed above). If an attribute value is provided, and it is not updatable because of the entity status or some other setup, an error message will be returned back and transaction will fail. This applies even when the new value provided is same as current value in PO.

- To nullify the value of a String type of attribute, pass the literal value "WEBSERVICE_NULL_CONSTANT_STRING" or java constant PoConstants.WEBSERVICE_NULL_CONSTANT_STRING

- To nullify the value of a Number type of attribute, pass the literal value -99999999 or PoConstants.WEBSERVICE_NULL_CONSTANT_NUMBER in java.

- To nullify the value of a Date type of attribute, pass the literal value or PoConstants.WEBSERVICE_NULL_CONSTANT_DATE in java

performDocControlAction This Service Method takes the ControlActionInput object as the input and performs the control action on the purchasing document as per the input provided.

Control Actions that are supported by this method are:

- CANCEL (Supports at Header/Line/Shipment level): Cancels the Purchasing document at the specified level

- CLOSE (Supports at Header/Line/Shipment level): Closes the Purchasing document at the specified level

- OPEN (Supports at Header/Line/Shipment level): Opens the Purchasing document at the specified level in case if it is already closed

- INVOICE CLOSE (Supports at Header/Line/Shipment level): Closes the invoice of the Purchasing document at the specified level

- INVOICE OPEN (Supports at Header/Line/Shipment level): Opens the invoice of the Purchasing document at the specified level in case if it is closed

- RECEIVE CLOSE (Supports at Header/Line/Shipment level): Closes the receiving transaction for the Purchasing document at the specified level

- RECEIVE OPEN (Supports at Header/Line/Shipment level): Opens the receiving transaction for the Purchasing document at the specified level in case if it is already closed

- FINALLY CLOSE (Supports at Header/Line/Shipment level): Performs Finally Close operation on the purchasing document at the specified doc level

- FREEZE (Supports at Header level): Performs Freeze operation on the Purchasing document

- HOLD (Supports at Header level): Holds the Purchasing document

- RELEASE HOLD (Supports at Header level): Releases the Hold on the Purchasing document if it is already on Hold

- DELETE (Supports at Header level): Deletes the Purchase order


This Service Method Creates a Purchase Order Modification document with the data provided in the input object PurchaseOrder.

CLM based document.


This Service Method takes the Modification Number and Organization Name as the input and retrieves the complete Purchase Order Modification details.

CLM based document.


This Service Method Updates an existing Purchase Order Modification as per the data provided in the input object PurchaseOrder.

CLM based document.

Thursday Apr 07, 2016

Attending Collaborate 16? Learn More about Analyzers and Social Media

Attending Collaborate 16 in Las Vegas April 10-14? Check out these sessions:

Want options other than logging a Service Request to solve issues? Attend 'Proactive Best Practices: Social Channels get the Conversation Started to Faster Resolution' to get information on how to use social media for quick answers and details on sharing information for quick solutions.

Interested in learning more about Analyzers and what Analyzers are available for EBS Supply Chain Products? Sit in on 'Proactive Best Practices: Case Studies using Supply Chain Management Analyzers'.

Collaborate 16 offers hundreds of presentations and panels packed with the latest information and practical tips for not only the Oracle E-Business Suite, but also Cloud/Fusion Applications, Hyperion, Primavera EPPM, EBS Extensions for Endeca, CRM On Demand, Siebel CRM, BI and EPM, Upgrades, Support, CRM, Financials, HCM, Application Strategy and more! Hope to see you in one of our sessions!

By the way, be sure to follow our live Tweeting during Collaborate 16 at

Tuesday Apr 05, 2016

Depreciation Override in Fixed Assets

Depreciation override can override the system-calculated depreciation amount when the calculated amount does not meet business requirements.  Override is a way to have a different periodic depreciation charged than what is calculated by the depreciation program.  Override amounts are still subject to all standard validations.

One prerequisite to using depreciation override is to set the profile option ‘FA: Enable Depreciation Override’ to Yes.

Depreciation override can be entered in two ways:  
  1. Via the depreciation override form.
  2. Via the FA_DEPRN_OVERRIDE table.
Depreciation override works in two different ways:
  • Used by Depreciation - used to override the system-calculated periodic depreciation amounts.
The steps to perform this override and to see its effects:
  1. Insert a record for the override with the book, asset number, current open period, override amount, used by depreciation, etc.  Set the status to POST.
  2. Run depreciation with or without closing the period.
  3. The status will be changed to POSTED from POST.  In the Asset Workbench form, the amounts entered for override will override the periodic system-calculated depreciation amount. 
OverrideFor example, the usual system-calculated monthly amount for Apr-16 is 500 for an asset.  An override of 800 is entered for Apr-16.  The monthly depreciation charged for Apr-16 is 800, visible when querying in the Asset Workbench.
  • Used by Adjustment - will be processed by performing an adjustment to incorporate the override data.  In this case, a transaction type of ADJUSTMENT will be created, much like a depreciation catch-up.  But, when depreciation is run for this period, the normal depreciation amount will also be calculated.
The steps to perform this override and to see its effects:
  1. Insert a record for override with the book, asset number, a closed period, override amount, and used by adjustment, with status set to POST.
  2. Perform an asset adjustment such as an increase in the cost of an asset. 
  3. After the cost adjustment, you see the line set to POSTED from POST.
  4. Run depreciation with or without closing the period.
For example, if the cost adjustment done in Apr-16 caused a system-calculated catch-up of 3000 and an override is entered with the period of Mar-16 for 2000, the system-calculated monthly depreciation amount for Apr-16, post cost adjustment, would be 500.  After the adjustment, the depreciation catch-up booked in Apr-16 would be 4500, i.e. 3000 system-calculated catch-up and 1500 entered via override, as 500 will be charged in periodic depreciation for Apr-16.  To get the desired adjustments to the catch-up amounts, periodic depreciation needs to be kept in mind.  If the additional catch-up needed is 2000 and the system-calculated catch-up is 500, the deprecation override entered should be 2500.
There are some rules for override to be successfully processed:
  • Override amounts are not picked up if depreciation is already run for the book.  Perform a manual override using an API or perform a transaction like a penny cost adjustment.  Re-run depreciation to have it picked up in the depreciation run.
  • Override amounts are not picked up in the period of retirement.
  • Backdated retirements overlapping depreciation/bonus override are not allowed.
  • Depreciation override of zero is not allowed for an MRC/ALC enabled book.
  • Depreciation override amount has to be less than or equal to the NBV of the asset.
  • Depreciation override amount should not cause the reserve to exceed the depreciation limit.
  • There is no API for depreciation override.
  • Override depreciation is not picked up in the last period of an asset's life for life-based methods.
Points to keep in mind while working with override records:
  • If depreciation is run for the period and an override is missed, enter an override and rollback depreciation via API or by performing a penny cost adjustment.  Re-run depreciation to pick up override amounts.
  • Override has been processed and you see the status as POSTED, but it is incorrect and the period is not closed yet.  Go back to the override form and set the status POSTED back to POST and correct the amounts.  This automatically rolls back depreciation for the asset.  Depreciation can now be re-run to get the correct override amounts picked up.
  • Depreciation run has ended in error due to a validation failure after an override.  Delete the line and enter the correct amount.  Re-run depreciation to get the correct amounts picked up.

With credit to Anshu Malhotra, Oracle Assets Support

Thursday Mar 31, 2016

UK Teachers Pensions

Do you operate payroll for Teachers or report data to the UK Teachers Pension?

Are you intending to start reporting your Teachers data via the Monthly Data Collection (MDC) in 2016 / 2017?

Then this is for YOU!

If you plan to start reporting your Teachers data via the Monthly Data Collection (MDC), you will need to ensure that you have applied the  TYE16: TEACHERS PENSION MONTHLY DATA COLLECTION : EVENT TRACKING functionality which delivers the event triggers to start recording updates which can be captured and produced at a later stage. 

This patch will need to be applied to your production environment by the 1st April to track all of your 2016 / 2017 changes

Please refer to MOS Note:2116089.1 : UK TPA Monthly Data Collection Report Whitepaper

Oracle HRMS Development will be running a Pilot program for the Monthly Data Collection (MDC).


Will deliver the full functionality, including the event triggers.  Although, at this time only customers participating in the MDC Pilot should apply patch 21032735:R12.PQP.C to their test environment.

The logic behind the split of the patches is that we anticipated that customers would not be comfortable applying the full patch into production prior to completion of a full a testing programme.So once the pilot is complete, a mail will be sent out informing all customers of the patch they should apply to their systems.

If any customer wishes to review the content of the MDC patch or apply it to their system, they may download it and test the patch.

However, please load the patch in a test environment only, as we are unable to give priority to issues relating to this patch raised by anyone not participating in the official MDC pilot program.

Oracle AME Integrated With GL Journal Approvals. Business Considerations In Implementing This Enhancement

Oracle Approvals Management (AME) is an Application that provides the users with multiple options to define business rules applying to processes related to approving transactions in Oracle Applications where AME was integrated. 

Recently General Ledger Journals Approval process has been integrated with AME and Workflow, enabling enhanced methods for journals approval processes.

Find below a few relevant details that may help decide in bringing this enhancement to the business: 

  • Can Standard Journal Approval still be used? 

Yes, it is possible to use AME Journal Approval or the Standard GL processes; this is controlled by profile option setup: GL: Use Approval Management (AME).

  • How are organization changes affecting the approval process?
 AME recalculates the chain of approvers after each approval, therefore each transaction will be approved under the latest conditions being set up. 
  • Is the Preparer of the journal affected if AME Journal Approval is used?

The answer is Yes. If AME Journal Approval is enabled, this profile option will not be considered: Journals: Allow Preparer Approval; if the business requires to use this profile in order to control Preparer's access to approve the journal he creates, then use Standard Journal approval in GL as the only method that will take this profile into consideration.  However you may include the Preparer in the Approvers Group and get the same functionality working with AME  even without the profile setup. 

  • Is Approval Limits setup considered by AME?
Maintaining Approval Limits is not mandatory for AME but this setup step could be useful for subsequent AME definitions. 
  • What are the right business situations where AME Journal Approval should be used? 

There is no right or wrong here, this is entirely business decision depending on organizational structures and separations of duties. AME Journal Approval is more flexible, providing ways to be proactive by automatically detecting and routing the journals to approvers according to the separation of duties and not mandatory based on hierarchy; this is very relevant especially for those organizations where the hierarchy is very complex or the approval roles are granted based on skill sets and capabilities of individuals, rather than considering hierarchy only. 

This new feature enables enterprises to enhance their governance, control and compliance with pre-set business rules.  

See how it works here:

Oracle General Ledger Journal Approvals Integration with Oracle Approvals Management (AME) and Oracle Workflow (Doc ID 2038960.1)



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



« June 2016