EBS Customizations (MOSC)

MOSC Banner

Oracle Alert - Column Alignment

edited Jan 25, 2017 4:33PM in EBS Customizations (MOSC) 8 commentsAnswered

Hello all,

I'm trying to create a simple alert with several columns, but the data is not aligned.

I tried to concatenate the columns into one column and ran the SQL, and with "Oracle SQL Developer" it's aligned perfectly:

SELECT (RPAD(msib.segment1,25,' ')) || RPAD(msib.description,45,' ') || RPAD(ol.request_date,15,' ') ||

       RPAD(oh.order_number,15,' ') || RPAD(loc.customer_name,40,' ')

But, when I put it into an Alert - the data is not aligned (sorry for erasing the data):

Any idea how this can be solved?

Thanks,

Tom.

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