My Oracle Support Banner

ECM Brazil Localization: Automated Accounting Does Not Track Transaction Reference ID From Historical TR (Doc ID 2832263.1)

Last updated on JANUARY 10, 2022

Applies to:

PeopleSoft Enterprise FIN Cash Management Brazil - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Historical TR is setup with SeqNum 4 set to Historic - Variable = Transaction Reference ID for a specific Accounting Template ID. External Transaction is created and associated to the specific Accounting Template ID. The External Transaction is reconciled and Automated Accounting is run to create Accounting Entries.

When checking the data on TRA_ACCTG_LINE for the External Transaction, the HIST_PART_BRL_4 field is populated with the Bank Code instead of the Transaction Reference ID.

STEPS
1. Navigate to Cash Management > Treasury Accounting > Accounting Templates
2. Verify the setup for Accounting Template ID = BSP-BANKTRANTAR
3. Navigate to Set Up Financials/Supply Chain > Common Definitions > Historical > Definition Historical TR
4. Add 1st Historical TR
a. Source Code = Bank Fees
b. Accounting Template ID = BSP-BANKTRANTAR
c. Template Line = 1
d. Bank Code = BB2
e. Bank Account = CC1
f. Debit /Credit Flag = Credit

5. On the Historical page add the following Historical Fields:
a. SeqNum 1: Historic - Literal = Test Text
b. SeqNum 2: Historic - Variable = From Bank Name
c. SeqNum 3: Historic - Variable = From Bank Account
d. SeqNum 4: Historic - Variable = Transactions Reference ID

6. Add 2nd Historical TR
a. Source Code = Bank Fees
b. Accounting Template ID = BSP-BANKTRANTAR
c. Template Line = 2
d. Bank Code = BB2
e. Bank Account = CC1
f. Debit /Credit Flag = Debit

7. On the Historical page add the following Historical Fields:
a. SeqNum 1: Historic - Literal = Test Text2
b. SeqNum 2: Historic - Variable = From Bank Name
c. SeqNum 3: Historic - Variable = From Bank Account
d. SeqNum 4: Historic - Variable = Transactions Reference ID

8. Navigate to Banking > Bank Accounts > External Accounts
a. Bank Code = BB2
b. External Bank ID = 002
c. Bank Account = CC1
d. GL Unit = BTGL1

9. On the External Accounts > Reconciliation page setup, Recon Method = Manual
10. Navigate to Banking > Reconcile Statements > External Transactions
11. Add an External Transaction
a. Tran Date = Today's Date
b. Bank ID = 002
c. Account # = 00000773794
d. Unit = BTGL1
e. Reference = TEST
f. Accounting Template ID = BSP-BANKTRANTAR

12. Navigate to Banking > Reconcile Statements > Manual Reconciliation
13. Reconcile the External Transaction
a. Bank ID = 002
b. Account # = 00000773794
c. Status = Unreconciled
d. From Date and Thru Date = Today's Date
e. Click Search

14. Check the Select box
15. Click Reconcile
16. Verify the External Transaction is reconciled
a. Bank ID = 002
b. Account # = 00000773794
c. Status = Reconciled
d. Click Search

17. External Transaction is reconciled / Status = REC
18. Navigate to Cash Management > Treasury Accounting > Automated Accounting
19. Run Automated Accounting
a. Business Unit = BTGL1
b. Combo Template = TREASURY
c. Acctg Events End Date = Today's Date
d. Check the box for All Sources

20. Navigate to Cash Management > Treasury Accounting > Accounting Entries
a. Business Unit = BTGL1
b. Accounting Date = Today's Date
c. Click Search

21. Display the transaction
22. Accounting Entries page
a. Transaction Reference ID = TEST
b. Accounting ID = 0000000038

23. Through SQL, data extract from PS_TR_ACCTG_LINE shows that HIST_PART_BRL_4 is populated with BB2 (the Bank Code) and not the Transaction Reference ID of TEST

 

NOTE: In the examples, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database. Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.