My Oracle Support Banner

Issue with Taxation Stored Procs after DB Import (Doc ID 2243562.1)

Last updated on JULY 12, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

On Oracle Communications Billing and Revenue Management (BRM) 7.5.0.6.0 version, Taxation, the below problem is observed.

Here the user have taken a DB export from one instance and imported into another instance of BRM. After the export the below errors where observed while executing billing/purchase deal and pin_sequence_body stored proc becomes invalid.

Tried compiling pin_sequence.pin_sequence_body, but it throws the error “Error(1): PLS-00753: malformed or corrupted wrapped unit” and becomes Invalid.

dm_oracle.pinlog:

SQL_STMT dm_search_robj: cmd="select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, effective_t from ordered_balgroup_t where ordered_balgroup_t.service_obj_ID0 = :1 and ordered_balgroup_t.account_obj_ID0 = :2 "
E Tue Feb 28 22:21:47 2017 dm:40480 dm_subr.c(161):3668 1::CustomerCenter:0:AWT-EventQueue-0:926:1488320423:0
  ORACLE error: do_proc_execute : PINStmtExecute: code 6502, op 0
  =ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "PIN.PIN_SEQUENCE", line 57
ORA-06512: at "PIN.PIN_SEQUENCE", line 136
ORA-06512: at "PIN.GET_SECTOR_BOUNDS", line 23
ORA-06512: at "PIN.PROC_DEFER_CYCLE_TAX_ACCT", line 96
ORA-06512: at "PIN.PROC_CYCLE_DEFERRED_TAX", line 105

 Snippet of cm.pinlog:

pcm_op: cannot retry PCM_OP_EXEC_SPROC, flags 0x0 - in a transaction - state=2
D Tue Feb 28 17:39:01 2017 cm:16184 fm_bill_cycle_tax.c:1180
 
  fm_bill_cycle_tax_proc procedure output
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /procedure -1 0
0 PIN_FLD_ERR_BUF ERR [0]
  <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
    <facility=0 msg_id=0 version=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!

In this Document
Goal
Solution


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