My Oracle Support Banner

The Sequence PIN_SEQUENCE_TYPE_BILL_NO Is Not Generating Continuous Sequence For Bill_no (Doc ID 1492859.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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

Symptoms

The sequence PIN_SEQUENCE_TYPE_BILL_NO is not generating continuous sequence for BILL_NO's. The problem happened during the execution of billing for 6002 accounts in production environment.  The sequence started in billing process is 7660, it was continuous until 7902, and then the next BILL_NO was 13819 and so on.

Here the BILL_NO generated must be sequential as it is a requirement.

Is there a parameter that needs to be set on the environment? Why can this sequence be modified in billing process?

Currently, the /data/sequence PIN_SEQUENCE_TYPE_BILL_NO has 19986. It is correct according to the last bill generated, but this is the second time this problem happened and the user had to correct the BILL_NO manually.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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