My Oracle Support Banner

Through Batch Mode When Person & Account Is Created Using BO The ID Generated Are Getting Duplicated (Doc ID 2658241.1)

Last updated on APRIL 15, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.6.0.1.0 version, ENV - Environment

ACTUAL BEHAVIOR
---------------
Through batch mode when Person & Account is created using BO, the ID generated are getting duplicated.

STEPS:
----------------
1)Upload data with Person detials and their Account details.
2)Approve the uploaded file and run the batch CM_CUST.
Then the Persons and their Accounts get created using BO.

For most of the entities generated, the Account ID is same as that of the Person ID.
And as a result, 2 entries get populated in CI_PARTY table for the same PARTY_ID with party_type_flg as ACCT and PER.
This causes issues while running the pricing batches which is based on these table entries.

Note
The new ID’s are getting generated with the same 3 digits as that of the last 3 digits of the SCHEDULER_ID in the same thread.

EXPECTED BEHAVIOR
-----------------------
All the customer ID and Account ID generated should be unique. No two ID's should be similar.

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.