My Oracle Support Banner

Where To Find Field HDR Destination Facility Code In WebReport Gen2? (Doc ID 2750873.1)

Last updated on FEBRUARY 16, 2021

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 20.4 and later
Information in this document applies to any platform.

Goal

Where to find field HDR Destination Facility Code in WebReport Gen2? This field exist in WebReport(Legacy) under category ‘Order Hdr’ - HDR Destination Facility Code. In Gen2 we added categories “Company, Facility, Order_Hdr, Dest_facility_attributes” not able to find field HDR Destination Facility Code on any of the categories. Also checked AIT / Query checked table Order hdr do not see “HDR Destination Facility Code” but only field shown on order hdr table is “DEST_FACILITY_ID NUMBER”. Checked table DEST_FACILITY_ATTR only find field “DEST_FACILITY_ID NUMBER”.

Followed (Doc ID 2680847.1) - Web Reports Gen2_Report_Creation_Guidelines in the joins, we used “order_hdr.dest facility_id” to link with DestFacility.id and there is <dest_facility_code> field but also need the <facility_code> field of the ORDER interface.

1. if the join between facility and order entities is configured with the field:
"order.facility_id"

The web report gen 2 give the field <facility_code> of the ORDER interface

2. If the join between the facility and order entities is configured with the field:
"order.dest_facility_id"

The web report gen 2 give the field <dest_facility_code> of the ORDER interface seems only one join between facility and order entities.

How to setup so that both fields display in the report?
<facility_code> and <dest_facility_code> of the ORDER Interface
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.