Receipt Traveler Report Errors With ORA-00936: Missing Expression, or REP-300: missing expression

(Doc ID 269421.1)

Last updated on NOVEMBER 06, 2015

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
This problem can occur on any platform.
RCVDLPDT module: Receipt Traveller Concurrent program

Symptoms

The Receipt Traveler report fails with the following errors :

ORA-00936: missing expression
SELECT rrp.item_id, rrp.organization_id rrp_organization_id, MSI.SEGMENT1
C_FLEX_ITEM ,MCA.SEGMENT1 C_FLEX_CAT ,rrp.revision_num, rrp.category_id,
rrp.item_description, rrp.un_num, rrp.un_description, rrp.hazard_class,
rrp.routing_name, rrp.documen

or

REP-300: missing expression
'||MCA.SEGMENT5 C_FLEX_CAT ,rrp.revision_num, rrp.category_id, rrp.item_description, rrp.un_num, rrp.un_description, rrp.hazard_class, rrp.routing_name, rrp.document_type_code, rrp.document_number, rrp.release_num, rrp.line_num, rrp.buyer_preparer_na

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms