Same Account_no Value Is Being Stored In Different Schemas In Multischema Setup (Doc ID 2105957.1)

Last updated on MARCH 09, 2016

Applies to:

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

Goal

On : 7.5.0.0.0 version,

Issue:

*  While placing End to End(E2E) order from Siebel to BRM, if PCM_OP_CUST_COMMIT_CUSTOMER is invoked twice then same account number is being stored in different schemas.

Scenario:

1. First order completed on BRM for account creation (PCM_OP_CUST_COMMIT_CUSTOMER), say account_no is X (created in schema 1)
2. Next order failed on BRM to add service for account created previously in schema 1
3. Order again re-pushed for some reason for account creation (PCM_OP_CUST_COMMIT_CUSTOMER), now new account with account_no X is created in schema 8
4. Order completed on BRM for modify account details (on schema 8)

Actual Result:

See that two account poids now have same account_no.


Expected Result:
There should be unique account_no being stored across all the schemas, how to achieve this?
 

Solution

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