Oracle EBS INV 查询物料无值 ECO

查找物料的时候报错 没有输入值

?

?

?

解决方法：

针对FORM做trace

多查看几个生成的trace

搜索 MTL_SYSTEM_ITEMS_b 的信息

查看到最后面的语句（一般可直接查看）

?

看SQL 哪地方不满足

这边是这块：

SELECT MTL_SYSTEM_ITEMS_VL.SEGMENT1 C0,MTL_SYSTEM_ITEMS_VL.DESCRIPTION

? "说明"

FROM

?MTL_SYSTEM_ITEMS_VL WHERE 1=1 AND MTL_SYSTEM_ITEMS_VL.ENABLED_FLAG = ‘Y‘ AND

? TO_DATE(:A00,‘YYYY/MM/DD HH24:MI:SS‘) BETWEEN

? NVL(TRUNC(MTL_SYSTEM_ITEMS_VL.START_DATE_ACTIVE),TO_DATE(:A01,‘YYYY/MM/DD

? HH24:MI:SS‘)) AND NVL(TRUNC(MTL_SYSTEM_ITEMS_VL.END_DATE_ACTIVE),

? TO_DATE(:A02,‘YYYY/MM/DD HH24:MI:SS‘)) AND (MTL_SYSTEM_ITEMS_VL.SEGMENT1

? LIKE :A03 OR MTL_SYSTEM_ITEMS_VL.SEGMENT1 IS NULL ) AND

? MTL_SYSTEM_ITEMS_VL.ORGANIZATION_ID = :A04 AND? ( ((:A05 = 1 AND

? ENG_ITEM_FLAG = ‘N‘) OR???????? (:A06 = 2))??????? AND

? INVENTORY_ITEM_STATUS_CODE NOT IN (:A07,:A08)????????????????????????????

? AND INVENTORY_ITEM_STATUS_CODE <> (SELECT NVL(BOM_DELETE_STATUS_CODE,‘A‘)

? FROM BOM_PARAMETERS WHERE ORGANIZATION_ID = :A09)??????? AND

? NVL(APPROVAL_STATUS,‘A‘) = ‘A‘ AND??? ?????((BOM_ITEM_TYPE = 4 AND :A0A =

? 1) OR???????? (BOM_ITEM_TYPE = 3 AND :A0B = 1) OR???????? (BOM_ITEM_TYPE =

? 2 AND :A0C = 1) OR???????? (BOM_ITEM_TYPE = 1 AND :A0D = 1))??????? AND????

???? ((:A0E = ‘N‘ AND EFFECTIVITY_CONTROL = 1) OR???????? (:A0F = ‘Y‘)) )???

? ORDER BY MTL_SYSTEM_ITEMS_VL.SEGMENT1;

?

?

定位到

select BOM_DELETE_STATUS_CODE from BOM_PARAMETERS

?

?

?

?

应为inactive。而环境是active

定位到界面是?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!