General Technical Discussions for Service

Get Involved. Join the Conversation.


  • Justin

    thats a new one to me, ive seen max joins many times but never max sql statements. Do you have a copy of the report you can upload that i could run in one of my demo instances to see if it could be an issue with the report (i have a 19a instance and some still on 18c that i could try it on)

  • Sylvia S

    Hi Justin,

    I tried to re-import the report once more and it is successful. 



  • Gursimran Singh Saini

    I had similar issues with Custom Scripts.
    Then I found a better way of importing bulk data.

    Use Data Import Wizard.
    I know you want to import data with some customizations.
    You can do that through Data Import Wizard too. Just enable 'Run External Events/CPMs'.
    Make sure the CPM is Asynchronous.

  • Sylvia S

    Hi Justin,

    Yes I did. I followed the step-by-step process in the link: 



  • Christian Linke

    Maybe not exactly what you are after, but in BUI you can use the 'Bookmark' function to get a URL directly to a report (in the format https://[yoursite][report ID]). You could use this to put a link in a workspace to open a report in a new browser tab.

  • Justin

    Are you sure you Deployed the custom object before trying to import this report?

  • Sharon Levin

    the team that edits the article  uses word document, (no way to change the format). then I have to copy the content that edited into the AK.

  • Sebastiaan Draaisma

    Why not just use CSS for your formatting? That way if you ever need to change the format you only have to do it in one place and not in thousands of individual answers.

  • Gursimran Singh Saini

    This answer has everything you need to know about how Oracle Service Cloud handles bots.

  • mikewaldron

    This is a valid point. Let me noodle on it.

    Update: 'pon further consideration, I share your concern that relying on a timestamp is a smell. But that's kind of my original question, restated: I know I can get to those extension components using the path that apparently includes a timestamp, but I'm nervous about counting on that in an extension that's being deployed to production. Really, I'd be happier if there was some kind of path like


    I could use that would always point to the most-recently-deployed version of the extension. I haven't found such a thing in the documentation, but if it existed, that would put my mind on the issue to rest.

    I'll take a look at Parcel, but I'm also not comfortable using the CP assets folder for something that's not actually a CP asset.

  • Rajan Davis

     I have 2 ideas of what might be a happier path:

    1. Load your bundled scripts into the CP assets folder. The publicPath could then be set as "./euf/assets/themes/<theme-name>/" which avoids some magic timestamp.

    2. Use something like Parcel which requires 0 additional configuration.

    I strongly feel as though relying on some timestamp is a smell... There is probably a much simpler way to accomplish what you're trying to do.

    If you want to talk about this off the boards, send a PM and I can take a look to give better practical advice.

    Kind Regards,


  • mikewaldron

    Having learned most of this modern Javascript framework jazz within the last year, I can tell you that the frustrating thing about it is there seem to be very few straightforward answers. Typically, even on a platform like StackOverflow, a guy is more likely to hear "Use a different/better/my favorite tool/approach!" than he is to get an answer to the question he asked.

    Thank you for your input, but we're very close to finalizing a develop/build methodology for BUI/Vue.js after ~9 months of work, so I'm less than excited about starting over or making fundamental changes to how we're doing things.

  • Rajan Davis

    Hi Mike,

    I have built a BUI extension with Vue and am kind of perplexed as to what you're trying to accomplish here.

    You probably don't need this build process unless you are building a full on Vue application. If that is the case, I could be mistaken but I believe that this would need to match whatever comes off of the "/AgentWeb/" url for the Browser UI and not the location of where you BUI code resides (according to the Vue docs).

    If you're just building a single component, you can probably avoid this build step and use something like uglify-js to concatenate and compress your files (that's what I did with my example).

    Again, I could be mistaken, but I think what you're doing is really outside of what was envisioned for BUI, but is very common in non-OSvC platforms. With that said, I am not sure if there is a best practice or right way to do what you're accomplishing, so take what I said with a grain of salt.

    Hope this helps,


  • Maruvada Manoj


    I think with HCM Cloud Adapter, we can create connection and then process via Oracle Integrating cloud(ICS) to Service cloud.



  • Kishore Madhavan

    @Luuk: Has anything changed recently from Aug 16 or it still stays the same?

    @Vijay Jayavarapu : Have you tried using Osvc's REST API for Integration btw HCM Cloud and Oracle Service and how did it go?