Voucher Number Not Populating in OTBI Report (Doc ID 1997218.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Unable to get Voucher Number into OTBI report, the column remains blank

SQL:
SELECT
  0 s_0,
  "Payables Invoices - Transactions Real Time"."- Account"."Concatenated Segments" s_1,
  "Payables Invoices - Transactions Real Time"."- Accounting Date Fiscal Calendar"."Fiscal Period" s_2,
  "Payables Invoices - Transactions Real Time"."- Accounting Date"."Accounting Date" s_3,
  "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Date" s_4,
  "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Description" s_5,
  "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Number" s_6,
  "Payables Invoices - Transactions Real Time"."- Invoice Distribution Details - General Information"."Distribution Line Number" s_7,
  "Payables Invoices - Transactions Real Time"."- Natural Account"."Account Code" s_8,
  "Payables Invoices - Transactions Real Time"."- Reference Information"."Voucher Number" s_9,
  "Payables Invoices - Transactions Real Time"."Supplier"."Supplier Name" s_10,
  SORTKEY("Payables Invoices - Transactions Real Time"."- Accounting Date Fiscal Calendar"."Fiscal Period") s_11,
  "Payables Invoices - Transactions Real Time"."- Invoice Amounts"."Paid Amount" s_12
FROM "Payables Invoices - Transactions Real Time"
WHERE
(("Payables Invoices - Transactions Real Time"."- Natural Account"."Account Code" BETWEEN '60000' AND '89999'))
ORDER BY 1, 12 ASC NULLS LAST, 11 ASC NULLS LAST, 7 ASC NULLS LAST, 5 ASC NULLS LAST, 6 ASC NULLS LAST, 10 ASC NULLS LAST, 2 ASC NULLS LAST, 9 ASC NULLS LAST, 4 ASC NULLS LAST, 8 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

Cause

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