Receivables - Transactions Real Time

Description

Real time information about transaction headers and lines for invoices, credit memos, debit memos and chargebacks, including tax, freight, sales credits, and the associated distributions and accounting.

Business Questions

This subject area can answer the following business questions:

• What portion of transactions is made up of invoices, credit memos, chargeback, or debit memos?

• What is the total amount of transactions for a specific customer?

• Which transactions affect the customer open balance for collections purposes, but not the general ledger account balance?

• What is the total amount of all transactions for 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

• Advanced Revenue Analyst

• Advanced Revenue Manager

• Billing Manager Segregated Role

• Billing Specialist Segregated Role

• Financial Analyst

• General Accountant

• General Accounting Manager

• Grants Accountant

• Grants Administrator

• Grants Department Administrator

• Intercompany Accountant

• Intercompany Transactions Entry

• Principal Investigator

• Project Accountant

• Project Administrator

• Project Billing Specialist

• Project Manager

Duty Roles

The following duty roles secure access to this subject area:

• Grants Management Transaction Analysis Duty

• Inter Company Transaction Analysis Duty

• Project Contract Invoice Transaction Analysis Duty

• Project Costing Transaction Analysis Duty

• Project Journals Transaction Analysis Duty

• Receivables Transaction Analysis Duty

• Receivables to Ledger Reconciliation Transaction Analysis Duty

Primary Navigation

Home > Receivables > Billing > Manage Transactions

Time Reporting

This subject area supports receivables transactions history.

Time dimension is linked to Receivables Transaction Date.

Transactional Grain

This subject area returns data at the grain of Transaction Distribution. (Key join at the lowest grain -> RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_LINE_ID = RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID(+) AND RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_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.