ECM Brazil Localization: Historical TR Generates Error "Template Line is required when selected Product is PS/TR. (25500,27)" (Doc ID 2043624.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

When setting Setid XXX to create a Historical to TR for Bank Fee and Accounting Template in Setid YYY, the fields "Accounting Template ID" and "Template Line" do not consider Set Control Value configured.

Steps:
-------
1. Create GLBU BRA00
2. From Record Group FS_BRL, delete the following records.
HIST_DTL_ABL
HIST_DTL_BRL
HIST_HDR_ABL
HIST_HDR_BRL
3. Create Record Group FS_HIST with the following records.
HIST_DTL_ABL
HIST_DTL_BRL
HIST_HDR_ABL
HIST_HDR_BRL
4.Update the Table Set Control for BRA00 with the following information.
FS_39:  BRA00
TR_05:  SHARE
FS_HIST:BRA00
5. Create a Bank and Bank Account for setid BRA00.
6. Create a Treasury Accounting  Template for Setid SHARE under Cash Management > Treasury Accounting >  Accounting template.
7. Navigate to Set Up Financials/Supply Chain > Common Definitions > Historical - Definition Historical TR and add Historical TR with the below details and click on Template Line look up which displays the following message.
SetID: BRA00
Source Code: Bank fees
Accounting template ID: BSP-BANKTRANTA

Error:
------
No matching values were found message
Template Line is required when selected Product is PS/TR. (25500,27)



Cause

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