Friday Aug 29, 2014

Subledger Accounting: Proration Types in Multi Period Accounting

Looking for an overview and explanation of different Proration Types in Multi Period Accounting (MPA) feature in R12?

Multi Period Accounting (MPA) enables users to create accounting for a single accounting event for more than one GL period.  This functionality is primarily used to recognize revenue or a prepaid expense across multiple GL periods.

Within Multi Period Accounting, application provides different ways to Prorate the amounts.

  • First Period
  • Days In Period
  • Total Days In Period
  • 360 Days

The Amount prorated depends on the Proration Type.

R12: Subledger Accounting: White Paper Explaining Different Proration Types in Multi Period Accounting (Doc ID 1915795.1)
explains the proration type in detail and includes a step by step guide on how to configure the MPA feature for a business transaction.

Wednesday Aug 27, 2014

RMA Calculates Tax as a Positive Value

Are you seeing positive tax values on Return Material Authorizations (RMAs) and negative tax values on the actual Credit Memo? 

If this is occurring, the calculated order total will be incorrect.  Also if you are using credit checking with exposure, the exposure calculation will also be calculated incorrectly.  Which may cause an incorrect credit hold.

If you are seeing positive tax values on RMAs and negative tax values on the actual Credit Memo, you will need to review Doc ID 1620464.1  RMA Calculates Tax as a Positive Value instead of Negative Value.    

The note explains what needs to be verified and any necessary actions.  Please note this is currently only occurring in version 12.2.

Updated 04-Sep-14: amended incorrect product version.

How healthy is your Order Management data?

Ever wonder how healthy your Order Management data is?  The new Order Management Analyzer has been released to assist you with this area!!  The Order Management / Sales Order Entry Analyzer is a 'Health Check' script which you can proactively use at any time to review the data relating to Sales Orders, including :
  • Sales Order Headers and Lines
  • Workflow Issues
  • Drop / Ship Orders
  • Models and Kits
  • Sets
  • Shipping / Delivery Data

Each script used by this report looks for specific symptoms which have been known to cause problems in the past.  The script can either be run manually in SQL*Plus, or as a concurrent request.  The script may be run safely at any time.   No data is created, updated, or deleted by this script.

To download the script, go to R12: Order Management (ONT) Sales Order Analyzer Diagnostic Script, Doc ID 1665244.1.  To see what others are saying about the script or to add a comment/request on the script, go to its' community thread.  

Are You Having Problems Finding the Procurement Community?

Since migration there have been some users reporting they can no longer find the Procurement Community or they are getting lost. Well let me help make it simple!  Just use this direct url access:

See the Procurement Community here.

You will then be taken to the main page of the Procurement Community where you can choose under the Actions section 'Start a discussion' to post a question or 'Create an Idea' to request an Enhancement Request:

From the main page choose the 'Content' link where you can then further drill down under the Discussion or Ideas sections to look at all activity.

And no worries if you get lost just bookmark/add to favorites the url for quick access:

Tuesday Aug 26, 2014

Understanding External Bank Account Masking

Struggling with Bank Account Masking functionality in Oracle Payments?

In support we often see questions asked related to the masking of External Bank Accounts so if you also want to learn more about this functionality then take a look at the following document:

External Bank Account Masking (Doc ID 1918242.1)

In it you will find the answers to the following common questions:

  • How are External Bank Account numbers masked?
  • What Setups Need to be Changed in Order to Update EXTERNAL Bank Accounts That Have Been Masked?
  • How to Set the Masking for Selected Responsibilities?

Monday Aug 25, 2014

Do you find it a challenge diagnosing issues with creating Requisitions to Purchase Orders Automatically?

Do you find it a challenge diagnosing issues when there are problems with creating Requisitions to Purchase Orders automatically?  Well it has become much easier with the newly enhanced 'CREATEPO Workflow - Data Collection Script' available in Doc ID 1415918.1.

Run the diagnostic and the output will include all the necessary information for problem solving; including:

1) Profile Option Values
2) Default values for CREATEPO attributes
3) Requisition header and line information
4) Document Setup for requisitions
5) Requisition approval workflow activity, attributes, errors and validation checks
6) CREATEPO overall workflow activity, attributes, errors and validation checks
7) CREATEPO requisition processing workflow activity, attributes, errors and validation checks
8) CREATEPO approval workflow activity, attributes, errors and validation checks
9) PO_WF_DEBUG messages
10) Purchase order / Blanket release information

