My Oracle Support Banner

EAP: ExcelToCI VNDR_ID Component Interface Error Upon Submission, 'Cannot Find Record.{VNDR_ID_ECEL.VNDR_LOC_SCROL(1).VNDR_LOC} (91,30)' (Doc ID 2966992.1)

Last updated on AUGUST 10, 2023

Applies to:

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


Using ExcelToCI VNDR_ID Component Interface to load supplier data. An Error is received when clicking ‘Stage Data for Submission’.


1. ExcelToCi File Connect Information tab > enter required values 

2. Template tab click Add-ins link > click ‘New Template’ > enter UserID, Password > Component Interface Name = VNDR_ID_EXCEL

3. Click on ‘Select Input Cell’ > Selected the following fields:
    Record Type 000: SetID, Supplier ID, Persistence, Short Supplier Name, Supplier Name, Display VAT Flag
    Record Type 8-0-0: Address Sequence Number, Description
    Record Type 8-1-0: Address Line 1, Address Line 2, City, State, Postal
    Record Type 10-0-0: Supplier Location

4. Click ‘New Data Input’ > Yes to message, ‘Are you sure you want to delete all the existing data in the Data Input worksheet?’

5. Enter field values in Data Input tab > click ‘Stage Data for Submission’ > > Staging & Submission tab shows Error




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.