Order Management - EBS (MOSC)

MOSC Banner

How to avoid Value_error exception in forrmula coloumn in oracle reports

edited Aug 15, 2019 5:01AM in Order Management - EBS (MOSC) 2 commentsAnswered

Dear Team,

I have created on formula coloumn but it is going in value error in exception .

I observed that because of '%'  .

my below query output is  :  80% TRC 10 % REC OF MATL 10 % PBG

select DESCRIPTION

  --  INTO lc_payment_terms

  from apps.oe_order_headers_all oha

       , apps.ra_terms rat

  where oha.PAYMENT_TERM_ID = rat.term_id

    AND oha.order_number = :Contract_No--70100028

    AND oha.org_id = :org_id--87

but not printed output in oracle report PDF format not also printing in XML output also.

Please suggest me .

Regards,

Sandip Chakor

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