Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to remove leading zeros from the returned value?
Summary:
How to remove leading zeros from the returned value?
Content (required):
We are storing the salary range under the grade rate values. The value is stored as NNN,NNN.00, but when we try to default the value into the DFF (type character), it shows up with leading zeros. such as: 146700.000000
We want the autocomplete rule to return the value as stored under the Grade rate values which is
146,700.00
Version (include the version you are using, if applicable):
22C
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
4