Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Extracting data from a different Schema from JDE UBE

Hi Mentors,


I have a requirement where i need to retrieve data using JDE report from a different Schema which resides in same database as our JDE. How do we do that? Can we use Table conversion for the same? What other options do we have?

eg:

Table in Other Schema: xxapps.xxDEF_ABC_qa_headers

Below is the table structure

Name Null Type

----------------- -------- --------------

QA_HEADER_ID NOT NULL NUMBER

CUSTOMER_ID NUMBER

ITEM_ID NUMBER

SERIAL_NUMBER VARCHAR2(30)

CASE_NUMBER NUMBER

WORK_ORDER_NUMBER NUMBER

OPERATION_ID NUMBER

OPERATION_SEQ NUMBER

HEADER_STATUS VARCHAR2(10)

CREATION_DATE DATE

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