AP: Need more information on the ECIN0001 process in regards to the PS_VCHR_PYMT_STG fields (Doc ID 2199480.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Goal

Need to know if there is any setup missing for the ECIN0001 process to resolve the error -A SQL Error was encountered during execution of the EC driver

 

EDI Manager is used to load vouchers.

 

When using the ECIN0001 program there are some fields which are missing and hence receiving errors as follows

1.Map ID(VCHRDEFN) Field Name(EFT_LAYOUT_CD) Source Field Number(0) Source Field Row(601). This is the pymt_stg table which does not exist in the 9.2 release in EDI.

2. Map ID(VCHRDEFN) Field Name(LINE_SEQ_NUM) Source Field Number(1) Source Field Row(601).3.Map ID(VCHRDEFN) Field Name(VAT_NONINV_AMT) Source Field Number(2) Source Field Row(601).

VAT_NONINV_AMT field . This FIELD doesn't appear in "VCHR_DST_STG_WD" record definition. It is defined on target record "VCHR_DIST_STG". LINE_SEQ_NUM field This field is defined on target record VCHR_LINE_STG and not defined in "VCHR_LN_STG_WD"

 


 

Solution

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