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.  

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).

Wednesday Aug 13, 2014

HTML User Interface for Order Management

You can now use the Order Management HTML user interface to create, update, and manage orders.  The HTML user interface is in addition to and co-exists with the existing sales order windows and Order Information Portal (OIP).

The HTML user interface is an additional option, if you desire a modern, easily configurable, tablet friendly user interface. This interface offers functional parity with Sales Orders, Order Organizer, and Scheduling Organizer.  It shares a common foundation with the existing sales order windows, Process Order API, and Order Import.

You can access this interface using the Order Management, HTML User Interface responsibility.  Access to this is controlled by roles. You can have various combinations of authorization granted either through a permission set or through grants. Additionally, the HTML interface is integrated with FND Security to enable rule-based access to the summary and detail views of sales orders.

For additional information, please refer to the following documents:

Tuesday Aug 12, 2014

Webcast: Troubleshooting Scheduling and ATP in R12 Order Management

Webcast_icon.jpgWebcast: Troubleshooting Scheduling and Available To Promise Issues in R12 Order Management

Date: August 19, 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 is recommended for technical and functional users who would like information on setup, common problems and tools to troubleshoot Scheduling and Available To Promise (ATP) issues in Order Management.

Topics will include:

  • Setups, Profile Options and System Parameters affecting ATP/Scheduling
  • How to capture OM Debug and ATP Session files for troubleshooting
  • Common ATP Issues in OM
  • Latest R12 Enhancements
  • Important Notes

Details & Registration: Doc ID 1684345.1

Monday Aug 11, 2014

Order Management Suite Product Resource Guide

The Order Management Suite Product Resource Guide brings together all pertinent information for each of the Order Management Suite Applications into one source document. The document identifies different types of structured content that you need for each of the Order Management Suite Applications:
  • Advanced Pricing
  • Configurator
  • Order Management
  • Release Management
  • Shipping Execution
  • Transportation Management
For each of the above listed applications, the following structured content links are displayed in a very easy to read table format:
  • Information Center(s)
  • Support enhanced release Content Documents (RCD)
  • Getting Started FAQs
  • Patching
  • Documentation
  • Diagnostic Scripts
  • Customer Newsletters & Blogs
  • White Papers
  • Communities  
  • Webcasts

This document provides you one location for all of the information you need most. 

Add Order Management Suite Product Resource Guide (Doc ID 1092425.1) to your list of favorites (click the yellow star to the left of the document name).  Once adding the document to your list of favorites, you can pull it up easily by clicking on the yellow star next to the search box (top right corner) in My Oracle Support.

Notify us if there are additional resources you would like added to the Resource Guide by adding a comment to the document (top right of any document).  Having all pertinent information in one place will save us all time.

Friday Jun 27, 2014

New OM 12.1 Cumulative Patch Released!

ORDER MANAGEMENT 12.1 JAN 2014 CUMULATIVE PATCH 19018023 has been released!!

The best way to stay ahead of data and program issues is to apply the latest cumulative patches (RUPs) at your first opportunity.

You can review the current list of cumulative patches via Order Management Cumulative Patches for Releases:11.5.10, 12.0.4, and 12.1, Doc ID 453944.1.

You can also dynamically search the latest EBS recommended patches using tools that are already available to you. See Doc ID 1400757.1 How to Find E-Business Suite Recommended Patches for the three methods. By using Method 1, Patch Wizard, you can see whether the recommended patches are already applied in your instance. You can also see the changes that an un-applied patch will introduce to your instance if you applied it.

Thursday Jun 26, 2014

During R12.2.3 Upgrade QP_UTIL_PUB Is Invalid

Release 12.2.3 upgrade below pll files recompile failed.  The following Oracle Forms objects did not generate successfully:

QOTLNSVI.pll         OEXOEGWY.pll
QOTPRDTL.pll         OEXOEADJ.pll
OEXOEBSE.pll         OEXOEBSO.pll
OEXTRTYP.pll         OKSAUDET.pll
QOTLNDET.pll         OEXOEHDR.pll
QPXQPDEB.pll         OEXOELIN.pll

There is a documented workaround for those that are receiving this error in note:  During R12.2.3 Upgrade on Patch 17020683 the pll Recompile Failed Showing That Object APPS.QP_UTIL_PUB Is Invalid, Doc ID 1683318.1

For those that have not yet upgraded, please review the readme and pre-requisites for Patch 18977965 as a pre-install / pre-upgrade step.

