R12 AP Supplier Open Balance Letter (APXSOBLX) For French Supplier Site Is Not Correct

(Doc ID 1433282.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


On 12.1.3 in Production:
Find no same output file for English and French 'Supplier Open Balance Letter' report.

To see same output file in French report.

The issue can be reproduced at will with the following steps:
When he run Supplier Open Balance for Supplier who have Language = French (in Supplier address)
The Report is not correct (It's only correct for English Language)

Test case :

Supplier : Supplier_X
=> There is 1 invoice and 1 prepayment (Prepayent in French = 'Acompte')

If the Language on Supplier site = French then the Report give following :

Votre solde EUR est 619.50, composé de la manière suivante :

Numéro Date Type de Montant Montant
facture facture facture facture du solde
------- ------- ------------ ------------ ------------
12___ 04-JAN-11 Acompte 619.50 619.50 ****
18___ 18-FEV-11 Standard 619.50 619.50

------------ ------------
Solde facture 1,239.00 1,239.00

Acomptes non lettrés

Numéro Date de Compte Montant du
d'acompte l'acompte d'acomptes solde
---------- ------------ ---------- -----------
Acomptes non lettrés ----------- -----------

Total 619.50

==> This Report is not correct : we see the Prepayment (Acompte) in Invoice section as it should be on Unapplied Prepayment Section

(For the Test, we change the supplier site language to set : American)

If the Language on Supplier site = American then the Report give following :

Your EUR open balance is 619.50 made up as follows:

Invoice Invoice Invoice Invoice Open Balance
Number Date type Amount Amount
------- ------- -------- --------- ------------
18___ 18-FEB-11 Standard 619.50 619.50

--------- ------------
Invoice Balance 1,239.00 1,239.00

Unapplied Prepayments

Prepayment Prepayment Prepayment Open Balance
Number Date Amount Amount
---------- ------------ ---------- -----------
12___ 04-JAN-11 619.50 619.50
---------- -----------
Unapplied Prepayments 619.50 619.50

Total 619.50

This is correct (except for Invoice Balance Amount but we have an other bug for that : 13547046 )

The Report use data stored in table ap_supplier_balance_itf
In this table the value stored for invoice_type is the meaning of fnd_lookup_values depending on Language
So the value four our prepayment is 'Acompte'

In the Report Filter (for Invoice Section) we see :

The issue has the following business impact:
Due to this issue, users cannot see same output file in French report.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms