Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 52 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Informatica LKp issue
Message Code: DBG_21263
Message: Invalid lookup override SELECT DISTINCT PO_HEADERS_ALL.SEGMENT1 AS PO_NUMBER,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID AS INVOICE_ID ,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER AS INVOICE_LINE_NUMBER,
HR_LOCATIONS_ALL.ATTRIBUTE4 AS BUSINESS_UNIT /* THIS IS TO EXPOSE THE TASK LEVEL COMMITMENT'S AND ACTUAL'S BUSINESS UNIT */
FROM PO_DISTRIBUTIONS_ALL,
AP_INVOICE_DISTRIBUTIONS_ALL, PO_HEADERS_ALL
left outer join
HR_LOCATIONS_ALL on PO_HEADERS_ALL.SHIP_TO_LOCATION_ID = HR_LOCATIONS_ALL.LOCATION_ID
where AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID = PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
and PO_DISTRIBUTIONS_ALL.PO_HEADER_ID = PO_HEADERS_ALL.PO_HEADER_ID--
Message Code: DBG_21263
Message: Invalid lookup override SELECT DISTINCT PO_HEADERS_ALL.SEGMENT1 AS PO_NUMBER,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID AS INVOICE_ID ,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER AS INVOICE_LINE_NUMBER,
HR_LOCATIONS_ALL.ATTRIBUTE4 AS BUSINESS_UNIT /* THIS IS TO EXPOSE THE TASK LEVEL COMMITMENT'S AND ACTUAL'S BUSINESS UNIT */
FROM PO_DISTRIBUTIONS_ALL
inner join
AP_INVOICE_DISTRIBUTIONS_ALL
on AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID = PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
inner join PO_HEADERS_ALL
on PO_DISTRIBUTIONS_ALL.PO_HEADER_ID = PO_HEADERS_ALL.PO_HEADER_ID
left outer join
HR_LOCATIONS_ALL on PO_HEADERS_ALL.SHIP_TO_LOCATION_ID = HR_LOCATIONS_ALL.LOCATION_ID
How can i implement left outer join in Lookup override Query?
Answers
-
Make sure that the query is correct and fetches some data using toad etc.
0