Technology Stack - EBS (MOSC)

MOSC Banner

R12.2 : custom schema registration : ADZDREG.sql or fnd_oracle_user_pkg.load row

edited Sep 9, 2019 11:27AM in Technology Stack - EBS (MOSC) 10 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center