95340 Error for Secondary/ALC Ledger Accounting and the Conversion Rate has Extended Decimals Beyond Currency Precision
Last updated on SEPTEMBER 15, 2017
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
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