AP: Need more information on the ECIN0001 process in regards to the PS_VCHR_PYMT_STG fields
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.
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"
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