EAR 9.2: Payment Predictor ARPREDCT ABENDED at Step AR_PREDICT2.PUPD_PAY.AMTREM with Error: ORA-00923: FROM keyword not found where expected (Doc ID 2228531.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

On : 9.2 Image #16, AR Update - Posting

AR_PREDICT2 ABENDED at Step AR_PREDICT2.PUPD_PAY.AMTREM

When looking at the code:

%SelectInit(AMT_REM)
 SELECT PAYMENT_AMT-%Bind(AMT_SEL) + %Bind(DISC_TAKEN)+ %Bind(AMT_ADJ)
  FROM %Table(PAYMENT)
 WHERE PROCESS_INSTANCE=%ProcessInstance
  AND DEPOSIT_BU = %Bind(DEPOSIT_BU)
  AND DEPOSIT_ID = %Bind(DEPOSIT_ID)
  AND PAYMENT_SEQ_NUM = %Bind(PAYMENT_SEQ_NUM)

When AMT_SEL is a negative value, it creates a double negative which comments out the rest of the line and generates an error message.

ERROR
-----------------------
Stmt #: 1703 Error Position: 156 Return: 923 - ORA-00923: FROM keyword not found where expected
Failed SQL stmt: SELECT PAYMENT_AMT--131.06 + 0+ 0 FROM PS_PAYMENT WHERE PROCESS_INSTANCE=1128741 AND DEPOSIT_BU = 'SLGA' AND DEPOSIT_ID = '111945' AND PAYMENT_SEQ_NUM = 404

Process 1128741 ABENDED at Step AR_PREDICT2.PUPD_PAY.AMTREM (SQL) -- RC = 923 (108,524)

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