Get Started with Redwood: Oracle Cloud SCM and Purchasing
Default Ship-to Location Behavior in PO View Mode
Hello,
I have a question about how the "Default Ship-to Location" displays on the Purchase Order (PO) screen. Here’s the issue:
- In edit / creation mode, the "Default Ship-to Location" field correctly displays a single default value from the BU configuration( the user can manually update if needed.)
This value is stored in the SHIP_TO_LOCATION_ID field within the PO_HEADERS_ALL table:
SELECT a.SHIP_TO_LOCATION_ID FROM PO_HEADERS_ALL a WHERE a.PO_HEADER_ID = 'YYYYY0';
- In view mode, however, the "Ship-to Location" field pulls data from the
PO_LINE_LOCATIONS_ALLtable, which can show multiple locations if there are different line entries.
Tagged:
0