不能創建會計分錄

發布時間：2020-08-09 23:34:34 來源：ITPUB博客閱讀：409 作者：xxc_weil 欄目：大數據

轉自：http://blog.csdn.net/yy5512/article/details/4404772

不能創建會計分錄
--------------------------------------------------------------------------------
打補丁:6826219和6901404

處理原理:
如果創建會計分錄失敗,只要把xla_events.event_status_code和xla_events.process_status_code都改成'U',
然后提交<<創建會計科目>>請求或者直接在**界面創建會計分錄,
創建會計分錄程序不管xla_ae_headers和xla_ae_lines是否有與xla_events相應記錄，
都會重新創建xla_ae_headers和xla_ae_lines記錄

-----------------------------------------------------------------------------
處理應付**不能創建會計分錄例子一:
create table xla_events_bkp
as select * from xla_events
where event_id in (select event_id  from xla_events e
               where e.application_id = 200
               and e.event_status_code ='P'
            and not exists ( select 1 from xla_ae_headers h
                              where e.event_id = h.event_id ));
UPDATE xla_events
SET event_status_code = 'U',
  process_status_code = 'U'
WHERE event_id IN (select event_id  from xla_events e
               where e.application_id = 200
               and e.event_status_code ='P'
               and not exists ( select 1 from xla_ae_headers h
                                 where e.event_id = h.event_id ));
運行<<創建會計科目>>請求
-----------------------------------------------------------------------------
處理應付**不能創建會計分錄例子二:
**號200803005(已取消) 部分創建會計分錄,付款號1102000006 不能創建會計分錄
因為先有**再有付款,所以思路
1.先試圖創建**的會計分錄
SELECT invoice_num,invoice_id,doc_sequence_id,doc_sequence_value FROM ap_invoices_all
WHERE invoice_num = '200803005'

select event_id,ae_header_id,a.* from xla_ae_headers a
WHERE doc_sequence_id = 130
AND doc_sequence_value = '210401983'

SELECT event_id,a.* FROM xla_ae_headers a
WHERE event_id IN (70300,80395)
找到那條xla_ae_headers記錄沒有創建會計分錄的event_id=70300,ae_header_id=57016

DELETE FROM xla_ae_lines
WHERE ae_header_id = 57016

DELETE FROM xla_ae_headers
WHERE ae_header_id = 57016

UPDATE xla_events
SET event_status_code = 'U',
  process_status_code = 'U'
WHERE event_id =  70300
運行<<創建會計科目>>請求
2.再試圖創建付款的會計分錄
SELECT * FROM xla_ae_headers
WHERE DESCRIPTION LIKE '%1102000006%'
  AND je_category_name = 'Payments'

DELETE xla_ae_lines
WHERE ae_header_id IN (101270,101271)

DELETE xla_ae_headers
WHERE ae_header_id IN (101270,101271)

UPDATE xla_events
SET event_status_code = 'U',
  process_status_code = 'U'
WHERE event_id IN (70302,80394)
運行<<創建會計科目>>請求
-----------------------------------------------------------------------------
處理應付**不能創建會計分錄例子三
ET1104應付 **號8000480849/859/862沒有創建會計分錄的原因是：
該**行１和 **行２　已放棄．

損益行中的帳戶無效。如果您已定義損益日記帳行類型，請在日記帳行定義中檢查附加至該類型的帳戶推導規則。否則，請檢查映射至會計屬性“匯兌收益帳戶”和“匯兌損失帳戶”
的來源值。
無法創建帳戶，因為 &OWNER 擁有的帳戶推導規則 &COMPONENT_NAME 的所有條件均不滿足。請更新 &COMPONENT_NAME 的條件，或分配其它帳戶推導規則至 &PAD_OWNER 擁有的
應用產品會計定義 &PAD_NAME.
子分類帳會計無法使用 &OWNER 擁有的帳戶推導規則 &COMPONENT_NAME 導出會計科目代碼組合。請復核帳戶推導規則，并確保對于為此事務處理傳送的來源值，此規則可以導出
有效的會計科目彈性域組合。

