When Run In Detailed Mode, the pin_ledger_report Utility Runs For A Long Time And Errors Out (Doc ID 1354594.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.

Symptoms

On BRM 7.3.1 version, General Ledger (GL).

When run in detailed mode, pin_ledger_report utility runs for a long time and errors out.

When pin_ledger_report utility is run in detailed mode it runs for a long time in production environment. When checking the dm_oracle.pinlog, we see the following ORA-04088 error:

E Tue Jan 04 19:42:24 2011 pc2an1 dm:24896 dm_subr.c(121):2243 1:pc2an1:pin_ledger_report:5487:1:133:1294125712:2
ORACLE error: do_sql_insert: PINStmtExecute: code 1555, op 0
=ORA-01555: snapshot too old: rollback segment number 86 with name "_SYSSMU86$" too small
ORA-06512: at "PIN_EU.GL", line 649
ORA-06512: at "PIN_EU.GL", line 2499
ORA-06512: at "PIN_EU.LEDGER_REPORT_TRIGGER", line 19
ORA-04088: error during execution of trigger 'PIN_EU.LEDGER_REPORT_TRIGGER'
"insert into ledger_report_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, name, gl_report_type, currency_only, type, start_t, end_t, gl_segment, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, created_t, mod_t, read_access, write_access, accts_num_for_group ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :name, :gl_report_type, :currency_only, :type, :start_t, :end_t, :gl_segment, :account_obj_DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :created_t, :mod_t, :read_access, :write_access, :accts_num_for_group )"
E Tue Jan 04 19:42:24 2011 pc2an1 dm:24896 dm_do_ops.c(78):2027 1:pc2an1:pin_ledger_report:5487:1:133:1294125712:2
ERROR do_create_create sql_insert err=1(PIN_ERR_NO_MEM)


Steps to Reproduce
------------------------
Run the pin_ ledger_report utiity in unbilled_earned mode as
pin_ledger_report -mode run_report -start 12/10/2010 -end 12/15/2010 -type unbilled_earned -detail


Cause

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