Amt_metadata_t Table Has Incorrect Record 'Recycle_suspended_usage_t'
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 188.8.131.52.0 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'.
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:
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