My Oracle Support Banner

ORA-1841 Error with On-line and Batch Packaging (Doc ID 2342182.1)

Last updated on DECEMBER 26, 2019

Applies to:

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

Symptoms

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


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






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.