My Oracle Support Banner

Unable To Create Entry In CI_ADJ_CLR_STG Table While Running APAYCRET Batch For Automatic Refund ADJ (Doc ID 2705365.1)

Last updated on SEPTEMBER 01, 2020

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 : 2.8.0.0.0 version, ENV - Environment

ACTUAL BEHAVIOR
---------------
Unable to create entry in CI_ADJ_CLR_STG table while running APAYCRET batch for automatic refund ADJ

Automatic refund adjustment creation module is not working. APAYCRET batch is firing below query (which is not getting any record, as C1_FT_EXT is not having any record) and then deleting credit bill entries from CI_BILL_ACH table.

select FT.TOT_AMT, FT.FT_ID, FT.FT_TYPE_FLG, FT.SIBLING_ID, FT.SA_ID, FT.CURRENCY_CD from ci_ft ft, c1_ft_ext ext where ft.ft_id=ext.ft_id and ft.bill_id=:billId and ext.acct_apay_id=:apayId

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.