My Oracle Support Banner

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:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

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

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
Changes
Cause
Solution
 Still Have Questions?
References

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