Oracle Transactional Business Intelligence

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

411
Views
8
Comments

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.  

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • 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

  • Rank 3 - Community Apprentice

    Hi Arun,

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

    Thanks,

    Tim

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.