請根據以上錯誤信息，檢查　當**行被放棄時，匯兌損益相關的帳戶推導規則，映射至會計屬性“匯兌收益帳戶”和“匯兌損失帳戶”的來源值，

但是顧問沒有檢查出來設置是否有問題。這也許是oracle的一個bug.

臨時處理方法:
直接在表中刪除了放棄行的**分配行和**行
CREATE TABLE AP_INVOICE_DISTRIBUTIONS_0427
AS SELECT * FROM AP_INVOICE_DISTRIBUTIONS_all
WHERE invoice_id = 15761 and invoice_line_number IN (1,2)

SELECT * FROM AP_INVOICE_DISTRIBUTIONS_0427

CREATE TABLE AP_INVOICE_LINES_0427 as
SELECT * FROM AP_INVOICE_LINES_all
WHERE invoice_id = 15761
  AND line_number IN (1,2)

SELECT * FROM AP_INVOICE_LINES_0427

DELETE FROM AP_INVOICE_DISTRIBUTIONS_all
WHERE invoice_id = 15761 and invoice_line_number IN (1,2)

DELETE FROM AP_INVOICE_LINES_all
WHERE invoice_id = 15761
  AND line_number IN (1,2)
直接在**界面創建會計分錄

最終處理方法:建議用戶提tar由oracle官方解決
-----------------------------------------------------------------------------
處理應付**不能創建會計分錄例子四:
這張**2008030888.不能創建會計分錄的原因是沒有錄入**的分配信息
-----------------------------------------------------------------------------
處理應付**不能創建會計分錄例子五:
標準**核銷預付款**后，部分會計分錄不能創建。已入帳顯示：部分
措施:
先在**界面上驗證相關**,然后在**界面上創建會計分錄
-----------------------------------------------------------------------------
處理應付**不能創建會計分錄例子六:
駱勇平員工由于EBS bug,再導入費用報表后,產生兩個駱勇平供應商,經過刪除其中一個供應商和供應商地點后
產生的出來會計分錄信息居然還有被刪除供應商的ID,供應商地點ID
措施:
找到了xla_ae_lines.party_id(這里找到有些會計分錄的創建是根據以前會計分錄記錄來創建的,比如ref_event_id,ref_ae_header_id)
于是將xla_ae_lines.party_id,xla_ae_lines.party_site_id統統改成了現在的駱勇平供應商ID和供應商地點ID
運行cux_fix_invoice_accounting_pkg.fix_invoices程序,修正數據
運行<<創建會計科目>>請求
----------------------------------------------------------------------------
修正數據的程序包cux_fix_invoice_accounting_pkg:
CREATE OR REPLACE PACKAGE cux_fix_invoice_accounting_pkg IS
  PROCEDURE fix_invoices(p_invoice_id IN NUMBER);
  PROCEDURE fix_payments(p_payment_num IN VARCHAR2);
END;
/
CREATE OR REPLACE PACKAGE BODY cux_fix_invoice_accounting_pkg IS
  PROCEDURE fix_invoices(p_invoice_id IN NUMBER) IS
CURSOR cur_invoice(i_cur_invoice_id IN NUMBER) IS
   SELECT doc_sequence_id,doc_sequence_value FROM ap_invoices_all
      WHERE invoice_id = i_cur_invoice_id;
CURSOR cur_xla_ae_headers(i_cur_doc_sequence_id IN NUMBER,i_cur_doc_sequence_value IN NUMBER) IS
   SELECT event_id,ae_header_id from xla_ae_headers
   WHERE doc_sequence_id = i_cur_doc_sequence_id
      AND doc_sequence_value = i_cur_doc_sequence_value;
  BEGIN
FOR rec_invoice IN cur_invoice(p_invoice_id) LOOP
   FOR rec_xla_ae_headers IN cur_xla_ae_headers(rec_invoice.doc_sequence_id,rec_invoice.doc_sequence_value) LOOP
      INSERT  INTO xla_ae_lines080421
      SELECT * FROM xla_ae_lines
         WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
      INSERT INTO xla_ae_headers080421
      SELECT * FROM xla_ae_headers
      WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
      DELETE xla_ae_lines
      WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
      DELETE xla_ae_headers
      WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
   END LOOP;
