Reporting - EBS (MOSC)

MOSC Banner

peformance on SQL Developer and Report Builder

edited Apr 15, 2017 5:00AM in Reporting - EBS (MOSC) 4 commentsAnswered

Hi,

we have an performance issue on SQL Developer and Report Builder.

SQL Developer version -> 4.1.5.21 64bit

Report Builder -> 10.1.2.0.2

We developing a report to provide data PO, Receive (Deliver Journal), Invoice. the report use Invoice Voucher Number (doc_sequence_value) as parameter and set as range (use between). We try to run the query on SQL Developer with range invoice voucher number are 5 (95608 - 95612) and the query was finish with 2.388 second. then try to create report with Report Builder and run the report with same parameter but Report Builder finished the report with 30 minute. But if we put the voucher number on query report builder (not use BETWEEN P_VOU_FROM and P_VOU_FROM, but BETWEEN 95608 and 95612)

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

EBS Reporting Tags

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