EAP: INTFAPAM abends at Step INTFAPAM.RETSERL.STEP02 (SQL) -- RC = 911 (108,524) (Doc ID 1932143.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

When running the Payables to Assets Interface (INTFAPAM), process abends at Step INTFAPAM.RETSERL.Step02 with an error.

ERROR
SQL error. Stmt #: 1623 Error Position: 3404 Return: 911 - ORA-00911: invalid character

Process 9791003 ABENDED at Step INTFAPAM.RETSERL.Step02 (SQL) -- RC = 911 (108,524)

STEPS
1.  Create a PO with Matching turned on, PO Qty = 6
2.  At the Distribution for Schedule 1, AM Unit and Profile ID fields are populated
3.  Dispatch the PO
4.  Create the Receiver from the PO
5.  Check the Serial box
6.  Under AM Status, click the Pending hyperlink
7.  Populate the Tag Number and Serial ID in order to Serialize the Asset
8.  Asset ID = NEXT
9.  Create Voucher from the PO
10.  Run Matching
11.  Run Voucher Posting
12.  Run Load Assets Request
13.  Close the Voucher -- Mark the Voucher for Closure
14.  Answer either Yes or No to the following question -- This voucher has been matched. Do you want to unmatch the voucher? (7030,719)
15.  Run Voucher Posting
16.  Run Load Assets Request

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