Thursday Jun 19, 2014

Tendering in Oracle Transportation Management

Tendering in Oracle Transportation Management involves the following basic functions:
  • Shipper sending the offer request to the transporter for moving the cargo
  • Transporters sending in their respective offers
  • Analyzing the offers and awarding of bid to the best/low cost transporter
This document covers the following topics:
  • About Tendering
  • Types of Tendering
  • Setup, Scenario & Statuses
  • Diagnostics

For the whitepaper, visit Tendering in Oracle Transportation Management, Doc ID 1677607.1.

Monday Jun 16, 2014

Webcast: Holds Unlocked

Webcast_icon.jpgWebcast: Holds Unlocked

Date: June 17, 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 advisor webcast provides functional users with a basic introduction to holds, their setup and how to use them. This will be a generic presentation without addressing specific holds (such as Credit Check).

Topics will include:

  • Setting up Holds
  • Defining and using Hold Sources
  • Applying Holds
  • Releasing Holds
  • Expired Holds
  • What to do after releasing a Hold

Details & Registration: Doc ID 1664061.1

Wednesday Jun 11, 2014

Generating Landed Cost Management Charges using Custom Pricing Attributes

Learn how to incorporate Custom Pricing Attributes into Landed Cost Management through a new whitepaper. 

The new application, Landed Cost Management (LCM), enables exact shipment charges to be applied to incoming receipts. These charges are calculated using the Freight and Special Charges functionality from Advanced Pricing within the Pricing Transaction Entity of “Purchasing”.

Advanced Pricing is very flexible in that custom attributes can be defined to derive specific charges. The way that Landed Cost Management builds these attributes is different from the processing for Advanced Pricing with Purchasing.

The whitepaper can be downloaded from document Oracle Advanced Pricing White Papers, Doc ID 136687.1.

Thursday May 15, 2014

Webcast: Processing Payments in Order Management R12

Webcast_icon.jpgWebcast: Processing Payments in Order Management R12

Date: May 20, 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 is recommended for technical and functional users who intend to know about the how payments are handled in Order Management.

Topics will include:

  • Mandatory Setups
  • Process Flow for payment methods
  • Discuss Common Error Messages regarding payments in OM
  • Run through Test Cases

Details & Registration: Doc ID 1641228.1

Tuesday May 06, 2014

Configuration Validation Resulted In Error(s) While Booking

Ever wonder how to troubleshoot a configuration validation error when booking a sales order? 

The Configuration Validation Resulted In Error(s) typically occurs when Oracle Configurator is used in batch mode and batch validation is not able to make a valid database connection. 

Well, we now have a step by step approach document to troubleshoot the error. 

The document will walk you through the debug, what to look for and where to find the error code.  The document lists all returned error codes and their meanings.  It then steps you through additional verification of your environment and setups to help you locate the actual issue along with their known resolutions.

The master note is:
Configuration Validation Resulted In Error(s) While Booking, Doc ID 1584974.1

Take a look at this note the next time you run into this issue.  Or take a look at the note now, so you know what to do if the error occurs.

Monday Apr 14, 2014

Sell Services from Order Management

Currently, you can order only service contracts of type Extended Warranty through Order Management.  In release 12.2.2, you can order service contracts of type Subscription Contract too. You can order Tangible as well as Intangible subscription contracts.  Tangible subscription contracts are fulfilled through Order Management. You can record Subscription Contract specific attributes such as Start Date, Period, Duration, and Subscription Template on the order line. As currently supported for standard inventory items, you can attach Extended Warranties to a Subscription Contract as well. Additionally, you can include a Subscription Contract in a model/kit. After fulfillment of the line, a Subscription Agreement is created in Service Contracts.

Currently, when an Extended Warranty is invoiced through Order Management, the invoice amount is for the entire duration of the Extended Warranty. In this release, additional billing options have been introduced for Extended Warranties and Subscription Contracts. The options are as follows:
  • Retain the existing behavior of generating an invoice for the entire duration from Order Management.
  • Generate the invoice for the first installment from Order Management and for the subsequent installments from Service Contracts.
  • Generate invoices for all installments from Service Contracts. In this scenario, Order Management does not generate any invoices.
For the orders that are billed in multiple installments over the duration of the service contract (Extended Warranties/Subscription Contracts), you can specify the billing schedule.

For additional information on this new Feature, refer to the Sell Services From Order Management section of Doc ID 1377743.1 Oracle Order Management Release Notes for Release 12.2.2.


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



« March 2015