Who's Online Now
0 registered members (), 7 guests, and 11 spiders.
Key: Admin, Global Mod, Mod
Newest Members
SAI, Balasubramaniam, Dataterrain, Sarathy R, pjchiverton
1258 Registered Users
Recent Posts
EDI Replacement
by delboy. 11/12/17 11:45 AM
OTL Preference - Unable to add new preference
by Sarathy R. 06/12/17 04:25 AM
Replacement Product for HR Intelligence
by Sarathy R. 27/11/17 11:38 AM
Top Posters(30 Days)
delboy 3
CT 1
Popular Topics(Views)
426,914 PAYE RTI
50,821 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,087
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,087
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,087
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,087
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,087
CT Offline
CT  Offline

****

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


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

Joined: Mar 2005
Posts: 1,254
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
Forums48
Topics2,197
Posts11,879
Members1,259
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,087
bcooper 1,285
delboy 1,254
paulgos 431
SBi 425
Gus 252
pat 249
vkumar 223
December
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.020s Queries: 15 (0.005s) Memory: 2.7715 MB (Peak: 2.9475 MB) Zlib disabled. Server Time: 2017-12-15 06:18:40 UTC