My Oracle Support Banner

ECM:Automated Accounting Process, TR_ACCTG, Does Not Populate Description Field in TRA_ACCTG_LINE (Doc ID 1320855.1)

Last updated on OCTOBER 18, 2021

Applies to:

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


It would be beneficial to those reviewing the accounting entries that TRA_ACCTG_LINE table have information in the description field, such as a combination of the Source ID and the Event Name. This is especially important as there is no drill back from the GL to the Treasury Accounting Entries.

Currently, only BSP external transactions will have descriptive information when Automated Accounting generates its accounting lines.

It is possible to determine the transaction id from PS_TRA_ACCTG_HDR.EVENT_ID but in the case of deals where there are multiple accounting events there is currently no way to determine the accounting event to which accounting lines belong to, other than by inference using the accounting template name.


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.