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

Tim Welsh

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.  

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