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 Nov 19, 2015

Webcast: Make Your Day Easier With The New EBS Oracle Receivables Transaction & Adjustment Analyzers!

Webcast_icon.jpgMake Your Day Easier With The New EBS Oracle Receivables Transaction & Adjustment Analyzers!


Date: December 10, 2015 at 11 am ET, 8 am PT, 4 pm GMT, 9:30 pm India (Mumbai)


This one-hour Advisor Webcast is recommended for those handling Receivables Transaction or Adjustment issues. Join us to learn about the features and benefits of the new EBS Oracle Receivables Transaction Analyzer & EBS Oracle Receivables Adjustment Analyzer. These Analyzers scan your Receivables environment for areas of concern. Easy to read HTML output provides system setup and configurations, recommendations to resolve known and prevent future issues, and possible causes for unposted items and/or reconciliation issues.

Topics will include:

  • Analyzer overview
  • Features & Benefits
  • Live Demonstration

REGISTER.jpg
Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 10-Dec-15: Make Your Day Easier With The New EBS Oracle Receivables Transaction & Adjustment Analyzers!

Wednesday Oct 29, 2014

Webcast: Inventory Period Close - Stuck Transactions

Webcast_icon.jpgWebcast: Inventory Period Close - Stuck Transactions


Date: November 5th, 2014 at 1:00 pm ET, 12:00 pm CT, 11:00 am MT, 10:00 am PT, 6:00 pm, GMT Summer Time (London, GMT+01:00)


This one-hour session is recommended for technical and functional Users who want to learn more about the standard datafixes available for the Inventory Module. The Standard Datafix Note 568012.1 outlines over 2 dozen data issues and their solutions. Newly created content includes the datafix directly downloadable from Note for more rapid resolution. The new datafix notes include an identify script, root-cause patches check, backup script and datafix.

Topics will include:

  • Overview of Common Datafixes in Inventory
  • Most Common Data Issues
  • Applying Common Data Fixes
  • Avoiding the Issue in the Future with Root Cause Patches
  • A short live demonstration will walk thru an example data issue and fix

REGISTER.jpg
Details & Registration: Doc ID 1290983.1

Monday Aug 11, 2014

Receivables: Autoaccounting Analyzer now available

Oracle Receivables has just launched our latest Analyzer, the AutoAccounting Analyzer.  This new analyzer is a self-service health-check script that reviews the current configurations and settings for your AutoAccounting set-up and provides feedback and recommendations to address errors you are encountering.  Your data is NOT altered in any way when you run the Analyzer.  It does not perform INSERTS, UPDATES or DELETES.

So how does it work?  When creating a transaction via the Transaction Form or via AutoInvoice, and AutoAccounting raises errors, this Analyzer could assist you in identifying the cause and how to fix it.  This list shows sample error messages, you may get variations of the error messages below:

  • Please complete the offset account assignments
  • Please correct the receivables account assignment
  • Please correct the revenue account assignment
  • APP-AR-42536 This transaction is associated with at least one invalid or end-dated GL Account.

Currently the AutoAccounting Analyzer handles issues with the following AutoAccounting Types, values in () are what you would enter as p_account_type_in parameter when running the Analyzer:

  • Revenue (REV)
  • Receivable (REC)
  • Unearned Revenue (OFFSET)
  • Unbilled Receivable (OFFSET)
  • AutoInvoice Clearing (OFFSET)


How do you download and use this Analyzer?  The AutoAccounting Analyzer can be run via SQL*Plus or as a Concurrent Request.  For step by step details on how to download and run see DocID: 1904785.1 Oracle Receivables AutoAccounting Analyzer

The note includes two short videos on how to install the Analyzer as well as how to use the Output of the Analyzer.

Below is a small portion of the sample output.


Friday May 23, 2014

Troubleshooting Enterprise Asset Management Transactions

New whitepaper!!  The objectives of this white paper are to provide an overview of how to resolve pending or errored transaction issues in Enterprise Asset Management. This paper will cover the following topics:
  • Consider the type of transactions affected
  • Specify the tables involved
  • Look at resource transaction errors and consider the  cause, validate if there is a root cause solution and explain how to fix these errors (including datafixes).
  • Look at material transaction errors and consider the  cause, validate if there is a root cause solution and explain how to fix these errors (including datafixes).

You can download the whitepaper from Doc ID 1672312.1 Troubleshooting Stuck/Errored Transactions in Enterprise Asset Management.

Thursday Apr 03, 2014

Experience a Smoother Period Close with the Inventory Analyzer

Get immediate analysis and output of your EBS Inventory Application by using the Inventory Analyzer. The Inventory Analyzer script reviews the current Inventory rollup levels, confirms installation of critical and recommended patches, analyzes common data issues, reviews setups, and provides information on some specific performance issues.

Go to Inventory Analyzer : Health Check For Common Inventory Data Issues, Critical Patches, And Setups (Doc ID 1499475.1) for more details, the Inventory Analyzer script download, and a short overview video.

Inventory Analyzer Benefits:

* Immediate Analysis and Output of your Environment
* Identifies Inventory roll-up patch levels
* Identifies Missing Critical and Recommended Patches
* Discover existing Common Data Corruptions in your Environment

The Inventory Analyzer presents key details in an easy to read manner. For example, the analyzer gives a table with patches marked Missing (red) or Installed (white).

In a similar way, data issues are flagged as marked having a Data Issue (red) or Not (white).



Run the Inventory Analyzer on a regular basis to monitor the health of your Inventory Transactions and Application. The Inventory Analyzer can be a key tool to help identify and fix issues well before the end of your accounting period. Line yourself up for a quicker, smoother, Inventory period close, by using the Inventory Analyzer.

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
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today