Pin_bill_accts Failing with DM NO_MEM Error on STEP_NEXT After Some Batches Completed (Doc ID 2204946.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

On : 7.5.0.16.0 version, DM

Performing testing between PS14 and PS16+ Patch 24588097, pin_bill_accts queries are now getting NUM_SUPPRESSED_CYCLES for each /billinfo in addition to POID and ACCOUNT_OBJ.

ERROR
-----------------------


STEPS
-----------------------
Process pin_bill_accts for pay type in following order:

Paytype Run Result # of accounts
10007 1 Success 325795
Sponsorship 1 Success 2806
10000 1 Success 239
10021 1 Failed 2640000
2 Success 1581381
10001 1 Success 466121
10003 1 Failed 330000

EXPECTED RESULT
---------------------------
The account to be processed should be about 1113154 for paytype 10003.

Same runs on the PS14 environment succeeded with these volumes. It appearred that dm_oracle fetches were leaking memory.
The addition of the extra field in the search output should not have this significant impact on dm shared memory sizing given in the pin_bill_accts settings.

Changes

 

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