EBS Customizations (MOSC)

MOSC Banner

Formatting Oracle Alerts

edited Jan 3, 2018 2:35PM in EBS Customizations (MOSC) 3 commentsAnswered

Hello Everyone:

Is it possible to format oracle Alerts?

Our Environment:-

Database 11.2.4.0 Oracle Apps = 12.2.5

I have tried to concatenate all the fields, padding them before doing it, tried printing individually, also tried my hand with dbms_xmlgen.getxml, none of them are producing a formatted output like one below. 

PO #               Line#     Release#   Buyer Name                     Vendor                                       Release Status                 Item#                          Creation Date

=======================================================================================================================

PO1234         Ln12       Rel122      John Smith                        Mom and Pop Store Inc.            Incomplete                       Item9999                     12-Jun-2017

Here is the base query.

select  rpad('PO#', 20, ' ') || ' ' || lpad('Line#', 10, ' ') || ' ' || lpad('Release#', 10, ' ') || ' ' ||

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