Who's Online Now
0 registered members (), 3 guests, and 17 spiders.
Key: Admin, Global Mod, Mod
Newest Members
SAI, Balasubramaniam, Dataterrain, Sarathy R, pjchiverton
1258 Registered Users
Recent Posts
Warning: VAT scam
by CT. 19/10/17 09:27 AM
EDI Replacement
by PaulD. 12/10/17 10:27 AM
Future dated records and API
by hpatel15. 10/10/17 08:04 AM
Faster Payments
by pat. 04/10/17 08:56 AM
Additional Org Info: Org Developer DF
by Sarathy R. 04/10/17 06:54 AM
Monthly Data Collection
by hpatel15. 28/09/17 07:33 AM
Top Posters(30 Days)
SBi 2
PaulD 2
CT 1
delboy 1
pat 1
Bobin 1
Popular Topics(Views)
417,709 PAYE RTI
49,884 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,285
bcooper Offline
bcooper  Offline


*****

Joined: Mar 2005
Posts: 1,285
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: 249
pat Offline
claiming squatters rights
pat  Offline
claiming squatters rights

Joined: Jun 2005
Posts: 249
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,086
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,086
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,250
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,250
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,250
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,250
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,086
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,086
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: 8
PaulD Offline
lurker
PaulD  Offline
lurker

Joined: Aug 2016
Posts: 8
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,086
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,086
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,250
delboy Offline
The Grand Daddy
delboy  Offline
The Grand Daddy
*****

Joined: Mar 2005
Posts: 1,250
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,086
CT Offline
CT  Offline

****

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


CT
Page 1 of 2 1 2

Moderated by  Administrator 

Forum Statistics
Forums48
Topics2,193
Posts11,868
Members1,258
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,086
bcooper 1,285
delboy 1,250
paulgos 431
SBi 425
Gus 252
pat 249
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.025s Queries: 16 (0.007s) Memory: 2.8074 MB (Peak: 3.0091 MB) Zlib disabled. Server Time: 2017-10-21 19:31:44 UTC