Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert to number.

This error comes when we are trying to do some calculations based on a column that returns NULL value.


This can be handled in the following way


<?xdoxslt:set_variable($_XDOCTX, ‘P’,xdoxslt:get_variable($_XDOCTX, ‘P’)+EXP2[.!=”])?>


Here EXP2 is a column that is returning NULL value.


DFF query

SELECT distinct ffv.descriptive_flexfield_name  “DFF Name”,
–ffv.application_table_name “Table Name,
ffv.title “Title”,
—-ap.application_name “Application”,
ffc.descriptive_flex_context_code “Context Code”,
ffc.descriptive_flex_context_name “Context Name”,
ffc.description “Context Desc”,
ffc.enabled_flag “Context Enable Flag”,
att.column_seq_num “Segment Number”,
att.form_left_prompt “Segment Name”,
att.application_column_name “Column”,
fvs.flex_value_set_name “Value Set”,
att.display_flag “Displayed”,
att.enabled_flag “Enabled”,
att.required_flag “Required”
FROM apps.fnd_descriptive_flexs_vl ffv,
apps.fnd_descr_flex_contexts_vl ffc,
apps.fnd_descr_flex_col_usage_vl att,
apps.fnd_flex_value_sets fvs
–apps.fnd_application_vl ap
AND ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
–AND ap.application_id=ffv.application_id
AND ffv.descriptive_flexfield_name = ffc.descriptive_flexfield_name
AND ffv.application_id = ffc.application_id
AND ffc.descriptive_flex_context_code=att.descriptive_flex_context_code
AND fvs.flex_value_set_id=att.flex_value_set_id
AND ffv.title like ‘Common Lookups’—name of   the lookup
AND ffc.descriptive_flex_context_code like ‘ACCOUNT SEGMENT’ — context name
–AND UPPER(att.form_left_prompt) = ‘MINOR HEAD’
ORDER BY att.column_seq_num

Invoice Status query

Invoice distributions are validated individually and the status is stored at the invoice distribution level. This status is stored in AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG.

Valid values for the column are:

A – Validated (it used to be called Approved)

N or NULL – Never validated

T – Tested but not validated

The invoice header form derives the invoice validation status based on the following:


  • If all of the invoice distributions have a MATCH_STATUS_FLAG = ‘A’

‘Never Validated’

  • If all of the invoice distributions have a MATCH_STATUS_FLAG = null or ‘N’

‘Needs Revalidation’

  • If there are any rows in AP_HOLDS that do not have a release code.
  • If any of the invoice distributions have a MATCH_STATUS_FLAG = ‘T’.
  • If the invoice distributions have MATCH_STATUS_FLAG values = ‘N’, null and ‘A’ (mixed).