R12:AP/IBY: AMEX Remittance File Output Does Not Contain All The Data From Extract

(Doc ID 2095383.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payments - Version 12.1.0 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The AMEX Remittance program that is not including everything that was selected in the PPR causing the file total to be incorrect.

Steps
-------------

1.  Expense Reports get entered in iExpense.
2.  Expense Reports go through approval process.
3.  Run the seeded Expense Report Export concurrent process.
4.  Run the seeded Invoice Validation concurrent process.
5.  Submit Single Payment Process Request - all the way through Confirmation
6.  Run the AMEX Remittance Program and check the log to verify it's the template in use:

IBY_FD_AMEX_REMIT module: Amex Remittance Program
+---------------------------------------------------------------------------+

While buildingoutput - m_instructionID : 74955
Enter: iby.engine.Format.Format (self loading constructor)
Preparing to load format record. format code := IBY_AMEX_REMITTANCE
Found format record. parsing attributes.
Done parsing. Fetched format record:
Format{formatCode:=IBY_AMEX_REMITTANCE,formatType:=AMEX_REMITTANCE_FILE,templateCode:=IBY_AMEX_REMIT,defaultOutputType:=null,locale:=en_00,extract:=Extract{extractCode:=IBY_FD_PAYMENT_INSTRUCTION,extractVersion:=1}}
Exit: iby.engine.Format.Format (self loading constructor)

 

7.  Check the payinst.xml AMEX extract total which matches the total from the Scheduled Selection Payment output:

<Beneficiary><Name>AMERICAN EXPRESS</Name></Beneficiary><PaymentAmount><Value>356508.24</Value>

Scheduled Selection Payment pdf output

Document Count 548
Total Amount Payable 356,508.24

<ApplicationDocumentSubType>PAYABLES_DOC</ApplicationDocumentSubType><Applicat
ionUniqueInternalID>76202</ApplicationUniqueInternalID><ReferenceNumber>OER605
967.1</ReferenceNumber>
<ApplicationDocumentSubType>PAYABLES_DOC</ApplicationDocumentSubType><Applicat
ionUniqueInternalID>76202</ApplicationUniqueInternalID><ReferenceNumber>OER643
453.1</ReferenceNumber>
<ApplicationDocumentSubType>PAYABLES_DOC</ApplicationDocumentSubType><Applicat
ionUniqueInternalID>76202</ApplicationUniqueInternalID><ReferenceNumber>OER644
751.1</ReferenceNumber>
<ApplicationDocumentSubType>PAYABLES_DOC</ApplicationDocumentSubType><Applicat
ionUniqueInternalID>76202</ApplicationUniqueInternalID><ReferenceNumber>OER644
887.1</ReferenceNumber>


8. Check the Payment Process_Request_ Data Collector diagnostic <note  420427.1>

IBY_PAY_SERVICE_REQUESTS CALL_APP_PAY_SERVICE_REQ_CODE = SS PPR 1
IBY_PAYMENTS_ALL & AP_CHECKS_ALL = 356508.24 which is the same as SceduledSelectionPayment_xxxxxx.pdf & payinst.xml.


However it does not match the AMEX file output Amex_Remittance_Program_XXXXXXXX.txt total 188,011.90:

99 000001880119000030 000000000000000000   

 

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