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

Accounts Payable

Accounts payable (AP), or "payables," refer to a company's short-term obligations owed to its creditors or suppliers, which have not yet been paid. The sum of all outstanding amounts owed to vendors is shown as the accounts payable balance on the company's balance sheet. Payables appear on a company's balance sheet as a current liability.

Accounts Payable Views

Serial no . View nameDescription
1AP 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.
2AP 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 Business_unit_Name, Ledger_Name, Supplier_Name, Supplier_Site_Name, Calendar_Year, Calendar_Quarter, Currency_Code_Base and Invoice_Number.
3AP 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.
4AP 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.
5AP 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.
6AP 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.
7AP 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.
8AP 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 instalment number.
9AP 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.
10AP 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.
11AP 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.
12AP 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.
13AP 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.
14AP 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.
15SLA 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.
16SLA 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.

Accounts Payable Dashboards

A dashboard is a way of displaying various types of visual data in one place. Usually, a dashboard is intended to convey different, but related information in an easy-to-digest form. And oftentimes, this includes things like key performance indicators (KPI)s or other important business metrics that stakeholders need to see and understand at a glance. Dashboards are useful across different industries and verticals because they’re highly customizable. They can include data of all sorts with varying date ranges to help you understand: what happened, why it happened, what may happen, and what action you should take. And since dashboards use visualizations like tables, graphs, and charts, others who aren’t as close to the data can quickly and easily understand the story it tells or the insights it reveals.

Published:

Accounts Payable

Accounts payable (AP), or "payables," refer to a company's short-term obligations owed to its creditors or suppliers, which have not yet been paid. The sum of all outstanding amounts owed to vendors is shown as the accounts payable balance on the company's balance sheet. Payables appear on a company's balance sheet as a current liability.

Accounts Payable Views

Serial no . View nameDescription
1AP 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.
2AP 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 Business_unit_Name, Ledger_Name, Supplier_Name, Supplier_Site_Name, Calendar_Year, Calendar_Quarter, Currency_Code_Base and Invoice_Number.
3AP 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.
4AP 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.
5AP 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.
6AP 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.
7AP 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.
8AP 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 instalment number.
9AP 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.
10AP 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.
11AP 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.
12AP 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.
13AP 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.
14AP 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.
15SLA 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.
16SLA 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.

Accounts Payable Dashboards

A dashboard is a way of displaying various types of visual data in one place. Usually, a dashboard is intended to convey different, but related information in an easy-to-digest form. And oftentimes, this includes things like key performance indicators (KPI)s or other important business metrics that stakeholders need to see and understand at a glance. Dashboards are useful across different industries and verticals because they’re highly customizable. They can include data of all sorts with varying date ranges to help you understand: what happened, why it happened, what may happen, and what action you should take. And since dashboards use visualizations like tables, graphs, and charts, others who aren’t as close to the data can quickly and easily understand the story it tells or the insights it reveals.

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