Excel to CI Run-time error 1004 after clicking 'Post Results' button.

3034235 Sep 17, 2015 7:09 PM

After submitting a data input sheet for VNDR_ID_EXCEL CI, I clicked the 'Post Results' button received this error: "Run-time error 1004 Select method of Range class failed".

I have also seen an error after clicking 'Stage for Submission', where the 'Staging and Submission' sheet is created entirely grey with none of the data from the data input sheet.

See the attachments.

Excel 2010 being used on PS Financials 9.1.

RUNTIME_ERROR.docx 19.9 K

1. Re: Excel to CI Run-time error 1004 after clicking 'Post Results' button.

Alvin.Daquioag Sep 18, 2015 1:05 AM (in response to 3034235)

Request for the fresh ExcelToCI.xls and load your VNDR_ID_EXCEL CI again to see if you are still encountering the error.

There are times that the worksheet (e.g. sheet itself, macro, etc.) gets tampered with causing this issue. An example would be https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=vcjpzd9l7_9&_afrLoop=507460875166503#CAUSE
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Excel to CI Run-time error 1004 after clicking 'Post Results' button.

3034235 Sep 18, 2015 6:23 PM (in response to 3034235)

Ok, thank you very much.

We are not aware of any tampered or modified macros/code in our ExcelToCI.xls, but we will continue testing to see if it occurs with more regularity or consistency.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.