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

Last updated on JUNE 30, 2016

Applies to:

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

Goal

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.

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