AR_S_00003 Transactions Workbench Issue: R12.1.1: Transaction Missing in Payment Schedule (Doc ID 2044211.1)

Last updated on APRIL 14, 2021

Applies to:

Symptoms

Issue:
======
Transaction does not have data in AR_PAYMENT_SCHEDULES_ALL
and if the transaction is a CM the AR_RECEIVABLE_APPLICATIONS_ALL is also missing.
Due to this corruption the transaction does not show a balance even though transaction type shows accounting_affect_flag = Y.
.
Analysis:
=======
Data is missing ar_payment_schedule row for transaction, if transaction is CM the ar_receivable_application and ar_distribution rows are also missing.
.
Fix Approach:
============
Missing records have to be inserted in PS (Payment Schedule), RA (receivable Applications) and ARD (AR Distributions) .

Changes

Cause

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