My Oracle Support Banner

PRC: PO: OTBI Procurement - Purchasing Real Time: OTBI Does Not Show Document History, Performed By Name/ROLE_CODE Field Values (Doc ID 2668950.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

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

Symptoms



ACTUAL BEHAVIOR
---------------
OTBI Procurement - Purchasing Real Time

Unable to show Document History: Performed by Name/ROLE_CODE values in OTBI Report.

EXPECTED BEHAVIOR
-----------------------
Document History: Performed by Name/ROLE_CODE values such 'Supplier' when action is performed by Supplier, 'Buyer' when action is performed by buyer, and so on.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an OTBI report based on Subject area: OTBI Procurement - Purchasing Real Time
2. Add all the columns available in Document History
3. Review the OTBI report output
notice that
No field shows the words 'Supplier' or 'Buyer'
Performed by : The words 'Supplier' or 'Buyer' do not print in this field/column. This field is being populated as follows
Blanks = When the action is taken by Supplier
Buyer's Name when the action is taken by Buyer

Performed by Party: Supplier's name if the action is taken by Supplier

This output is different than Document History UI

In Document History UI
There are 2 fields
Performed By Name shows 'Supplier' , 'Buyer' and so on;
Performed by Party 'Supplier's Name' , 'Buyer's name' and so on.


Changes

 

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


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