Projects - EBS (MOSC)

MOSC Banner

Not able to query PA_EXPEND_ITEMS_ADJUST2_V

edited Mar 9, 2016 4:01AM in Projects - EBS (MOSC) 3 commentsAnswered

Hi All,

We are trying to run a query for the view PA_EXPEND_ITEMS_ADJUST2_V but it is returning no data (only the column names are coming). The query we have used is as below.

SELECT * FROM apps.PA_EXPEND_ITEMS_ADJUST2_V

We have even tried running the below query with the ORG_ID prior to running the above query but still it is not returning any data.

BEGIN

  DBMS_APPLICATION_INFO.SET_CLIENT_INFO('NNNN');

END;

Any help in this regrad will be much appreciated.

Tagged:

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