Amt_metadata_t Table Has Incorrect Record 'Recycle_suspended_usage_t'

(Doc ID 1389458.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.
***Checked For Relevance on 16-Jan-2013***


In Account Migration Manager (AMM) installation, "amt_metadata_t" table has one incorrect record - one with table_name = 'recycle_suspended_usage_t'.

e.g. the entry from controller log file:

2 - 02/24/11 15:24:45:265 - exception: java.sql.SQLException: ORA-02055: distributed update operation failed; rollback required
ORA-00904: "ACCOUNT_OBJ_ID0": invalid identifier
ORA-06512: at "PIN08P.AMT_MV", line 351
ORA-06512: at line 1

There is an invalid entry to amt_metadata_t which causes the problem.

select table_name,srch_type from amt_metadata_t where table_name like 'recycle_suspended_usage_t' ;


query should give result like this:

workaround that can be used:
UPDATE amt_metadata_t
SET srch_type='P'
WHERE table_name='recycle_suspended_usage_t'


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