APPS.AR_CASH_RECEIPTS_V showing No data

Question

When i tried to call APPS.AR_CASH_RECEIPTS_V view in OBIEE rpd through physical layer then it is showing 'No Data'. Please help me resolve it.

Gianni Ceresa · Answer

I guess it's a standard thing with EBS sources that you need to set a context first. Can't remember the details, something about the security and/or profile of the user requesting the data.

That thing must be managed in OBIEE as well.

Read this: Calling Oracle Stored Procedure from OBIEE 11g

PS: if you post all the details when you ask things it is easier to get the full pictures directly ....

M.A. Adeel · Answer

Dear Gianni,

By running below function can able to see data in SQL Developer. But in OBIEE i cant run it, directly importing it. By the way these are all (ar_cash_receipts_v, ap_checks_v) Oracle EBS standard views.

begin mo_global.set_policy_context ( 'S',101); end;

Thanks and Regards

M.A. Adeel · Answer

Dear Gianni,

By running below function can able to see data in SQL Developer. But in OBIEE i cant run it, directly importing it. By the way these are all (ar_cash_receipts_v, ap_checks_v) Oracle EBS standard views.

begin mo_global.set_policy_context ( 'S',101); end;

Thanks and Regards