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 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, ENV - Environment
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
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