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

科技前沿 • 2025-01-29 10:12 • 阅读 53

大家好，我是讯享网，很高兴认识大家。

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

ERROR

The issue started after upgrading database to 19.c.

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

-- 刘轶鹤

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

相关推荐