My Oracle Support Banner

PSP: Summarize And Transfer Adjustments Error Unexpected Oracle error occured ORA -1 PSP_SUM_ADJ Procedure GET_THE_BATCH_DETAILS (Doc ID 2514006.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Labor Distribution - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Distribution Adjustments

When attempting to run PSPSTADJ: PSP: Summarize And Transfer Adjustments
the following error occurs.

ERROR
-----------------------
Summary Batch Name : xxxxxxxxxxxxxx
Batch Name : Batch : XXXXXX   Assign ID xxxxxxx Unexpected Oracle error occured ORA -1
Person Name : &PERSON_NAME
Assign Num : &ASSIGNMENT_NUMBER
Element Type : &ELEMENT_TYPE
Start Date : &DISTRIBUTION_START_DATE
End Date : &DISTRIBUTION_END_DATE
User-Defined Exception in Package PSP_SUM_ADJ Procedure GET_THE_BATCH_DETAILS
User-Defined Exception in Package PSP_SUM_ADJ Procedure MARK_BATCH_BEGIN


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Run PSP: Summarize And Transfer Adjustments


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.