Friday Jan 27, 2017

Ladies and Gentlemen...The Inventory Consignment Analyzer!

Consigned Inventory is a popular feature of the Oracle Inventory product – allowing you to keep track of material owned by third parties, but that you manage in your warehouses.

The Inventory Consignment Analyzer is a tool designed to review and report any consignment issues that may cause headaches, by recommending known consignment datafixes, code updates, and other guided assistance. It is a must use tool for Customers who use the Consignment functionality. We recommend that the analyzer be run pro-actively and regularly, to help you keep ahead of any consignment issues. And of course, the analyzer is the go-to tool when having any Consignment errors or issues. The analyzer is so convenient, you can even schedule it to run as a Concurrent Program (like any analyzer).

This Inventory Consignment Analyzer includes checks for:
- Several types of errors and known issues
- Invalid Database objects
- Unprocessed Consignment transactions
- Profile settings related to Consignment functions
- Outdated file versions

Have a look at note EBS Inventory Consignment Analyzer (Doc ID 2048039.1) to learn more (including sample output) and to download the Analyzer .

New to Analyzers? See them all in Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1) (Note: this is updated frequently as we create / update Analyzers across the EBS Product Lines). Also use Doc ID 1545562.1 to get information on the Bundle Menu Tool, where you download all EBS analyzers in a single download.

Wednesday Nov 23, 2016

You Have To See The New R12.2 Consignment Feature!

If you're not aware, there is a great new feature for R12.2 consignment users. You now have the option to transfer implicit consumption back to consigned.

The new feature makes using consignment easier and more flexible for everyone. When attempting a “Transfer to Consigned”, implicit transactions like miscellaneous issues become available allowing the user to select material returned via miscellaneous receipt.

The list of transactions to return back to consigned was updated to include implicit consumption:

Enjoy the new consignment flexibility. Want to learn more? Check out Webcast:
New R12.2.x Feature / Enhancement Request Implemented: Consumption To Consigned For Implicit Consumption (Doc ID 1938948.1)

Got questions on the feature or the Webcast? We'd like to hear from you in the Logistics Community thread:
Advisor Webcast Questions? "Consignment R12.2 New Features" On Aug 17th 2016

Friday Nov 04, 2016

Relinking Saves The Day!

For this post, we've got a great tip that can help when patching any EBS module. During patching, modules can get out of sync and require rebuilding. This is done with relinking. Imagine after patching that suddenly the Inventory Manager never completes. This could be a small problem and it could be because Inventory is out of sync with other modules. You can fix this by relinking. Check out document, Relinking Oracle Home FAQ (Frequently Asked Questions) (Doc ID 1467060.1)

Doc ID 1467060.1 gives full details on the who, what, how, and why of relinking. It's your one-stop resource. If you do any patching, we would certainly recommend to bookmark the document.

Learn about relinking, and add another resource that makes sure patching doesn't slow your business down.

Thursday Sep 15, 2016

A Smartphone App That Goes Beyond Cat Videos

We know your smartphone is a handy tool to watch the latest viral cat video on social media. How do we know? Because we watch them too. But did you know that you can also use EBS Mobile Supply Chain Applications (MSCA) or Mobile Warehouse Applications (MWA) on your smart phone? Check out note, Oracle Mobile Supply Chain Applications for Oracle E-Business Suite Release Notes (Doc ID 2108155.1). In Doc ID 2108155.1 you can find out information like:

If you're interested in installing the app (and why wouldn't you be), also take a look at note, Install Process for the Oracle Mobile Supply Chain Applications/MSCA/MWA on Mobile Apps for Oracle E-Business Suite Release (Doc ID 2163603.1).

Install MSCA on your smartphone now, and let's get some extra warehouse work done in between our social media laughs!

Friday Sep 02, 2016

Tag You're It - Try The New Serial Tagging Feature In Inventory

Have you seen the new Serial Tagging feature in Inventory? Check out, FAQ: Serial Tagging Assignment Feature (Doc ID 2168049.1).

Serial Tagging provides additional control by enabling serial tracking for non-serial controlled items (Items with ‘No serial control’ or ‘At Sales order Issue’) for specific transactions.  This satisfies the need to assign and track serial numbers for transactions rather than in Inventory.

As of release 12.2.2, transactions that can be serial tagged include WIP component issue, Field Service usage and Return to vendor.  

The new attributes for this setup are added to the Item master form as well as Product Hub Item Setup page. The feature helps in businesses where many items are not tracked when they are received or transferred within the organization. Such items are tracked only when they are transacted, such as a WIP issue or return, items that are returned to a vendor, or items that are recovered during task debriefing. Go back to playing tag, and take advantage of this new feature!

Thursday Jul 28, 2016

Get Your Physical Inventory Completed Faster

The Inventory Social Media Team is going to take a guess and say that completing your physical inventories might not be your favorite task. Manually entering physical inventory tag counts and approving the adjustments can be time consuming, and dare we say, monotonous. We are again happy to announce that there is another option to make processes easier on our EBS Customers. There are new application program interfaces (API's) to make processing your physical inventories easier. See document, How to use the Physical Inventory API in 12.2.5 (Doc ID 2161869.1)

Doc ID 2161869.1 provides full information on getting the new physical inventory API's as well as API set-up and usage information.

If you use the Physical Inventory functionality, take advantage and make your counting easier, and happy counting!

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)

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 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!

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



« February 2017