95340 Error for Secondary/ALC Ledger Accounting and the Conversion Rate has Extended Decimals Beyond Currency Precision

(Doc ID 1360696.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

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

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 = alc1
invoice_id = 974021
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 5 for amount 8767.17
check_id = 404342
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.

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