Fixed Assets - EBS (MOSC)

MOSC Banner

FA_QUERY_BALANCES_PKG and Group Asset

edited Jul 21, 2010 10:50AM in Fixed Assets - EBS (MOSC) 3 commentsAnswered
Hi,

We are trying to use the fa_query_balances_pkg to get the nbv of assets. I am seeing expected values for all assets except when it is a group asset. Can anyone assist? We are using UOP method for our group assets. Always I am getting zero for the cost value. The below is the call details :

set serveroutput on
declare
  L_PERIOD_CTR   NUMBER;
 l_dist_id   NUMBER;
 l_period_name   VARCHAR2(20);
 l_deprn_method   VARCHAR2(10);
 l_salvage_value   NUMBER;
 L_COST    NUMBER;
 L_DEPRN_RSV   NUMBER;
 L_REVAL_RSV   NUMBER;
 L_YTD_DEPRN   NUMBER;
 L_YTD_REVAL_EXP   NUMBER;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center