Oracle EBS: 用於處理OM order之API

Oracle EBS: 用於處理OM order之API

OE_ORDER_PUB.Process_order(

Standard Parameters

Specific Parameters)

 

功能包括:

CREATE

UPDATE

Reserve

Unreserve

Split line

Delete

Book order

Apply hold

Release hold

Ref:

1.Process Order API In Order Management (Doc ID 746787.1)

Oracle EBS: OM的transaction type是否有API可用?

Q: OM的transaction type是否有API可用?

A: 沒有, 若要update, 可以直接改table, 但對於新增, 尚未能確定要寫入哪些table, 或許可以只處理以下兩個table:

OE_TRANSACTION_TYPES_ALL.

OE_TRANSACTION_TYPES_TL.

Ref:

1.API for creating transaction type in order management in r12

https://community.oracle.com/mosc/discussion/4297735/api-for-creating-transaction-type-in-order-management-in-r12

Oracle EBS: Receipt Routing概述

 Receipt Routing常看到, 但沒特別注意有什麼差別. 既然有人問了, 就來查查.

依原始說明資料:

Direct Delivery: 收貨後直接入庫, 在同一筆交易中

Standard Receipt: 收貨與入庫是各自獨立的交易, 入庫前可作檢驗或轉倉

Inspection Required: 收貨後進行檢驗, 另一筆獨立交易作入庫

--

Direct Delivery

Shipments are received into a receiving location and put away in the same transaction. Put away happens automatically upon receipt creation.

Standard Receipt

Shipments are received into a receiving location and then put away in a separate transaction. Standard receipts can be inspected or transferred before put away.

Inspection Required

Shipments are received into a receiving location and then inspected and put away in separate transactions. You can accept or reject material during the inspection, and put away to separate locations, based on the inspection result.

Ref:

1.Receipt Routing

https://docs.oracle.com/en/cloud/saas/supply-chain-management/23a/famli/receipt-routing.html#s20029748

EXCEL: 解決 UTF-8 編碼 CSV 檔案出現亂碼問題

解決 UTF-8 編碼 CSV 檔案出現亂碼問題

STEP 1: 在 Excel 中選擇「資料」頁籤中的「從文字/CSV匯入」。

STEP 2: 選擇自己的 CSV 檔案。

STEP 3: 實際匯入資料之前可以先預覽資料的狀況，預設的編碼方式是 Big5，要選擇正確的編碼才能得到正確的資料。

STEP 4: 如果是 UTF-8 編碼的 CSV 檔案，就選擇「65001: Unicode (UTF-8)」這個編碼方式。

STEP 5: 如果選擇的編碼正確，就可以看到實際的資料了，如果分隔符號不是逗號，也可以在這裡調整。確認資料沒問題之後，按下「載入」即可匯入資料。

STEP 6: 這是搭配正確的編碼，將 UTF-8 資料匯入的結果。

Ref:

1.Excel 解決 UTF-8 編碼 CSV 檔案出現亂碼問題教學

https://officeguide.cc/excel-import-csv-file-with-utf8-big5-encoding-tutorial-examples/

Oracle EBS: 客製的 Oracle Form 查不出使用記錄

問題: 客製的 Oracle Form 多數查不出使用記錄, 只有少數Form有記錄

原因: 客製的Form需要在 Pre-Form 中註明 Form name 跟 Application , 才會被加入使用記錄中

Oracle EBS: 查詢 Oracle Form 使用記錄

 查詢 Oracle Form 使用記錄

開啟 Oracle EBS 表單使用紀錄，且從DB查詢資料

SELECT ff.form_name,

fu.user_name,

he.full_name,

fl.start_time,

fl.end_time,

fl.pid,

fl.spid

FROM fnd_login_resp_forms flrf,

fnd_logins fl,

fnd_form ff,

fnd_user fu,

hr_employees he

WHERE ff.form_name = 'XXOMF005'

AND fl.start_time = TO_DATE('20110101', 'yyyymmdd')

AND fu.user_id = fl.user_id

AND flrf.login_id = fl.login_id

AND ff.form_id = flrf.form_id

AND he.employee_id(+) = fu.employee_id

