Oracle EBS 创建一揽子采购订单时提示错误无法推导指定采购员 item_number 或 vendor_product_num 的 item_id

Oracle EBS 创建一揽子采购订单时提示错误无法推导指定采购员 item_number 或 vendor_product_num 的 item_id

Unable to derive item_id for specified purchaser item_number or vendor_product_num.
错误： 无法推导指定采购员 item_number 或 vendor_product_num 的 item_id.
错误： PO_HEADER_ID 每个单据至少应有一行。
On : 12.1 version, Purchasing Processes

When attempting to run PDOI: Import Price Catalogs,
the following error occurs.

ERROR

Error: Unable to derive item_id related to specified buyer item_number or vendor_product_num.            PO_PDOI_DERV_PART_NUM_ERROR                 PO_LINES_INTERFACE
Error: PO_HEADER_ID There should be at least one line per document.                                                PO_PDOI_INVALID_NUM_OF_LINES                  PO_HEADERS_INTERFACE

The issue started after upgrading database to 19.c.

原因：
The issue is caused by the following setup:

The 'System Items' flexfield was not compiled properly after Upgrading database to 19.c
 
The mtl_system_items_b_kfv view has been changed.  In particular, the field "concatenated segments" is null after the upgrade.

解决方法  

1.优先检查物料配置
采购页签  默认采购员
2.检查 物料编码是否符合规则 是否有特殊符号
参考SQL
SELECT ASCIISTR('物料编码 ') FROM DUAL
;  --注意物料编码后面的特殊字符
SELECT Unistr(REPLACE('\7269\6599\7F16\7801\00A0',
                      '\u',
                      '\'))
  FROM Dual;
SOLUTION
To implement the solution, execute the following steps:

1. Go into the responsibility: Purchasing

2. Navigate to Setup > Flexfields > Key > Segments

3. Query on:
   Application = Inventory
   Flexfield Title = System Items

4. Remove the check mark from the Freeze Flexfield Definition.
   User will receive the following caution message:
   Unfreezing this flexfield and making changes to the segment definitions
   could affect the validity of the data already existing for this flexfield.
 
5. Acknowledge the message by clicking the OK Button
  
6. Click on the Freeze Flexfield Definition Check box to refreeze the flexfield.
    User will receive the following caution message:
    Make sure you do not want to make any more changes to the flexfield segment
    definitions before freezing the flexfield.
    Unfreezing and changing the definitions later could affect the validity of existing
    data for your flexfield.

7. Acknowledge the message by clicking the OK Button, then Click the Compile button

8. Retest the issue

9. Migrate the solution as appropriate to other environments

-- 刘轶鹤