R12.2 : custom schema registration : ADZDREG.sql or fnd_oracle_user_pkg.load row
Hello ,
We are upgrading from 11i to R12.2.7 . Before enabling online patching , adzdpsum.txt throws up un registered custom schema report and asks us to register the schemas. However , if we execute adzdpsum.sql , we get 2 different scripts to register custom schema.
sqlplus apps @$AD_TOP/patch/115/sql/ADZDREG.sql <system-pwd> <apps-user> XXXXXXX
or
exec fnd_oracle_user_pkg.load_row('XXXXXXX', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
Both of them work fine, Our question is , which is the correct script to execute?
Thanks
Ram