Israel Localization : ORA-20000: TO currency NULL AND cannot determine Functional Currency too error when applying prepayment invoice (Doc ID 2633584.1)

Last updated on NOVEMBER 18, 2024

Applies to:

Symptoms

Reported Issue
------------------
When trying to apply prepayment invoice, it is failing with an error. 

Error Message
----------------
AP.PLSQL.AP_APPROVAL_PKG.Execute_Dist_Generation_Check 1 "Execute_Dist_Generation_Check-insert from dist set has error -
ORA-20000: TO currency NULL AND cannot determine Functional Currency too.
ORA-06512: at ""APPS.CLEF062_INV_DISTRIBUTIONS_BIR1"", line 328
ORA-04088: error during execution of trigger 'APPS.CLEF062_INV_DISTRIBUTIONS_BIR1'" 
error during execution of trigger CLEF062_INV_DISTRIBUTIONS_BIR1

Steps to replicate 
-----------------------
The issue can be reproduced at will with the following steps:
1. (N) Open invoice workbench and query for standard invoice.
2. Click on prepayment 
3. Select Prepayment and enter all mandatory fields
4. When click on click on All Distributions tab .
    Here , an error is raised ( as mentioned above).
  
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create invoice

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.