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

Last updated on SEPTEMBER 14, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms