Expenses - Expense Transactions Real Time Subject Area Returns Null Values "Account"."Concatenated Segments" When Adding Credit Card Member Name (Doc ID 3024107.1)

Last updated on MAY 21, 2024

Applies to:

Goal

Steps to reproduce the issue:

1. Create an analysis using the Expenses - Expense Transactions Real Time subject area such as follows:

   SELECT
   "Expenses - Expense Transactions Real Time"."Account"."Concatenated Segments" s_1,
   "Expenses - Expense Transactions Real Time"."Employee"."Employee Name" s_2,
   "Expenses - Expense Transactions Real Time"."Employee"."Employee Number" s_3,
   "Expenses - Expense Transactions Real Time"."Expense Line Details"."Corporate Card Transaction" s_4,
   "Expenses - Expense Transactions Real Time"."Expense Line Details"."Expense Category" s_5,
   "Expenses - Expense Transactions Real Time"."Expense Line Details"."Expense Description" s_6,
   "Expenses - Expense Transactions Real Time"."Expense Line Details"."Expense Line Id" s_7,
   "Expenses - Expense Transactions Real Time"."Expense Line Details"."Expense Type" s_8,
   "Expenses - Expense Transactions Real Time"."Expense Report Details"."Expense Report Number" s_9,
   DESCRIPTOR_IDOF("Expenses - Expense Transactions Real Time"."Expense Line Details"."Expense Category") s_10,
   "Expenses - Expense Transactions Real Time"."Corporate Card Transaction Amounts"."Transaction Amount" s_11,
   REPORT_SUM("Expenses - Expense Transactions Real Time"."Corporate Card Transaction Amounts"."Transaction Amount" BY "Expenses - Expense Transactions Real Time"."Expense Report Details"."Expense Report Number") s_12
   FROM "Expenses - Expense Transactions Real Time"

2. All fields display values except when adding both the credit card member name and the "Account"."Concatenated Segments" at the same time.
3. The member name is displayed but the "Concatenated Segments" returns null.
4. Once the credit card member name is removed, the "Account"."Concatenated Segments" values are displayed.

Solution

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