Oracle-Developer.com Forums

[vj.jain]

Ran into this one during an 11.0.3 upgrade to R12

Oracle Human Resources - Version: 11.5.9
This problem can occur on any platform.
PERWSDOR 11.5.122
Symptoms
Getting errors when attempting to update a descriptive flexfield segment for the
descriptive flexfield titled "Add'l Org. Unit Details" which is accessed off the
Organization description form (PERWSDOR).

APP-PAY-07207: The mandatory argument object_version_number value cannot be null.
Cause: The mandatory argument object_version_number has either not been
specified or has been explicitly set to null in the API hr_oru_shd.lck.
Action: Either specify a value for the object_version_number argument which is
not null or contact your local support representative.
Changes
Navigation:

Work Structure--> Organization--> Description > Add'l Org. Unit Details (Descriptive Flexfield )
Cause
Object_version_number was null in hr_all_organization_units.
The value of object_version_number was not updated for existing records at the time of upgrading.
Fix
The supported workaround in the following script:

Run the following script to determine if you have any organization definitions where
select ORGANIZATION_ID, NAME, OBJECT_VERSION_NUMBER
from HR_ALL_ORGANIZATION_UNITS
where OBJECT_VERSION_NUMBER IS NULL;
If you have rows returned, run the following scripts. alter trigger HR_ALL_ORGANIZATION_UNITS_OVN disable;

update hr_all_organization_units
set object_version_number = 1
where object_version_number IS NULL;
commit;

alter trigger hr_all_organization_units_ovn enable; .