My Oracle Support Banner

R12: Iexpense Expense Reports Join To Ap Invoices (Doc ID 1914546.1)

Last updated on JULY 01, 2019

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

User would like to confirm the join from iexpense tables to ap invoice tables.

Option 1:
ap_expense_report_headers_all.vouchno = ap_invoices_all.invoice_id
ap_expense_report_lines_all.distribution_line_number = ap_invoice_lines_all.line_number

Option 2:

ap_expense_report_lines_all.report_header_id = ap_invoices_all.reference_key1
ap_expense_report_lines_all.report_line_id = ap_invoices_all.reference_key2

Questions:

1. Are the joins above correct?
2. Is it possible that a single ap_expense_report_lines_all can point to more than one ap_invoice_lines_all record?
3. This 2nd question is concerned with the associated ap_invoice_distributions_all records. If after joining ap_expense_report_lines_all to ap_invoice_lines_all record we then join to ap_invoice_distributions_all and filter ap_invoice_distribution_all where line_type_lookup_code = 'ITEM', is it possible that there could be more than 1 ap_invoice_distributions_all record?


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.