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: https://support-lite.oracle.com

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 (sftp.oracle.com) (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: http://www.oracle.com/support/contact.html

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 twitter.com/Oracle_EBS.

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

MSCA



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: https://community.oracle.com/ideas/2485.

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!

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!

Tuesday Sep 08, 2015

Webcast: Solving Issues Using Work In Process (WIP) Job Diagnostics

Webcast_icon.jpgWebcast: Solving Issues Using Work In Process (WIP) Job Diagnostics


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


This one-hour advisor webcast is recommended for technical users and functional users who use E-Business Logistics, Inventory, and Work In Process. The presentation will provide a summary of various diagnostics available focusing on the WIP Job Diagnostic and related wipjob11i.sql. The presenters will walk through the differences between the various diagnostics and deciding which is the best for you to use. Key differences between the diagnostics will be provided then presenters will apply the diagnostics to demonstrate using them to resolve issues. References will be made to the WipJob11i.sql Doc ID 316142.1 and the Work Order Tests Doc ID 732341.1.

Topics will include:

  • Review of the various WIP diagnostics
  • Key differences between WIP diagnostics
  • Demonstration using WIP diagnostics
  • Using WIP diagnostics to solve issues

REGISTER.jpg
Details & Registration: Doc ID 1290983.1

Monday Jun 29, 2015

Continue Your Work In Process!

In the June 5th post, we discussed "Move Order On Down The Road!" about Pending Transactions related to move orders. Two of many other common Pending Transaction types is a Work In Process (WIP) Completion or a WIP Issue transaction. Pending WIP Completion and Issue transactions can be tricky if you have processing issues. In Support we have seen examples where WIP Completion or Issue transactions have been duplicated, hence creating duplicate WIP Pending Transactions that either won't process or create duplicate Material Transactions historical records. Particularly if the WIP Pending Transactions won't process, they could prevent period close, making them highly visible during month end processing. Don't fret; again The Inventory Social Media Team is here to guide you to a solution.

If you process a lot of WIP Completion and WIP Issue transactions, and you want to check for duplicates, a great place to start diagnosing is 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).



Doc ID 1073279.1 contains identification sql scripts, root cause analysis, and solution suggestions if you determine you have WIP duplicates. We would also suggest Doc ID 333572.1, which contains an attached Word document which provides details on how to review pending work order transactions; Diagnosing WIP Related Transaction and Data Issues (Doc ID 333572.1).

Duplicate WIP Completion or WIP Issue pending transactions can be tricky, but with the right tools you can turn a period close tsunami into a smooth sailing.

Friday Jun 05, 2015

Move Order On Down The Road!

Is it the end of the month and you are frightened about what you are going to find in your Pending Transactions form? You hesitate to check, but you click “Find” in Pending Transactions, and again there are weird “Allocated” move order lines that seem to happily just sit there. Didn't this happen last month? … Why, why, why won't these move orders resubmit from Pending Transactions!?!? The Inventory Social Media Team is again here with helpful tips to resolve pesky period close stoppers.

For Allocated Move Orders that don't seem to process, we recommend to bookmark note, How to Check the Move Order Status of Pending Transactions (Allocations) Show in Pending Transactions Form (Doc ID 1370430.1). Using Warehouse Management Systems (WMS)? Doc ID 1370430.1 has also got you covered.



Doc ID 1370430.1 will help you find and process Allocated Move Orders. Sometimes you see move order lines in a status 'Allocated' that cannot be processed in the Pending Transactions form. This is situation normal. Processing manual move order lines are as simple as clicking the “Transact” button in Transact Move Orders form.

You'll also see that there are rare examples that are not so ideal. There can be corrupted move order lines related to Closed or Cancelled Move Orders which require different actions. Doc ID 1370430.1 will guide you on how to proceed when data is corrupted, like when move order status is Closed, Cancelled, or Cancelled by Source.

Pending move order transactions do not need to be mysterious. Use Doc ID 1370430.1 and don't let Move Order Allocations roadblock your period close ever again.

Tuesday May 26, 2015

Transactions Resources, Resources, and More Resources

Do you import transactions into EBS Inventory using the Transactions Open Interface functionality? Inventory Support offers many resources to assist in resolving any issues that may occur. One resource the Inventory Social Media team recommends is the diagnostic in note, R12.0.6+ : Inventory Open Interface Transactions Transaction Data Test (Doc ID 732248.1). Want to see all R12 EBS diagnostics? Check out Doc ID 1083807.1. Still on 11i? Check out all the EBS diagnostics in Doc ID 179661.1.

Want more assistance than just a diagnostic? The Inventory Social Media Team is especially excited about the Analyzers being created across Oracle Support and EBS Products that offer warnings, recommendations, and solutions for your data and/or Product set-up. Check out note, Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1).



Existing Analyzers are currently being reformatted into our new and improved standards, so keep a look out for formatting improvements to existing Analyzers, and new Analyzer offerings. By the way, the Inventory Social Media team is particularly proud of the Inventory Analyzer (Doc ID 1499475.1) which has been previously discussed in this blog. So, be sure to use the many Support resources, and let's get those interface transactions processed!

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

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

Twitter

Search

Archives
« July 2016
SunMonTueWedThuFriSat
     
2
4
5
6
7
8
9
10
14
15
16
17
20
21
22
23
24
25
26
27
28
29
30
31
      
Today