ORDER BY start_time;

Notice:

需要將 profile: Sign-On:Audit Level 設成為 FORM , FND_LOGIN_RESP_FORMS 才會有資料
修改 profile Oracle AP 要重新啟動才會生效

Ref:

1. 查詢 Oracle Form 使用記錄

https://j178.mtgbb.com/?p=5

2. 找出180天內新增Form的使用次數

https://blog.twtnn.com/2017/04/ebs180form.html

3. {How TO} 誰曾經使用某個Form的紀錄?

https://somebabytina.pixnet.net/blog/post/11181884

Oracle EBS: reopen closed Inventory period

 標準功能不支援, 但可用SQL達成

--

DISCLAIMER: THE RE-OPENING OF A CLOSED INVENTORY PERIOD COULD POTENTIALLY CAUSE DATA CORRUPTION AND ANY DATA CORRUPTION CAUSED BY RE-OPENING A CLOSED INVENTORY PERIOD WILL BE THE RESPONSIBILITY OF THE CUSTOMER AND NO DATA FIX WILL BE PROVIDED FOR ANY DATA CORRUPTION THAT HAS BEEN CAUSED BY RE-OPENING A CLOSED PERIOD.

TEST THOROUGHLY ALL SCRIPTS ON A NON-PRODUCTION INSTANCE, FIRST BACKING UP ALL TABLE DATA PRIOR TO IMPLEMENTING IN PRODUCTION.

IF THERE IS CONCERN THAT RE-OPENING A CLOSED PERIOD MAY CAUSE DATA CORRUPTION PLEASE OPEN AN SR WITH ORACLE SUPPORT PRIOR TO RE-OPENING A CLOSED PERIOD.

-- A script to list all inventory periods for a specific organization

-- A script to reopen closed inventory accounting periods

-- The script will reopen all inventory periods for the specified 

-- Delete scripts to remove the rows created during the period close process to prevent duplicate rows

-- organization starting from the specified accounting period. 

-- The organization_id can be obtained from the MTL_PARAMETERS table. 

-- The acct_period_id can be obtained from the ORG_ACCT_PERIODS table.

1. Backup the following tables:

 org_acct_periods, mtl_period_summary, mtl_period_cg_summary, mtl_per_close_dtls and cst_period_close_summary.

 

2. SELECT acct_period_id period, open_flag, period_name name,

period_start_date, schedule_close_date, period_close_date

FROM org_acct_periods

WHERE organization_id = &org_id

order by 1,2;

3. UPDATE org_acct_periods

SET open_flag = 'Y',

period_close_date = NULL,

summarized_flag = 'N'

WHERE organization_id = &&org_id

AND acct_period_id >= &&acct_period_id;

DELETE mtl_period_summary

WHERE organization_id = &org_id

AND acct_period_id >= &acct_period_id;

DELETE mtl_period_cg_summary

WHERE organization_id = &org_id

AND acct_period_id >= &acct_period_id;

DELETE mtl_per_close_dtls

WHERE organization_id = &org_id

AND acct_period_id >= &acct_period_id;

DELETE cst_period_close_summary

WHERE organization_id = &org_id

AND acct_period_id >= &acct_period_id;

4. commit

5.Re-summarize all periods after problematic period again in order by running 'Period Close Reconciliation Report'.

Note:

The tables,  mtl_period_summary, mtl_period_cg_summary and mtl_per_close_dtls are designed in 11i. After R12 upgrade they were not used.

But as the script is available from earlier days, those tables were kept like that without deleting from the resummarization script.

they can ignore these tables  now.

The table cst_period_close_summary is the only table used in R12. The PCRR report picks the records from this table.

Ref:

1.Re-Open a Closed Inventory Accounting Period (Doc ID 472631.1)

Oracle EBS: 開啟Oracle Reports出現閃退問題

 問題: 開啟Oracle Reports出現閃退問題

原因: 可能有用過其他編碼儲存過檔案

解法: 新增環境變數

NLS_LANG = AMERICAN_AMERICA.UTF8

補充:

1.檔案路徑名稱不可有中文

2.若有在client端執行的Form , 中文會變亂碼