Updating Person Address Override Via Business Object Deletes The Row From Database in ETM (Doc ID 1111373.1)
Last updated on JUNE 23, 2010
Oracle Enterprise Taxation Management - Version: 2.2.0 and later [Release: and later ] Information in this document applies to any platform.
When using Scripts in updating the table CI_PER_ADDR_OVRD, which is a Child Table specified in every Business Object of the ‘Account’ Maintenance Object every row specified to be updated for CI_PER_ADDR_OVRD is being deleted. Person Address Override object is persisted in the table CI_PER_ADDR_OVRD. Because the row representation of Person Address Override for a certain Account Person is unexpectedly deleted in the database, it causes server errors when it is attempted to be retrieved.
Steps To Recreate 1.) Create a Script that retrieves a Business Object that has CI_PER_ADDR_OVRD as a child table and references it in its schema. 2.) In the same Script, invoke the same Business Object for update. 3.) Query in the database, if the same record for CI_PER_ADDR_OVRD still exists. 4.) Notice that the same records specified for update for CI_PER_ADDR_OVRD no longer exists
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms