Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

OCA Accounts Payable (AP)

To download the description for the business views in a PDF format, click OCA Accounts Payable (AP).

No.

Views

Description

1

AP Invoices

This view returns information about Invoice headers in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices. A record is returned for each combination of an invoice number, a supplier name, and a business unit name.

2

AP Invoice Aging

This view returns information about AP Invoice balance aging. This aging report shows the unpaid invoice balances along with the duration for which they have been outstanding. This report helps businesses identify invoices that are open and allows them to keep on top of slow paying clients. A record is returned for each combination of BusinessunitName, LedgerName, SupplierName, SupplierSiteName, CalendarYear, CalendarQuarter, CurrencyCodeBase and InvoiceNumber.

3

AP Invoice Line Details

This view returns information about invoice lines and invoice tax lines for supplier transactions in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Lines. A record is returned for each combination of an invoice number, an invoice line number, a supplier name, a business unit name, and a summary tax line amount.

4

AP Invoice Payments

This view returns information about payment disbursements in Oracle Fusion Payables. This information is accessible through the Payables > Payments > Manage Payments work area. A record is returned for each combination of an invoice payment identifier , a business unit name, a supplier name, an invoice identifier, an invoice currency code, and a check identifier.

5

AP Checks

This view returns information about payable checks in Oracle Fusion Payables. This information is accessible through Payables work area > Payments > Manage Payments. A record is returned for each combination of a check number, payment date, business unit name, and supplier name.

6

AP Invoice Distributions

This view returns information about invoices and their distributions in Oracle Fusion Payables.This information is accessible through Payables > Invoices work area > Manage Invoices > Lines > Distributions > Manage Distributions. A record is returned for each combination of a distribution line number, an invoice number, an invoice line number, a supplier name, a supplier site name, and a business unit name.

7

AP Invoice Holds

This view returns information about current and released invoices on hold in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Holds and Approvals. A record is returned for each hold identifier.

8

AP Invoice Installments

This view returns information about the installments payments of invoices in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Installments. A record is returned for each combination of an invoice identifier and an installment number.

9

AP Invoice Prepayments

This view returns information about prepayment invoices in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices. A record is returned for each combination of a prepayment number, a business unit name, an applied invoice number, and an applied invoice line number.

10

AP Invoice Summary

This view returns information about the invoice summary. This information is accessible through Payables > Invoices work area > Invoice Number search > Validation Status. A record is returned for each combination of an invoice number, a business unit name, and a supplier name.

11

AP Invoice Withholding Taxes

This view returns information about withholding taxes of invoices in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Withholding taxes. A record is returned for each combination of an invoice number, a business unit name, and a supplier name.

12

AP Payment Distributions

This view returns information about payment distributions in Oracle Fusion Payables. This information is accessible through Payables work area > Payments > Manage Payments. A record is returned for each combination of a payment number, a business unit name, a supplier name, an invoice number, an invoice currency code, an invoice payment identifier, and a payment distribution identifier.

13

AP Payment History

This view returns information about payments and payment histories in Oracle Fusion Payables. This information is accessible through Payables > Payments work area > Manage Payments > Payments > History. A record is returned for each payment history identifier.

14

AP Trial Balance Details

This view returns information about the original and remaining amounts for accounted invoices in Oracle Fusion Payables. This information is displayed for the transactions that have been transferred to Oracle Fusion General Ledger and have an unpaid balance. A record is returned for each combination of a ledger name, a business unit name, a concatenated key flexfield value, a supplier name, and an invoice number.

15

SLA AP Distributions

This cross-functional view links accounting entries in Oracle Subledger Accounting to the corresponding invoice/payment transaction distribution lines in Oracle Fusion Payables. This view returns information about subledger accounting distributions for all accounting events generated for invoices/payments in Payables. A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.

16

SLA Payables Reconciliations

This view returns information about the reconciliation of accounting and transactional data recorded in Oracle Fusion Payables and Oracle Fusion Subledger Accounting with the journals posted to Oracle General Ledger for open payables balances. This information is accessible through Payables > Invoices work area > Accounting > Payables to Ledger Reconciliation Report. A record is returned for each combination of a ledger name, a reconciliation request name, a reconciliation item, and an accounting period name.

Published:

OCA Accounts Payable (AP)