More importantly now valuable errors and warnings are provided with links to the solutions!

So you can potentially resolve the issue on your own, or if you still need Supports help proactively run the diagnostic before logging a Service Request and the data collection will be available for the analyst immediately.  Add Doc ID 1415918.1 to your favorites today.

Friday Aug 22, 2014

Channel Revenue Management and General Ledger Integration

Back in February of this year, we told you about the EBS Business Process Advisor: CRM Channel Revenue Management document which has detailed information about the Channel Revenue Management application business flow and explains integration points with other applications.  But we thought that you might like to have even more information on exactly how Channel Revenue Management passes data to General Ledger.

Take a look at Integration Troubleshooting: Oracle Channel Revenue Management to GL via Subledger Accounting (Doc ID 1604094.2).  This note includes comprehensive information about the data flow between Channel Revenue Management and GL, offers troubleshooting tips and explains some key setups.

Let us know what you think - start a discussion in the My Oracle Support Channel Revenue Management Community!

Announcing Oracle Mobile Timecards for Oracle E-Business Suite, Release 12.1 and Release 12.2

Oracle E-Business Suite Development is pleased to announce the availability of Oracle Mobile Timecards for Oracle E-Business Suite iPhone application.  With this new mobile app, users can record time on the go, and quickly submit timecards to ensure that downstream processes like Payroll, Projects Costing and Vendor Settlements are executed on time. Key features include:

  • Enter time day-wise for easy time booking
  • Enter time in Quick Time or Regular Time modes
  • Support Payroll and Projects based time entry
  • Aggregate day-wise entries into timecard periods
  • Submit and view timecards while on the go

Oracle Mobile Timecards for Oracle E-Business Suite is currently available on OS, and Android availability is planned. It is available to Oracle E-Business Suite customers as part of an existing Oracle Time and Labor product license; no new "mobile" license is required.

Download Availability

You can download Oracle E-Business Suite Smartphone Applications directly from the Apple Store and run them on Oracle Business Suite 12.1.3 or 12.2.3 – the same client-side code runs with either release:

iTunes link:

 For each app, an administrator performs a simple, one-time ennoblement using server-side patches. For deployment instructions, see Oracle E-Business Suite Mobile Apps, Release 12.1 and 12.2 Documentation (Note 1641772.1).

Demo Availability  

Support for demo-ING in GS environments will be available shortly. A demo preview of Oracle Mobile Timecards for Oracle E-Business Suite is available here.

Configured Layouts on Mobile Timecards

Note.1671889.1 Mobile Timecard Layout Configuration Whitepaper for OTL Mobile Time Entry

Thursday Aug 21, 2014

Use Oracle Product Hub Business Events to Integrate Additional Logic into Your Business Flows

Business events provide a mechanism to plug-in and integrate some additional business processes or custom code into standard business flows.  You could send a notification to a business User, write to advanced queues or perform some custom processes. In-built business events are available specifically for each flow like Item Creation, Item Updation, User-Defined Attribute Changes, Change Order Creation, Change Order Status Changes and others.

To get a list of business events, refer to the PIM implementation Guide or Using Business Events in PLM and PIM Data Librarian (Doc ID 372814.1) .

If you are planning to use business events, Doc ID 1074754.1 walks you through a setup with examples. How to Subscribe and Use Product Hub (PIM / APC) Business Events [Video] ? (Doc ID 1074754.1). Review the 'Presentation' section of Doc ID 1074754.1 for complete information and best practices to follow while implementing code for subscriptions. Learn things you might want to avoid, like commit statements for instance. Doc ID 1074754.1 also provides sample code for testing, and can be used to troubleshoot missing setups or frequently experienced issues. Take advantage and run a test ahead of time with the sample code to isolate any issues from within business specific subscription code.

Get more out of Oracle Product Hub by using Business Events!

Webcast: Flow Manufacturing Work Order-less Completion

Webcast_icon.jpgWebcast: Flow Manufacturing Work Order-less Completion

Date: August 27, 2014 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This advisor webcast is intended for technical and functional users who want to understand the Flow Manufacturing Work Order-less Completion and its Transaction types. This presentation will include the required setups and provide details of the business process.

