Import Standard Purchase Order (标准ＰＯ订单导入接口)ＢＵＧ集合(1)

this week , I was puzzled by this PO interface program .Up to now , I find two big bugs in this program . 希望不再发现任何bug in this program .也希望不再有Import Standard Purchase Order (标准ＰＯ订单导入接口)ＢＵＧ集合(2)

Oracle , 原来你的代码也这样地烂......

bug 1:Import Standard Purchase Order , Find 'REJECTED' in po_headers_interface table , But couldn't find records in PO_interface_errors

bug2:ORA-1403 ORA-6512

DECLARE*ERROR at line 1:ORA-01403: no data foundORA-06512: at line 55

bug 1:Import Standard Purchase Order , Find 'REJECTED' in po_headers_interface table , But couldn't find records in PO_interface_errors

我看了PO_DOCS_INTERFACE_SV5,找了两天 ,问题在这里

IF (x_header_processable_flag <> 'Y') THEN -- Bug 3428196
X_progress := '190';
ROLLBACK TO SAVEPOINT header_record_savepoint;

UPDATE po_headers_interface
SET process_code = 'REJECTED'
WHERE interface_header_id = X_headers_interface.interface_header_id;

END IF; -- x_header_processable_flag <> 'Y'

这里没有向po_interface_errors 里面写数据.但是如果完全弄明白x_header_processable_flag 为什么变成了'N'还需要时间把相关地几个包读明白.时间不允许了,后来干脆把line 也导进去,死马当活马医.

解决办法 ,不能只导入PO HEADERS ,如果单独导po headers ,会出现这个错误

如果不可以单独导po headers , oracle 应该在documention 里面注明!可是现在oracle 在.10连接口文档都不加了,shit

bug2:ORA-1403 ORA-6512

DECLARE*ERROR
at line 1:ORA-01403: no data found
ORA-06512: at line 55

首先骂一下,oracle 不能把错误文件写到output file 里面.output 是不该给用户看的,应该放到log 里面

其次,ora-1403是个极其常见的错误，一般写隐性cursor（select into ）才会出现这个错误，如果写程序连这个都考虑不到，可以说水平比较差，可是这却是oracle写的，Oracle ，让我怎么信仰你？！

解决方法：

Cause

Invalid term defined in the Vendor or vendor site.
If terms_id or payments terms is not populated, then system try to default the terms id from vendor site and if null then from vendor.

Solution

Change the setup for the supplier and Site
Use a Valid Payment Term in the vendor and Vendor Site used in the import ReferencesBug 5690677 - ''IMPORT STANDARD PURCHASE ORDERS'' PROGRAM IS THROWING AN ERROR ''ORA-01403: NO