APPS_DDL package issues in fs_clone

This blog is intended for DBA’s who have issues in completing fs_clone. We applied a critical patch for one of the client and afterwards executed fsclone, but it failed with the error message “Unable to get APPS_DDL package version from db <XXXX> <APPS_DDL> <PACKAGE>”.

I’ve outlined the solution and root cause of the problem below.

ISSUE:

While running fsclone we got the below error,

AutoPatch error:

Unable to get APPS_DDL package version from db <XXXX> <APPS_DDL> <PACKAGE>

AutoPatch error:

adpmrp: Error while installing apps_ddl packages.

CAUSE:

Settings (READ_ONLY_FLAG and ENABLED_FLAG) are not correct for users of custom schema XXXX.

SOLUTION:

Confirm that the value for READ_ONLY_FLAG and ENABLED_FLAG is not as expected by running:

select ORACLE_USERNAME, READ_ONLY_FLAG, ENABLED_FLAG, ORACLE_ID, INSTALL_GROUP_NUM, last_update_date from FND_ORACLE_USERID where ORACLE_USERNAME in (‘XXXX’);

Set values as expected :

============================

READ_ONLY_FLAG to ‘A’

ENABLED_FLAG to ‘N’

2.Update READ_ONLY_FLAG

update fnd_oracle_userid set read_only_flag=’A’ where oracle_username in (‘XXXX’);

commit;

3.Update (if necessary) ENABLED_FLAG

update fnd_oracle_userid set ENABLED_FLAG=’N’ where oracle_username in (‘XXXX’);

commit;

4.Re-test the issue

Venkateshwaran Govindaraj