Welcome, Guest
Sign In / Register
Thread: How to query apps views Guest Settings
Search
FAQ
Reply to this Search Back to Thread
Thread Forum List
Sin
a
Posts: 63
Registered: 11/30/07
How to query apps viwes
Posted: Apr 24, 2008 12:10 AM
In apps database i have came across many views that are only accessible by forms and
built in reports. i have tried many ways to query these views but no success. i have
even logged in as System and tried to query these views but no luck. does anybody
know how i can query these views or what environment variable should i have for these
views to work? for example try this view or any of its subviews
apps.ap_invoice_distributions_v
Avia Re: How to query apps viwes Repl
d Posted: Apr 24, 2008 2:38 AM in response to: Sina y
Elba
z In order to query those views from sqlplus you must initialize apps authentication
variables.
Posts: 155
Registered: 04/01/07 You can use the following procedure:
begin
fnd_global.apps_initialize(p_user_id, p_resp_id, p_resp_appl_id);
end;
Aviad
http://Oracle-Apps-DBA.blogspot.com
dgood7 Re: How to query apps viwes Repl
6 Posted: Apr 24, 2008 2:43 AM in response to: Aviad Elbaz y
Posts: 724 You can run this one as well :
Registered: 01/30/99
begin
dbms_application_info.set_client_info('<org id>');
end;
oradba1 Re: How to query apps viwes Repl
23 Posted: Apr 24, 2008 3:36 AM in response to: dgood76 y
Posts: 290 You can use, even this->
Registered: 08/10/05 call fnd_client_info.set_org_context(<org_id>);
R's
Anmol
Message was edited by:
Anmol
Sin Re: How to query apps viwes Repl
a Posted: Apr 24, 2008 4:33 AM in response to: Sina y
Posts: 63 woow, i have never got so many right answer so fast
Registered: 11/30/07
thanks guys you really made my day
U Re: How to query apps viwes Repl
D Posted: Jul 2, 2008 10:51 PM in response to: Sina y
Posts: 300 I'd tried it in Apps 11i and it worked but in Oracle Apps R12.0.4 and it didn't work. Any
Registered: 11/08/05 other solution? Thanks.
hsawwa Re: How to query apps viwes Repl
n Posted: Jul 3, 2008 3:31 AM in response to: UD y
Posts: 41,986 UD,
Registered: 03/13/06
It is the same in R12, so it should work.
"Oracle Applications Developer's Guide " Manual. Page 29-3,
FND_GLOBAL.APPS_INITIALIZE (Server)
http://download.oracle.com/docs/cd/B40089_09/current/acrobat/120devg.pdf
U Re: How to query apps viwes Repl
D Posted: Jul 7, 2008 1:05 AM in response to: hsawwan y
Posts: 300 UD,
Registered: 11/08/05
It is the same in R12, so it should work.
"Oracle Applications Developer's Guide " Manual. Page
29-3, FND_GLOBAL.APPS_INITIALIZE (Server)
http://download.oracle.com/docs/cd/B40089_09/current/a
crobat/120devg.pdf
well I'd tried using :
begin
fnd_global.apps_initialize(1154, 20678, 222);
end;
and :
begin
dbms_application_info.set_client_info('88');
end;
and :
call fnd_client_info.set_org_context(88);
but none of it didn't show me anything in R12.
In 11i I only used
begin
dbms_application_info.set_client_info('88');
end;
select * from ra_customer_trx_partial_v;
then I could see results of the select query. In R12 if I use oracle apps it showed me the
view such as in receivables > transactions > transactions but if I query from sql
developer it didn't show me any record from ra_customer_trx_partial_v using :
call fnd_client_info.set_org_context(88);
If I tried using :
begin
fnd_global.apps_initialize(1154, 20678, 222);
end;
select * from ra_customer_trx_partial_v;
or :
begin
dbms_application_info.set_client_info('88');
end;
select * from ra_customer_trx_partial_v;
then I got this error message :
ORA-06550: line 5, column 1:
PLS-00103: Encountered the symbol "SELECT"
ORA-06550: line 5, column 68:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
* & - + ; / at for mod remainder rem <and exponent (**)> and or groups having
intersect minus order start union where connect || multiset
06550. 00000 - "line %s, column %s: \n%s"
*Cause: Usually a PL\SQL compilation error.
*Action:
Error at Line:1
So, where's the mistake? Thx
SPNaj Re: How to query apps viwes Repl
a Posted: Oct 3, 2008 2:12 AM in response to: UD y
Posts: 11 I know this question it's a bit old, but this could be of some help.
Registered: 10/03/08
In R.12, you have to initialize the user and use the mo_global package.
begin
fnd_global.apps_initialize(p_user_id, p_resp_id, p_resp_appl_id);
mo_global.init (p_appl_short_name);
end;
Bicho' Re: How to query apps viwes Repl
s Posted: Apr 13, 2009 1:28 PM in response to: SPNaja y
its not to late for me.
Posts: 6
Registered: 03/27/06
thanks.
mm_tah Re: How to query apps viwes Repl
a Posted: Jun 17, 2009 9:47 AM in response to: SPNaja y
Posts: 5 Thanks Aloooooooooooooooooooooooooooooooooooooooooot
Registered: 03/08/06
user6111 Re: How to query apps viwes Repl
81 Posted: Mar 7, 2011 11:06 AM in response to: SPNaja y
Posts: 1
Thanks - found exactly what I needed in 2011. Never too
Registered: 12/18/07
