ORA-1841 Error with On-line and Batch Packaging

(Doc ID 2342182.1)

Last updated on JANUARY 04, 2018

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : CS 9 Patch 26326358 or CS 9.2. Patch 26492610 FA LEGISLATIVE - YEAR ROUND PELL BEING REINTRODUCED BY FSA

When attempting to run any mode of packaging on-line or batch
the following error occurs.

ERROR
-----------------------
On-line, e.g. clicking Validate button: Remote program FAPPKRCL failed with return code: 1841. Reason ORA-1841: (full) year must be between -4713 and +9999, and not be 0. In section: SQLRT:EXECUTE-STMTSELECT FATERMS (2,-1) DERIVED_PACKAGE.VALIDATE_AWARD_PB.FieldChange PCPC:1071 Statement:19

Batch, e.g. Need Summary Validation:

Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01841
Error Message : ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Stored Stmt : FAPPKCTL_S_FATERMS

Error W/FAPPKCTL !

SQL Error: SELECT FATERMS

Application Program Failed
In Pgm Section : SELECT FATERMS
With Return Code: 01841
Error Message : ORA-01841: (full) year must be between -4713 and +9999, and not be 0




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to assign awards to students for any student with an existing aid package
2. Validate


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