Updating Person Address Override Via Business Object Deletes The Row From Database in ETM

(Doc ID 1111373.1)

Last updated on JUNE 23, 2010

Applies to:

Oracle Enterprise Taxation Management - Version: 2.2.0 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms

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

Cause

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