Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Best way tune up sql for Asset reserve summary report

Received Response
51
Views
4
Comments
Jaswanth Elite
Jaswanth Elite Rank 4 - Community Specialist
in Oracle Analytics Forum

Summary

Best way tune up sql for Asset reserve summary report

Content

Need sql for asset reserve summary and summary detail report

Answers

  • timdexter
    timdexter Rank 6 - Analytics & AI Lead

    Hi

    Assuming you are using an Oracle Application (EBS/PSoft, JDE, Fusion) why not go a get the report that is doing this right now and get the SQL out of it. I remember many years ago working on the Asset Detail Report ... it was a monster!

    Good luck

    Tim

  • Hendrik Schmidt
    Hendrik Schmidt Rank 4 - Community Specialist

    Hi,

    Could it be that you asked for an BI Publisher Report , not for Oracle Reports Developer Reports?

    If yes , please change thread to BI Publisher community.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics & AI Coach

    in which platform you are running the report? is it EBS concurrent program?

  • Jaswanth Elite
    Jaswanth Elite Rank 4 - Community Specialist

    Running it On Oracle fusion cloud