My Oracle Support Banner

REPORT BUILDER SHOWS A NULL SYNONYM COLUMN WIDTH VALUE (Doc ID 2498418.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Report Builder with RDBMS 12.1.0.2.0 shows a null column width field value within the Property Inspector window when an outer join is used on a synonym object; however, the same join works okay with RDBMS 11.2.0.3.0.

The same symptom is present with the Standalone Developer 10gR2 (Oracle Reports) product and the Developer
10gR2 (Oracle Reports) product integrated with E-Business Suite (EBS) 12.1.3, even after patching to latest code as per Doc ID 437878.1. The issue is present with any report and any synonym database object.

If the outer join is removed or the actual table used, instead of the synonym, the column width is set properly.

Changes

 RDBMS upgrade from 11.2.0.3.0 to 12.1.0.2.0

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
References


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