Hi Erika, Have you looked into EPM Narrative Reporting or Process Cloud within the Visual Builder PaaS offering? I think one of those two might be the start of what you're looking for - wrapping an approval/editing workflow around a report production process. Hope that helps, Glen

Agreed, this would be very useful for validating/documenting current configuration.

Hi Lokanath, Ok, sorry for the confusion. You mentioned OTBI in the question, so that's what made me think you were pulling from a subject area. But if this is BIP only, you might have an option to do it in the layout. There is some pivot functionality there, but I haven't personally used it. What I was suggesting was…

BIPublisher gives you control over the SQL, so I think that should work for you. You may get better performance if you can extract the physical SQL from your original OTBI Analysis and pare that down to just the essential columns and base tables, but hopefully that's not a concern for you. Pulling from the OTBI Subject…

Hi Lokanath, Have you looked into writing your own Logical SQL in OTBI, or creating a BI Publisher report based upon the OTBI Subject Area you're interested in seeing? There are ways to pivot rows to columns in SQL, so I believe this is something you should be able to accomplish today. It won't be end user drag-and-drop,…

Agreed, this is much needed functionality. Audit exists around the objects in the BI Catalog, but now Admin configuration like Delivery Channels or Runtime Configuration properties.

Hi Cody, Are you creating those layouts as BI Publisher RTF templates? If the ultimate output is Excel, you'd be better off building this with a single true Excel layout template. Those support producing multi-tab Excel files, plus better Excel field formatting overall than RTF templates. So one BIP template leads to one…

Hi Karan, Sorry for the late response, but correct - that's the intent of the LE timezone settings, to derive the correct accounting date for all applicable transactions. Hope that helps, Glen

Agreed, it would be useful to combine the best features of true Excel layout templates with online preview.

Agreed, would be a nice enhancement that can easily be implemented by checking the module status in Functional Setup Manager.

Agreed, would be very helpful to end users doing ad hoc reporting in all modules.

Agreed, many industries would benefit from the level of visibility into project PO commitments that this would enable. So many other OTBI areas can join where there's a common dimension, why not these two? Glen

Hi Rich, Correct, CAST is one way to deal with removing a timestamp component from an OTBI analysis. But I think the first issue here is the determination of accounting date, which does not have a time component. So if an invoice is entered into the system at 8PM local time in Columbia (GMT-5) on May 31st, creation date in…

Hi Marco, Are you using the Legal Entity time zone feature? It sounds like you're not but you'd like to be, and/or that you don't have a timezone set on your LE. Have you seen the following docs? Incorrect Invoice Date or Payment Defaults based on Local vs. UTC Time Zone Differences (1629641.1) Legal Entity Time Zone -vs-…

Hi Eric & David, I'm speculating there, which is why I was asking if anyone has seen and could post an official pronouncement from Oracle on this. But my guess is that just because this one SQL Connect tool wraps the :sql bind variable doesn't preclude some type of injection - or that other tools (or regular BI data…

Is there an official Oracle announcement here? If the risk is indeed SQL injection, I'd argue that's better off being closed for security purposes. Plus I feel this change is not that difficult to work around with BI Publisher data models and reports, at least for static SQL (i.e. all the ad hoc requests). It can be…

Ravi, Do you have a reference to an Oracle note on this? Did Oracle cite security concerns? I'm familiar with the tool and it always seemed a big risk for SQL injection, but I'd be interested to hear Oracle's official stance. Thanks, Glen

Linga, Is this an end user report or an integration? If it's the latter, have you looked into BI Cloud Connector? That's a better choice than BIP for extracts like this. Glen

Hi Mike, As a workaround, have you looked into defining a BI Publisher data model and report? You could base the BIP data model off an OTBI analysis and schedule the report with SFTP delivery. It changes where you look for the running BIP job vs. an OTBI agent, but that should deliver the file you want to the destination…

Agreed, striped data access in BI Publisher would be very useful - and not just for HCM. For now your options for transactional reports are OTBI (which respects data access privileges, like you say) or centrally-deployed BI Publisher data models that have also been coded to respect role security (e.g. querying secured…