SQL*Plus (MOSC)

MOSC Banner

run query based on a view

edited Nov 25, 2018 12:33AM in SQL*Plus (MOSC) 8 commentsAnswered

Dear All,

if i run this query :  select count(*) from CE_260_RECONCILED_V

because it is a view : the result is zero

but usually to select data from a view we have to run this before

begin

    fnd_global.apps_initialize(user_id =>user_id,

    resp_id => resp_id,

    resp_appl_id => app_id);

    mo_global.init(p_appl_short_name => 'CE');

    xla_security_pkg.set_security_context(p_application_id => app-id);

end;

but now even when i run this code the result is still zero..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center