My Oracle Support Banner

Suspense Manager Not Working In Multi-schema Environment On Second Node (Doc ID 1088120.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.4.0.0.0 [Release 7.3.0 to 7.4.0]
Information in this document applies to any platform.

Goal

 Recycling through Suspense Manager and PCM_OP_SUSPENSE_RECYCLE_USAGE fails with the error message  ERR_TRANS_ALREADY_OPEN.  This error occurs only when recycling /suspended_usage object loaded into secondary schema.

From cm.pinlog:


D Sat Feb 20 17:54:40 2010  dev  cm_batch:1123  cm_child.c(106):4357 1:DEV-3D407D4B92AE:UnknownProgramName:0:Thread-27:4450:1270666874:0
XXX CMAP: op_custom() past op_decode, opcode: PCM_OP_SUSPENSE_RECYCLE_USAGE
D Sat Feb 20 17:54:40 2010  dev cm_batch:1123   
fm_suspense_recycle_usage.c:131 1:DEV-3D407D4B92AE:UnknownProgramName:0:Thread-27:4450:1270666874:0
op_suspense_recycle_usage input flist
# number of field entries allocated 20, used 5
0 PIN_FLD_POID           POID [0] 0.0.0.1 /admin_action/suspended_usage/recycle -1 0
0 PIN_FLD_OVERRIDE_REASONS    STR [0] ""
0 PIN_FLD_MODE           ENUM [0] 1
0 PIN_FLD_PROGRAM_NAME    STR [0] "Suspense Management Center"
0 PIN_FLD_SUSPENDED_USAGE_OBJS  ARRAY [0] allocated 20, used 1
1     PIN_FLD_SUSPENDED_USAGE_OBJ   POID [0] 0.0.0.2 /suspended_usage/telco/gsm 1152921504923268021 0

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.