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

Last updated on MARCH 08, 2017

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.

Goal


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 C-0001> Validate Transaction

2. Settlements > Settlements > Query Deal 13062 > 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 C-0001.

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 13062.
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 C-0001.

Solution

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