Oracle Report Error
Hi,
We are encountering an Error when we run a leave report for 2024 in oracle report in EBS.
The interesting thing is that when we run the same report for years before 2024, it runs fine.
Here is the error log that we get when we ran for 2024:
*********************************************************************************
+---------------------------------------------------------------------------+Human Resources: Version : 12.2Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.XXGL_ANNUAL_LEAVE_SHEET: XXGL Annual Leave Sheet+---------------------------------------------------------------------------+Current system time is 25-JAN-2025 08:44:10+---------------------------------------------------------------------------++-----------------------------| Starting concurrent program execution...+-----------------------------Arguments------------P_DATE='2024'------------Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing APPLLCSP Environment Variable set to : Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :American_America.UTF8'.,'BINARYEnter Password: REP-2103: Column 'G_1' : PL/SQL formula returned invalid value or no value.REP-0069: Internal errorREP-57054: In-process job terminated:Terminated with error: REP-2103: Column 'G_1' : PL/SQL formula returned invalid value or no value.Report Builder: Release 10.1.2.3.0 - Production on Sat Jan 25 08:44:11 2025Copyright (c) 1982, 2005, Oracle. All rights reserved.+---------------------------------------------------------------------------+Start