AP: Need more information on the ECIN0001 process in regards to the PS_VCHR_PYMT_STG fields
(Doc ID 2199480.1)
Last updated on MAY 05, 2021
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.
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"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document