You are browsing the archive for Oracle Shipping.

Shipping Execution R12 Enhancements

Process Manufacturing Support

  • In R12 you don’t need separate Shipping module for Oracle Process Manufacturing (OPM). Standard Shipping Execution module will support process and discrete manufacturing

Deliveries(Shipments) without sales orders:

  • Deliveries can be created without a Sales Order using XML gateway (EDI 940 IN). This will help to facilitate any miscellaneous shipping activities that is not tied to sales order.

Pick Release changes

  • Additional functionality to support cross-docking is provided through pick release form. Parallel pick release functionality enhanced to support multi-threading.

Revenue Recognition Deferment

  • Revenue recognition can be deferred beyond ship confirm. This is a great feature of businesses that would to recognize revenue after customer acceptance or installation or on a future date.

XML ready documents

  • Many out of the box XML reports were added that can be flexibly modified to meet business requirements.

Shipping Purge

  • Shipping transactions can be purged now, this will reduce the database table size and improves the performance.

Workflow enabled Shipping Transactions

  • Many workflow business events are available out of the box to send notifications users based on business rules

Shipping Concurrent Programs

Oracle Shipping Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
WSHDSNO Departure Ship Notice Outbound
WSHINVIS Interface Interface – SRS
WSHINVI Inventory Interface
WSHOMIS Order Management Interface – SRS
WSHRDXCP Shipping Exceptions Report
WSHRDVLD Vehicle Load Sheet Details
WSHRDVLS Vehicle Load Sheet Summary
WSHRDBSR Backorder Summary Report
WSHRDBDR Backorder Detail Report
WSHRDLAB Mailing Label
WSHRDPAK Packing Slip Report
WSHRDINV Commercial Invoice
WSHRDMBL Master Bill of Lading
WSHRDBOL Bill of Lading
WSHIDL Import into Delivery Lines
WSHRDPIK Pick Slip Report
WSHPSRS Generate Selection List for Pick Release by Standard Report Submission
WSHPSGL Generate selection list for pick release
WSHOMI Order Management Interface
WSHINVIAS Interface All Trip Stops – SRS
WSHINVIA Interface All Trip Stops
WSHINTERFACES Interface Trip Stop – SRS
WSHINTERFACE Interface Trip Stop
WSHLRMA Location to Region Mapping
WSHRGINT Region Interface
WSHAFCTD Assign Freight Cost to Deliveries
WSHRDASC Auto Ship Confirm Report
WSHAPDSRS Auto-Pack Deliveries -SRS
WSHASCSRS Automated Ship Confirm – SRS
WSHRDAPK Auto-pack Report
WSHRDSDL Shipped Delivery Lines Report
WSHMAPCD Import Shipping Locations – Child
WSHAUMN Automated Shipment Request/Shipment Advice
WSHMLOCR Import Shipping Locations
CCLAUNCHER Program to launch Clearcross Adapter
WSHRDOPN Open Deliveries Report
CCSHUTDOWN Program to shut down clearcross adapter
WSHADOVR Skip Service Request/Response
WSHRDAST Adapter Status Report
WSHGTCST Startup ITM Adapter
WSHGTCSH Shutdown ITM Adapter
WSHADRES Resubmit Service Request/Response
WSHITOVR Skip Screening
WSHITRES Skip Screening
WSHRDIST ITM Adapter Status Report
ITMSTARTUP Program to launch ITM Adapter
ITMSHUTDOWN Program to shutdown ITM Adapter
WSHITESB Submission of Deliveries to ITM for Export Compliance Screening
WSHPDSRS Process Deliveries SRS Program
WSH_ITM_ITEM_SYNC ITM Item Synchronization
WSH_ITM_PARTY_SYNC ITM Party Synchronization
WSHPFUP Print Freight Codes to be Upgraded
WSHFRUCL Freight Upgrade Closed Orders
WSHUPFCL Upgrade Freight Carriers (Closed Orders)
WSHUPDATESM Update Ship Methods
WSHLRMCD Location To Region Mapping – Child
WSHMDC WSH Multi Delivery Consolidation Program
WSHRDLABX Mailing Label PDF Output
WSHRDVLSX Vehicle Load Sheet Summary PDF Output
WSHRDBOLX Bill of Lading PDF Output
WSHRDMBLX Master Bill of Lading PDF Output
WSHRDINVX Commercial Invoice PDF Output
WSHRDPAKX Packing Slip Report PDF Output
WSHRDPIKX Pick Slip Report PDF Output
WSHPURGE Program to purge shipping entities
WSHPSGL_SUB Generate selection list for pick release child process
WSHOTMRL Planned Shipment Interface
WSHTMCAR Synchronize Carriers/Carrier Sites with Transportation Management
WSHOOCHL Shipping-Transportation outbound interface – Child
WSHOOINT Shipping-Transportation Outbound Interface
WSHRDVLSX_XML Vehicle Load Sheet Summary PDF Output
WSHRDXCP_XML Shipping Exceptions Report
WSHRDASC_XML Auto Ship Confirm Report (XML)
WSHRDBDR_XML Backorder Detail Report
WSHRDBOL_XML Bill of Lading
WSHRDBOLX_XML Bill of Lading PDF Output
WSHRDBSR_XML Backorder Summary Report
WSHRDINV_XML Commercial Invoice
WSHRDINVX_XML Commercial Invoice PDF Output
WSHRDIST_XML ITM Adapter Status Report
WSHRDLAB_XML Mailing Label
WSHRDLABX_XML Mailing Label PDF Output
WSHRDMBL_XML Master Bill of Lading
WSHRDMBLX_XML Master Bill of Lading PDF Output
WSHRDOPN_XML Open Deliveries Report
WSHRDPAK_XML Packing Slip Report
WSHRDPAKX_XML Packing Slip Report PDF Output
WSHRDPIK_XML Pick Slip Report
WSHRDPIKX_XML Pick Slip Report PDF Output
WSHRDSDL_XML Shipped Delivery Lines Report
WSHRDVLD_XML Vehicle Load Sheet Details
WSHRDVLS_XML Vehicle Load Sheet Summary
WSHRDAPK_XML Auto-pack Report (XML)
WSHSRINB Process Shipment Requests

