set serveroutput on
DECLARE
l_header_rec OE_ORDER_PUB.Header_Rec_Type;
l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
l_header_adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_Type;
l_header_scr_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
l_line_scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
l_request_rec OE_ORDER_PUB.Request_Rec_Type ;
l_return_status VARCHAR2(1000);
問題: 在查看org item存檔速度問題時, 發現ICX_CAT_ITEMS_CTX_DTLS_TLP的資料有2G, 超過1700萬筆, 因此找了purge的方法(雖然事後證實這與現有存檔速度問題無關)
作法:
1. Go into the responsibility: Purchasing.
2. Navigate to Reports / Run / Single Request
3. Execute Purge Catalog Intermedia Index (ICXPCIIP)
4. Create Index on ICX_CAT_ITEMS_CTX_DTLS_TLP
a) Creating index
create index ICX.XX_ICX_CAT_ITEMS_CTX_TLP_99 on ICX.ICX_CAT_ITEMS_CTX_DTLS_TLP (INVENTORY_ITEM_ID,ORG_ID,LANGUAGE,SEQUENCE) online compute statistics parallel 8;
b) Disabling parallel on an index (example):
ALTER INDEX ICX.XX_ICX_CAT_ITEMS_CTX_TLP_99 NOPARALLEL;
c) Gathering stats on a table (example):
Exec fnd_stats.gather_table_stats('ICX','ICX_CAT_ITEMS_CTX_DTLS_TLP',100);
Ref:
1.Performance Issue with INVIDITM.fmb or INCOIN Involving ICX_CAT_ITEMS_CTX_DTLS_TLP (Doc ID 1925118.1)
修正ra_interface_lines_all中資料以重新作autoinvoice
1.確認Auto Invoice程式未在執行中
2.清除ra_inteface_lines_all中的flag並commit
UPDATE ra_interface_lines_all
SET interface_line_id = NULL,
customer_trx_id = NULL,
request_id = NULL,
link_to_line_id = NULL,
interface_status = null
WHERE NVL (interface_status, 'x') != 'P';
3.重新執行AutoInvoice
Ref:
1.AutoInvoice: "Stuck in the Interface" issue
http://oraclapps.blogspot.com/2019/07/autoinvoice-stuck-in-interface-issue.html
2.Troubleshooting AutoInvoice: "Stuck in the Interface" issues: Interface line not created in AR and no error is showing in the interface (Doc ID 1146573.1)
針對以程式批次產出之PO PDF output, 整批進行更名並下載.
1.找出request_id與其中PO之關聯, 取得PO number
2.組出如下內容, 存檔為cp_po.sh
cp -p o172681076.out /tmp/pdf_file/3200244536.pdf
cp -p o172681077.out /tmp/pdf_file/3200244557.pdf
cp -p o172681078.out /tmp/pdf_file/3200244558.pdf
cp -p o172681079.out /tmp/pdf_file/3200244559.pdf
cp -p o172681080.out /tmp/pdf_file/3200244564.pdf
cp -p o172681081.out /tmp/pdf_file/3200244566.pdf
3.執行cp_po.sh
4.下載/tmp/pdf_file中的PDF檔案
• Yes: Journals from this source cannot be changed in the Enter Journals form nor the Journal Correction form. In addition, you cannot reverse journals with Subledger Accounting journal sources that are frozen.
• No: Journals from this source can be changed in both the Enter Journals form and the Journal Correction form. In addition, you can reverse journals with unfrozen Subledger Accounting journal sources.
• Journal Entry Page Only: Journals from this source cannot be changed in the Enter Journals form but can be changed in the Journal Correction form. In addition, you cannot reverse journals with Subledger Accounting journal sources that have this option.NOTE: It is strongly advised that you freeze the subledger source back after you reverse the journal; unfreezing subledger journal sources will allow users to reverse subledger sourced journals at will, causing reconciliation problems between General Ledger and subledgers.