My Oracle Support Banner

Fusion OTBI - Manager Field Expenses - Expense Transactions Real Time (Doc ID 2374367.1)

Last updated on JANUARY 31, 2020

Applies to:

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

Goal

You have a expense report and are trying to view the manager who approved the expense for a person. However, for each report there are multiple managers. But if you go through the BPM there is only one manager for each expense report.

Sample query:

SELECT
0 s_0,
"Expenses - Expense Transactions Real Time"."Employee"."Employee Name" s_1,
"Expenses - Expense Transactions Real Time"."Expense Report Details"."Expense Payment Date" s_2,
"Expenses - Expense Transactions Real Time"."Expense Report Details"."Expense Report Number" s_3,
"Expenses - Expense Transactions Real Time"."Expense Report Details"."Final Approval Date" s_4,
"Expenses - Expense Transactions Real Time"."Expense Report Details"."Last Audited By" s_5,
"Expenses - Expense Transactions Real Time"."Expense Report Details"."Purpose" s_6,
"Expenses - Expense Transactions Real Time"."Expense Report Details"."Report Status" s_7,
"Expenses - Expense Transactions Real Time"."Expense Report Details"."Report Submission Date" s_8,
"Expenses - Expense Transactions Real Time"."Manager"."Manager Name" s_9,
DESCRIPTOR_IDOF("Expenses - Expense Transactions Real Time"."Expense Report Details"."Report Status") s_10,
"Expenses - Expense Transactions Real Time"."Expense Report Amounts"."Expense Report Total" s_11
FROM "Expenses - Expense Transactions Real Time"
 

 

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.