No data for View during run time !!! [message #541167] |
Sun, 29 January 2012 01:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
eshta
Messages: 33 Registered: February 2006 Location: Saudi Arabia
|
Member |
![beegees812003](/forum/theme/orafaq/images/yahoo.png)
|
|
Hello,
There is a view from Oracle APPS related to Purhcasing Module which I want to uses it fetch the data to the form.
from back end it is needed to execute the command to view its contents:
dbms_application_info.set_client_info('0')
I tried to do that in the form under When-new-form-instance trigger even when-new-block-instance trigger but alway showing the message:
FRM-40350: Query Caused no records to be retrieved.
Please adivse.
[Updated on: Sun, 29 January 2012 13:52] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: No data for View during run time !!! [message #541494 is a reply to message #541330] |
Tue, 31 January 2012 12:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/45399.jpg) |
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
Tried checking the code for the view.Quote:Got doubt on the following.
1. NVL's on org_id
2. USERENV('CLIENT_INFO')
3. USERENV('LANG') As it is working from back end sql, CLIENT_INFO and NVL's should not be an issue.
So, I suspect on the LANG setting.
Please crosscheck the above USERENV's from Help -> Diagnostics -> Examine.
By
Vamsi
|
|
|