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)

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

Thursday Jul 23, 2015

Troubleshooting the Closing of Work Orders in EAM and WIP

New whitepaper!  The following topics are discussed in detail.

A brief overview about closing work orders. 

How to close work orders in EAM and WIP. This section looks at the different methods for closing work orders in EAM and WIP.

What happens when a work order is closed.  Looking at the differences in EAM and WIP in terms of closing work orders. This discusses the tables that  are updated and looks at variances in EAM and WIP and the GL postings that take place when a work order is closed.  It explains the different processes for both EAM and WIP.

Troubleshooting the closing of work orders. This section looks at the issues faced when closing work orders and how to resolve these issues.  There is an existing white paper for this : White Paper: Understanding Discrete Job Closure Process Doc ID 1902476.1. However this document is mainly around WIP and does not look at the differences between EAM and WIP. Also, the paper does not cover all the different methods of closing work orders in EAM and WIP. 

Download the Troubleshooting the Closing of Work Orders in EAM and WIP white paper from Doc ID 2035692.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.

Wednesday Feb 18, 2015

Webcast: Setup and Integration of Work in Process with Oracle Quality

Webcast_icon.jpgWebcast: Setup and Integration of Work in Process with Oracle Quality


Date: February 25, 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 who want to learn more about the setup and integration of Oracle Work In Process and Oracle Quality. During this one hour session you will create a collection plan, enable it for move transactions, create a discrete job, and perform the move transaction for the job by entering Quality results, reviewing the Quality results, Closing the work order and reviewing the material transactions. The summary will include additional resources related to this topic.

REGISTER.jpg
Registration: Webcast: Setup and Integration of Work in Process with Oracle Quality

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

Wednesday Jan 21, 2015

Webcast: Mastering Component Pick Release Process in Work in Process

Webcast_icon.jpgWebcast: Mastering Component Pick Release Process in Work in Process


Date: January 28, 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 and functional users who are operating with discrete jobs transactions and provides an overview of Component Picking in Work in Process and Parallel with Enterprise Asset management allocation process.

REGISTER.jpg
Registration: Webcast: Mastering Component Pick Release Process in Work in Process

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

Tuesday Jun 24, 2014

Webcast: Setup and Usage of Configure to Order (CTO) Business Flow in Sync with Work in Process

Webcast_icon.jpgWebcast: Setup and Usage of Configure to Order (CTO) Business Flow in Sync with Work in Process


Date: June 25, 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 Functional Users, Key Users, and Implementation Consultants, and will show During this presentation will show a complete setup of a CTO Model with options then how this model is being used to generate a CTO item. This webcast will also demonstrate how CTO item will be generating discrete jobs in Work in Process.

Topics will include:

  • define CTO Model
  • define CTO components
  • define Options, Bills of Material and Routing for the CTO Model
  • define Sales Order for the CTO Model
  • use the Oracle Configurator to generate the CTO Item
  • auto-generate WIP Discrete Job to fulfill the SO

REGISTER.jpg
Details & Registration: Doc ID 1670446.1

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
« May 2016
SunMonTueWedThuFriSat
1
3
7
8
9
11
13
14
15
17
18
19
21
22
23
26
28
29
30
31    
       
Today