My Oracle Support Banner

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 JANUARY 30, 2020

Applies to:

EMEA Add-on Localizations - Version 12.1.1 and later
Information in this document applies to any platform.


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).
The issue has the following business impact:
Due to this issue, users cannot create invoice


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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