PIM Transaction Viewer (Also Known As 360 Transaction Viewer) Does Not Show Open Order Or Open Purchase Order Information (Doc ID 2139328.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

360 transaction viewer in PIM is not showing open order or open purchase order related information.
  
STEPS

a) Setup

Load 360 transaction view information into IMC_THREE_SIXTY_COLS_TL.
Run example SQL to validate existing information:

b) Usage/Problem

Go to item supply demand form and query any item that has open sales or purchase orders.
Go to development manager related responsibility and go to item catalog and do simple search for that same item that has open sales orders and purchase orders.
Go to transactions tab and look at the results. Notice there are no results found in sections 'Open Orders' or 'Open Purchase Orders'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms