My Oracle Support Banner

"Payables Invoices - Transactions Real Time" Approver Display Name Renders As Internal User ID (Doc ID 2817567.1)

Last updated on NOVEMBER 01, 2021

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.21.04.0 and later
Information in this document applies to any platform.

Symptoms

Created a new OTBI analysis using the "Payables Invoices - Transaction Real Time" Subject Area that displays the user name who approved an invoice.
Instead of showing the User Display Name,  the analysis is displaying the internal UserID.

 

Changes

 New Analysis

SELECT
0 s_0,
"Payables Invoices - Transactions Real Time"."- General Information"."Invoice Number" s_1,
"Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action Date" s_2,
"Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action" s_3,
"Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Context" s_4,
"Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Status" s_5,
"Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approver User Name" s_6,
"Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approver" s_7,
"Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Reviewed Amount" s_8,
"Payables Invoices - Transactions Real Time"."- Invoice Line Details - Approval Information"."Line Approver" s_9,
DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action") s_10,
DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Status") s_11
FROM "Payables Invoices - Transactions Real Time"
WHERE
("- General Information"."Invoice Number" = '000000000005Cancel')

Cause

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
Symptoms
Changes
Cause
Solution
References


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