General OBIEE

Get Involved. Join the Conversation.

Topic

    Tim Welsh
    Customizing a Seeded Report - Editing the Data Model and...
    Topic posted May 19, 2017 by Tim WelshBlue Ribbon: 750+ Points, tagged BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, Discussion Forums, Fusion, OBIEE Answers, Reports, SQL 
    490 Views, 8 Comments
    Title:
    Customizing a Seeded Report - Editing the Data Model and using Packages
    Summary:
    The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package.
    Content:

    I am searching for usage documentation on how to use Oracle packages, specifically AP_APXINAGE_XMLP_PKG.  I have not located anything about packages in the Oracle Enterprise Repository for Fusion Apps.  

    Comment

     

    • Arun Raj

      Hi Tim,

      Even I couldn't find any information in OER or in support.oracle.com. I found this link though. Not sure if this is going to help.

      http://demo.enginatics.com/reports/SQLAP_Invoice_Aging_Report_Not_Supported_Reserved_For_Future_Use.html

      Thanks,

      Arun

      • Tim Welsh

        Hi Arun,

        Yeah, I saw that and I'm not sure what to make of it.  

        Thanks,

        Tim

        • Arun Raj

          Hi Tim,

          I believe that is the SQL in the package. For the custom report are you trying to add additional fields? Is this something that you may be able to achieve without modifying the standard package?

          Thanks,

          Arun

          • Tim Welsh

            Hi Arun,

            That looks identical to the SQL from the seeded report data model so I don't think it's from the package.  

            What I'm trying to accomplish is there are three columns that report Overdue as 1-7 days, 8-14 days and 15+ days.  I want to condense these into just one column of 7+ days.  I'm sure there is another way to do that but I figured it would be easier to use the logic and structure already in the data model.  

            Thanks,

            Tim

          • Satyanarayana Narayana

            Hi Arun,

             

            Could you please help me with the steps to add new columns to the report/DM.

             

            Thanks in advance !!

            Satya

            • Arun Raj

              Hi Satya,

              Are you trying to create a new custom Data Model? Or trying to customize and existing one?

              Thanks,

              Arun

              • Satyanarayana Narayana

                Hi Arun,

                 

                I want to customize the existing datamodel to include the collector name, item, delivery details etc. Please let me know if you have any idea.

                 

                Thanks,

                Satya

                • Arun Raj

                  If there are standard packages used in the data model it may not compile / save correctly when you customize it. I would rather build a new report with the custom logic.

                  Also check if you can use any of the OTBI subject areas to build a new analysis.

                  Thanks,

                  Arun