Help with Transaction History Report in OTBI (DUE DATE and OUTSTANDING BALANCE)

Kauan_Bohn

I aim to generate a comprehensive report of transaction history.

I need the fields DUE DATE and OUTSTANDING BALANCE of the transaction to be displayed in my analysis.

For the DUE DATE field, I found the following:

• Payment."Term Due Date"

However, there is an issue: it fails to return the correct due dates for all records, even though this information exists for each installment.

Additionally, the OUTSTANDING BALANCE ()

field is not returning any values.

Is there any solution for this?

I have attached my analysis in case it helps.

transactionHistory.txt

Nathan CCC

Hi,

Yes a receivables transaction does not have a due date but many dues date for each of its installment(s) so you can only have like an earliest or latest due date on the header transaction itself. As you say due date is an attribute of the child instalment, also known as, payment schedule. Then a transaction may also have many payments. Yes then a transaction may have an instalment with a due date but with no payment date(s) yet because it is not not paid it is outstanding without payment disbursements.

In global header select Navigator in Receivables in work area Billing task Manage Transactions on a selected transaction to a customer select Actions, Review Installments. This gives you your aging outstanding amounts grouped by due date. For example, a transaction may have instalment 1 EUR 111.11 due in 7 days time and instalment 2 a further EUR 222.22 due in 90 days time. It may be that in most cases your accounts receivables people have only created one instalment per transaction but some transactions may have multiple.

Here is the subject area for receivables payment schedules

https://docs.oracle.com/en/cloud/saas/financials/24d/faofb/Receivables--Payment-Schedules-Real-Time-SA-35.html#Receivables__Payment_Schedules_Real_Time_SA_35_d1e10256

You have some pre-defined reports so remember to look at the outstanding balance in them so you can validate if your query is returning expected results or not for a selected point in time.

Oracle Fusion Cloud Financials
Using Analytics and Reports for Financials G12448-01 24D

Receivables

https://docs.oracle.com/en/cloud/saas/financials/24d/ocuar/oracle-receivables-predefined-reports.html#s20047342

Collections

https://docs.oracle.com/en/cloud/saas/financials/24d/ocuar/oracle-fusion-advanced-collections-predefined-reports.html#s20047300

For example, the 3 aging reports in collections

Aging By Common Currency

Collections Aging 4 Bucket Report

Collections Aging by Collector 7 Bucket Report

Kauan_Bohn

Hi @Nathan CCC,

This subject area allowed me to complete my report successfully, thank you very much!