Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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
52
Views
4
Comments
Jaswanth Elite
Jaswanth Elite Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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