95340 Error for Secondary/ALC Ledger Accounting and the Conversion Rate has Extended Decimals Beyond Currency Precision
(Doc ID 1360696.1)
Last updated on FEBRUARY 03, 2019
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.
--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'
USD extended precision = 5
CAD extended precision = 5
Rate type = Corporate
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)
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
Message_number = 95340
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
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