Home » Applications » Oracle Fusion Apps & E-Business Suite » Mass Allocation
icon7.gif  Mass Allocation [message #167622] Fri, 14 April 2006 12:27 Go to next message
Shaggywillis
Messages: 8
Registered: September 2005
Location: Louisville
Junior Member
I am trying to build a mass allocation formula for the following:

Create a stat figure based on rev/comp of each office/dept (segment 2 and 3) outside of Oracle and then upload this value into oracle as a STAT account (segment 4). The problem is that the stat is four decimals which Oracle cuts off into two and with this, 3/4th of the office/dept combinations would equal zero. Other then multiplying and dividing out by 100, is there any way that Oracle will accept a four decimal stat to use for mass allocations?

Report message to a moderator

Re: Mass Allocation [message #167983 is a reply to message #167622] Tue, 18 April 2006 04:24 Go to previous message
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
Multiply all of the STAT values by 100. Then the sum of the values will be 100 times greater, so the calculations will still work.

Try it on paper first, if you want to prove it to yourself.

Cool HTH

David.

Report message to a moderator

Previous Topic: Checking status of financial standard report from Backend.
Next Topic: Invoice Approval Workflow
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 12:57:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.