Oracle ERP R12. 密碼複雜度檢查機制開啟-Password complexity checks

一般公司為配合資安政策會要求User自行設定的密碼必需有一定程度的複雜性.
以下是Oracle ERP 啟用複雜性檢查的Profile

Profile : Signon Password Hard To Guess 設定為 Yes

其複雜性檢查邏輯如下 :
1. The password contains at least one letter and at least one number.
2. The password does not contain the username.
3. The password does not contain repeating characters

Oracle ERP R12. - Resubmitting WIP_MOVE_TXN_INTERFACE

Resubmitting Failed Move Transactions

若WIP_MOVE_TXN_INTERFACE執行失敗後,經修正完錯誤原因後,要重新執行的Update 語法如下 :


UPDATE WIP_MOVE_TXN_INTERFACE A
   SET A.GROUP_ID = NULL,
       A.TRANSACTION_ID = NULL,
       A.PROCESS_STATUS = 1
 WHERE A.TRANSACTION_ID = <要重新執行的那些資料>


參考文件 : Oracle - Resolving Period Close Pending Transaction

Oracle ERP R12. - Resubmitting Pending Material Transactions

若有些交易卡在MTL_TRANSACTION_INTERFACE,並在修正完錯誤資料欄位,想透過Update interface的方式來重新執行,其Update 語法如下 :


UPDATE MTL_TRANSACTIONS_INTERFACE A
   SET A.PROCESS_FLAG = 1,
       A.LOCK_FLAG = 2,
       A.TRANSACTION_MODE = 3,
       A.ERROR_CODE = NULL
 WHERE A.PROCESS_FLAG = 3 --ERROR


Ps. 但一般仍建議由Oracle Standard 的Transaction Interface功能(INVTVPTX)來Resubmit

參考文件 : Oracle - Resolving Period Close Pending Transaction

Oracle ERP R12. - Resubmitting WIP_COST_TXN_INTERFACE

Resubmitting Failed or Pending Resource Transactions

若工單過站charge resource交易的成本收集失敗,其交易會卡在WIP_COST_TXN_INTERFACE,並會造成無法關結期間.
重新執行的Update語法如下:


UPDATE WIP_COST_TXN_INTERFACE A
   SET A.GROUP_ID = NULL,
       A.TRANSACTION_ID = NULL,
       A.REQUEST_ID = NULL,
       A.PROCESS_STATUS = 1
 WHERE A.PROCESS_STATUS = 3 --Error


參考文件 : Oracle - Resolving Period Close Pending Transaction

Oracle ERP R12. - Resubmitting MTL_MATERIAL_TRANSACTIONS's Uncosted transactions

Resubmitting Uncosted Transactions

若MTL_MATERIAL_TRANSACTIONS有些交易執行Cost Manager失敗,導致該交易的成本未收集到,並影响關帳,其重新執行的Update 語法如下:


UPDATE MTL_MATERIAL_TRANSACTIONS A
   SET A.COSTED_FLAG = 'N',
       A.TRANSACTION_GROUP_ID = NULL
 WHERE A.COSTED_FLAG IS NOT NULL


參考文件 : Oracle - Resolving Period Close Pending Transaction