Receivables - Miscellaneous Receipts Real Time
Description
Real time information on miscellaneous receipts, such as non-AR trade related receipts, credit card refunds and credit card chargebacks, including the associated distributions, accounting details and remittance bank information.
Business Questions
This subject area can answer the following business questions:
-
What was the volume of credit card refunds and chargebacks for the period?
-
What are the most prevalent reversal reasons that may indicate a process improvement is needed?
-
Which miscellaneous receipts from previous months were reversed this month?
-
What receipts were reversed for a specific remittance bank over a range of reversal dates?
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Home > Receivables > Accounts Receivable > Manage Receipts
Time Reporting
This subject area supports non-AR trade related receipts, credit card refunds and credit card chargebacks history.
Time dimension is linked to Receipt Date.
Transactional Grain
This subject area returns data at the grain of Receipt Distribution with these filter conditions applied:
AR_CASH_RECEIPTS_ALL.Type='MISC' (Key Join at the lowest grain -> AR_DISTRIBUTIONS_ALL.SOURCE_ID = AR_MISC_CASH_DISTRIBUTIONS_ALL.MISC_CASH_DISTRIBUTION_ID AND AR_DISTRIBUTIONS_ALL.SOURCE_TABLE = 'MCD' AND AR_MISC_CASH_DISTRIBUTIONS_ALL.CASH_RECEIPT_ID = AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID AND AR_CASH_RECEIPTS_ALL.TYPE = 'MISC').
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.