How to modify Asset Cost Summary Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How to modify Asset Cost Summary Report

Summary: I'm trying to modify the Asset Cost Summary Report. I created a copy of the DM (path = /shared/Custom/Financials/Fixed Assets/Asset Balances/Data Model/Cost Summary Data Model. If I save the sql (as-is, no modifications) in Q_MAIN it removes the existing group by in the data set. I believe it's because of the GROUP BY &lp_flex_segments_no_aliases in the sql. Does anyone know how I can modify this report without losing the group by? I still want to run it from scheduled processes and it populates temp tables using a package, so I don't think I can just replace the sql.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!