AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch

Please follow below steps to overcome this issue

  1. Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG are 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.1 If application is up and running:

  1. As an application user with sysadmin rights Navigate to Security–>Oracle–>Register
  2. Search for schema user and change the Privilege to Enabled.
  3. Save and check value in the table.

2.2 If application is not available

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

commit;

  1. Update (if necessary) ENABLED_FLAG

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

commit;

  1. Re-test the issue
Recommended Posts

Start typing and press Enter to search