Do you find OEBS RAagent.zip file in AutomicDownload?

[IndikaPeiris611408]

Dear Community,

AWA ,RA - Oracle E-Business Suite AgentGuide document asking to use some SQL files(aq_admin_setup.sql,aq_user_setup.sql,upgrade.sql,eOEBS_DROP.sql ... etc ) which need to be downloaded from the AutomicDownload center ( ZIP file call "OEBS RAagent.zip"). 

I tried and did not find any such file in the AutomicDownload center . can someone please help me find whare exactly this file is?

Thank you,
Indika peiris

[Legacy User]

https://downloads.automic.com/downloads/advanced_mode?selected_tab=&lifecycle_entity_id=1409731986384&component_id=1409731986840&search=&no-default-values=on&show-files=on&show-patch-descriptions=on

There you go

kindest regards,

Harald

[Tran-Hoang_Hau_348]

Well If you are downloading RA OEBS 4.0.0 (RA.Oracle.EBS_RA.OracleEBS.Solution_4_0_0+build.14) from download page, Sql files are missing from the zip package and we are fixing these issue, as a workaround, we can use the V3.1 sql files from the download center.

[IndikaPeiris611408]

Harald Heidinger

Thank you for the quick response.
I have already downloaded available ZIP files(RA.Oracle.EBS_RA.OracleEBS.Solution.NoWeb_4_0_0+build.14.zip) from AutomicDownload center. It has got only "OebsAgent_solution.jar" file and could not see any SQl files.

I'm looking for the SQL files(aq_admin_setup.sql, aq_user_setup.sql, upgrade.sql, OEBS_DROP.sql ... etc ) which is mentioned in the Oracle E-Business Suite AgentGuide document.

https://us.v-cdn.net/5019921/uploads/editor/xk/75v7xs1avc0u.png" width="710">

Rgds,
Indika Peiris

[Legacy User]

Indika,

Thankfully Tran-Hoang_Hau_348 has the solution for you, please use the files out of the OEBS 3.1.1 installation. The OEBS 4.0 does not contain them.

[IndikaPeiris611408]

Tran-Hoang_Hau_348

Thanks.
Will there be any version conflicts if I use those SQLs from the old Agent version?

I'm on AWA 12.0.0 HF4 and OEBS agent 12.0.0.

Rgds,
Indika Peiris

[Tran-Hoang_Hau_348]

Indika Peiris said:

Tran-Hoang_Hau_348

Thanks.
Will there be any version conflicts if I use those SQLs from the old Agent version?

I'm on AWA 12.0.0 HF4 and OEBS agent 12.0.0.

Rgds,
Indika Peiris

I would say, there should be no problem since there is no change made to their files from V3.1 and I also believe if you are on V12 then you should use for the AWI
RA.Oracle.EBS_RA.OracleEBS.Solution_4_0_0+build.14.zip 

[IndikaPeiris611408]

Tran-Hoang_Hau_348

Thank you for the support. I will take the SQL files from the "RA.Oracle.EBS_RA.OracleEBS.Solution_3_1_0+build.2.ZIP".

One last question, I have my AE Test environment server processes and the OEBS Agent installed on one windows server. I'm trying to connect to our OEBS Application test environment which is running on Linux. As per the documentation this combination should work. Can you pls confirm?

Reason for the question is that , when we have OEBS Application with Multi node configuration , document guide us to install OEBS Agent on the Oracle node where the primary node with Oracle E-Business Suite.

https://us.v-cdn.net/5019921/uploads/editor/mm/kqgj1k51a3ah.png" width="718">
Rgds,
Indika Peiris

[Tran-Hoang_Hau_348]

Hi Indika Peiris 

I can confirm that scenario would work as it should, Linux or window doesn't matter as long as your set up of Connection object, Agent, Jobs are correctly, then It will work.

Cheer,
Hau

[Tran-Hoang_Hau_348]

Now the fixed version for this issue was released on 2017-01-19 RA.Oracle.EBS 4.0.1