Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Customizing a Seeded Report - Editing the Data Model and using Packages

391
Views
8
Comments
Tim Welsh
Tim Welsh Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

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.  

Tagged:

Comments

  • rajArun
    rajArun Rank 5 - Community Champion

    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
    Tim Welsh Rank 3 - Community Apprentice

    Hi Arun,

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

    Thanks,

    Tim

  • rajArun
    rajArun Rank 5 - Community Champion

    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
    Tim Welsh Rank 3 - Community Apprentice

    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
    Satyanarayana Narayana Rank 1 - Community Starter

    Hi Arun,

     

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

     

    Thanks in advance !!

    Satya

  • rajArun
    rajArun Rank 5 - Community Champion

    Hi Satya,

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

    Thanks,

    Arun

  • Satyanarayana Narayana
    Satyanarayana Narayana Rank 1 - Community Starter

    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

  • rajArun
    rajArun Rank 5 - Community Champion

    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