Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to format number in IBYDE_CTX_en.rtf file

edited Jan 25, 2019 2:50PM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered ✓

Hi,

EBS 12.1.3

I am new to formatting the data for using electronic payments.  There is a requirement where the amount column with 0 value should be displayed with 2 decimal values with leading 0 (zeroes) i.e. 0000000.00 format.  I used the below functions to format the data but only a single 0 is displayed in the file.  However the below function works fine in SQL.

TRIM(TO_CHAR(DiscountTaken/Amount/Value, ‘000000009.99’))

Also is there a guide or some sort of documentation which tells the statements, functions etc that can be used.

Thanks.

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