Shipping Tables

Oracle Shipping Execution Tables:

  • WSH_ACTIVITY_GROUPS
  • WSH_CALENDAR_ASSIGNMENTS
  • WSH_CARRIERS
  • WSH_CARRIER_SERVICES
  • WSH_CARRIER_SHIP_METHODS
  • WSH_CARRIER_SITES
  • WSH_CARRIER_VEHICLE_TYPES
  • WSH_CC_ADAPTER_STATUS
  • WSH_CC_DENIED_PARTIES
  • WSH_CC_PARAMETER_SETUPS_B
  • WSH_CC_PARAMETER_SETUPS_TL
  • WSH_CC_REQUEST_SETUPS
  • WSH_CC_RESPONSE_HEADERS
  • WSH_CC_RESPONSE_LINES
  • WSH_CC_SERVICE_SETUPS
  • WSH_CC_TRANS_CONTROL
  • WSH_CC_TRANS_HEADERS
  • WSH_CC_TRANS_LINES
  • WSH_CC_USER_SETUPS
  • WSH_CONTAINER_ITEMS
  • WSH_DELIVERY_ASSIGNMENTS
  • WSH_DELIVERY_DETAILS
  • WSH_DELIVERY_LEGS
  • WSH_DELIVERY_LEG_ACTIVITIES
  • WSH_DELIVERY_LEG_DETAILS
  • WSH_DEL_ASSGN_INTERFACE
  • WSH_DEL_DETAILS_INTERFACE
  • WSH_DEL_LEGS_INTERFACE
  • WSH_DOCUMENT_INSTANCES
  • WSH_DOC_SEQUENCE_CATEGORIES
  • WSH_EXCEPTIONS
  • WSH_EXCEPTION_DEFINITIONS_B
  • WSH_EXCEPTION_DEFINITIONS_TL
  • WSH_FOLDER_CUSTOM_ACTIONS
  • WSH_FOLDER_EXTENSIONS
  • WSH_FREIGHT_COSTS
  • WSH_FREIGHT_COSTS_EFC
  • WSH_FREIGHT_COSTS_INTERFACE
  • WSH_FREIGHT_COST_TYPES
  • WSH_FTE_ACK_INTERFACE
  • WSH_FTE_CHARGES_INTERFACE
  • WSH_FTE_COMP_CLASSES
  • WSH_FTE_COMP_CONSTRAINTS
  • WSH_FTE_DLVY_DET_INTERFACE
  • WSH_FTE_DLVY_HDR_INTERFACE
  • WSH_FTE_EXCEPTION_INTERFACE
  • WSH_FTE_SCHEDULE_INTERFACE
  • WSH_FTE_TRANSACTION_EXCEPTIONS
  • WSH_FTE_TRANSACTION_HISTORY
  • WSH_GLOBAL_PARAMETERS
  • WSH_GRANTS
  • WSH_GTC_RESPONSE_RULES
  • WSH_INBOUND_TXN_HISTORY
  • WSH_INTERFACE_ERRORS
  • WSH_ITM_ADAPTER_STATUS
  • WSH_ITM_DENIED_PARTIES
  • WSH_ITM_ITEMS
  • WSH_ITM_PARAMETER_SETUPS_B
  • WSH_ITM_PARAMETER_SETUPS_TL
  • WSH_ITM_PARTIES
  • WSH_ITM_PARTY_CONTACTS
  • WSH_ITM_REQUEST_CONTROL
  • WSH_ITM_RESPONSE_HEADERS
  • WSH_ITM_RESPONSE_LINES
  • WSH_ITM_RESPONSE_RULES
  • WSH_ITM_SERVICE_PARAMETERS
  • WSH_ITM_SERVICE_PREFERENCES
  • WSH_ITM_USER_SETUPS
  • WSH_ITM_VENDORS
  • WSH_ITM_VENDOR_PARAMETERS
  • WSH_ITM_VENDOR_SERVICES
  • WSH_ITM_VENDOR_STYLESHEETS
  • WSH_LOCATIONS
  • WSH_LOCATION_DATA_EXT
  • WSH_LOCATION_OWNERS
  • WSH_MESSAGE_ATTACHMENT
  • WSH_NEW_DELIVERIES
  • WSH_NEW_DEL_INTERFACE
  • WSH_ORG_CARRIER_SERVICES
  • WSH_ORG_CARRIER_SITES
  • WSH_PICKING_BATCHES
  • WSH_PICKING_RULES
  • WSH_PICK_GROUPING_RULES
  • WSH_PICK_SEQUENCE_RULES
  • WSH_QUERY_ASSIGNMENTS
  • WSH_REGIONS
  • WSH_REGIONS_INTERFACE
  • WSH_REGIONS_TL
  • WSH_REGIONS_TL_INTERFACE
  • WSH_REGION_LOCATIONS
  • WSH_REPORT_PRINTERS
  • WSH_REPORT_SETS
  • WSH_REPORT_SET_LINES
  • WSH_ROLES
  • WSH_ROLE_PRIVILEGES
  • WSH_SAVED_QUERIES_B
  • WSH_SAVED_QUERIES_TL
  • WSH_SERIAL_NUMBERS
  • WSH_SHIPPING_PARAMETERS
  • WSH_SHIP_CONFIRM_RULES
  • WSH_TMP
  • WSH_TRANSACTIONS_HISTORY
  • WSH_TRIPS
  • WSH_TRIPS_INTERFACE
  • WSH_TRIP_STOPS
  • WSH_TRIP_STOPS_INTERFACE
  • WSH_UPGRADE_LOG
  • WSH_UPGRADE_PLD_TMP
  • WSH_UPGRADE_SITE_TMP
  • WSH_UPGRADE_TMP
  • WSH_WMS_SYNC_TMP
  • WSH_ZONE_REGIONS