My Oracle Support Banner

EAR 9.2: When Users Logged Into System With Language Other Than Eng for Approving WorkFlow Receives Fatal PeopleCode SQL Error, "ORA-00904: "PTPN_EVENTNAME": invalid identifier". (Doc ID 2865899.1)

Last updated on APRIL 29, 2022

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Users logged into the system with a language other than ENG receive a Fatal PeopleCode SQL Error when approving WorkFlow.

ERROR
-----------------------
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
PSAPPSRV.45744330 (779) 1-23223 17.07.27 5.803466 SQL error. Function: SQLExec
  Error Position: 74
  Return: 904 - ORA-00904: "PTPN_EVENTNAME": invalid identifier
  Statement: select descr100 from ps_ptpn_cat_reglng where ptpn_category_name = :1 and PTPN_EVENTNAME = :2
  Original Statement: SELECT DESCR100 FROM PS_PTPN_CAT_REGLNG WHERE PTPN_CATEGORY_NAME = :1 and PTPN_EVENTNAME = :2
  PSAPPSRV.45744330 (779) 1-23224 17.07.27 0.000159 PCodeWTL(1/3): SQL-Fehler bei Exec (2,280) PTPN_PUBLISH.PublishToWindow.OnExecute Name:Publish PCPC:14719 Statement:229



Replication Steps:
-----------------------
1. Enable Enable Write-Off Workflow in Receivable Options (setup financials - Business unit related - Receivable - Receivable options).
2. Enter the maintenance worksheet and submit it for approval (Receivables - Receivable maintenance - Maintenance worksheet).
3. Login as approver with language as Spanish.
4: Goto Classic menu -  Receivable - AR workcenter - Alerts, approve the maintenance worksheet, the error pops up.



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
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.