EGL: Error When Running Archiving Commitment Control Tables. (Doc ID 2243920.1)

Last updated on MARCH 14, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 ARCHIVE DATA TO HISTORY BATCH PROCESS FAILS : SQL ERROR OCCURS 

Stmt #: 1617 Error Position: 230 Return: 907 - ORA-00907: missing right
parenthesis Failed SQL stmt:INSERT INTO PS_KKAR_ACT_TAO SELECT 15385 ,
KK_TRAN_ID , KK_TRAN_DT , 'Y' FROM PS_KK_ SOURCE_HDR A WHERE A.BUSINESS_UNIT
>= 'US005' AND A.BUSINESS_UNIT <= 'US005' AND A.KK_TRAN_DT <=
TO_DATE('2000-08-08','YYYY-MM-DD'

 

 

REPLICATION STEPS
=================
1. Go to PeopleTools > Data Archive Manager > Manage Archive Objects >
Setup Archive Object.
2. Go to PeopleTools > Data Archive Manager > Manage Archive Objects >
Manage Archive Templates.
3. Go to PeopleTools > Data Archive Manager > Manage Archive Objects >
Archive Data To History. Run the program

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