Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Custom Discoverer Reports not returning data

Shanku BanerjeeDec 10 2012 — edited Dec 19 2012
Hi Guys,

we have done an upgrade from 4i to 11G for disco reports. The issue is, all those biz areas which have reference to views (Policy Context) does not return any data when mapped to a workbook.

It happens with the custom reports. We are not using apps.mo_global.set_policy_context anywhere which might be the issue. In toad it returns data once the policies are set. Any clue if there are any set up or patches which does this (policy context setting) @ the OU or environment level.

Thanks

Comments

unknown-7404

I have scheduled a job to run a batch file which exports a schema , every day in 3 P.M. ,

when i created it , i did not specify a start date or end date , and i chose " Daily " as a FREQ , and did not check any days .

Ok

1. What is your question or issue?

2. What does you question or issue have to do with Sql Developer?

Unless this is a Sql Developer question please mark it ANSWERED and repost it in the General DB forum

When you repost provide the code you used to create the job. And because your start_date uses an unusual format also post the NLS settings you are using.

If the job hasn't run at all it could be that the start_date you provided is either in the past or far into the future.

JuanM

As others mentioned, mark this question "as assumed answered"

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2013
Added on Dec 10 2012
6 comments
718 views