问题:销售订单-工具-计划-保留撤销后再次保留报错APP-FND-01048: WHERE 子句 ' ( exists (select 1 from oe_transaction_types_tl otl, oe_order_headers_all oeh, oe_order_lines_all oel where otl.transaction_type_id = oeh.order_type_id and oeh.header_id = oel.header_id AND otl.language = (Select language_code from fnd_languages where installed_flag = 'B') AND oel.inventory_item_id = 11162 and oel.ship_from_org_id = 87 and mtl_sales_orders.segment1 = oeh.order_number and mtl_sales_orders.segment2 = otl.name AND Nvl(OEH.source_document_type_id,0) <> 10 AND oeh.open_flag = 'Y' AND DECODE(OEL.LINE_CATEGORY_CODE, 'ORDER',2, 12) = 2) and segment3 = 'ORDER ENTRY' ) ' 限制此组合的使用。
Create a new transaction type or change the CONCATENATED_SEGMENT_DELIMITER to another character.
解决:
The flex field segments, segment values should not contain the delimiter as part of the value.
Create a new transaction type or change the CONCATENATED_SEGMENT_DELIMITER to another character.
弹性域的段、值不应包含分隔符作为值的一部分。因此,改变“
销售订单
”弹性域的分隔符或者在销售订单事务处理类型中不使用该分隔符。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29534067/viewspace-1355865/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29534067/viewspace-1355865/