Cathy Wilbur
Well Known Member
Batch Users have security defined - having a problem getting data with business view V8300001
We have a custom report written using the financial rpt writer using V8300001 business view. IF a person with cost centre/business unit (MCU) security uses this report they get column headings and row headings but no dollar figures in the report. I ran the report (I have no row security for MCU) and I get data just fine with the same selection criteria. Peoplesoft/Oracle said it had to be a problem with the rpt defn.
We have other reports from JDE that we slightly modified and gave our own names (these use different business views) and we can run these rpts no problem whether we have cost centre security/business unit (MCU) or not.
So we went to the cross reference facility and found a JDE rpt (R10211A) that uses the same business view V8300001 that we are using in our own custom rpt. We ran this standard JDE report with one cost centre/business unit. The end user that had row security on MCU got just row and column headings but no dollar figures. I ran the same rpt and I got column and row headings and dollar figures. Again I have no row security. I am one of the programmers that maintains the system. So this means that there is something wrong with this business view V830001.
Has anyone had this problem with business view V8300001? If so what is causing the problem and how do I quickly fix it. We have end user rpts rolling out to different groups on Wednesday of next week so it would be nice to have this resolved. I attached the report to show what the user with row security gets back.
We have a custom report written using the financial rpt writer using V8300001 business view. IF a person with cost centre/business unit (MCU) security uses this report they get column headings and row headings but no dollar figures in the report. I ran the report (I have no row security for MCU) and I get data just fine with the same selection criteria. Peoplesoft/Oracle said it had to be a problem with the rpt defn.
We have other reports from JDE that we slightly modified and gave our own names (these use different business views) and we can run these rpts no problem whether we have cost centre security/business unit (MCU) or not.
So we went to the cross reference facility and found a JDE rpt (R10211A) that uses the same business view V8300001 that we are using in our own custom rpt. We ran this standard JDE report with one cost centre/business unit. The end user that had row security on MCU got just row and column headings but no dollar figures. I ran the same rpt and I got column and row headings and dollar figures. Again I have no row security. I am one of the programmers that maintains the system. So this means that there is something wrong with this business view V830001.
Has anyone had this problem with business view V8300001? If so what is causing the problem and how do I quickly fix it. We have end user rpts rolling out to different groups on Wednesday of next week so it would be nice to have this resolved. I attached the report to show what the user with row security gets back.