Home » Applications » Oracle Fusion Apps & E-Business Suite » Balance Dimensions for Supplemental Earnings
Balance Dimensions for Supplemental Earnings [message #328287] Thu, 19 June 2008 10:51 Go to next message
rbertrand
Messages: 45
Registered: November 2005
Member
hello,
I have a proc that gets balances. I use it to get 401k contribution balance and employer matching balance for a payroll run. Problem: it works fine for regular payroll run, but we have a earning element that is a bonus that creates a separate check. The employees with this element get picked up but have a zero 401k balance reported? This is what my proc looks like:

declare
p_contribution_amt number ;
begin
p_contribution_amt := Lgmc_Get_Balance_Value (
1520, --assignment id
'12-jun-08', --p_effective_date
'Def Comp 401K', --balance name
'Assignment within Government Reporting Entity Run' ) -- balance dimension ;
dbms_output.put_line('p_contribution_amt || p_contribution_amt) ;
end ;



If I change the balance dimension to:
'Assignment within Government Reporting Entity Pay Date' it gets the correct 401k balances for employees with bonus pay and without.

What is the difference in the two balance dimensions?
Re: Balance Dimensions for Supplemental Earnings [message #328290 is a reply to message #328287] Thu, 19 June 2008 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You didn't post formated
2/ What you post does not say anything of you actually do in your procedure

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Balance Dimensions for Supplemental Earnings [message #328296 is a reply to message #328287] Thu, 19 June 2008 12:35 Go to previous messageGo to next message
rbertrand
Messages: 45
Registered: November 2005
Member
hello,
I have a proc that gets balances. I use it to get 401k contribution balance and employer matching balance for a payroll run.

Problem: it works fine for regular payroll run, but we have an earning element that is a bonus that creates a separate check. The employees with this element get picked up but have a zero 401k balance reported? This is what my proc looks like:

declare
p_contribution_amt number ; 
begin
p_contribution_amt := Lgmc_Get_Balance_Value (
               1520, --assignment id
              '12-jun-08', --p_effective_date
              'Def Comp 401K', --balance name
              'Assignment within Government Reporting  
               Entity Run') --balance dimension

dbms_output.put_line('p_contribution_amt || p_contribution_amt) ; 
end ;



If I change the balance dimension to:
'Assignment within Government Reporting Entity Pay Date' it gets the correct 401k balances for employees with bonus pay and without.

What is the difference in the two balance dimensions?

Quote:

Re: Balance Dimensions for Supplemental Earnings [message #328298 is a reply to message #328287] Thu, 19 June 2008 12:41 Go to previous messageGo to next message
rbertrand
Messages: 45
Registered: November 2005
Member
I did format new entry.
Re: Balance Dimensions for Supplemental Earnings [message #328300 is a reply to message #328298] Thu, 19 June 2008 12:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
rbertrand wrote on Thu, 19 June 2008 10:41
I did format new entry.

why?
Is this not the same problem?
Re: Balance Dimensions for Supplemental Earnings [message #328302 is a reply to message #328300] Thu, 19 June 2008 12:47 Go to previous messageGo to next message
rbertrand
Messages: 45
Registered: November 2005
Member
I did new topic and formatted it per Michelle.
Re: Balance Dimensions for Supplemental Earnings [message #328304 is a reply to message #328302] Thu, 19 June 2008 12:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
rbertrand wrote on Thu, 19 June 2008 10:47
I did new topic and formatted it per Michelle.

1) Michel (guy) not Michelle (gal)
2) He did not state or suggest a new thread was needed
3) Since the question seems directly related to Oracle Apps., it might get more/better response if it gets moved to the Apps subforum.
Re: Balance Dimensions for Supplemental Earnings [message #328311 is a reply to message #328304] Thu, 19 June 2008 13:11 Go to previous message
rbertrand
Messages: 45
Registered: November 2005
Member
oops, sorry Michel. My apologies...
Previous Topic: Oracle iStore
Next Topic: Oracle AP IPV calculation
Goto Forum:
  


Current Time: Wed Jul 03 18:25:37 CDT 2024