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 CODECONCURRENT PROGRAM NAME
WSHDSNODeparture Ship Notice Outbound
WSHINVISInterface Interface – SRS
WSHINVIInventory Interface
WSHOMISOrder Management Interface – SRS
WSHRDXCPShipping Exceptions Report
WSHRDVLDVehicle Load Sheet Details
WSHRDVLSVehicle Load Sheet Summary
WSHRDBSRBackorder Summary Report
WSHRDBDRBackorder Detail Report
WSHRDLABMailing Label
WSHRDPAKPacking Slip Report
WSHRDINVCommercial Invoice
WSHRDMBLMaster Bill of Lading
WSHRDBOLBill of Lading
WSHIDLImport into Delivery Lines
WSHRDPIKPick Slip Report
WSHPSRSGenerate Selection List for Pick Release by Standard Report Submission
WSHPSGLGenerate selection list for pick release
WSHOMIOrder Management Interface
WSHINVIASInterface All Trip Stops – SRS
WSHINVIAInterface All Trip Stops
WSHINTERFACESInterface Trip Stop – SRS
WSHINTERFACEInterface Trip Stop
WSHLRMALocation to Region Mapping
WSHRGINTRegion Interface
WSHAFCTDAssign Freight Cost to Deliveries
WSHRDASCAuto Ship Confirm Report
WSHAPDSRSAuto-Pack Deliveries -SRS
WSHASCSRSAutomated Ship Confirm – SRS
WSHRDAPKAuto-pack Report
WSHRDSDLShipped Delivery Lines Report
WSHMAPCDImport Shipping Locations – Child
WSHAUMNAutomated Shipment Request/Shipment Advice
WSHMLOCRImport Shipping Locations
CCLAUNCHERProgram to launch Clearcross Adapter
WSHRDOPNOpen Deliveries Report
CCSHUTDOWNProgram to shut down clearcross adapter
WSHADOVRSkip Service Request/Response
WSHRDASTAdapter Status Report
WSHGTCSTStartup ITM Adapter
WSHGTCSHShutdown ITM Adapter
WSHADRESResubmit Service Request/Response
WSHITOVRSkip Screening
WSHITRESSkip Screening
WSHRDISTITM Adapter Status Report
ITMSTARTUPProgram to launch ITM Adapter
ITMSHUTDOWNProgram to shutdown ITM Adapter
WSHITESBSubmission of Deliveries to ITM for Export Compliance Screening
WSHPDSRSProcess Deliveries SRS Program
WSH_ITM_ITEM_SYNCITM Item Synchronization
WSH_ITM_PARTY_SYNCITM Party Synchronization
WSHPFUPPrint Freight Codes to be Upgraded
WSHFRUCLFreight Upgrade Closed Orders
WSHUPFCLUpgrade Freight Carriers (Closed Orders)
WSHUPDATESMUpdate Ship Methods
WSHLRMCDLocation To Region Mapping – Child
WSHMDCWSH Multi Delivery Consolidation Program
WSHRDLABXMailing Label PDF Output
WSHRDVLSXVehicle Load Sheet Summary PDF Output
WSHRDBOLXBill of Lading PDF Output
WSHRDMBLXMaster Bill of Lading PDF Output
WSHRDINVXCommercial Invoice PDF Output
WSHRDPAKXPacking Slip Report PDF Output
WSHRDPIKXPick Slip Report PDF Output
WSHPURGEProgram to purge shipping entities
WSHPSGL_SUBGenerate selection list for pick release child process
WSHOTMRLPlanned Shipment Interface
WSHTMCARSynchronize Carriers/Carrier Sites with Transportation Management
WSHOOCHLShipping-Transportation outbound interface – Child
WSHOOINTShipping-Transportation Outbound Interface
WSHRDVLSX_XMLVehicle Load Sheet Summary PDF Output
WSHRDXCP_XMLShipping Exceptions Report
WSHRDASC_XMLAuto Ship Confirm Report (XML)
WSHRDBDR_XMLBackorder Detail Report
WSHRDBOL_XMLBill of Lading
WSHRDBOLX_XMLBill of Lading PDF Output
WSHRDBSR_XMLBackorder Summary Report
WSHRDINV_XMLCommercial Invoice
WSHRDINVX_XMLCommercial Invoice PDF Output
WSHRDIST_XMLITM Adapter Status Report
WSHRDLAB_XMLMailing Label
WSHRDLABX_XMLMailing Label PDF Output
WSHRDMBL_XMLMaster Bill of Lading
WSHRDMBLX_XMLMaster Bill of Lading PDF Output
WSHRDOPN_XMLOpen Deliveries Report
WSHRDPAK_XMLPacking Slip Report
WSHRDPAKX_XMLPacking Slip Report PDF Output
WSHRDPIK_XMLPick Slip Report
WSHRDPIKX_XMLPick Slip Report PDF Output
WSHRDSDL_XMLShipped Delivery Lines Report
WSHRDVLD_XMLVehicle Load Sheet Details
WSHRDVLS_XMLVehicle Load Sheet Summary
WSHRDAPK_XMLAuto-pack Report (XML)
WSHSRINBProcess 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