目前分類:OM:Order Management (46)

瀏覽方式: 標題列表 簡短摘要
  • Transportation Execution Module Tables (FTE)
    • Version 11.5.10.2
      FTE_BULKLOAD_DATA
      FTE_BULKLOAD_FILE
      FTE_DELIVERY_PROOF
      FTE_FACILITY_CARRIERS
, , ,

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Demo on New features 12.1.1 In Internal Sales Orders – Internal Requisitions Flow [ID 883508.1]


SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

How to Generate the COGS Account from the Order Type [ID 414314.1]


Modified 26-NOV-2010     Type BULLETIN     Status PUBLISHED

In this Document
Purpose
Scope and Application
How to Generate the COGS Account from the Order Type

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Intercompany IR/ISO => OM: Generate Cost of Goods Sold Account

Intercompany SO => OM : Generate Cost of Goods Sold Account

Standard SO => OM : Generate Cost of Goods Sold Account


,

SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

image

,

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Which parameter names are supported in Shipping Document sets ? [ID 1079914.1]

SELECT
        decode(
          lower(decode(l_execution_method_code, 'P', srw_param, 'K', srw_param, end_user_column_name)), --Bugfix 7493868 Modified decode
          'p_request_id',             to_char(l_doc_set_params(i).p_request_id), -- bug 1589045

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

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

image 

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

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

  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))

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

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

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

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

DECLARE
   gpr_return_status             VARCHAR2 (1) := NULL;
   gpr_msg_count                 NUMBER := 0;
   gpr_msg_data                  VARCHAR2 (2000);
   gpr_price_list_rec            qp_price_list_pub.price_list_rec_type;
   gpr_price_list_val_rec        qp_price_list_pub.price_list_val_rec_type;
   gpr_price_list_line_tbl       qp_price_list_pub.price_list_line_tbl_type;
   gpr_price_list_line_val_tbl   qp_price_list_pub.price_list_line_val_tbl_type;
   gpr_pricing_attr_tbl          qp_price_list_pub.pricing_attr_tbl_type;
   gpr_pricing_attr_val_tbl      qp_price_list_pub.pricing_attr_val_tbl_type;
   ppr_price_list_rec            qp_price_list_pub.price_list_rec_type;
   ppr_price_list_val_rec        qp_price_list_pub.price_list_val_rec_type;
   ppr_price_list_line_tbl       qp_price_list_pub.price_list_line_tbl_type;
   ppr_price_list_line_val_tbl   qp_price_list_pub.price_list_line_val_tbl_type;
   ppr_pricing_attr_tbl          qp_price_list_pub.pricing_attr_tbl_type;
   ppr_pricing_attr_val_tbl      qp_price_list_pub.pricing_attr_val_tbl_type;
   ppr_qualifiers_tbl            qp_qualifier_rules_pub.qualifiers_tbl_type;
   ppr_qualifiers_val_tbl        qp_qualifier_rules_pub.qualifiers_val_tbl_type;
   gpr_qualifiers_tbl            qp_qualifier_rules_pub.qualifiers_tbl_type;
   gpr_qualifiers_val_tbl        qp_qualifier_rules_pub.qualifiers_val_tbl_type;
  ------------=------------------------------==-------------------------
  -- Batch Inactive Price List which was not used from 01-JAN-2010
  -- Condition : Currency in (USD and TWD)
  ------------=------------------------------==-------------------------
   CURSOR cur_tmp
   IS
        SELECT t.list_header_id,
               t.NAME,
               b.active_flag,
               b.START_DATE_ACTIVE,
               b.END_DATE_ACTIVE,
               (SELECT user_name
                  FROM fnd_user
                 WHERE user_id = b.created_by)
                  created_by,
               b.creation_date
          FROM qp_list_headers_tl t, qp_list_headers_b b
         WHERE b.list_header_id = t.list_header_id
           AND t.LANGUAGE = 'US'
           --AND t.NAME NOT LIKE '%sample%'
           AND b.active_flag = 'Y'
           AND b.currency_code IN ('USD', 'TWD')
           AND b.list_type_code = 'PRL'
           AND NVL (b.END_DATE_ACTIVE, SYSDATE) >= SYSDATE
           AND NOT EXISTS
                      (SELECT 1
                         FROM oe_order_lines_all
                        WHERE price_list_id = b.list_header_id
                          AND creation_date >= TO_DATE ('20100101', 'yyyymmdd')
                          AND cancelled_flag = 'N')
           AND t.creation_date <= TO_DATE ('20100101', 'yyyymmdd')
      ORDER BY b.creation_date;
