My Oracle Support Banner

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:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.


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'

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:

 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.




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.