To download the description for the business views in a PDF format, click OCA Accounts Payable (AP).

No.

Views

Description

1

AP Invoices

This view returns information about Invoice headers in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices. A record is returned for each combination of an invoice number, a supplier name, and a business unit name.

2

AP Invoice Aging

This view returns information about AP Invoice balance aging. This aging report shows the unpaid invoice balances along with the duration for which they have been outstanding. This report helps businesses identify invoices that are open and allows them to keep on top of slow paying clients. A record is returned for each combination of BusinessunitName, LedgerName, SupplierName, SupplierSiteName, CalendarYear, CalendarQuarter, CurrencyCodeBase and InvoiceNumber.

3

AP Invoice Line Details

This view returns information about invoice lines and invoice tax lines for supplier transactions in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Lines. A record is returned for each combination of an invoice number, an invoice line number, a supplier name, a business unit name, and a summary tax line amount.

4

AP Invoice Payments

This view returns information about payment disbursements in Oracle Fusion Payables. This information is accessible through the Payables > Payments > Manage Payments work area. A record is returned for each combination of an invoice payment identifier , a business unit name, a supplier name, an invoice identifier, an invoice currency code, and a check identifier.

5

AP Checks

This view returns information about payable checks in Oracle Fusion Payables. This information is accessible through Payables work area > Payments > Manage Payments. A record is returned for each combination of a check number, payment date, business unit name, and supplier name.

6

AP Invoice Distributions

This view returns information about invoices and their distributions in Oracle Fusion Payables.This information is accessible through Payables > Invoices work area > Manage Invoices > Lines > Distributions > Manage Distributions. A record is returned for each combination of a distribution line number, an invoice number, an invoice line number, a supplier name, a supplier site name, and a business unit name.

7

AP Invoice Holds

This view returns information about current and released invoices on hold in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Holds and Approvals. A record is returned for each hold identifier.

8

AP Invoice Installments

This view returns information about the installments payments of invoices in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Installments. A record is returned for each combination of an invoice identifier and an installment number.

9

AP Invoice Prepayments

This view returns information about prepayment invoices in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices. A record is returned for each combination of a prepayment number, a business unit name, an applied invoice number, and an applied invoice line number.

10

AP Invoice Summary

This view returns information about the invoice summary. This information is accessible through Payables > Invoices work area > Invoice Number search > Validation Status. A record is returned for each combination of an invoice number, a business unit name, and a supplier name.

11

AP Invoice Withholding Taxes

This view returns information about withholding taxes of invoices in Oracle Fusion Payables. This information is accessible through Payables > Invoices work area > Manage Invoices > Withholding taxes. A record is returned for each combination of an invoice number, a business unit name, and a supplier name.

12

AP Payment Distributions

This view returns information about payment distributions in Oracle Fusion Payables. This information is accessible through Payables work area > Payments > Manage Payments. A record is returned for each combination of a payment number, a business unit name, a supplier name, an invoice number, an invoice currency code, an invoice payment identifier, and a payment distribution identifier.

13

AP Payment History

This view returns information about payments and payment histories in Oracle Fusion Payables. This information is accessible through Payables > Payments work area > Manage Payments > Payments > History. A record is returned for each payment history identifier.

14

AP Trial Balance Details

This view returns information about the original and remaining amounts for accounted invoices in Oracle Fusion Payables. This information is displayed for the transactions that have been transferred to Oracle Fusion General Ledger and have an unpaid balance. A record is returned for each combination of a ledger name, a business unit name, a concatenated key flexfield value, a supplier name, and an invoice number.

15

SLA AP Distributions

This cross-functional view links accounting entries in Oracle Subledger Accounting to the corresponding invoice/payment transaction distribution lines in Oracle Fusion Payables. This view returns information about subledger accounting distributions for all accounting events generated for invoices/payments in Payables. A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.

16

SLA Payables Reconciliations

This view returns information about the reconciliation of accounting and transactional data recorded in Oracle Fusion Payables and Oracle Fusion Subledger Accounting with the journals posted to Oracle General Ledger for open payables balances. This information is accessible through Payables > Invoices work area > Accounting > Payables to Ledger Reconciliation Report. A record is returned for each combination of a ledger name, a reconciliation request name, a reconciliation item, and an accounting period name.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk