My Oracle Support Banner

Duplicate FT ID Getting Picked Up In POSTPROC (CIPBIPOB) Batch Job (Doc ID 2968084.1)

Last updated on AUGUST 21, 2023

Applies to:

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

Symptoms

On RMB v2.9.0.0.0, Batch run shows error for Duplicate FT ID.

The POSTPROC(CIPBIPOB) batch job has failed with duplicate FT ID soft error.
Unfortunately, this issue is not reproducible as we are unsure on what is causing this issue and how the POSTPROC is picking up the same FT ID. This is a random behavior. To try reproducing the behavior, below steps can be tried:

1. Create adjustment in freezable state.
2. Then manually add entry in CI_FT table with same sibling id and ft_type_flg as BS from backend.
3. Then run POSTPROC job.

We also could not find any custom code in the repository which adds entry into CI_FT table.

For the recent occurrence of this issue, the bill was finalized and work around was not performed. There are no steps involved before invoking POSTPROC batch. This job is
scheduled job.

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
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.