Oracle Reports (MOSC)

MOSC Banner

Custom Report upgraded from 6i to 10.1.2.0.2 is not showing output

edited Nov 8, 2011 9:28PM in Oracle Reports (MOSC) 4 commentsAnswered ✓
Hi,

 

We are in the process of upgrading to oracle apps R12.1.3, so we are migrating the custom reports from version 6i to Reports version 10.1.2.0.2

the report query if i run in before-report trigger returns the data (proving the query is fine and should get data), but the report is not showing any output.

i have added a debug code in the report query (autonomous commit), and no debug is logged when i run the report from SRS.

it shows that report query is not being executed, any idea what causing this issue?

 

another test i did is, commented the user exits and set the org context in before report trigger and ran the report from the Report Builder and the report is returning the data correctly...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center