END LOOP;

UPDATE xla_events
SET event_status_code = 'U',process_status_code = 'U'
WHERE event_id IN (SELECT event_id  FROM xla_events e
                     WHERE e.application_id = 200
                        AND e.event_status_code ='P'
                        AND NOT EXISTS (SELECT 1 FROM xla_ae_headers h
                                          WHERE e.event_id = h.event_id ));
COMMIT;
  END;

  PROCEDURE fix_payments(p_payment_num IN VARCHAR2) IS
CURSOR cur_xla_ae_headers(i_cur_payment_num IN NUMBER) IS
   SELECT event_id,ae_header_id from xla_ae_headers
   WHERE description LIKE '%'||i_cur_payment_num||'%'
      AND je_category_name = 'Payments';
  BEGIN
FOR rec_xla_ae_headers IN cur_xla_ae_headers(p_payment_num) LOOP
   INSERT  INTO xla_ae_lines080421
      SELECT * FROM xla_ae_lines
      WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
   INSERT INTO xla_ae_headers080421
      SELECT * FROM xla_ae_headers
      WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
   DELETE xla_ae_lines
      WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
   DELETE xla_ae_headers
      WHERE ae_header_id = rec_xla_ae_headers.ae_header_id;
END LOOP;

UPDATE xla_events
SET event_status_code = 'U',process_status_code = 'U'
WHERE event_id IN (SELECT event_id  FROM xla_events e
                     WHERE e.application_id = 200
                        AND e.event_status_code ='P'
                        AND NOT EXISTS (SELECT 1 FROM xla_ae_headers h
                                          WHERE e.event_id = h.event_id ));
COMMIT;
  END;
END;
/
--=============================================================================
處理應收事務處理不能創建會計分錄例子:
貸項通知單11040000002921不能創建會計分錄

通過界面找到貸項通知單11040000002921對應的原始**11040000002801,
發現11040000002801沒有創建會計分錄,在界面上將11040000002801創建會計分錄成功。

貸項通知單11040000002921按完成按鈕后,發現不能保存,做跟蹤約束值,
發現跟蹤文件的最后幾句
*******************************************************************************

SELECT AE.EVENT_ID , AE.EVENT_DATE , AE.EVENT_STATUS_CODE, AE.EVENT_TYPE_CODE
FROM
XLA_EVENTS AE, XLA_TRANSACTION_ENTITIES_UPG XT, RA_CUSTOMER_TRX_ALL TRX
  WHERE TRX.CUSTOMER_TRX_ID = :B3 AND NVL(XT.SOURCE_ID_INT_1,-99) =
  TRX.CUSTOMER_TRX_ID AND XT.ENTITY_CODE = 'TRANSACTIONS' AND XT.LEDGER_ID =
  TRX.SET_OF_BOOKS_ID AND XT.ENTITY_ID = AE.ENTITY_ID AND XT.APPLICATION_ID =
  222 AND AE.APPLICATION_ID = 222 AND NVL(AE.EVENT_DATE, TO_DATE('01-01-1900',
  'DD-MM-YYYY')) = :B2 AND AE.EVENT_STATUS_CODE <> 'P' AND :B1 =
  AE.EVENT_TYPE_CODE

call    count    cpu elapsed    disk    query current       rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       1    0.00    0.00       0       0       0          0
Execute    1    0.00    0.00       0       0       0          0
Fetch       1    0.00    0.00       0       11       2          1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       3    0.00    0.00       0       11       2          1

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44    (recursive depth: 1)
*******************************************************************************

SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY,
  SEVERITY
FROM
FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 =
  M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID =
  A.APPLICATION_ID

call    count    cpu elapsed    disk    query current       rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       0    0.00    0.00       0       0       0          0
Execute    1    0.00    0.00       0       0       0          0
Fetch       1    0.00    0.00       0       0       0          0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       2    0.00    0.00       0       0       0          0

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 44    (recursive depth: 1)
********************************************************************************

