My Oracle Support Banner

Updating Person Address Override Via Business Object Deletes The Row From Database in ETM (Doc ID 1111373.1)

Last updated on AUGUST 24, 2020

Applies to:

Oracle Public Sector Revenue Management - Version 2.2.0 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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.