My Oracle Support Banner

OTBI Receipt Amount attribute value. (Doc ID 2670204.1)

Last updated on MAY 25, 2020

Applies to:

Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Goal

Customer is using one subject area, in this report we could see all the attributes data expect 'Receipt Amount' attribute value.

No value for the column : Receiving - Transactions Real Time > Receipt Amount

Roles have been verified. .

 

set variable LOGLEVEL = 2,PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Receiving - Transactions Real Time"."- Inventory"."Inventory Item" s_1,
"Receiving - Transactions Real Time"."- Receiving Transaction Details"."Po Header" s_2,
"Receiving - Transactions Real Time"."- Receiving Transaction Details"."Receipt Number" s_3,
"Receiving - Transactions Real Time"."- Receiving Transaction Details"."Transaction Date" s_4,
"Receiving - Transactions Real Time"."Category"."Category Name" s_5,
"Receiving - Transactions Real Time"."Receiving Inventory Organization"."Receiving Inventory Organization Business Unit Name" s_6,
"Receiving - Transactions Real Time"."Supplier Profile"."Supplier Name" s_7,
"Receiving - Transactions Real Time"."Supplier Profile"."Supplier Number" s_8,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Actual Received Quantity" s_9,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Item Quantity" s_10,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Receipt Amount" s_11,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Received Quantity" s_12,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Transaction Quantity" s_13
FROM "Receiving - 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
References


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