Unable To View workflow Status Diagram

Unable To View workflow Status Diagram

When pressed on the click Here link the below error message displays:
oracle.apps.fnd.framework.OAException: java.lang.NullPointerException ( and it displays lot of lines with the exception message)

Solution:

Set the profile option Server Timezone at Site level (should be set to the value of database timezone) and Bounce the Apache Server

Query to fetch vendor bank details, check, invoice etc

SELECT
VOUCHER_NUMBER,
TRANSACTION_DATE,
CHECQUE_DATE,
CHECK_NUMBER,
INVOICE_NUMBER,
NAME_OF_BANK,
BANK_ACCOUNT_NUMBER,
AMOUNT_PAID,
AMOUNT_PAID_TO,
OPERATING_UNIT,
ORG_ID,
SUP_BANK,
REMIT_BANK_AC_NUM
FROM
(
SELECT DISTINCT
aia.attribute1 “VOUCHER_NUMBER”,
to_char(aia.invoice_date,’DD-MON-RRRR’) “TRANSACTION_DATE”,
to_char(aca.check_date,’DD-MON-RRRR’) “CHECQUE_DATE”,
aca.check_number “CHECK_NUMBER”,
aia.invoice_num “INVOICE_NUMBER”,
cbb.bank_name “NAME_OF_BANK”,
cba.bank_account_num “BANK_ACCOUNT_NUMBER”,
aca.amount “AMOUNT_PAID”,
asa.vendor_name “AMOUNT_PAID_TO”,
hou.name “OPERATING_UNIT”,
hou.organization_id org_id,
eb.bank_name “SUP_BANK”,
(
SELECT DISTINCT
ie.masked_bank_account_num
FROM po_vendors pv,
ap_invoices_all ap,
iby_ext_bank_accounts ie,
apps.ce_bank_branches_v cb
WHERE ap.vendor_id = pv.vendor_id
AND ap.external_bank_account_id = ie.ext_bank_account_id(+)
AND ie.branch_id = cb.branch_party_id(+)
AND ie.bank_id = cb.bank_party_id(+)
AND ap.invoice_num = aia.invoice_num
AND ap.invoice_id = aia.invoice_id
)”REMIT_BANK_AC_NUM”
FROM
ap_invoice_payments_all aipa,
ap_invoices_all aia,
ap_checks_all aca,
ap_suppliers asa,
ap_supplier_sites_all assa,
hr_operating_units hou,
ce_bank_branches_v cbb,
ce_bank_accounts cba,
ce_bank_acct_uses_all cbau,
iby_ext_bank_accounts eba ,
iby_account_owners ao ,
iby_ext_banks_v eb ,
iby_ext_bank_branches_v ebb
WHERE 1 = 1
AND UPPER(aca.vendor_site_code) <> UPPER(‘Petty Cash’)
AND aia.invoice_id = aipa.invoice_id(+)
AND aca.check_id(+) = aipa.check_id
AND aia.org_id = hou.organization_id
AND asa.vendor_id(+) = aia.vendor_id
AND asa.vendor_id = assa.vendor_id
AND cbb.branch_party_id(+) = cba.bank_branch_id
AND cbau.bank_account_id = cba.bank_account_id(+)
AND aca.ce_bank_acct_use_id = cbau.bank_acct_use_id(+)
AND ao.account_owner_party_id(+) = asa.party_id
AND eba.ext_bank_account_id(+) = ao.ext_bank_account_id
AND eba.branch_id = ebb.branch_party_id(+)
AND eba.bank_id = eb.bank_party_id(+)
and nvl(aia.invoice_num,:p_voucher_num) = nvl(:p_voucher_num,aia.invoice_num)
AND NVL(hou.name ,:P_OPERATING_UNIT) = NVL(:P_OPERATING_UNIT,hou.name )
AND aca.check_date = :CHECQUE_DATE_MAIN
GROUP BY
aia.attribute1 ,
aia.invoice_date,
aca.check_date,
aca.check_number,
aia.invoice_num,
cbb.bank_name ,
cba.bank_account_num ,
aca.amount ,
asa.vendor_name ,
hou.name ,
hou.organization_id ,
eb.bank_name ,
aia.invoice_num,
aia.invoice_id,
eba.masked_bank_account_num
)
WHERE
1 = 1
AND OPERATING_UNIT = nvl(:P_OPERATING_UNIT,OPERATING_UNIT)
GROUP BY
OPERATING_UNIT,
ORG_ID,
VOUCHER_NUMBER,
TRANSACTION_DATE,
CHECQUE_DATE,
CHECK_NUMBER,
INVOICE_NUMBER,
NAME_OF_BANK,
BANK_ACCOUNT_NUMBER,
AMOUNT_PAID,
AMOUNT_PAID_TO,
SUP_BANK,
REMIT_BANK_AC_NUM
ORDER BY
OPERATING_UNIT,
CHECQUE_DATE

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.

Capture

This can be handled in the following way

<?EXP2[.!=”]?>

<?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
WHERE 1=1
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