My Oracle Support Banner

RENW Entry In PEND Status Not Updated After Reactivation In Membership Proc Table (Doc ID 2883107.1)

Last updated on JULY 18, 2022

Applies to:

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


On RMB v3., DB Fields are not updated when Membership gets reactivated.

Scenario: Enroll, Terminate and reactivate a membership.
It seems DB fields do not get updated info and also it is not easy to confirm if it is a new membership or reactivated one.

RENW entry remains in CNCL value after reactivation of the membership in CI_MEMBERSHIP_PROCESS table.

CI_MEMBERSHIP_PROCESS table should update the value to PEND instead of remaining in CNCL.

The issue can be reproduced at will with the following steps:
1. Enrollment of membership
2. Terminate the membership with Term Date – 03312022
3. Reactivate the membership - Inbound msg for reactivation processed
  - Find that no new RENW entry for Memb_Process_Flg field with PEND status in Mem_Prc_Stat_Flag field


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

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