Payables Invoices - Transactions Real Time

Description

Real time information on payable invoices such as invoice number, supplier, site, business unit, invoice amount, currency, paid amount, discount amount, tax amount, invoice approval/validation/cancellation status at invoice header level. Includes information such as matching PO or receipt, project, asset, prepayment application, tax and AWT details at invoice header. Contains information such as accounted amount, distribution combination, and all other invoice line level attributes mentioned earlier at invoice distribution level.

Note: The attributes of the Self-Assessed Tax folder can be pulled with other folders in the subject area but not along with the attributes of the Accounting folder because they are at different grains/granularity.

Business Questions

This subject area can answer the following business questions:

• Which suppliers have invoices frequently put on a particular hold?

• What approval actions are applied to an invoice?

• Which invoices for a particular business unit, supplier, and supplier site have a specified approval status?

• What are the details for an invoice including related purchase order, amounts, and payment details?

• Which invoices or invoice lines are placed on hold?

• Which invoices are currently on hold and are preventing period close?

• Which invoices are currently pending approval?

Job Roles

The following job roles secure access to this subject area:

• Accounts Payable Invoice Supervisor

• Accounts Payable Manager

• Accounts Payable Specialist

• Accounts Payable Supervisor

• 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 Manager

Duty Roles

The following duty roles secure access to this subject area:

• Grants Management Transaction Analysis Duty

• Inter Company Transaction Analysis Duty

• Payables Invoice Transaction Analysis Duty

• Payables to Ledger Reconciliation Transaction Analysis Duty

• Project Costing Transaction Analysis Duty

• Project Journals Transaction Analysis Duty

Primary Navigation

        
          
        
        Home > Payables > Invoices > Manage Invoices > Edit Invoice
      

Time Reporting

This subject area supports payables invoices transactions history.

Time dimension is linked to Invoice Date.

Transactional Grain

This subject area returns data at the grain of Invoice Distribution with the following filter conditions applied:

Invoice_Type='PREPAYMENT'

(Key Join -> AP_PREPAY_APP_DISTS.PREPAY_APP_DISTRIBUTION_ID=AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID

AND AP_PREPAY_APP_DISTS.INVOICE_ID = AP_INVOICE_LINES_ALL.INVOICE_ID AND AP_PREPAY_APP_DISTS.INVOICE_LINE_NUMBER= AP_INVOICE_LINES_ALL.LINE_NUMBER

)

Note that Oracle 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

          
        

The seeded Accounts Payable Specialist role doesn't have Report Payables privilege which results in no data in the OTBI payable reports. Create a Custom role based on Accounts Payable Specialist and add this policy.

Policy Name: Grant on Business Unit
Policy Description: Accounts payable manager can report payables for the business units for which they are authorized
Data Resource: Business Unit
Privilege: Report Payables
Condition: Access the business units for which the user is explicitly authorized.