Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VBA and Smart View add-ins

LucLucSep 21 2016 — edited Oct 7 2016

Hello colleagues,

This is my first post in Oracle community, that's why I would like to say HELLO to all of you.

I need your expertise.

I creating VBS macro in outlook to automate HFM refresh process (take excel attachment refresh and reply). I stuck in the part responsible for load ad-ins in Excel part. Please see below:

Set xlApp = CreateObject("excel.application")

xlApp.Visible = True

xlApp.COMAddIns("Hyperion.CommonAddin").Connect = True

xlApp.Workbooks.Open ("C:\Oracle\SmartView\bin\HsTbar.xla")

Set xlApp = xlApp.Workbooks.Open(link_to_file, UpdateLinks:=False)

Above code create Excel application, run Smartview add-ins and open the specific file. Unfortunately Smart View add-in not load successfully. smartView fail.JPG

Would you mind help me/ give some advise?

Kind Regards,

Luc

Comments

SMOOTHEDATH

Hello @"Muralish"

Oracle EBS 11.5.10.2 is supported with Excel 2013 with patch 18402183 .

Please refer Document 1907418.1

So please upgrade EBS to 11.5.10.2 first

-Regards

Sohin

Muralish

Hi Smoothedath,

Thanks for your input.

Is there any other workaround to fix this issue without doing upgrade.

Thanks.

Muralish

Its working in "Microsoft Excel 2013(15.0.4569.1504) MSO(15.0.4569.1506) 32-bit"

But not working in "Microsoft Excel 2013(15.0.5207.1000)MSO(10.0.5172.1000) 32-bit"

Any help to fix this issue would be appreciated.

Thanks.

mdtaylor

11.5.9 exports to Office 2016 fine on Windows 10.

Screen Shot 2020-02-03 at 6.13.29 PM.png

Muralish

Hi Mdtaylor,

Thanks for you input.

Its very strange behaviour. Are you directly Opening the xls or saving it in local PC and then Opening it?

For me the issue is occurring only when I open it directly. Thanks.

mdtaylor

I am just opening directly.

Muralish

Ok. Thanks Mdtaylor.

I have another query which is not related to the issue which i posted in the subject.

JInitiator 1.1.8.19 is not working on wndows 8, so which JInitiator you are using on windows 10. Thanks.

mdtaylor

I have configured all of my EBS instances from 11.5.9 to 12.2.8 to use the same 1.6.0_27 Sun Java Plugin

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i (Doc ID 290807.1)

Muralish

Thanks Mdtaylor for all your valuable input.

mdtaylor

It appears that JRE note for 11i does not still have the steps for converting to JRE for 11i.  Let me know if you need those steps.

Muralish

Yes, could you please share the steps. Thanks.

Muralish

Getting "session" no longer valid message in access_log file.

172.23.193.254 - - [11/Feb/2020:15:06:42 +0100] "GET /pls/IGNPROD/fndgfm/fnd_gfm.get/34793954402/347938/fnd_gfm.xls HTTP/1.1" 200 5127

172.23.193.254 - - [11/Feb/2020:15:06:48 +0100] "OPTIONS /pls/IGNPROD/fndgfm/fnd_gfm.get/34793954402/347938/ HTTP/1.1" 404 370

172.23.193.254 - - [11/Feb/2020:15:06:48 +0100] "OPTIONS /pls/IGNPROD/fndgfm/fnd_gfm.get/34793954402/347938/ HTTP/1.1" 404 370

172.23.193.254 - - [11/Feb/2020:15:06:52 +0100] "HEAD /pls/IGNPROD/fndgfm/fnd_gfm.get/34793954402/347938/fnd_gfm.xls HTTP/1.1" 302 0

172.23.193.254 - - [11/Feb/2020:15:06:52 +0100] "HEAD /oa_servlets/oracle.apps.fnd.sso.AppsLogin?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fdeapvi5l.dcc.btignite.com%3A9010%2Foa_servlets%2Foracle.apps.fnd.sso.AppsLogin&errText=Your%20session%20is%20no%20longer%20valid.%20Please%20login%20again. HTTP/1.1" 500 0

mdtaylor

I attached the steps.  Please try to reproduce on Sun JRE.

1 - 13
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 1 2016
Added on Sep 21 2016
#essbase, #excel, #problem, #reports
6 comments
1,892 views