Receivables - Standard Receipts Application Details Real Time

Description

Real time information on customer receipts, including manual receipts, receipts uploaded from a spreadsheet and receipts imported through lockbox, and the associated distributions, accounting, and remittance bank information.

Business Questions

This subject area can answer the following business questions:

• What is my total receipt amount by currency and remittance bank account?

• Which receipts are posted to the customer's account but not applied to invoices?

• What receipts were applied to other receipts allowing the combined balance to be applied to invoices?

• Which receipts do not have the customer identified?

• Which receipts had earned or unearned discounts and how much for each?

• What is the total amount of receipt applications for the period by business unit?

• What receipts are not applied during the period by business unit?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager

• Accounts Receivable Manager Segregated Role

• Accounts Receivable Specialist

• Accounts Receivable Specialist Segregated Role

• Billing Manager Segregated Role

• Billing Specialist Segregated Role

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• Receivables Receipts Transaction Analysis Duty

• Receivables to Ledger Reconciliation Transaction Analysis Duty

Primary Navigation

Home > Receivables > Accounts Receivable > Manage Receipts > navigate to a single receipts for Applications

Time Reporting

This subject area supports customer receipts history.

Time dimension is linked to Receipt Application Date.

Transactional Grain

This subject area returns data at the grain of Receipt Distribution with an additional filter criteria to restrict data where AR_CASH_RECEIPTS_ALL.TYPE = 'CASH' (Key Join at the lowest grain -> AR_DISTRIBUTIONS_ALL.SOURCE_TABLE = 'RA' AND AR_DISTRIBUTIONS_ALL.SOURCE_ID = AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID AND AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID = AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID).

Note that Fusion Financials data security may further restrict the data being returned in OTBI as OTBI uses the same data security as Oracle Fusion Financials.

Special Considerations

None.