Thursday Jun 23, 2016

Get The API (De)bugs Out!

Hey all you Inventory, Product Hub, Engineering, Bills of Material, Work in Process, Warehouse Management et el. people! Most of you are probably already familiar with the basic techniques to create database level trace files (Doc ID 141278.1), and application level debugging files (Doc ID 148651.1), using the tools available directly in the EBS applications. These are highly useful in diagnosing behind-the-scenes code and data issues.

As EBS products have evolved, Oracle has made many Application Programmer Interfaces (APIs) available for general use by the Oracle User community. Wouldn't it be tremendously helpful if you could trace/debug your own API work as you develop code based on the APIs? Well we're here to let you know, you can!

Check out My Oracle Support (MOS) document, How to Enable Trace or Debug for APIs executed as SQL Script Outside of the Applications ? [Video] (Doc ID 869386.1), to see short, complete details on using trace and debug techniques at a SQL command line or in a SQL*Developer session. Both techniques are quite simple to use and very effective tools for helping you to figure out where your code is getting stuck, or why it is returning unexpected results.

With these techniques you may be able to resolve complex error situations without asking Support to assist you (which we will gladly do, of course -- especially if you're really stuck.)

Doc ID 869386.1, includes video demonstrations on these techniques, like:

Doc ID 869386.1 has become one of the most-reviewed documents in our EBS Manufacturing Inventory space. We are certain you'll find this useful. Happy coding, tracing, and debugging!!!

Wednesday Jun 08, 2016

MOS Slow? MOS Connectivity Issues? There's An Option

So, one of our goals in Support is to keep My Oracle Support (MOS) always running smoothly. In those very rare times there is a problem with MOS, we do have a backup plan. MOS has an backup system for customers to access some of what we call MOS "Lite" features, to search and use the Knowledge Management (KM) system. KM Lite allows access to knowledge documents and searches. Save this URL in case you need it and give it a try:

* My Oracle Support Lite URL:

For inventory issues, you probably have many of your favorite documents setup but these are a few to keep in mind when diagnosing new issues with limited access to service requests. You would look for Service Request Data Collection (SRDC) documents like the following:

* SRDC - Data Collection For Inventory Items (Doc ID 1933242.1)
* SRDC - Data Collection For Inventory Stuck Transactions (Doc ID 1672424.1)
* SRDC - Stuck Transactions Focused on Internal/Sales Order (Doc ID 1672391.1)

There are also alternate systems available for sending files. Read more in these articles:

* How do I access Oracle's SFTP server? (Doc ID 549180.1).
* How to Send a File to Oracle Support Using SFTP ( (Doc ID 464666.1).

Read more about MOS features in the My Oracle Support Resource Center (Doc ID 873313.1). You could also keep this link for support contact details:

Wednesday Apr 27, 2016

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.

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

Friday Mar 18, 2016

Return Material To Vendors Using R12.2's New Functionality

In R12.2, now you can return material to vendors from any Organization (org). The new enhanced functionality allows users to do the following:
• Create a return order for returned lines.
• Return material to vendors from any Organization.
– For example, If an item is received in org M1 and is moved to org M2, it can be returned to the supplier from M2 itself. In the Returns form, the user can enter the receipt org as M1 and enter the original receipt number of org M1. User will be shown receipt details of org M1 and he can return the material from M2 itself.
• Users will be able to create returns without referencing a PO or receipt i.e. return against no document.
–E.g. user can return a damaged hard drive of a laptop to the vendor even though the original PO was created for the laptop. Users will need to enter the item, quantity, supplier and other details in receipt form.

Note: This functionality is available only from R12.2 above and will not be backported to prior versions.

The simple data flow model:

To learn more about this new functionality, you can review the functional Webcast recording found in the Logistics Community: Advisor Webcast Questions? "Release 12.2 Return to Vendor with Shipping Integration" on February 24th 2016.

You can also view the Webcast information from document:
Document for this webcast: Enhanced Return to Vendor Process in R12.2.2+ (Doc ID 2109517.1)

Happy return's, and don't forget to keep an eye on our Webcast series:

  • Oracle Inventory, Product Information Management and Warehouse Management Teams Informational Webcasts (Doc ID 1290983.1)

Thursday Mar 03, 2016

Upgrade BOM's With Confidence

Upgrading from 11i to R12 and you use Bill of Material's (BOM's)? Strike before you upgrade to avoid known errors related to duplicate BOM's. In later versions of 11.5.10, index BOM_STRUCTURES_B_U1 was added to prevent the ability to create duplicate BOM's. Great, right? Yes, very great, except in a case where you are upgrading to R12 and you haven't checked for and removed old duplicate BOM's, before or if index BOM_STRUCTURES_B_U1 was added. If you have duplicate BOM's, upgrade processes such as the one offered in Doc ID 1082375.1, will fail. You can get ahead of this issue by using note, Find Two Bills of Material (BOM) for the Same Item (BOMFDBOM) leading to ORA-01427 or SQL-02112 error (Doc ID 370841.1).

Duplicate BOM's not only can cause errors while upgrading, they can cause different issues in your system and affect resources. Use Doc ID 370841.1 to help check for duplicate BOM's and let's make sure duplicate BOM's don't throw a wrench into your upgrade.

Friday Feb 05, 2016

Mobile Apps and MSCA – A Tale Of Two Products

Have you heard the terms Mobile Applications (Apps) and Mobile Supply Chain Applications (MSCA)? Confused? Let's try to add some clarity.

Technology brings us great benefits, but for some people benefits are not obvious until they are explained or demonstrated. To do this well often requires specialized, discipline-specific vocabulary (the word “ray” means something different to an astronomer [think gamma ray, ray of sunlight] than it does to a marine biologist [manta ray? sting ray?])

The “Oracle discipline” is no exception - In Inventory we work with two different Products with the term "Mobile" in their names; Mobile Apps and Mobile Supply Chain Apps. People have been known to casually refer to either one as “the Mobile”, which obviously can cause some confusion. We recommend an excellent document to clear up the confusion: What Is The Difference Bewteen Mobile Applications and Mobile Supply Chain Applications (MSCA)? (Doc ID 2103922.1)

Mobile Apps

Mobile Apps


Whether you're a Mobile Apps User, a MSCA User, or both, it's important to know the distinction between the Product names. Hopefully Doc ID 2103922.1 helps clear things up, and happy mobiling!

Thursday Jan 21, 2016

Add An Idea And Get Your ER's Moving

Back in our November 2014 post, we posted our first Blog on the the Enhancement Request (ER) process move to Community Ideas. We thought it might be time to revisit this important subject.

As a refresher, the Idea process has replaced the old ER Process. In the new Idea process, you no longer need to create a Service Request (SR) with the corresponding Product group for an ER, you create your own Idea directly in the Product community. Then you and anyone in the Community can vote on and/or discuss your Idea.

Benefits of the new process? You have the ability to create, manage, and vote on your own Idea. You can discuss and expand on your Idea in threads with other Community Users (which includes Oracle Development and EBS Product Management). You can see the progress that your Idea is making through votes and discussion threads. You can view, vote on, and discuss all other existing Idea's. You can filter Ideas by many different options, including 'Delivered' Ideas. And best of all, you can easily monitor where your Idea stands.

How does it work? To get to existing Ideas, go to the Logistics or Inventory Items (APC/PLM/PIM) Communities, navigate: Content > Ideas (tab). To create an Idea, click on: Create an idea.

You can create an Idea with any information that suits you. We suggest that you be as detailed as possible and provide your product release, screenshots or video's (if applicable), define your business process (including industry benefits), feature gaps, and the overall benefits of the Idea. Remember, this is your opportunity to provide information on why you would like your Idea implemented and how it would benefit others. Your stumping for votes.

The new Idea ability in Communities is the quickest way to get your ideas directly in front of Oracle Development. Top voted ideas float to the top and certainly draw more attention. As always, Oracle puts you, the Customer, in the forefront. Moving ER's to Communities Ideas now gives you the power over your ER's. Please help us in tracking features that are important to you. Also, for more information on ER's to Communities, see note Oracle E-Business Suite Product Enhancement Request to My Oracle Support Community FAQ (Doc ID 1584210.1).

Thursday Jan 07, 2016

Too Many Decimals? Round And Round

Occasionally, Inventory Support runs into confusion over how the E-Business Suite (EBS) handles decimal places for transaction quantities. An example is that the Work In Process (WIP) Product allows 6 decimals places versus the Inventory Product, which allows 5 decimal places. This is a known limitation that the applications handle by rounding quantities.

In a normal Inventory transaction, the rounding is taken care of immediately, so rounding does not usually cause confusion. If for example, you entered a quantity .000006 in a Miscellaneous Receipt, then the system will round the quantity to .00001. The system rounds using the "ROUND" function to 5 decimals. As a result, 1 through 4 will round down and 5 thru 9 will round up. If for example we try to receive .000004, this would round down to 0 which is not a valid transaction quantity and would raise an error.

Here is an example in Inventory where the application rounds down. The user had entered the Quantity of .000004 (six decimal places) and received the following message:

Here is an example where the system rounds down to 0 and raises an error:

In WIP, the examples can be more complicated. The WIP forms often will help the user avoid issues. For example, you would not be able to issue .000004 because it would round to 0 in inventory. The WIP Completion and Issue forms should stop the user from entering this quantity. The user though could enter .000005 and greater as this rounds up to .00001, not zero. If we build a job for .000006. We assemble the job and look at the Inventory transactions. In Inventory, we see the assembly quantity .000006 rounded to .00001.

Would you like to see this changed? You have the power by voting in the long standing Idea (Enhancement Request) where you can discuss and vote on an enhancement:

Rounding is something you may want to be aware of in EBS. You can find more information in documents:
Inventory and Work in Process Round Decimal Quantities Differently (Doc ID 793356.1)
What is the Restriction of Decimal Precision for Receiving Forms in 11.5.10 and R12? (Doc ID 736699.1)

Thursday Dec 03, 2015

Time To Resolution Reduced!

In EBS Inventory Support, we offer many avenues to help you get quick solutions. One important avenue is the My Oracle Support (MOS) Knowledge Management database to help you search and quickly solve issues. Another avenue is to log a Service Request (SR). In order to help to reduce your SR time to resolution (TTR), we are proud to announce the release of new Problem Types for the Inventory Product.

Problem Types allow you to categorize your SR issue in order to direct it to the correct Support Team and Subject Matter Expert. We have expanded the Inventory Problem Types in areas like Inventory Transactions, in order to give you an ability to log a more detailed SR for an area like 'Transactions Setup'.

Along with the new Problem Types, we have also automated Inventory SR's in order to request important diagnostic information up front, in order to speed up the TTR. This will help you get your solutions faster.

Oracle Inventory Support offers many different paths to solutions for your issues. Don't forget all the quick easy solutions in the Logistics and Inventory Items (APC/PLM/PIM) Communities, or the searchable Knowledge Management documents in the MOS Knowledge base. And if you need to log a SR, the new Inventory Problem Types will help to better define your issue and reduce your SR TTR.

Thursday Nov 19, 2015

Try Our New Inventory Transactions Analyzer!

Back in our early November 2015 post, we announced the release of the EBS Inventory Consignment Analyzer Doc ID 2048039.1. The Inventory Social Media Team is now excited to announce the release of the EBS Inventory Transactions Analyzer Doc ID 1499475.1.

You may be familiar with Doc ID 1499475.1, it used to offer the Inventory Analyzer. The Inventory Support Team upgraded the Inventory Analyzer to the new Transactions Analyzer to offer a more transactions specific focus.

The new Transactions Analyzer provides the same Inventory patch level checks and Inventory Administration information as the Inventory Analyzer, but it then takes transactions solution capabilities to a different level. It provides a snapshot of your current transactions tables in the 'Transactions Summary' section, then provides definitive solutions to known data issues in the 'Common Data Issues' section.

All of our EBS Analyzers are Support Tools designed to help Customers find quick solutions. We hope you take advantage of the EBS Inventory Transactions Analyzer as another tool to help manage and prevent roadblocks for transactions processing. By the way, don't forget to provide Feedback using the Feedback button at the bottom of Doc ID 1499475.1. We welcome suggestions for improving the Transactions Analyzer. Here's to using the Transactions Analyzer and successful transactions processing!

Wednesday Nov 04, 2015

Checkout the Brand New Consignment Analyzer!

The Inventory Social Media Team is proud to announce the release of the 'EBS Inventory Consignment Analyzer'. The EBS Conignment Analyzer is the first tool offered by Oracle Inventory Support to deal specifically with Inventory Consignment issues. Check out note - EBS Inventory Consignment Analyzer (Doc ID 2048039.1).

Use the EBS Inventory Consignment Analyzer to review Inventory consignment related set-up, consignment proactive recommendations, consignment processing, and to help diagnose known consignment issues.

The EBS Inventory Consignment Analyzer is an all-in-one tool to help get ahead of known issues, or just to maintain your consignment health. If you use the Consignment functionality, the EBS Consignment Analyzer will be an indispensable tool to help manage your Inventory. By the way, don't forget to give us Feedback (at the bottom of Doc ID 2048039.1) on the analyzer, and let us know what you like and where you would like to see enhancements

Monday Oct 26, 2015

Have You Seen 'Allow Cross Project for Pick Wave Allocation'?

Are you on EBS 12.1.3 or above? Do you use Project Manufacturing (PJM)? If yes, you already have the options to 'Allow Cross Project Issues' and 'Allow Cross Unit Number Issues'. Now you can also choose to select the 'Allow Cross Project Pick Wave' in the Project Manufacturing Parameters window. This will enable cross project sales order or internal order pick wave allocation.

With the enhancement, you can still 'Allow Cross Project Issues' to other move order types and transactions (WIP jobs, etc), but Users now also have the ability to decide whether to allow cross project issue based on the move order type – pick wave or others.

For more information on the the patches required to get the enhancement, and the enhancement itself, see notes:
*PJM - R12 - Pick Release Unexpectedly Allocating Common or Different Project Stock For Hard Pegging Items (Doc ID 1613522.1)
*PJM - R12 - Pick Release Failing to Allocate Project Sales Orders After Applying Inventory Management Rollup Patch (Doc ID 1613656.1)
*Oracle Project Manufacturing Release Notes for Release 12.2.4 (Doc ID 1912375.1)

Sunday Oct 11, 2015

Clean Your Supply/Demand

So you noticed that there is inconsistent data in the Supply/Demand form (INVDVDSD) for a specific item/organization? No need to worry. We have some suggestions that may clear things up.

First, check out note, INVDVDSD - Troubleshooting Issues With The Inventory Supply/Demand Form (Doc ID 286755.1). Then download script 'INVDVDSD_data_check.sql' and run it in sqlplus for the item and organization.

After running 'INVDVDSD_data_check.sql', review the output for data corruption or issues for your specific item/organization. The script output will show different areas that that may need clean-up.

You can also further troubleshoot Supply/Demand by using note, Troubleshooting the Item Supply/Demand Form (Doc ID 404459.1).

As always, use Support tools and diagnostics to help keep you data sparkling clean.

Friday Sep 25, 2015

Finally Eliminate Those Duplicate WIP Transactions!

Back in our June 29th, 2015 Inventory Blog post, we discussed Doc ID 1073279.1 dealing with duplicate Work in Process (WIP) transactions issues. We have an update! The Inventory Social Media Team is happy to announce that Oracle Development has just released a root cause fix to resolve duplicate WIP transactions. See the 'Root Cause Analysis' section of note, Duplicate Pending (MMTT) WIP : How To Verify If Pending WIP Completion And Issue Transactions In MMTT Are Duplicates Or Not (Before Resubmitting Or Deleting) (Doc ID 1073279.1).

The root cause fix adds a profile option to allow or deny repeated submission of WIP transactions processed through mobile apps or forms, in background mode, if pending transactions exist for a WIP job. Get full details from Doc ID 1073279.1.

Need more information on diagnosing WIP transaction issues? Check out the recording of the Advisor Webcast Questions? "Solving Issues with the Work In Process (WIP) Job Diagnostics", from the Logistics Communities. Also don't forget that all Inventory Webinar's are available in Doc ID 1290983.1 and all EBS wide Webinar's are at Doc ID 1455369.1.

Follow the directions in Doc ID 1073279.1 and let's end those duplicate WIP transactions!

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