Technical Discussion :: Oracle Apps HRMS
Home > Technical Interview Q&A > Oracle Apps HRMS > Discussion
94 / 106
What is Object version number and how do you assign values for it in an API?
Answer:
- Object Version number is an assigned number to a row in a database table.
- When a new row inserted its number is set to 1
- If any updates performed on the row then the Object version number is incremented.
- Every API has the p_object_version_number control parameters.
- For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts.
- For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory.
Asked In ::
Abhay Singh
23 Feb, 2019 5:07 AM
- Object Version number is an assigned number to a row in a database table.
- When a new row inserted its number is set to 1
- If any updates performed on the row then the Object version number is incremented.
- Every API has the p_object_version_number control parameters.
- For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts.
- For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory.