Mass Additions Create,AP 拋 INVOICE 到FA 時不成功 的應對

/* AP 拋 INVOICE 到FA 時， RUNING ： Mass Additions Create? 這個RUN到最後是ERROR 有如下提示： **Ends**03-MAY-2011 16:38:01 ORA-01403: no data found occurred in ->Get_PO_Account_Segment with parameters (P_base_ccid: 260733,P_po_distribution_id: 5380082,P_coa_id: 101) 用以下SQL可以查到是哪筆AP 然後對這筆AP進行處理: 將distributionS中的assets_tracking_flag改為非V的. */ select a.invoice_id,a.invoice_num,a.accts_pay_code_combination_id,a.invoice_amount, a.invoice_currency_code,a.invoice_date,a.invoice_type_lookup_code, a.description,b.accounting_date,b.accrual_posted_flag,b.assets_addition_flag, b.assets_tracking_flag,b.distribution_line_number,b.dist_code_combination_id, b.amount,po_distribution_id from AP_INVOICES_all a,AP_INVOICE_DISTRIBUTIONS_all b where a.set_of_books_id=2 and a.org_id=801 --and a.invoice_num='20083464-228488' and b.invoice_id=a.invoice_id and b.dist_code_combination_id=260733 and po_distribution_id=5380082 and invoice_date>sysdate-30[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/92289/viewspace-1049464/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/92289/viewspace-1049464/