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 22.214.171.124.0 and later
Information in this document applies to any platform.
On Oracle Communications Billing and Revenue Management (BRM) 126.96.36.199.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.
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:
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.1 /procedure -1 0
0 PIN_FLD_ERR_BUF ERR 
<location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
<facility=0 msg_id=0 version=0>
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