EAP: Receiving Error On Submitting Data In ExceltoCI Template Using Component Interface VNDR_ID_EXCEL.

(Doc ID 2412737.1)

Last updated on JUNE 20, 2018

Applies to:

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

Symptoms

Receiving Error on Submitting Data in ExceltoCI Template

Steps:
The issue can be reproduced at will with the following steps:
1. Try to load the Vendor data using the Excel TO CI for Component Interface VNDR_ID_EXCEL.

Error1:
On Submitting the Data ,we receive an Error. tested the Data with New as well as Existing Data but still facing the Error.

# Invalid Value -- press the prompt button or hyperlink for a list of valid values (15, 11)
# Error changing value. {VNDR_ID_EXCEL.STATE} (91,34)

2. Remove the value for state.

Error2:
On Submitting the Data ,we receive an Error. tested the Data with New as well as Existing Data but still facing the Error.

#1 - Property or collection VENDOR_ADDR was not found in the component interface at the given level.

OR

# Invalid Value -- press the prompt button or hyperlink for a list of valid values (15, 11)
# Error changing value. {VNDR_ID_EXCEL.CORPORATE_VENDOR} (91,34)

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