Who's Online Now
0 registered members (), 4 guests, and 5 spiders.
Key: Admin, Global Mod, Mod
Newest Members
nicolekristen, Raj@402, paulbenf, Samora, mahesh kumar
1246 Registered Users
Recent Posts
Gross to Net Summary Report
by delboy. 17/08/17 01:48 PM
11i or R12.1.x to R12.2.x Upgrade
by CT. 08/08/17 08:23 AM
R11.1.3 BACS Running slowly post TYE 17
by PaulD. 07/08/17 01:14 PM
Employment Intermediaries Changes
by CT. 02/08/17 06:54 AM
Shared Parental Leave
by SBi. 25/07/17 07:59 AM
Payroll Purge
by PaulD. 21/07/17 02:12 PM
So...(the IR35 discussion thread)
by PaulD. 21/07/17 09:47 AM
Top Posters(30 Days)
CT 6
PaulD 4
SBi 4
DanC 2
delboy 2
Popular Topics(Views)
406,675 PAYE RTI
48,758 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
Page 1 of 2 1 2
#11828 - 24/02/17 01:56 PM 11i or R12.1.x to R12.2.x Upgrade  
Joined: Mar 2005
Posts: 1,283
bcooper Offline
bcooper  Offline


*****

Joined: Mar 2005
Posts: 1,283
Earth, Europe, England, here
Anyone else actively working on an R11i or R12.1.x upgrade to R12.2.x?

Anyone willing to share any gotchas or war-stories?

Thanks in advance

Barry

#11943 - 04/07/17 12:26 PM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Jun 2005
Posts: 247
pat Offline
claiming squatters rights
pat  Offline
claiming squatters rights

Joined: Jun 2005
Posts: 247
Hardy's Way
This thread's been dormant for to long so I thought I'd try to get some idea on people's thoughts about migration paths.

As part of our Strategic Review we are starting to consider our migration options from R12.1 and Oracle's latest road map (https://blogs.oracle.com/ebs/exciting-update-to-the-oracle-e-business-suite-release-roadmap) has generated more questions than answers:

  • is it too early to move to HCM? Even though there appears to be a UK payroll I'm not convinced I'm ready for HCM!!!
  • with 12.1 Premier Support going through to Dec. 2021 is it worthwhile moving to 12.2 or should we wait and jump to 12.X?
  • looking ahead to the subsequent migration, from what I've heard migration from R12.2 to HCM is not a walk in the park - could it be that one feature of 12.X will be an easy (or at least easier) migration path to HCM?


Any thoughts from high level conspiracy theories down to actual observations as a result of migrating to 12.2 welcomed.

#11959 - 13/07/17 09:24 AM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Mar 2005
Posts: 2,074
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,074
Something that just surfaced here, and in not a pleasant way...

Apparently with 12.2, the payroll process does NOT create run results with null result values. So any custom code out there that wants to retrieve a result value, and doesn't cover itself for not finding a row at all, will give rise to some 'interesting' results!

Happy days.


CT
#11960 - 17/07/17 05:30 AM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Mar 2005
Posts: 1,237
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,237
Somewhere in South of England
I think it's available in 12.1 but you have to switch it on by running the 'Generic Upgrade Mechanism' concurrent process for, 'Enable Sparse Matrix Null Run Results Functionality'.

#11961 - 17/07/17 05:39 AM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Mar 2005
Posts: 1,237
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,237
Somewhere in South of England
See Oracle Note 1154523.1

#11962 - 17/07/17 06:25 AM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Mar 2005
Posts: 2,074
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,074
Thanks Del Boy. Here's the problem, though... I am led to believe that in 12.2 you don't get the choice to run this process - it goes with the territory! Not good for business when one has a myriad customisations that are wont to go looking for run result values and assuming that something will be there even if it's null...

I do rather feel that Messrs Oracle have missed a trick with not giving people the opportunity to decide for themselves whether or not their site should do this.

I feel a world of pain descending.


CT
#11971 - 24/07/17 09:55 AM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: CT]  
Joined: Aug 2016
Posts: 4
PaulD Offline
stranger
PaulD  Offline
stranger

Joined: Aug 2016
Posts: 4
Woking
I've been looking at ways of shrinking the HCM footprint prior to a cloud migration and there appears to be two separate but linked strands to the Oracle method of consolidating the pay_run_results and pay_run_result_values tables. These are the suppression of null results using Sparse Matrix Functionality (Note 1154523.1) and the suppression of insignificant result's done with setting 'SUPPRESS_INSIG_INDIRECTS' in table PAY_ACTION_PARAMETERS to 'Y', (Note 368723.1). There's also then a script to remove existing insignificant results.

The Sparse Matrix magic suppresses null values in the pay_run_result_values table, whilst the suppression of insignificant results will remove '0' or '0.0' run results in addition to null values. So in the latter's case if all the pay_run_result_values are insignificant then they AND the pay_run_results are deleted. In short the Sparse Matrix seems to be the less drastic little brother of the insignificant result suppression.

As CT points out, the Sparse Matrix is the default functionality in 12.2, it has to be explicitly enabled in 12.1. The suppression of insignificant results must also be explicitly added to all 12.x instances.

Has any tried to suppress insignificant run results, if so what was the outcome from this process? From my initial analysis of my clients tablespace it should result in clearing out half their run results value records. Any exciting if slightly worrying result! Obviously as an experienced developer all my run result queries currently handle no results being returned (cough) but is there anything else to consider in adopting this approach?

#11973 - 26/07/17 08:47 AM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Mar 2005
Posts: 2,074
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,074
Another interesting feature cropped up here yesterday, at this time we are not sure if it's as a result of the 12.2 patch or not, but worth checking out nonetheless:

If you are of a mind to make use of the P11D / Non-P11D element entry history taskflows, be aware that the seeded P11D/Non-P11D taskflow nodes appear to have been stripped of their customisation restrictions. These are ultimately implemented as element sets - which will still exist - however with the missing customisation restrictions, you'll see entries of all elements, not just the ones in the relevant element set.

If anyone on 12.2 can check their installation and see if they have the same issue, that would be useful.

Under UK HRMS Manager or UK Super HRMS Manager, go to Security -> Task Flow Nodes, and query the task flow name %P11D%. The customisation column is on the right side of the screen.


CT
#11974 - 31/07/17 02:02 PM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Mar 2005
Posts: 1,237
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,237
Somewhere in South of England
I seem to recall that it's a known bug, but I may be wrong.

#11980 - 02/08/17 07:02 AM Re: 11i or R12.1.x to R12.2.x Upgrade [Re: bcooper]  
Joined: Mar 2005
Posts: 2,074
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,074
Del Boy, you are never wrong! wink


CT
Page 1 of 2 1 2

Moderated by  Administrator 

Forum Statistics
Forums48
Topics2,177
Posts11,794
Members1,246
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,074
bcooper 1,283
delboy 1,237
paulgos 430
SBi 416
Gus 252
pat 247
vkumar 223
August
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.028s Queries: 16 (0.010s) Memory: 2.8088 MB (Peak: 3.0098 MB) Zlib disabled. Server Time: 2017-08-17 21:34:14 UTC