SQL Error when Adding Related Language Record for BANK_EC_TBL in Smart HR Template (Doc ID 2024281.1)

Last updated on FEBRUARY 12, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to add bank details to newly created template, the following error occurs.

ERROR

SQL Error : Please consult your system log.


STEPS

The issue can be reproduced at will with the following steps:
1. Add record PYE_BANKACCT to the Smart HR Templates (Set Up HCM > Product Related > Workforce Administration > Smart HR Template > Template Record/Field, Add a new value) using the fields ACCOUNT_NAME, BANK_CD, COUNTRY_CD and INTL_BANK_ACCT_NBR.
2. Add a new section to the Smart HR Templates with record PYE_BANKACCT (Set Up HCM > Product Related > Workforce Administration > Smart HR Template > Template Section, Add a new value)
3. Add the new section to Transaction Type HIRE (Set Up HCM > Product Related > Workforce Administration > Smart HR Template > Template Transaction Type, select the existing Transaction Type HIRE and go the the Sections tab):
4. Add the new section to template KN2_HIRE_NLD (Set Up HCM > Product Related > Workforce Administration > Smart HR Template > Template Creation, select the existing Transaction KN2_HIRE_NLD in Correction mode and go the the Sections tab) and save.
5. Login into Nederlands
6. Create a new HR-transaction using template KN2_HIRE_NLD (Hoofdmenu > Personeelsbeheer > Automatisch HR-sjabloon > Automatische HR-transacties)
7. Click on the button ‘Transactie maken’
8. Click on the button ‘Doorgaan’
9. Scroll down to the Bank Account Information section and search for a Bank-ID:
Error occurs.


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