Oracle BI Publisher - How to treat numbers as text

How to treat numbers as text so that leading zeroes don't disappear

How to check "Invoice Match Option" in PO

How to check "Invoice Match Option" in PO

Table: po_line_locations_all
Column: match_option

Modify Currency Rate at Receipt

Modify Currency Rate at Receipt

There are two conditions to reach this function enable.



1.  Rate type: User while PO creation.

2. Invoice Match Option : Receipt at Shipments

Update created PO's match option as below:

How to query for null values in a form

- press Enter Query 
- navigte to your field 
- type "# IS NULL" in the field (without quotes) 
- press Execute Query 

it does not guarantee to work 
essentially anything after # is added to SQL query for 
your field, so you could do: 
# IN ('A','B')