My Oracle Support Banner

R12:XTR:Beneficiary Account Settlement Leads To Incorrect Accounting (Doc ID 1273284.1)

Last updated on NOVEMBER 19, 2021

Applies to:

Oracle Treasury - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


Business Scenario:

When a SPOT transaction is settled to a beneficiary bank account the accounting for the "Bank GL" is not generated based on the bank account defined. We settled the SPOT transaction to an account owned by a different Treasury company.

Steps to Reproduce
1. Treasury > Foreign Exchange Transactions > Spot/Forward > Create New SPOT Deal for Treasury Company X> Validate Transaction

2. Settlements > Settlements > Query Deal XXXX > Settle > Select different beneficiary account.
Beneficiary account is an account owned (i.e. same legal entity) as another Treasury company (C-0001)

3. Treasury > Accounting > Daily Journals > Generate Non-Revaluation/Non-Accrual Related Journals >
Bank GL is not generated for the Beneficiary Account even though the Cash Account listed on the
Bank Account is authorized for Treasury company X.

I. BeneficiarySettlement_Accounting.docx - details the exact steps and screenshots of the Deal Entry,
Settlement Process, Treasury System Parameters, Beneficiary Bank Account (as defined in
Oracle Cash Management), and the related accounting.

II. Batch18008_DealNo13062 - shows the journal entries generated for Deal No XXXX.
Please notice the Suspense Account that is generated where the Bank GL (1031.00000.113760.000000.0000.00000.000000.00000)
should actually be.

III.  Journal Entry Action setup for company X.


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.