My Oracle Support Banner

EPY:Publishing Rule PAY_ACKNOWLEDGE For Message PAYMENT_EXPENSES_ACKNOWLEDGE (18022,62) (Doc ID 2593171.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Interfaces and Integrations

Publishing Rule PAY_ACKNOWLEDGE for Message PAYMENT_EXPENSES_ACKNOWLEDGE fails with below error



ERROR
-----------------------


SQL error. Function: CreateSQL
  Error Position: 163
  Return: 904 - ORA-00904: "A"."PROCESS_INSTANCE": invalid identifier
  Statement: select a.emplid, a.empl_rcd, a.ex_doc_id, a.ex_doc_type, a.ex_line_nbr, a.monetary_amount, a.currency_cd, a.erncd, a.grossup, a.sepchk from ps_pay_request a where A.PROCESS_INSTANCE = :1 ORDER BY A.EMPLID, A.EMPL_RCD, A.EX_DOC_ID, A.EX_DOC_TYPE, A.EX_LINE_NBR
  Original Statement: Select A.EMPLID, A.EMPL_RCD, A.EX_DOC_ID, A.EX_DOC_TYPE, A.EX_LINE_NBR, A.MONETARY_AMOUNT, A.CURRENCY_CD, A.ERNCD, A.GROSSUP, A.SEPCHK from %Table(:1) A where A.PROCESS_INSTANCE = :2 order by A.EMPLID, A.EMPL_RCD, A.EX_DOC_ID, A.EX_DOC_TYPE, A.EX_LINE_NBR

SQL error in Exec. (2,280) EOL_PUBLISH.PUBLISH2.GBL.default.1900-01-01.Step10.OnExecute PCPC:19071 Statement:243

Process 1519608 ABENDED at Step EOL_PUBLISH.PUBLISH2.Step10 (PeopleCode) -- RC = 8 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 13.56.30 2019-09-10



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. PAYMENT_EXPENSE_REQUEST was triggered from the Finance side.
2. On the HCM side the subscription peoplecode triggers application engine PY_EXPVALIDT
3.After Application engine PY_EXPVALIDT is completed it triggers PAY_ACKNOWLEDGE for Message PAYMENT_EXPENSES_ACKNOWLEDGE
4. PAY_ACKNOWLEDGE fails with above error


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.