ROLLBACK TO AR_PAYMENT_SCHEDULE

SELECT AE.EVENT_ID , AE.EVENT_DATE , AE.EVENT_STATUS_CODE, AE.EVENT_TYPE_CODE FROM XLA_EVENTS AE, XLA_TRANSACTION_ENTITIES_UPG XT, RA_CUSTOMER_TRX_ALL TRX WHERE TRX.CUSTOMER_TRX_ID = :B3 AND NVL(XT.SOURCE_ID_INT_1,-99) = TRX.CUSTOMER_TRX_ID AND XT.ENTITY_CODE = 'TRANSACTIONS' AND XT.LEDGER_ID = TRX.SET_OF_BOOKS_ID AND XT.ENTITY_ID = AE.ENTITY_ID AND XT.APPLICATION_ID = 222 AND AE.APPLICATION_ID = 222 AND NVL(AE.EVENT_DATE, TO_DATE('01-01-1900','DD-MM-YYYY')) = :B2 AND AE.EVENT_STATUS_CODE <> 'P' AND :B1 = AE.EVENT_TYPE_CODE
END OF STMT
PARSE #358:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=4237611529714
BINDS #358:
kkscoacd
Bind#0
  oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
  oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
  kxsbbbfp=110ad52a0  bln=22  avl=04  flg=09
  value=22716
Bind#1
  oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
  oacflg=13 fl2=206001 frm=00 csi=00 siz=8 off=0
  kxsbbbfp=110ad52d0  bln=07  avl=07  flg=09
  value="5/23/2008 0:0:0"
Bind#2
  oacdty=01 mxl=32(09) mxlc=00 mal=00 scl=00 pre=00
  oacflg=13 fl2=206001 frm=01 csi=871 siz=32 off=0
  kxsbbbfp=110ad4a60  bln=32  avl=09  flg=09
  value="CM_CREATE"
將具體參數值代入sql語句，得到:
SELECT AE.EVENT_ID, AE.EVENT_DATE, AE.EVENT_STATUS_CODE, AE.EVENT_TYPE_CODE
  FROM XLA_EVENTS                AE,
   XLA_TRANSACTION_ENTITIES_UPG XT,
   RA_CUSTOMER_TRX_ALL       TRX
WHERE TRX.CUSTOMER_TRX_ID = 22716
AND NVL(XT.SOURCE_ID_INT_1, -99) = TRX.CUSTOMER_TRX_ID
AND XT.ENTITY_CODE = 'TRANSACTIONS'
AND XT.LEDGER_ID = TRX.SET_OF_BOOKS_ID
AND XT.ENTITY_ID = AE.ENTITY_ID
AND XT.APPLICATION_ID = 222
AND AE.APPLICATION_ID = 222
AND NVL(AE.EVENT_DATE, TO_DATE('01-01-1900', 'DD-MM-YYYY')) = to_date('2008-05-23 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND AE.EVENT_STATUS_CODE <> 'P'
AND 'CM_CREATE'= AE.EVENT_TYPE_CODE
也就是說在按完成按鈕是不應該出現以上SQL語句有值,即XLA_EVENTS.EVENT_STATUS_CODE <> 'P'的記錄應該不存在

措施:
1.AE.EVENT_STATUS_CODE,ae.process_status_code暫時都改為'P',
然后再按完成按鈕,這次保存成功。

2.將AE.EVENT_STATUS_CODE,ae.process_status_code都改回'U',
檢查 xla_ae_headers,xla_ae_lines是否有數據,
SELECT * FROM xla_ae_headers--no row
WHERE event_id IN (162517,162518)
SELECT * FROM xla_ae_lines--no row
在界面上將11040000002801創建會計分錄成功

向AI問一下細節

中文字幕av专区_日韩电影在线播放_精品国产精品久久一区免费式_av在线免费观看网站

不能創建會計分錄

猜你喜歡

中文字幕av专区_日韩电影在线播放_精品国产精品久久一区免费式_av在线免费观看网站

不能創建會計分錄

猜你喜歡

最新資訊

相關推薦

相關標簽