Inventory Management - EBS (MOSC)

MOSC Banner

LCM Erro When i create Shipment ??

edited May 27, 2015 10:07AM in Inventory Management - EBS (MOSC) 1 commentAnswered


Hi,

i faced this error when i create LCM shipment.

excatly when i put the PO number and click go to show the lines i have this error. any help

Thanks

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT er.po_line_location_id, er.po_header_id, er.po_release_id, er.po_line_id, er.to_organization_id, er.ship_to_location_id, pv.party_id, pvs.party_site_id, er.item_id, er.po_number, er.po_line_number, --er.item_description, msi.description AS item_description, -- Bug #9328448 er.po_shipment_number, er.ordered_qty, er.unit_price, er.currency_code, er.currency_conversion_type, er.currency_conversion_date, er.currency_conversion_rate, er.item_revision, msi.concatenated_segments, mum.uom_code, --er.ordered_uom, mum.unit_of_measure_tl AS ordered_uom, -- Bug #9328605 er.vendor_item_number, er.need_by_date, er.container_num, er.truck_num, er.bar_code_label, er.po_release_number, INL_SHIPMENT_PVT.Get_SrcAvailableQty('PO', er.po_line_location_id) as available_qty, er.primary_uom as primary_uom_desc, er.secondary_ordered_uom as secondary_uom_desc, er.closed_code, er.secondary_ordered_qty, /*

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