BEGIN
   DBMS_OUTPUT.put_line (
      'Start to batch inactive price list book on '
      || TO_CHAR (SYSDATE, 'YYYY/MM/DD HH24:mi:ss'));

   FOR rec_tmp IN cur_tmp
   LOOP
      gpr_return_status := NULL;
      gpr_price_list_rec.operation := qp_globals.g_opr_update;
      gpr_price_list_rec.list_header_id := rec_tmp.list_header_id;
      gpr_price_list_rec.active_flag := 'N';
      gpr_price_list_rec.end_date_active := TRUNC (SYSDATE);

      BEGIN
         -- DBMS_OUTPUT.put_line ('process_price_list');
         qp_price_list_pub.process_price_list (
            p_api_version_number        => 1,
            p_init_msg_list             => fnd_api.g_false,
            p_return_values             => fnd_api.g_false,
            p_commit                    => fnd_api.g_false,
            x_return_status             => gpr_return_status,
            x_msg_count                 => gpr_msg_count,
            x_msg_data                  => gpr_msg_data,
            p_price_list_rec            => gpr_price_list_rec,
            p_price_list_line_tbl       => gpr_price_list_line_tbl,
            p_pricing_attr_tbl          => gpr_pricing_attr_tbl,
            x_price_list_rec            => ppr_price_list_rec,
            x_price_list_val_rec        => ppr_price_list_val_rec,
            x_price_list_line_tbl       => ppr_price_list_line_tbl,
            x_price_list_line_val_tbl   => ppr_price_list_line_val_tbl,
            x_qualifiers_tbl            => ppr_qualifiers_tbl,
            x_qualifiers_val_tbl        => ppr_qualifiers_val_tbl,
            x_pricing_attr_tbl          => ppr_pricing_attr_tbl,
            x_pricing_attr_val_tbl      => ppr_pricing_attr_val_tbl);
      EXCEPTION                                           --2009/02/10 Tinalee
         WHEN OTHERS
         THEN
            --   DBMS_OUTPUT.put_line ('  3*] Process Exception =>' || SQLERRM);
            gpr_return_status := 'Error';
      END;

      IF gpr_return_status <> fnd_api.g_ret_sts_success
      THEN
         ROLLBACK;                 -- must rollback insert data ... no mark !!
         gpr_msg_data :=
            oe_msg_pub.get (p_msg_index => gpr_msg_count, p_encoded => 'F');
         DBMS_OUTPUT.put_line (
               '   Error Message::=>id='
            || rec_tmp.list_header_id
            || '-'
            || SUBSTR (gpr_msg_data, 1, 239));
      ELSE
         --  DBMS_OUTPUT.put_line ('Success');
         COMMIT;
      END IF;
   END LOOP;
END;

, , ,

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Carrier Setup

image

Where to maintain {service level}

Find Lookup Code from Shipping Execution applicaiton.

  • Lookup Code : WSH_SERVICE_LEVELS
  • Meaning : Carrier Service Levels

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Issue Description

We cannot use “Workflow Status” when we using new responsility of OM but we can see the function at Toolbar.

image

Solution

Add below functions into your new responsilibity menu.

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Function Name : View Detailed Shipping Status

image

image


SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Responsibility: OM Super User
image

Navigator : Shipping > Setup > Regions and Zones > Regions and Zones 

Issue description : I cannot choose any value from Country List-of-value at Regions and Zones form.

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

This may be any positive integer numeric value.
When a line is scheduled it is also automatically reserved whenever the schedule
date is within the reservation time fence.

image

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

OM System Parameters

image


SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

UPDATE  wsh_delivery_details wdd
SET     released_status = 'D'
       ,src_requested_quantity = 0
       ,src_requested_quantity2 = decode (src_requested_quantity2
                                         ,NULL

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Document : Pricing Data Bulk Loader API

翻譯 By me…

Overview

這份文件是用來說明”Pricing Data Bulk Loader API”功能的概要。這個功能可以用在Base Pricing 與Advanced Pricing.對於Base Pricing 設置, 只需要提供基本要匯入系統的Pricing 資料即可;”Pricing Data Bulk Loader API”是由一組Interface tables 與一個Concurrent Program 組成。所有的檢核工作與預設值都會在資料被inserte,deleted or updated前就完成,系統會自動把以經成功轉入的資料從Interface Table清除。

Purpose of introducing this API

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

We hold on order line.

Order Line –>Action > Additional Line Information.

image


SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

When user do book ,system display error“Order-level sales credit total () must equal 100%.”

image

WHY

image

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

怎麼找”Generate Constraints Validation Packages”會產生的package

image

Generate validation package 是抓取”Validation Template”的設定

The generated validation packages all live in the apps schema.

The easiest way to get the name of your package(s) is from the validation_pkg column of the oe_pc_validation_pkgs table. The format is:

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

1 23