Who's Online Now
0 registered members (), 2 guests, and 6 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Renuka, KavyaMurthy, Del, Bejoylin P, Shaqirre
1278 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
465,198 PAYE RTI
54,995 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#12043 - 18/09/17 12:18 PM Costing Proration  
Joined: Sep 2017
Posts: 6
Sarathy R Offline
lurker
Sarathy R  Offline
lurker

Joined: Sep 2017
Posts: 6
Dear All,

We have the following scenario in costing at Organization (Cost Centre) level.

Organization Cost Centre Information:

Organization A - XX.0010.XXXX
Organization B - XX.0020.XXXX

Employee Assignment Information:

01-Jan-2017 to 15-Jan-2017 (15 Days): Organization A
16-Jan-2017 to 31-Jan-2017 (16 Days): Organization B

Net Pay: 31000

Expected Results in Costing:

XX.0010.XXXX = 15000
XX.0020.XXXX = 16000

Actual Result in Costing:

XX.0020.XXXX = 31000

Requesting experts advice on this.

#12045 - 18/09/17 01:19 PM Re: Costing Proration [Re: Sarathy R]  
Joined: Mar 2005
Posts: 2,092
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,092
HI,

As far as I am aware, the costing is applied to run result values, which only exist for the effective date for the payroll run that created them - usually this will be the end of the pay period. So regardless of what proration took place, the costing will be applied according to the rules in place as at the end of the pay period.

Unless something has changed in R12.2.x ?

I am happy to be corrected, but it sounds like you need some sort of custom costing process to look back at the originating element entry for each run result and apply the rules in place at the effective start date of the change.


CT
#12046 - 19/09/17 04:11 AM Re: Costing Proration [Re: Sarathy R]  
Joined: Sep 2017
Posts: 6
Sarathy R Offline
lurker
Sarathy R  Offline
lurker

Joined: Sep 2017
Posts: 6
CT,

You're correct! cost allocation happening for the code combinations exists as of pay period end date. I've tested it in R12.2.4.

To my surprise, the same happening at employee assignment level costing as well which is date tracked! No clue what's the logic behind this particular date tracking.

Example,

Net Pay: 31000

01-Jan-2017 to 15-Jan-2017: 100% - Organization A i.e., XX.0010.XXXX
16-Jan-2017 to 31-Jan-2017: 100% - Organization B i.e., XX.0020.XXXX

Costing Result:

XX.0020.XXXX = 31000

It only works when assignment costing is set as follows. However, this involves manual calculation/effort and may not be suitable for large volume.

31-Jan-2017 - 48% - Organization A i.e., XX.0010.XXXX
31-Jan-2017 - 52% - Organization B i.e., XX.0020.XXXX

I think this is a big miss in Oracle costing process. Isn't it? In the above example, Organization B has to bear the costing for the entire month which employee had worked only for 16 days! Custom process for a basic concept/functionality makes me worried :-(

#12047 - 19/09/17 07:44 AM Re: Costing Proration [Re: Sarathy R]  
Joined: Mar 2005
Posts: 2,092
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,092
A very big miss - the best you can do for a solution from Oracle is to raise an enhancement request. I would warn you in advance that if you want to time their response, a calendar should be used in preference to a stop-watch.

I would be worried too at the prospect of customising - particularly when one considers the additional burden of retro-costing.


CT
#12048 - 19/09/17 08:27 AM Re: Costing Proration [Re: CT]  
Joined: Sep 2017
Posts: 6
Sarathy R Offline
lurker
Sarathy R  Offline
lurker

Joined: Sep 2017
Posts: 6
CT,

Sure! Thanks for sharing knowledge. Will take up this with internal team for further action.

Have a nice day :-)

#12049 - 19/09/17 08:52 AM Re: Costing Proration [Re: Sarathy R]  
Joined: Mar 2005
Posts: 2,092
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,092
You're welcome, good luck.


CT
#12050 - 20/09/17 12:21 PM Re: Costing Proration [Re: CT]  
Joined: Mar 2005
Posts: 1,287
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,287
Somewhere in South of England
Originally Posted by CT
A very big miss - the best you can do for a solution from Oracle is to raise an enhancement request. I would warn you in advance that if you want to time their response, a calendar should be used in preference to a stop-watch.


Should be a simple enough enhancement to cost at pro-ration end date instead of pay period end date.


Moderated by  CT, delboy 

Forum Statistics
Forums60
Topics2,211
Posts11,952
Members1,279
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,092
bcooper 1,289
delboy 1,287
paulgos 434
SBi 426
pat 254
Gus 252
vkumar 223
October
S M T W T F S
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
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.021s Queries: 15 (0.005s) Memory: 2.7769 MB (Peak: 2.9519 MB) Zlib disabled. Server Time: 2018-10-22 09:32:15 UTC