R12: AP: 95340 Error for Secondary/ALC Ledger Accounting and the Conversion Rate has Extended Decimals Beyond Currency Precision (Doc ID 1360696.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

The Create Accounting report shows a 95340 error for Seconary/ALC ledger accounting and the conversion rate has extended decimals beyond currency precision. e.g.

Ledger Setup
==============

--Setup Primary and ALC Ledger

Primary Ledger = USD
ALC Ledger = CAD

Payables Options Setup (ap_system_parameters_all set up)
======================
recon_accounting_flag = 'N'
automatic_offsets_method = 'N'
WHEN_TO_ACCOUNT_PMT = 'ALWAYS'
WHEN_TO_ACCOUNT_GAIN_LOSS = 'ALWAYS'

Currency Details
==================
USD extended precision = 5
CAD extended precision = 5
Rate type = Corporate

Invoice Details
==================
Invoice Number = XXX
Invoice Amount = 9962.69
Dist 1 Amount = 8442.96
Dist 2 Amount = 1519.73
Invoice Date = 20-Feb-2011
GL Date = 20-Feb-2011
GL Daily rate for 20-Feb-2011 = 0.3623188405797101449275362318840579710145
(This is the rate that will be used for the Invoice ALC Exchange Rate)

Payment Details
===============
Check Number X for amount 8767.17
Check Date = 22-Feb-2011
GL Date = 22-Feb-2011
GL Daily rate for 22-Feb-2011 = 0.3654970760233918128654970760233918128655
(This is the rate that will be used for the Payment ALC Exchange Rate)

 The ALC Secondary Ledger Payment accounting shows:

 EXCHANGE_GAIN_LOSS 27.86 DR
 LIABILITY 3176.51 DR
 CASH 3204.38 CR

 Debit total = 3204.37
 Credit total = 3204.38
 Difference = .01

 Error shown:

 Message_number = 95340
 Message =
 The total debits and the total credits do not balance for this subledger
 journal entry. Please ensure that the application accounting definition
 Accrual Basis owned by Oracle contains journal line types for the event
 class Payments and event type Payment Created that can create a balanced
 entry. Also verify that any conditions associated with a journal line type
 are correct.

Changes

Cause

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