My Oracle Support Banner

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.