Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.3 : Patch 17865815 UK TYE - HRGENERAL2.OVN returns ora-01403 NO DATA FOUND

edited Jan 14, 2014 10:46PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Hi,
We are following note 1610646.1 to apply the UK TYE patch.

For the pre-patch mandatory step we need to set OVN on pay_balance_feeds_f but it is returning an error:

SQL> select count(*) from pay_balance_feeds_f where object_version_number is null;

COUNT(*)
----------
    1446


SQL> select owner, object_name, object_type from dba_objects
2  where object_name like '%PAY_BALANCE_FEEDS_F%'
3  /

OWNER      OBJECT_NAME               OBJECT_TYPE
---------- ------------------------- -------------------
HR         PAY_BALANCE_FEEDS_F       TABLE
HR         PAY_BALANCE_FEEDS_F_PK    INDEX
HR         PAY_BALANCE_FEEDS_F_UK2   INDEX
HR         PAY_BALANCE_FEEDS_F_N2    INDEX

Tagged:

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