Report Parameter Input Changes from XID to GID (Doc ID 786878.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.05.02 to 5.5.05.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:

After installing 5.5 CU5 RU2 or RU3, it is noticed that when running Reports whose parameters include a specific GID (selected by a finder), they are now failing to return any data for any custom reports (note: standard reports work fine).

For example, in analyzing one of the standard reports in CU5, the following is found:

:P_L_SHIPMENT_ID := 'rpt_general.f_remove_domain(SHIPMENT_GID)'||get_filter_condition(:P_L_SHIPMENT_ID ) ;

A similar entry in the 5.5 CU3 reports is as follows:

:P_L_INVOICE_ID := 'INVOICE_GID'||get_filter_condition( :P_L_INVOICE_ID ) ;

Notice that input to the CU5 version is a GID (with domain stripped), whereas input in CU3 is an XID. Because of this, all custom reports have been coded the CU3 way and failing to return any results.

-- Steps To Reproduce:
1. Run a custom Report that was created in an earlier version that is based on a specific GID
(selected by a finder).

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