Oracle eBS經驗分享

今天有整批修改schedule_ship_date 的需求  測了一整天...

以下是實做分享：

Use Order Interface Method to Update Schedule Date.
First Step: Change the Profile :OM: Authorized To Override ATP ="Yes"

Scecond Step:Run Insert Interface Sql

First Setp: Check your order Line Source Type is "External"

Otherwide

You can run Workflow Background process manually to progress the line:
1. OM responsibility: (or System Administrator)
2. Reports, Requests>Requests: Submit
3. Workflow Background Process
4. Item Type: OM Order Line
Process Deferred: Yes
Process Timeout: Yes

 SELECT *
  FROM wf_item_activity_statuses wias, wf_process_activities wpa
  WHERE wias.process_activity = wpa.instance_id
-- AND   wpa.activity_name = 'PURCHASE RELEASE ELIGIBLE'
  AND   wias.item_type = 'OEOL'
  AND   wias.item_key  = to_char(2369510) -- order line id
-- AND   wias.activity_status = 'NOTIFIED';

--目前資料庫的語系
SELECT *
  FROM nls_database_parameters
 WHERE parameter = 'NLS_CHARACTERSET';

--查詢目前資料庫名稱
SELECT NAME
  FROM v$database;

Solution:

找出User Client 使用的jdk版本，並到該版本的Jre目錄(C:\Program Files\Java\jre1.6.0_07\bin\client\)下複製 Jvm.dll 覆蓋Jinititator 1.3.1.xx\(C:\Program Files\Oracle\JInitiator 1.3.1.28\bin\hotspot)下的 jvm.dll

ps. 請先備份原Jinititator 1.3.1.xx 下的Jvm.dll

資料提供：Diodes-Brian

or You can reference Oracle Metalink.=>

Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=290807.1

資料提供：ArimaComm-CH