Arun Raj
Arun Raj
  • 65
  • 272 017
Oracle BI Publisher : All About Date Parameters
In this video, we delve into using Date Parameters in Oracle Fusion BI Publisher Data Model and Reports.
#oraclebip #oracle #bip #bipublisher
Medium Articles on BI Publisher Web Services:
- tinyurl.com/2dbfu7t2
- tinyurl.com/u85p6pb8
- tinyurl.com/9xj98khz
- tinyurl.com/37kavy4v
-------------------------------------------------------------------------------------------------------------------
Let me know your suggestions and feedback!!
Connect with me
--------------------------
LinkedIn - bit.ly/3eFhI6V
Twitter - bit.ly/3dC2rCz
My Blog - quest4apps.com
Medium - bit.ly/3dFhQSX
Переглядів: 170

Відео

How to invoke a Pipeline from Pipeline in Oracle EPM
Переглядів 285Місяць тому
Let me show you how you can invoke a pipeline from a pipeline in Oracle EPM. Hit me up on LinkedIn if you have questions. REST API Documentation: shorturl.at/oryCF Medium Article on Connections: shorturl.at/mnw35 Blog: Invoke Pipeline from a Pipeline www.linkedin.com/pulse/invoke-epm-pipeline-from-arun-raj-a0c9c Support Me: Kofi: ko-fi.com/atarunraj Buy from Amazon using my link (I do get a kic...
How to Install Oracle Database 23ai on Windows
Переглядів 4,2 тис.4 місяці тому
Learn how to install Oracle Database 23ai on your Windows laptop or desktop #oracledatabase #oracledatabase23ai #23ai #oracle #database #oraclevmvirtualbox Here are the links: Download Virtual Box : www.oracle.com/virtualization/technologies/vm/downloads/virtualbox-downloads.html Download OVA File: www.oracle.com/ca-en/database/free/get-started/#quick-start Step by Step Guide: arun-raj.medium.c...
SQL Harmony Deep Dive with Alexey: SQL Developer for Oracle Fusion?
Переглядів 1894 місяці тому
Here is my discussion with the creator of SQL Harmony! We had fun discussing the tool. For any Oracle Fusion technical consultant, this tool might be a great add on to there arsenal. The tool also includes ChatGPT integration. And there are more planned as future enhancements. You can reach out to Alexey : www.linkedin.com/in/alexeymatveev/ Let me know if you like to see more videos like this. ...
SQL Harmony : Execute Oracle Fusion SQL Queries including ChatGPT integration
Переглядів 5044 місяці тому
Excited to share my latest UA-cam video featuring a fantastic tool for Oracle Fusion technical consultants - SQL Harmony! This tool is a game-changer, offering a high-level overview of its features and functionality, including ChatGPT integration. #oraclesql #oraclefusion #bipublisher #oraclecloud
Oracle BI Publisher : Create Dependent List of Values
Переглядів 9968 місяців тому
In this video, I will show you how to create dependent list of values in Oracle BI Publisher data model. #oraclebip #oracle #bip #bipublisher Medium Articles on BI Publisher Web Services: - tinyurl.com/2dbfu7t2 - tinyurl.com/u85p6pb8 - tinyurl.com/9xj98khz - tinyurl.com/37kavy4v Let me know your suggestions and feedback!! Connect with me LinkedIn - bit.ly/3eFhI6V Twitter - bit.ly/3dC2rCz My Blo...
Invoke EPM Data Pipeline from Groovy Business Rule
Переглядів 1,2 тис.10 місяців тому
#oracleepm #oracleepmcloud #datapipeline #epmgroovy In this video learn how to invoke an EPM Data Pipeline from a Groovy Business Rule. Topics covered: 1. Creating a connection 2. Creating global variables in calc manager 3. creating and deploying the Groovy business rule 4. testing the process Hit me up on LinkedIn if you have questions. REST API Documentation: shorturl.at/oryCF Medium Article...
Oracle EPM data Pipeline Cross Pod File Operations
Переглядів 63510 місяців тому
Create an EPM Data Pipeline to perform the below operations 1. Unzip file 2. Upload File to Remote EPM Instance 3.Download File from a remote EPM instance you will also learn how to create custom Variables to be used as part of the data pipeline. #oracleepm #oracleepmcloud #datapipeline #oracle Let me know your suggestions and feedback!! Connect with me LinkedIn - bit.ly/3eFhI6V Twitter - bit.l...
EPM Data Pipeline File Operations
Переглядів 1,2 тис.10 місяців тому
Create an EPM Data Pipeline to perform the below operations 1. Unzip file 2. Copy File 3. Move File 4. Delete File you will also learn how to create custom Variables to be used as part of the data pipeline. #oracleepm #oracleepmcloud #datapipeline #oracle Let me know your suggestions and feedback!! Connect with me LinkedIn - bit.ly/3eFhI6V Twitter - bit.ly/3dC2rCz My Blog - quest4apps.com Mediu...
Oracle EPM Data Pipeline Execute Options
Переглядів 2,3 тис.Рік тому
Oracle EPM Data Pipeline Execute Options
Cloud Miner: The SQL Developer Equivalent for Oracle ERP / HCM / SCM Cloud
Переглядів 775Рік тому
Cloud Miner: The SQL Developer Equivalent for Oracle ERP / HCM / SCM Cloud
Oracle BI Publisher : Add a List of Values to the Parameter
Переглядів 2,3 тис.Рік тому
Oracle BI Publisher : Add a List of Values to the Parameter
Oracle BI Publisher : Add a Parameter to the Report
Переглядів 3,5 тис.Рік тому
Oracle BI Publisher : Add a Parameter to the Report
Oracle Integration Cloud (OIC) Tutorial: Insert BIP Report Output to ATP Database Table
Переглядів 6 тис.Рік тому
Oracle Integration Cloud (OIC) Tutorial: Insert BIP Report Output to ATP Database Table
Oracle BI Publisher : Charts and Repeating Groups
Переглядів 5 тис.Рік тому
Oracle BI Publisher : Charts and Repeating Groups
Oracle BIP : Edit Layout and Add a New Report Layout
Переглядів 6 тис.Рік тому
Oracle BIP : Edit Layout and Add a New Report Layout
Oracle BIP : Create First Data Model
Переглядів 3,8 тис.2 роки тому
Oracle BIP : Create First Data Model
Oracle BIP Tutorial: Review Sample BIP Report and Data Model
Переглядів 4,6 тис.2 роки тому
Oracle BIP Tutorial: Review Sample BIP Report and Data Model
5 Oracle SmartView Tips for Oracle EPM and ERP Users
Переглядів 2,6 тис.2 роки тому
5 Oracle SmartView Tips for Oracle EPM and ERP Users
10+ Different Ways to Refresh Database in Oracle EPM Cloud
Переглядів 1,4 тис.2 роки тому
10 Different Ways to Refresh Database in Oracle EPM Cloud
Oracle Integration Cloud (OIC) Tutorial: Invoke BIP Report with Parameters
Переглядів 14 тис.3 роки тому
Oracle Integration Cloud (OIC) Tutorial: Invoke BIP Report with Parameters
Oracle Integration Cloud (OIC) Tutorial: Invoke BIP Report and Write Output to FTP Server
Переглядів 17 тис.3 роки тому
Oracle Integration Cloud (OIC) Tutorial: Invoke BIP Report and Write Output to FTP Server
Zoom Session on Python and EPM REST APIs
Переглядів 1,6 тис.3 роки тому
Zoom Session on Python and EPM REST APIs
Oracle Fusion OTBI For Beginners - Part 14 BI Publisher Report in OTBI Dashboard
Переглядів 4,6 тис.3 роки тому
Oracle Fusion OTBI For Beginners - Part 14 BI Publisher Report in OTBI Dashboard
Oracle Integration Cloud (OIC) Tutorial: FTP Adapter To Move Files Between FTP / SFTP Servers
Переглядів 10 тис.3 роки тому
Oracle Integration Cloud (OIC) Tutorial: FTP Adapter To Move Files Between FTP / SFTP Servers
Getting Started with Oracle EPM REST APIs - Part 2: EPM REST APIs using Python and Jupyter Notebooks
Переглядів 3,3 тис.3 роки тому
Getting Started with Oracle EPM REST APIs - Part 2: EPM REST APIs using Python and Jupyter Notebooks
Oracle Fusion OTBI For Beginners - Part 13 Your First Dashboard with Dashboard Prompts
Переглядів 8 тис.3 роки тому
Oracle Fusion OTBI For Beginners - Part 13 Your First Dashboard with Dashboard Prompts
Oracle Integration Cloud (OIC) Tutorial: Create REST API
Переглядів 22 тис.3 роки тому
Oracle Integration Cloud (OIC) Tutorial: Create REST API
Oracle Fusion OTBI For Beginners - Part 12 Anatomy of a Dashboard
Переглядів 2,6 тис.3 роки тому
Oracle Fusion OTBI For Beginners - Part 12 Anatomy of a Dashboard
New SmartView Extension for Oracle Account Reconciliation: Load Data using Excel
Переглядів 1,3 тис.3 роки тому
New SmartView Extension for Oracle Account Reconciliation: Load Data using Excel

КОМЕНТАРІ

  • @THARIQ-
    @THARIQ- 2 дні тому

    We are expecting videos on FlexFields & Bursting

  • @ProtyushGhoshal-ov7vp
    @ProtyushGhoshal-ov7vp 4 дні тому

    Hi Arun, I am so happy to see you resumed making videos on BIP, got to know so much new about default values parameters.

  • @Kimpossible__15
    @Kimpossible__15 4 дні тому

    so helpful tutorials thank you for your efforts, really appreciated!!

  • @THARIQ-
    @THARIQ- 6 днів тому

    You're an Underrated Gem 😇

    • @atarunraj
      @atarunraj 6 днів тому

      Appreciate the kind words

    • @THARIQ-
      @THARIQ- 4 дні тому

      @@atarunraj Expecting more fusion technical contents in future .... I Hope you will get more attention bro ❤

    • @atarunraj
      @atarunraj 4 дні тому

      Let me know if you have suggestions for content. Thanks. It will help if you share the channel and videos with friends, colleagues, etc.

    • @THARIQ-
      @THARIQ- 4 дні тому

      @@atarunraj Sure I will share with my friends

  • @vishalshinde3860
    @vishalshinde3860 8 днів тому

    Nice Explanation!😍 Sir Ji

  • @meiyappanamirthalingam1619
    @meiyappanamirthalingam1619 13 днів тому

    How do we practice sir! I am interested in learning. But I could able to sign in sir.

    • @atarunraj
      @atarunraj 9 днів тому

      Do you have access to demo.oraclecloud.com?

  • @shitalramtekeloa
    @shitalramtekeloa 14 днів тому

    I am trying same but I am calling ERP REST API and it fails at the authentication. Not sure how to make it work.

    • @atarunraj
      @atarunraj 14 днів тому

      Which rest api are you calling?

    • @shitalramtekeloa
      @shitalramtekeloa 14 днів тому

      @@atarunraj /fscmRestApi/resources/11.13.18.05/invoices . Trying to get all invoices in ERP. But unable to authenticate. Same credentials work on postman.

  • @romanticvideos9134
    @romanticvideos9134 14 днів тому

    Hi Arun, ESS job integration can we call through SOAP adapter?

    • @atarunraj
      @atarunraj 7 днів тому

      Can you expand on your question?

  • @SuperSagar1234
    @SuperSagar1234 26 днів тому

    Hello Arun, Would you please share the web service used for this purpose?

  • @vidyeshranade8849
    @vidyeshranade8849 Місяць тому

    Hello Arun, Excellent Tutorial!!! Very clearly explained in simple steps. No confusion. Use case is very-much used in the industry. Really enjoyed doing the same and cleared the doubts and consolidated the various concepts like parameter assignment, looping file operation actions etc. Thanks once again. Best regards, Vidyesh RANADE

  • @SwethaMukka-o9l
    @SwethaMukka-o9l Місяць тому

    Great Videos Arun ! I would like initiate the Data loads which connects with source for selected Period( Can we refer to Subs vars) during PIPELINE setup?

    • @atarunraj
      @atarunraj Місяць тому

      You can reference substitution variables and pass values to the prompts / parameters for the pipeline

  • @er.deepshikhasahu3094
    @er.deepshikhasahu3094 Місяць тому

    Please let me know if it will help me to create report now also in 2024?

  • @TruptiTivhan-r3t
    @TruptiTivhan-r3t Місяць тому

    Please Help me with formula its not working. Where I do mistake.

    • @atarunraj
      @atarunraj Місяць тому

      Without seeing what you did, it will be difficult to help.

  • @Chick0714
    @Chick0714 Місяць тому

    Can't we install windows zip file and use, sir?

    • @atarunraj
      @atarunraj Місяць тому

      sure you can. You will need to install DB and go through all the config. If you use the VM, everything is configured for you. You can start using right away.

  • @VSR_Garage
    @VSR_Garage Місяць тому

    Is it possible to download inbox/outbox files using groovy rest api in epbcs?? If yes could you please share the insights or reference docs on this….Appreciate your response

    • @atarunraj
      @atarunraj Місяць тому

      You can download files using REST APIs. You cannot use a Groovy Business Rule and expect to download the file to your local system.

    • @VSR_Garage
      @VSR_Garage Місяць тому

      @@atarunraj kindly share reference link having code (Rest api )to download the file… 2. By the way what process we can choose to move the file from windows server to linux or vicevers?

  • @sagarprit4293
    @sagarprit4293 Місяць тому

    How to do with schedule integration? Please help

    • @atarunraj
      @atarunraj Місяць тому

      Is your question how to schedule the integration?

    • @sagarprit4293
      @sagarprit4293 Місяць тому

      @@atarunraj my question is how to with schedule integration for invoke bip report with parameters , ??? Please help , i have seen many videos , all are using app driven methods for invoking report with parameters

    • @atarunraj
      @atarunraj Місяць тому

      Connect with me on LinkedIn. I am not clear on your requirement

  • @harikanth4336
    @harikanth4336 Місяць тому

    Hi Arun, Thanks for the valuable content. in my organization my user account was created but when i try to create simple analysis report that you were explained, i can't see the data so kindly help me what are the roles should be added to my user account so that i can create any reports related to AP and PO modules.

  • @divyadarji5152
    @divyadarji5152 Місяць тому

    Great explanation Arun Raj, can you plz tell me if is it possible to pass input files as parameter to groovy? What I am trying to understand is above example has unzip, copy, move and delete files options but is it possible to provide a prompt to load file itself at the time of running groovy ?

    • @atarunraj
      @atarunraj Місяць тому

      You can provide a prompt for the filename.

    • @divyadarji5152
      @divyadarji5152 Місяць тому

      @@atarunraj Yes, I have tried to provide the file name by using string type RTP, but in that case each time user needs to upload the revised file (in case of any changes in file) in inbox or in pipeline before running groovy so file can be picked up from there, but is there any way by which we can enable user to upload revised file directly via groovy, so user can directly upload the revised file from his local system while running groovy rule itself instead of uploading it in pipeline or inbox and then again running groovy for further file operations?

    • @atarunraj
      @atarunraj Місяць тому

      @divyadarji5152 Groovy doesnt have a function to upload file from the local system. The new REST API to copy file from SFTP Server to EPM could be useful. Provided the user can upload file to the SFTP server.

    • @divyadarji5152
      @divyadarji5152 Місяць тому

      @@atarunraj Okay, thanks..

  • @jeevithakonangi2064
    @jeevithakonangi2064 2 місяці тому

    Thank you, this was really nice.

    • @atarunraj
      @atarunraj Місяць тому

      Thanks for the feedback

  • @mrter2011
    @mrter2011 2 місяці тому

    it work . thank you

  • @AJ-qf2zg
    @AJ-qf2zg 2 місяці тому

    STILL USING 11G

  • @acprogress
    @acprogress 2 місяці тому

    Hi Arun, very nice video! . Would be good to have a video to create business rule /calcuation by using the drag drop as well as script? E.g. creating business rules to get 50% of an entity net profit and move to another entity etc.

  • @vinodkumar-k1c5u
    @vinodkumar-k1c5u 2 місяці тому

    Hi can you please the URL for PO i mean video at 12:20 that hyper link can please share and let me know where i can find

    • @atarunraj
      @atarunraj 2 місяці тому

      Here you go my friend docs.oracle.com/en/cloud/saas/procurement/24c/oapro/deep-links-for-procurement.html

  • @srinureddyjalireddy6472
    @srinureddyjalireddy6472 2 місяці тому

    When we migrate the report to another instance, we have to change the corresponding instance URL. Is there a way to do this dynamically, or is there a best approach for handling this?

    • @atarunraj
      @atarunraj 2 місяці тому

      Interesting question. Let me check on that b

  • @kmyersco
    @kmyersco 3 місяці тому

    Hi :) I am so grateful for these videos!! I knew what I wanted to build but had no idea how to get started until now

    • @atarunraj
      @atarunraj 2 місяці тому

      Glad to know the content is helpful. I am working on more. Let me know if you have specific requirements that you want to see in future videos.

  • @ThebL0dYsBeast
    @ThebL0dYsBeast 3 місяці тому

    Why we need a virtual box env?

  • @luisfwarriors
    @luisfwarriors 3 місяці тому

    Hello Arun, I am trying to make a report with this information but I can't do it, can you please help me, how can I do it? thanks. Cost Center Description Administrator Business Unit Cia_Op_Fact Cta_May__Fact Seg_Bus_Op I appreciate all your help, if someone in the group can help me with any idea or suggestion it will be welcome I try to make several reports, but I think what is wrong with me are the rules, it sends me an error as a result

    • @atarunraj
      @atarunraj 3 місяці тому

      Which subject area are you using to create your analysis ?

  • @mahmoudhamdy9550
    @mahmoudhamdy9550 3 місяці тому

    thank you Sir

  • @mahmoudhamdy9550
    @mahmoudhamdy9550 3 місяці тому

    great sir👏

  • @Pushtoonkhan622
    @Pushtoonkhan622 3 місяці тому

    How do you register the instance. which part of url needed to be copied?

  • @mahmoudhamdy9550
    @mahmoudhamdy9550 3 місяці тому

    awesome thank you

  • @mahmoudhamdy9550
    @mahmoudhamdy9550 3 місяці тому

    thank you sir

  • @mahmoudhamdy9550
    @mahmoudhamdy9550 3 місяці тому

    please i am beginner and when i choose this cloumns from Payable Invoice and choose result button the message apear to me is no result i perform search for this problem and assign the job role to my user and try again also same problem appear to me please how i can access this data , please help me

    • @atarunraj
      @atarunraj 3 місяці тому

      Message me on LinkedIn please

  • @srinureddyjalireddy6472
    @srinureddyjalireddy6472 3 місяці тому

    Thank you, Arun Raj, for the detailed information. Could you please make a video on how to create an OTBI report based on multiple subject areas?

    • @atarunraj
      @atarunraj 3 місяці тому

      Yes sir. One of the items in my plan.

  • @NianOuyang123
    @NianOuyang123 3 місяці тому

    Pretty cool video series for me to learn OTBI! 💯Thanks Arun! The link for white paper doesn't work now. Could you provide another link? Or do you have the similar white paper for HCM? 😁

    • @atarunraj
      @atarunraj 3 місяці тому

      Glad it is helpful. I will check the link . I am building a course on OTBI and BIP. Connect with me on LinkedIn and I will provide you with a discount code when the course is ready.

  • @תמיקדם-ט4ד
    @תמיקדם-ט4ד 3 місяці тому

    Thank you, Arun Raj, for your insightful and very useful UA-cam presentation. Can you tell me if it is possible to invoke EPM pipelines containing business rules from Groovy Business Rule, not just Data Pipelines? Thanks, Tami

    • @atarunraj
      @atarunraj 3 місяці тому

      You can invoke a pipeline from Groovy. The pipeline itself can have business rules in it. Let me know if that answers the question

    • @תמיקדם-ט4ד
      @תמיקדם-ט4ד 3 місяці тому

      @@atarunraj Hi, thank you, but when I tried to invoke a pipeline containing business rules the process failed.

    • @atarunraj
      @atarunraj 3 місяці тому

      What does the log file say??

    • @תמיקדם-ט4ד
      @תמיקדם-ט4ד 3 місяці тому

      @@atarunraj It says: "Error executing pipeline" The pipeline contains only one stage that runs a very simple BR which runs smoothly without any issues when I run the pipeline manually. But when I ran the groovy rule that invokes the pipeline, it ran into an endless process, and I had to stop it by changing the status to "Failed" manually. Thanks, Tami

  • @hanzalakhan3955
    @hanzalakhan3955 3 місяці тому

    Hello, Thank you for the video. Instead of adding the vendor name as a column is there a way to show vendor name (single value) on top of the table in the report output since that value is repeated. In other words, how to display the parameter in the report output without explicitly showing it in a column.

    • @atarunraj
      @atarunraj 3 місяці тому

      Yes we can. Let me make a quick video on that next

    • @hanzalakhan3955
      @hanzalakhan3955 Місяць тому

      @@atarunraj Hello: Have you made a video on that. If yes, can you please share because this requirement is in many of our reports.

  • @ProtyushGhoshal-ov7vp
    @ProtyushGhoshal-ov7vp 3 місяці тому

    OFFSET :P_OFFSET ROWS FETCH NEXT :P_LIMIT ROWS ONLY----> P_OFFSET= THE NUMBER OF ROWS YOU WANT TO SKIP, P_LIMIT=LIMIT THE NUMBER OF ROWS

  • @shubhampanchal9433
    @shubhampanchal9433 4 місяці тому

    Hi @ArunRajTutorials, Is it possible to upload a file from the local directory to the DM inbox folder via the pipeline?

    • @atarunraj
      @atarunraj 4 місяці тому

      It's not. You will look at EPM Automate or REST APIs

  • @alexeykondrakov5228
    @alexeykondrakov5228 4 місяці тому

    Great job Alex! Looking forward for new releases

  • @lovestitanic2004
    @lovestitanic2004 4 місяці тому

    Data Fusing, SQL Connect,cloudminer

    • @atarunraj
      @atarunraj 4 місяці тому

      Data Fusing seem to be extremely slow. I have tried SQL connect and CloudMiner. Both are paid products, but helpful.

    • @lovestitanic2004
      @lovestitanic2004 4 місяці тому

      @@atarunraj for Production SQL Connect is best but for Dev connects Data Fusing is best

    • @atarunraj
      @atarunraj 4 місяці тому

      SQL connect is good. Data Fusing is too slow. I would rather use my own Jupyter Notebook than use Data Fusing.

  • @Dhanasc
    @Dhanasc 4 місяці тому

    This something new I came to know today, thanks for the quick demo

  • @vigneshprabhu1
    @vigneshprabhu1 4 місяці тому

    Nice one Arun.. What happenes if we have parameters in the sql. Let me check today.

    • @atarunraj
      @atarunraj 4 місяці тому

      Great question. Check and let me know 😀

    • @alexeymatveev9031
      @alexeymatveev9031 3 місяці тому

      This was just added.

    • @atarunraj
      @atarunraj 3 місяці тому

      I will check it out tonight.

    • @alexeymatveev9031
      @alexeymatveev9031 3 місяці тому

      @@atarunraj and also now counting is optional for performance. Like, if you have a really big query and you would rather prefer it to execute faster -- uncheck 'count' option and you only receive data without count information.

  • @vakeeshganeshar9623
    @vakeeshganeshar9623 4 місяці тому

    Hi Arun, Thank you very much for sharing.

    • @atarunraj
      @atarunraj 4 місяці тому

      You are welcome. Make sure to join the live stream on Saturday so you can ask questions directly to the creator of the tool. Please do encourage your friends and colleagues as well. Cheers.

  • @nickaest4846
    @nickaest4846 4 місяці тому

    Thanks Arun!

  • @ahmadfathy8660
    @ahmadfathy8660 5 місяців тому

    clear to understand . thak you 💯

  • @ahmadfathy8660
    @ahmadfathy8660 5 місяців тому

    appriciate

  • @ahmadfathy8660
    @ahmadfathy8660 5 місяців тому

    I really benefit You put me on the way

  • @Firatayrilik
    @Firatayrilik 5 місяців тому

    Hello, thanks for the content. How to set REPORTNAME parametric? Like, "FILENAME_$YYYYMMDD" YYYYMMDD represents first day of the current month. Ty in advance.

    • @atarunraj
      @atarunraj 5 місяців тому

      I am not clear on what your requirement is. Report name cannot be dynamic. Are you may be looking at generating the report output name dynamically?

    • @Firatayrilik
      @Firatayrilik 5 місяців тому

      @@atarunraj yes, exactly. Can you help me?

  • @ahmadfathy8660
    @ahmadfathy8660 5 місяців тому

    very useful