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

Friday May 08, 2015

Data Solutions For Your Inventory Items

Does it seem that you sometimes experience what appears to be the same data issues when adding or updating Inventory Items? It's not happenstance. Oracle Product Information Management (PIM) Development and Support have identified certain data corruption scenario's that might be common to certain Inventory Item data. Development and Support have worked together to create, test, and approve Standard Datafixes (SDF's) that can be safely used by PIM and/or Inventory Items Customers, without logging a Service Request. Be sure to bookmark note, FAQ: Item And PIM (APC/PLM) Standard Datafixes (Doc ID 1295001.1).

The note references 7 data issues, identifies if error identification scripts are available for each, let's you know if each issue has a standard datafix and/or a root cause patch, and shows the Product versions covered. You can have confidence using the SDF's because they were thoroughly tested and have Oracle PIM Developments stamp-of-approval. Use the fixes in Doc ID 1295001.1 to limit down time, and let's get those Inventory Items ready for processing.

Wednesday May 06, 2015

Webcast: Understanding the Output of the Discrete Job Value Report

Webcast_icon.jpgUnderstanding the Output of the Discrete Job Value Report

Date: May 12, 2015 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 technical users, functional users, system administrators who are involved in analyzing the cost of Discrete Jobs.

Topics will include:

  • A description of the Discrete Job Value Report
  • Clarification of the different sections of the output of the Discrete Job Value Report
  • Things that could cause variance in a Job
  • An example of variance in a Discrete Job

Details & Registration:  Understanding the Output of the Discrete Job Value Report on May 12, 2015

Webcast: Demantra Certification. Are you attempting to get certified? Let's walk through the process!

Webcast_icon.jpgDemantra Certification. Are you attempting to get certified? Let's walk through the process!

Date: May 13, 2015 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 all who are considering the Demantra certification test. We will cover a number of topics to steer you in the correct direction for your study efforts leading to the actual test. I cannot guarantee that you will pass but we can make you aware of test topics.

Topics will include:

  • Collaborator Workbench
  • Worksheets
  • Analytical Engine
  • Simulation Engine
  • Forecast Tree
  • Business Modeler
  • Data Model
  • Workflow Manager and Workflows
  • Member Management
  • Chaining
  • Series
  • Levels
  • Methods
  • User Security
  • Main Data Tables
  • Modules (Components)
  • Oracle Database
  • Middleware/Client info
  • EBS Modules
  • JDE, Siebel and Legacy systems
  • Installation
  • Product Architecture
  • SQL Tools and Programming Language
  • Collections and Load Data

Details & Registration:  Demantra Certification. Are you attempting to get certified? Let's walk through the process! on May 13, 2015

Thursday Apr 30, 2015

Critical Update to the EBS Procurement Approvals Analyzer (Version 200.3)

Today we have released a new version of the EBS Procurement Approval Analyzer.  Its not that we want to keep you dba's busy but there were some critical updates that necessitated this change.

In the new version 200.3 we have modified for the following errors in the analyzer output.

Under the Approver checks:
- Error:This employee is not assigned to any active applications user.
- Error:This employee does not exist in the workflow tables (WF_USERS)
- Warning:There is a loop in the employee/supervisor hierarchy   

In the Document Manager Errors section:
-ORA-01403: no data found error in R12.2 in the "Document Manager Errors" section

Download version 200.3 today here!

Thursday Apr 23, 2015

So really why should I apply the March 2015 12.1.3: Procurement Family Update - Rollup Patch?

Well for one thing there have been great improvements to the Purchasing Document Open Interface (PDOI) for 12.1.3, but additionally check out all the improvements in the iProcurement, Sourcing, Purchasing and SLM areas, as listed below.  Scared applying these big rollup patches?  Well don't be! run the Patch Wizard and you'll most likely find that the impact to your system is far less.  Get all the information on this patch including a link to the patch wizard via Doc ID 1468883.1.

Feature Name Description


Requisition Update API

The Requisition Update API enables users to update multiple requisitions one at a time.  Using the Requisition Update API, users can update requisition information (such as header,lines, distributions) and can also add new lines to the requisition. Users can update incomplete and approved requisitions (provided the approved requisitions are not associated to a purchase order).

Autowrap for Requisition Description

The Requisition Line Details page enables you to enter a Requisition Description. You can enter a long description that will be autowrapped and will be easily readable, instead of your having to scroll to the left or right to see the requisition description.

Content Zone Enhancements

The categories or supplier columns in a Content Zone in iProcurement was previously limited. Users needed to define multiple content zones for this reason. This has now been extended and users can enter or define categories or suppliers in a single Content Zone.

Change Reason added to Change History page

When a Change Order is initiated, the Change History page displays a Reason column to enable the user to enter a reason for the changes made to the requisition.

Search Capability in Smart Forms

The iProcurement Catalog Administrator can search for one or more smart forms using the Search button for Smart Forms. The Search parameters are: Smart Form Name, Operating Unit, Item Type, Stores. The Add Another dropdown enables you to select other search criteria.

Returning Requisition Lines In the Demand Workbench (Oracle Purchasing), if a requisition has multiple lines and the buyer returns a requisition line, only that line is returned instead of the entire requisition. The remaining lines are available to autocreate purchase orders and are available in the Demand Workbench. The returned lines go back to iProcurement.
Reminder Notifications for Requisitions with AME setup The modified Approval Management Engine (AME) Approval process in the Requisition Approval Workflow enables you to send reminder notifications to approvers during the requisition approval process.
Contract Number Parsing in CXML Shopping Cart The system parses 3 new extrinsic elements  (buyerContractLineNumber, buyerContractNumber and  supplierContractNumber) to support the contract numbers in CXML. The supplier is able to send these details in the cXML during Punchout.(similar to the native XML format) so that this item gets linked to the contract in the requisition line created.


GBPAs and POs in Supplier Scheduling Supplier Scheduling enables viewing expected deliveries based on shipping schedules and planning schedules, for the standard purchase orders created that refer to Global Blanket Purchase Agreements (GBPAs).

ASL API Enhancements

The Approved Supplier List (ASL) API enables users to create, update, and delete approved supplier lists in bulk.

Using the API, users can create an ASL with details that include type, commodity, item details and key attributes such as supplier, site, operating unit, and manufacturer. Other ASL attributes that can be created include plan schedule, shipping schedule, delivery calendar, ASL capacity, and tolerance information.

Cancel Backing Requisitions from a Complex PO Users can select or unselect the Cancel Requisition option on the page, and re-create the demand if the backing requisition is not canceled.


Dynamic Questionnaire The Requirements section is used to gather information from the suppliers in a negotiation document. The Requirements section now has a hierarchy, where dependent requirements are included. Based on the supplier response, the subsequent question(s) change dynamically for the supplier. There is a two-level hierarchy of dependent questions for every questionnaire. The advantage is that no superfluous questions are asked of the supplier during the questionnaire. The questionnaire will come up with different question set combinations, depending on how the supplier responds in the initial question(s).
Create Negotiation: Supplier Page Enhancements

The Supplier tab in the Create Negotiation page has been enhanced with the following features:

  • ability to sort by supplier
  • ability to delete some or all suppliers
  • removal of duplicate suppliers when a reusable list is added to the supplier invitation list
Buyers can Edit Approved Negotiation Documents

Approved or Draft Negotiation documents can be edited by buyers.

Buyer's Manager can be Removed from Collaboration Team A buyer can delete his manager who was added to the collaboration team members. This removal can take place when the document has a status of Draft or is Published. Using the Manage Collaboration Team option, buyers can remove their managers from the negotiation approval process.

Supplier Lifecycle Management

Prequalification Template

During the supplier prequalification and registration process, buyers often find that they need to gather further information from the supplier. This can be due to incomplete entry of the registration form, outdated information, inadequate information given by suppliers, attaching a non-specific information gathering form for supplier responses by the buyer, etc.

The Supplier Registration page enables buyers to quickly scan the supplier responses. However, it is cumbersome for buyers to attach a prequalification template that is completely relevant to the supplier's profile. Additionally, only one template can be attached to the Supplier Registration process at a time. In order to address these issues, the buyer can now do the following:

  • The buyer administrator can link one or more questionnaire lists to a profile attribute. Questionnaire Lists are attached to Profile Attributes using the Profile Extension page.
  • When a supplier registers, the system will retrieve the appropriate questionnaire list based on the supplier attributes that are found in the supplier registration page, as part of the supplier responses.
  • The buyer can now select one or more questionnaire lists and send the selected lists to the supplier for gathering supplier responses and further information.
Streamline Supplier Registration Approval Process

With the streamlined supplier registration approval process, users can:

  • Ask suppliers to provide more information by selecting the Use the Supplier to Provide Details action in the actions drop down list in the Supplier Request Review page.
  • Use the New Supplier Registration Process page to register a new supplier. Three new buttons are available on this page: Cancel, Save and Continue, Send Invitation to Supplier. Users can click Save and Continue to save the supplier information and take the requester to the next page (New Supplier Request) where the user can enter additional information and select actions such as Register, Save, Cancel. Send Invitation to Supplier saves the information and sends an invitation notification to the supplier to register. The status of the request is now Supplier to Provide Details.
  • Enter profile attributes: Buyers and suppliers are required to enter User Defined Attributes (UDA).  When the requester selects the Send Invitation to Supplier action in the request review page, all the mandatory UDA attributes to be entered by the user are validated and appropriate errors message will be displayed to the requester in case he has missed any such UDA.
  • Send the Pre-Qualification Questionnaire: The user sends an invitation to register to the supplier. Then the Action Required: Please fill out the Supplier pre – qualification questionnaire notification is sent to the supplier.
Update Submitted Evaluation The system enables buyers to update previously submitted evaluations. Additionally, a warning message is sent to the evaluation team member who attempts to update an evaluation for an Assessment, for which the scoring is locked.
Also users can send email notifications to various stakeholders (including evaluation teams) using Online Discussions, so that the administrator can inform / remind the team members of important dates such as Lock Scoring Date, date of completion of Assessment, etc.
Oracle iSupplier Portal: Supplier Registration related Enhancements

The following enhancements are related to the supplier registration process:

  • The prospective supplier registration approval notification page displays status history and notification history. When the buyer approves or rejects a prospective supplier, the system notifies the supplier. If rejected, the system informs the supplier the reason for rejection, which is captured in Note to Supplier. In this scenario, rejection is permanent and cannot be revoked. If the administrator does not want to reject and would like to send it back to the supplier to update their request / enter additional information, administrators can use Return to Supplier after entering a note to the supplier.
  • As a buyer you can add a new approver or an FYI approver during the supplier registration process, using the Manage Approvals action. As a current approver you can also add a new approver or an FYI approver during the supplier registration approval process, using the Manage Approvals action. Both buyer and current approver need to note that they can only add a new approver or an FYI approver only after current approver group(s), and not before or between current approver group(s).
  • The Approval History link in the Supplier Profile page (Quick Update page), displays the supplier registration approval history. If there is no approval history for the supplier, an appropriate message displays to tell the user that no approval history has been found for the supplier. The Approval History page enables internal users to track the history of supplier records, such as who approved or rejected the supplier and when.
Oracle Supplier Lifecycle Management Enhancements

Several improvements have been made to the Supplier Lifecycle Management (SLM) user interface, functions and features. Key reasons for improving and enhancing the SLM product:

  • Ease of use for users and administrators
  • Removal of unrequired Sourcing flows and functions
  • Streamlining of SLM flows with simplified user interfaces and logical arrangement of tabs/sub-tabs/menus/functions

Major changes include:

1. Functionality changes: The Supplier Qualification and Evaluation menu is now removed from the Supplier Management Administrator/User responsibility. This menu enabled the user to navigate to the Sourcing home page, where the user could select the relevant option to create an RFI. Now, using the Supplier Management Administrator responsibility, the user can see the pages/regions belonging to the Supplier Qualification and Evaluation menu. This is visible to users by selecting the Supplier Home menu option that opens the Home page > Suppliers tab. The Home page now retain the existing features related to supplier search and supplier creation.

2. Nomenclature changes: New terminology introduced that is specific to SLM. Examples of such changes in all pages including notifications are:

  • Negotiation is now called Assessments
  • Requirements are now called Questions
  • Requirement Lists are now termed Questionnaires

Assessment creation now requires a template.

The Enable as Supplier button is available on the Supplier’s Home page.

The Register New Supplier button is available only if either iSupplier Portal is installed and/or Supplier Lifecycle Management is enabled.

Tuesday Apr 21, 2015

Webcast: Pick Release Move Order Related To OPM Production Batches

Webcast_icon.jpgWebcast: Pick Release Move Order Related To OPM Production Batches

Date: April 28, 2015 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 is recommended for technical users, functional users, system administrators, database administrators, and other users work with Project Manufacturing transaction types that need to be cost collected and passed to Projects. A focus will be on eligible and non eligible transaction types that might pass to Projects.

Registration: Webcast: Pick Release Move Order Related To OPM Production Batches

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

Whats New in the Procurement Approval Analyzer - Version 200.2

So you may be wondering why there has been a new version of the Procurement Approval Analyzer so soon?  Well version 200.2 contains fixes for the following  two issues:

  • Blank output was occurring when running the analyzer in 12.2 instances.  
  • Potential error with the Approval Management Engine (AME) enabled:

Error: ORA-06502: PL/SQL: numeric or value error: dbms_sql.describe_columns overflow, col_name_len=39. Use describe_columns2
Error in run_stored_sig procedure for sig_id: AME_ACTION_TYPES
Error: ORA-06531: Reference to uninitialized collection

Since the Analyzer is required output for logging Approvals Service Requests it was necessary to get this fix out quickly.

Questions or feedback?  Post your comments here.

Monday Apr 20, 2015

Webcast: Oracle Receivables Balance Forward Billing (BFB) Setup & Usage

Webcast_icon.jpgWebcast: Oracle Receivables Balance Forward Billing (BFB) Setup & Usage

Date: April 30, 2015 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 who want to learn about the Balance Forward Billing (BFB) features of Oracle Receivables from setup to printing. What is BFB, how is it setup and used? What is the difference between BFB and AR Statements? What tables are involved? Join us to get these answers and more!

Topics will include:

  • Patches for the latest BFB features
  • Required setups
  • Balance Forward Billing printing options
  • Related tables and diagnostics
  • Resolving commonly encountered BFB issues

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast On 30-Apr-15: Oracle Receivables Balance Forward Billing (BFB) Setup & Usage

SR Automation Explained

We have been working hard to improve our time to resolution on the Service Requests you raise by automating the information and diagnostic gathering step. 

A vast majority of Payables SRs will now automatically ask you to provide a specific set of files, depending on how you answer the questions we ask when you choose your problem type.  The system will provide you with a clear action plan shortly after the SR is submitted requesting files e.g screenshots, log files and diagnostic outputs. 

Automation will continue to ask you to provide any missing files, until all the needed files have been provided.  At that point, your assigned engineer will be in a position to begin reviewing your issue and analyzing your uploaded files, with the intention to get you your solution faster.

For more information about Automation and how it works please review the following document:

Automated Troubleshooting Process (Doc ID 1998077.1)

Friday Apr 17, 2015

Are You Considering Item Web Services for Oracle Product Hub?

Need information on the different item web services available for Oracle Product Hub? Yes? Then we bet your concerned about extracting Product Hub item and structure information because of the complexity of item attributes. Your probably especially concerned if you have a large number of user-defined attributes (UDA's). No Worries. The Inventory Social Media team will again be a beacon.

Oracle Product Hub provides web services for publishing and integration to other external systems, and the functionality has evolved over various releases (12.1.x and higher). It may be overwhelming to review the various options available and select what best suits your business requirements and still stay supported by Oracle. To help out, we suggest Doc ID 1931478.1 which provides a complete discussion on the various options available, tools required, terminology used, supportability moving forward, setup required, limitations and workarounds.

We would also suggest the following brown bags on available features:
OPH: Brownbag on Publication and WebServices [Video] (Doc ID 1613913.1)
PDH/EGO/PIM/OPH: Webinar on Publishing Metadata (Item Catalog Categories, Value Sets and Attribute Groups) from PDH to PDH Instances in R12.2 [Video] (Doc ID 1926970.1)

Keep in mind web services are also available for other publishing entities like Item Catalog Categories and Value Sets. Use the MOS notes like above and implementing item web services may be easier than you think. Cheers!

There's a New Tool in Oracle Payroll...it's the Payroll Dashboard!

A new tool has been delivered in Oracle Payroll, to help you get ready for and progress through your payroll processing. It's the Payroll Dashboard! 

Have you tried the Payroll Dashboard yet?  Have questions on the setup or functionality?  Read on!

Delivered last year in Release 12.1 HCM RUP7 and Release 12.2.4, the Payroll Dashboard provides payroll and assignment information at-a-glance, to assist Payroll Professionals with payroll readiness, analysis and validation for the entire payroll cycle.

The Payroll Dashboard also provides Payroll Administrators with payroll and assignment processing and monitoring tools.

For example, you can...

  • View Assignment Status details to rectify any data issues prior to kicking off the payroll compute cycle
  • Perform both seeded and custom Payroll Readiness checks
  • See a snapshot of payroll process counts and details
  • Monitor, rollback, or retry Payroll processes
  • View, rollback, or retry errored assignments
  • Analyze payrolls by comparing earning and/or deduction amounts between current and previous pay periods, to check for variances

To help you with this new functionality, Development has released a whitepaper:

The Oracle Payroll Dashboard: Setup and Usage - An Oracle EBS Development Whitepaper (Doc ID 1956751.1)
This whitepaper provides the steps to guide you through how to set up and use the Payroll Dashboard. It also provides some common issues and how to troubleshoot them.

So if you haven't done so already, go ahead and check out the Payroll Dashboard.  It may be just what you're looking for to help smooth out your payroll processing!

If you have questions on the Payroll Dashboard functionality, please log a new Service Request with the Oracle Payroll team.

Thursday Apr 16, 2015

Webcast: Enhancement Request to My Oracle Support Community

Webcast_icon.jpgWebcast: Enhancement Request to My Oracle Support Community

Date: April 23, 2015 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 is recommended for technical users, functional users, system administrators, and database administrators who would like to know more about the new E-Business Suite Enhancement Request to My Oracle Support Community Process. This session will cover the available communities offering the ability to log and Enhancement Request, and what you need to know about this new process.

Registration: Webcast: Enhancement Request to My Oracle Support Community

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

Tuesday Apr 14, 2015

OM Suite 12.1.3+ Recommended Patch Collections Now Available!

We are pleased to announce the release of E-Business Suite 12.1.3+ Recommended Patch Collection 3 (RPC3) Patch 20203366.

The following are the OM related patches included in this release:

  • Oracle Advanced Pricing Patch 19572462:R12.QP.B -- Advanced Pricing Recommended Patch Collection - September 2014
  • Oracle Advanced Pricing Patch 17761720:R12.QP.B -- This patch resolves the issue caused when PBH lines are created using the Shift+F6 functionality in both Price Lists and Modifier forms
  • Oracle Order Management Patch 20390490:R12.ONT.B -- Order Management 12.1 October 2014 Cumulative Patch
  • Oracle Shipping Execution Patch 18058537:R12.WSH.B -- Oracle Shipping Execution Recommended Patch Collection - January 2014. Refer to My Oracle Support Knowledge Document 1600845.1.

For more information, please refer to Oracle E-Business Suite 12.1.3+ Recommended Patch Collection 3 (RPC3) Document 1986065.1, published on My Oracle Support.

Monday Apr 13, 2015

A Brief Discussion of Globalization Profile Options

If you are setting up country-specific globalizations and you use custom responsibilities, then you may need to know about the profile options you would set upGlobe for a non-multi-org product such as Fixed Assets.  For each custom responsibility that uses windows with country-specific or regional features that belongs to a non-multi-org product, you must set the JG: Application, JG: Territory, and JG: Product profile options.  Note:  You do not need to set these profile options for multi-org products such as Payables and Receivables, which make use of the organization field.

These globalization profile options are:

  • JG: Application:

Used to determine which Oracle Applications product the responsibility is associated with.  The list of values for this profile option consists of a complete list of Oracle Applications products.

  • JG: Territory:

Used to determine which country the responsibility is associated with.  The list of values for this profile option consists of a list of countries.

  • JG: Product:

Used to determine which Global Financials product the responsibility is associated with.  The list of values for this profile option consists of a list of Global Financials products.

You will find additional information about globalization setups in the Oracle® Financials Country-Specific Installation Supplement.


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 2015