GP-MEX: Submit GPMXPYSL Process - GPMXPS01 Finish on Error SQR 5528 Oracle OCIStmtExecute Error 1791 In Cursor 9 - ORA-01791 (Doc ID 1910273.1)

Last updated on AUGUST 02, 2017

Applies to:

PeopleSoft Enterprise HRMS Global Payroll Mexico - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Legislative

Payslip process - When submit the GPMXPYSL process, the step for GPMXPS01 finishes on error when the parameter for ID Orden was modified to use only PAYGROUP and EMPLID.

**(SQR 5528) ORACLE OCIStmtExecute error 1791 in cursor 9: ORA-01791: not a SELECTed expression

This process is part of job GPMX PYSL:
 
GPMXPS01
Payslip
Ver. 2014-C.01.1
Report Began: 09:43:41
Language: ENG
(SQR 5528) ORACLE OCIStmtExecute error 1791 in cursor 9:
  ORA-01791: not a SELECTed expression
SQL: SELECT DISTINCT GE.EMPLID, GE.EMPL_RCD, GE.JOB_EFFDT, GE.JOB_EFFSEQ,

Due to this issue, users cannot generate the payslip to CFDI process.

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