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

Last updated on MARCH 08, 2017

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.

Symptoms


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

EXPECTED BEHAVIOR
-----------------------
To see same output file in French report.

STEPS
-----------------------
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 :



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

Cause

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