Topics will include:

  • Overview of Flow Manufacturing and Integration with Work In Process
  • Overview of Work Order-less Completion
  • Basic Setup Steps
  • Transactions performed in Work Order-less Completion form

Details & Registration: Doc ID 1906749.1

Wednesday Aug 20, 2014

Enable Configurator for Return Orders

With release 12.2.4 for non-referenced RMAs, Order Management will allow you to configure the model from Sales Order / Quick Sales Order windows. This is only allowable when profile  OM: Enable Configuration UI for RMA is set to Yes.  All selected options must be returnable, as well as all included items.

Order Management explodes included items and creates options and option classes in a way similar to outbound orders. The application creates all selected components with same line number but different option/component number. 

Additionally, the application does not allow re-configuration and/or deletion of any line if any line in the same configuration is received, fulfilled, closed, cancelled, or split.

For additional information refer to the Oracle Order Management Release Notes for Release 12.2.4 (Doc ID 1906521.1).

Tuesday Aug 19, 2014

Substitute Items on Internal Sales Orders

Oracle Order Management now enables you to substitute items on internal sales order lines to manage item availability.  Oracle Order Management enables you to substitute items on internal sales order lines to manage item availability. Source organizations can decide to ship a substitute item in case the original item is not available to be shipped. The application supports manual (using Related Items window) and automatic (using ATP functionality) substitutions.

To substitute an item on ISO, you must ensure that the value of the Item Substitution on Internal Order system parameter is set to a value other than None. In addition, you must ensure to define substitute item relationships and automatic item substitution setup in the system. The application provides the option to not send the notifications when any change happens on the ISO related to quantity, schedule arrival date, or item. You can control these notifications using the OM: Send Notifications of Internal Order Change profile option.

For additional information refer to the Oracle Order Management Release Notes for Release 12.2.4 (Doc ID 1906521.1).

Monday Aug 18, 2014

EBS Extensions for Endeca 12.2 V5 Now Available

E-Business Suite Development has announced the availability of Oracle E-Business Suite Extensions for Oracle Endeca 12.2 V5 - see the announcement here

This release adds the following new modules that can be used to extend Oracle E-Business Suite 12.2:

  • Oracle Service Contracts Extensions for Oracle Endeca
  • Oracle TeleService Extensions for Oracle Endeca
  • Oracle Human Resources Extensions for Oracle Endeca
  • Oracle Quality Extensions for Oracle Endeca.

These new modules are in addition to those already previously available.  Availability of these new and updated V5 modules for 12.1 is planned.

Where can I find more information?

  • Subscribe to the YouTube channel for Oracle E-Business Suite to get the latest on Oracle E-Business Suite Extensions for Oracle Endeca.
  • Bookmark the Information Center: Oracle E-Business Suite Extensions for Oracle Endeca (Doc ID 1486924.2)
  • Read about how to install Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V5 (Doc ID 1614014.1).

Friday Aug 15, 2014

Oracle E-Business Suite 12.2.4 is Available for Download!

This Release Update Pack (RUP) for the EBS 12.2 release codeline includes new features as well as statutory and regulatory updates, and error corrections for stability, performance, and security. 

This is a consolidated suite-wide patch set. Release 12.2.4 is cumulative and includes new updates as well as updates made available in one-off patches for prior 12.2 releases.

The details for downloading and applying the Oracle E-Business Suite 12.2.4 Release Update Pack can be found in the Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1).

Thursday Aug 14, 2014

Webcast: Extend EBS eAM using OAF Personalization

Webcast_icon.jpgWebcast: Extend EBS eAM using OAF Personalization

Date: August 21, 2014 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This one-hour session will focus on extending Oracle EBS eAM functionality using the OA Personalization Framework. The OA Personalization Framework allows you personalize your display of Oracle Self–Service Web Applications without modifying any underlying code. OA Personalization Framework allows you to make personalizations at distinct levels so that you may target those personalizations to specific audiences. Personalizing the appearance or behavior in an Oracle Self–Service Web Application page is as easy as changing your web browser preferences.

Topics will include:

  • What is Personalization?
  • Administrator vs User Level Personalizations
  • Setup
  • eAM Use Case Demonstrations
  • Resources

Details & Registration: Doc ID 1901429.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



« August 2014 »