My Oracle Support Banner

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

Last updated on AUGUST 17, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.