Oracle eBS經驗分享

<Root Cause>

Unexpected Error: Error in Routine WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS_BULK,  Oracle Error - 1
User-Defined Exception

Cause

The issue is caused by the following setup: The Shipping Parameters were not setup for the Shipping organization.

Solution

-- To implement the solution, please execute the following steps:
1. Go into the responsibility: Order Management Super User
2. Navigate to Shipping > Setup > Shipping Parameters
3. Setup the parameters for the Shipping Organizations (orgs).
4. Retest the issue.
5. Migrate the solution as appropriate to other environments.

  SELECT l.lookup_code, l.meaning
    FROM so_lookups l
   WHERE l.lookup_type = 'FREIGHT_TERMS' AND l.enabled_flag = 'Y'
     AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, TRUNC (SYSDATE))
                             AND NVL (end_date_active, TRUNC (SYSDATE))
ORDER BY l.meaning

------------------------------------------------------------------

失效很久沒有使用的Price List : Disable not-used price list

------------------------------------------------------------------

Data link with your profile [ MO: Operating Unit ]