Error When Viewing Requisition Approval Header Comments in MS SQL Server DB (Doc ID 2208222.1)

Last updated on NOVEMBER 28, 2016

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When navigating to Requisition Approval and clicking on Header comments,It gives Error:

A fatal PeopleCode SQL error occurred"
Original Statement: SELECT count(1) FROM PS_EOATT_CFG_D_TBL WHERE EOATT_CONFIG_ID = :1 AND EOATT_LEVELNO = :2 AND EOATT_DISPLAY = 'Y' AND EOATT_HEADER ='Y' ORDER BY EOATT_SEQNBR

 
ERROR
--------
A fatal PeopleCode SQL error occurred"
  Original Statement: SELECT count(1) FROM PS_EOATT_CFG_D_TBL WHERE EOATT_CONFIG_ID = :1 AND EOATT_LEVELNO = :2 AND EOATT_DISPLAY = 'Y' AND EOATT_HEADER ='Y' ORDER BY EOATT_SEQNBR

Steps to reproduce the issue:
1) Navigate to eProcurement -> Requisition
2) Create a new requisition in such a way that the Requisition goes to Manager level Approval.
And Enter line level comments and the Approval Justification Comments in the Requisition before Submitting the Requisition.
3) Now login as Approver.
4) Goto Worklist page and look for the Req to be Approved. Click on the hyperlink.
5) Click on the Header Comments and Line Comments.
6) Fatal SQL Comments came in.



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