Discrete Manufacturing - EBS (MOSC)

MOSC Banner

Cannot import PR from MRP

edited Apr 19, 2012 5:08PM in Discrete Manufacturing - EBS (MOSC) 13 commentsAnswered
when i released planning order in MRP workbench ,i cannot find PR in PR summary,then

(1) i used the SQL:

select

MSI.SEGMENT1,MSI.DESCRIPTION,

msi.item_type,

PRI.QUANTITY,

PRI.NEED_BY_DATE,

 

PRI.INTERFACE_SOURCE_CODE,

interface_transaction_id Transaction_Id

,         column_name              Column_Name

,         error_message            Error_Message

from PO_REQUISITIONS_INTERFACE_ALL PRI,

      po_interface_errors pie,

      MTL_SYSTEM_ITEMS_B MSI

WHERE 1=1

and (pie.interface_transaction_id = pri.transaction_id  )

AND MSI.INVENTORY_ITEM_ID=PRI.ITEM_ID

AND MSI.ORGANIZATION_ID=207

AND PRI.INTERFACE_SOURCE_CODE='MRP'

out:This item is missing a list price in the item master setup window. Please enter a list price greater than zero (0) in the item master

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center