Tuesday May 12, 2015

Webcast: Basic Troubleshooting Information for Duplicate Sales Order Transactions Stuck in Inventory Tables

Webcast_icon.jpgWebcast: Basic Troubleshooting Information for Duplicate Sales Order Transactions Stuck in Inventory Tables

Date: May 20th, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 5:00 pm CET, 9:30pm IST

This one-hour advisor webcast is recommended for (technical users, functional users, system administrators, Database Administrators, etc.) who normally work with Inventory Month End Closing process including resolution for stuck transactions in Inventory tables.

Topics will include:

  • Provide basic troubleshooting techniques to identify and fix duplicate sales order transactions between Inventory tables MTL_TRANSACTIONS_INTERFACE, MTL_MATERIAL_TRANSACTIONS_TEMP, and MTL_MATERIAL_TRANSACTIONS
  • Provide information regarding the Root Causes of this data corruption, how to verify your code level and confirm if you area already in a known fixed version, and how to avoid recurrence of this issue
  • Note: This webcast is focus on sales orders and has no affect on Inventory transactions like Miscellaneous Receipts or WIP transactions

Details & Registration: Doc ID 1290983.1

Wednesday Aug 27, 2014

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.  

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.

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

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.

Friday Mar 21, 2014

Purging Order Management Workflow

For maintaining a healthy workflow environment, the "Purge Order Management Workflow" concurrent request should be scheduled regularly. 

Purge Order Management Workflow Concurrent Program purges workflow items associated with Oracle Order Management, such as OM Order Line and OM Order Header. Unlike the Purge Obsolete Workflow Runtime Data program provided by Oracle Workflow, the Purge Order Management Workflow program purges workflows of closed sales order lines even if the sales order header is still open. It tries to close open workflows in a few very specific cases to make more workflow items eligible for purge. Use this purge program to reduce the size of workflow tables and improve high volume order processing performance.

Information on the use of "Purge Order Management Workflow" concurrent program, to purge closed workflows, specific to Order Management can be found in document: How To Purge Order Management Workflow, Doc ID 878032.1.

Friday Mar 07, 2014

Three New Order Management Diagnostic Tests

Three new Order Management Diagnostic Tests available for 12.1.1+ via Patch 18013753 (Please visit E-Business Patching (MOSC) to request the initial password to download).

The Apps Check Diagnostic is now available via the Oracle Diagnostic Framework.  This is the same as what is executed from the Concurrent Program.  Executing the Diagnostic Test via the Diagnostic Framework 'Applications Diagnostics > Diagnose' offers a user friendly execution experience and HTML output that is validated and can be directly uploaded to a Service Request.  Please see Doc ID 1631911.1 for details.

Duplicate Lines From OE Drop Ship Sources, is new to the Diagnostic Framework.  This Diagnostic Test selects all duplicate lines from OE Drop Ship sources table.  Please see Doc ID 1632022.1 for details.

RMA Lines Stuck At Awaiting Return Or Disposition, is new to the Diagnostic Framework.  This Diagnostic Test selects all the RMA lines that are stuck at Awaiting Return or Awaiting Return Disposition status, even after the order lines had been fully received and fully or partially delivered.  Please see Doc ID 1632024.1 for details.

Thursday Jan 23, 2014

Order Information Portal (OIP) Enhancements

In Release 12.2, Order Information Portal (OIP) has been enhanced.  These enhancements are in the following areas:

Several search parameters have been added to allow more search criteria. Customer Number has been added to the Simple Search. Customer Number, Invoice Number, Orders On Hold (Yes/No), Ship To Customer, Bill To Customer, and Deliver To Customer have been added to the Advanced Search.

Previously, only contacts associated with the Sold To Customer on the sales order could view and track sales orders through OIP. Now OIP has been enhanced to allow contacts associated with the Bill To Customer on the sales order to view and track sales orders through OIP.

Several display fields have been added to the summary and detail views of the sales order and delivery.

External users can subscribe to receive notifications based on key business events such as scheduling, schedule date changes, and shipping. In addition, external users can choose to receive notifications individually in their Notifications Worklist for each sales order or consolidated across sales orders by setting up preferences in Workflow mailer.

OIP has been integrated with FND Security to enable rules-based access to the summary and detail views of sales orders and deliveries.

For more information regarding the enhancements made to Order Information Portal in Release 12.2, please refer to the Oracle Order Management Release Notes for Release 12.2.2, Doc ID 1377743.1.

Wednesday Dec 18, 2013

Use Approvals Management Engine for Approval Mechanism of Order Lines

In R12.2.2, Order Management integrates with Oracle Approval Management (AME) to leverage the robust capabilities of the approval rules engine to dynamically determine the list of approvers for Quotes, Sales Agreements and Returns (RMA). Order Management has been integrated with Oracle Approval Management for the workflow "Negotiation Flow - Generic with Approval" and "Order Flow - Mixed or Return with Approval" to provide an additional option to use Approvals Management Engine (AME) for the approval mechanism of order lines with the above work flows.

You can enable this option by selecting the Use Approvals Management Engine check box on the Order Management Transaction Types window. For the AME enabled transactions, Order Management utilizes the AME capabilities of a central business rules repository and a common execution engine, to manage approvals for its business processes.

AME repository has been enhanced to include certain OM specific attributes on which rules can be defined. Such seeded attributes are:

  • Header Level - Customer (Sold To Customer), Customer Category (of Sold To Customer), Order Type and Ordered Amount
  • Line level - Line Type, Item, Quantity, Line Amount and Line Discount Percent

Key benefits of this integration are:
  • You can use seeded as well as custom attributes to create AME conditions and rules.
  • AME dynamically determines the list of approvers based on conditions and rules.
  • You can define the approval process with Serial or Parallel Approvals. In the case of Parallel Approvals, additional options such as “First Responder Wins” and ”Consensus” are available to choose from when defining the approval rules.
  • With this new feature, Order Management leverages AME to dynamically generate the list of approvers based on attribute values, conditions, approval types and approval group.
  • In addition, centralizing storage of approval policies in AME improves audit and accountability. Moreover, the new capabilities can be rapidly and easily implemented in AME.

For additional R12.2.2 new features, please review Oracle Order Management Release Notes for Release 12.2.2 (Doc ID 1377743.1)

Tuesday Nov 12, 2013

OM: Effective Troubleshooting Techniques to Debug Order Import


There is a new document available to help you debug Order Import in Order Management: 
Effective Troubleshooting Techniques to Debug Order Import Issues (Doc ID 1558196.1)

The white paper addresses debugging from a technical perspective. This approach is to assist users in understanding the actual issue, as well as help them in the early resolution of any order import issue.

It will walk you through several cases, with supporting debug logs / trace files taken for each case. Educating you along the way for what debug logs / trace files should be gathered, as trace files are not always needed.  It will also walk you through the supporting documents so you will know what to look for in your case.

Please refer to this note the next time you have an Order Import error. Or you could step through it now, so you are informed the next time you encounter an Order Import error.  Happy debugging!


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



« December 2015