Finding Parameter Values for Scheduled Concurrent Report Sets

最新推荐文章于 2022-07-31 01:11:20 发布

kikiwhq

最新推荐文章于 2022-07-31 01:11:20 发布

阅读量152

点赞数

分类专栏： SA 文章标签： SA

本文链接：https://blog.csdn.net/kikiwhq/article/details/80611616

版权

SA 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

请参考：https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F3290991&_afrLoop=447586915730115&resultTitle=Finding+Parameter+Values+for+Scheduled+Concurrent+Report+Sets&commId=3290991&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=s7czj7990_94

问题

I have several Report Sets that are scheduled to run daily. Often, I have to find out what parameters where set for each individual stage (job) of the Report Set. But I can't, for the life of me, figure out how to do this.

For example, I have a scheduled Report Set as follows:

Report Set Name (scheduled)
- Stage One
  - Parameter 1
  - Parameter 2
- Stage Two
  - Parameter 1

I need to know what values were input for all three parameters. How can I do that?

正确答案

They can be found in FND_RUN_REQUESTS. e.g. SELECT * FROM fnd_run_requests WHERE parent_request_id=:reqid; Where reqid is the request id for the request ou will see submitted in FND_CONCURRENT_REQUESTS and the Requests form.