BI Publisher (MOSC)

MOSC Banner

Error on line 2 at column 585

edited Jun 14, 2016 5:20AM in BI Publisher (MOSC) 8 commentsAnswered

Dear all,

I encountered the above error while select the multiple Production Number from the list.

Attached my SQL Script. Any one have any ideas about this? Please kindly assist.

select A.MMPMPN as "PROD_NO"

, B.SDDOCO as "SO_NO"

, TRUNC(B.SDLNID/1000,0) as "SO_LINE"

, to_date(to_char(H.SHTRDJ+1900000),'YYYYDDD') as "ORDER_DT"

, B.SDITM as "FG_ITEM_NO"

, B.SDLITM as "FG_ITEM_NO2"

, to_date(to_char(B.SDPDDJ+1900000),'YYYYDDD') as "CUST_PO_DT"

, to_date(to_char(B.SDDRQJ+1900000),'YYYYDDD') as "REQST_DT"

, to_date(to_char(B.SDOPDJ+1900000),'YYYYDDD') as "OR_PRMS_DT"

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