Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Merge - Change Capture and Print

RengudiDec 1 2022

Hi Guru,

Is there a method to print the values of insert, update, and remove before and after a MERGE statement has been executed?

If so, could you kindly give one example;

Thanks

Comments

HakanBiroglu
Hi,

Oracle is now a days delivering PeopleSoft in Revision Recuts.
After each Feature Pack the application is rereleased with all bundles and patches preinstalled until that feature pack.
During the course of an Application (normally 3 years), several PeopleTools release are released.
For example
FIN 9.1 was initially released with PeopleTools 8.50
FIN 9.1 FP1 recut is delivered at PeopleTools 8.51
FIN 9.1 FP2 recut is delivered at PeopleTools 8.52

So I can image that some steps in the template only apply of you are on PeopleTools 8.52.

I would advise to upgrade to FIN 9.1 FP2. You would then have all patches and bundles preinstalled by Oracle, this will save a lot of time and effort, but only if you are planning to run on PeopleTools 8.52.
Honza
Yes thank you Hakan, that's what I figured, it's just the "applies to" section is different in all of the homepage documents and I would expect them to be the same, or even further list all products ... anyhow, yes we will be using tools 8.52 and the latest patches, using FP2 and probably any other patches while at it.
1 - 2

Post Details

Added on Dec 1 2022
#plsql, #sql
2 comments
172 views