How to Modify the Asset State Parameter in Property Tax Report

Question

Hi ,

PFB details -

1) We want to pass 'All' Values in Asset State Parameter of Property Tax Report. However, by default there is no option to select 'All values' in the parameter in ESS Job of standard report. (PFA Screenshot of ESS Job)

2) When we try to customize the report and modify the ESS Job, We have to make changes in the parameter used in the seeded data model as well in order to pass 'All' but we found that this parameter has been used in the package only which is not accessible by us. (PFA Screenshot of Standard Data Model)

So, the request here is - Is there any alternative to modify the parameter to pass 'All' Values in this report?

Screenshot_2024-06-10_Parameter_used_in_Package.jpg

Screenshot_2024-06-10_ESS_Job_Parameter.jpg

Mallikarjuna Kuppauru-Oracle · Accepted Answer

Hi @User_Jyotsna

By default existing logic won't allow to modify the design . Refer below MOS doc -

Add New Parameter To Custom Report 'Property Tax Report' (Doc ID 2756443.1)

Workaround (Customization)-

1) removing the dependency of having the existing plsql xmlp package

2) converting the xmlp package's corresponding logic to multiple subqueries in the xdm.

Regards,

Arjun