Order Management - EBS (MOSC)

MOSC Banner

no data found in OE_ORDER_HEADERS

edited Nov 29, 2014 10:00AM in Order Management - EBS (MOSC) 2 commentsAnswered

i am login using APPS.

select * from dba_synonyms where synonym_name in ('OE_ORDER_HEADERS','OE_ORDER_HEADERS_ALL') and owner='APPS';

                                        

OWNERSYNONYM_NAMETABLE_OWNERTABLE_NAMEDB_LINK
APPSOE_ORDER_HEADERSONTOE_ORDER_HEADERS_ALL
APPSOE_ORDER_HEADERS_ALLONTOE_ORDER_HEADERS_ALL

select * from apps.oe_order_headers;

no data found.

select * from apps.oe_order_headers_all;

a lot of records.

what's wrong? how to check why the apps.oe_order_headers is not working?

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