- Видео 67
- Просмотров 283 063
Arun Raj
Канада
Добавлен 3 июн 2011
My goal is to make it easy for you to learn Oracle ERP Cloud and EPM Cloud. I share videos mostly on OTBI, BI Publisher, OIC and Oracle EPM.
If you are interested in one on one trainings, or partnership, connect with me on LinkedIn.
Subscribe for videos on Oracle Cloud ERP and EPM. Connect with me on LinkedIn, Twitter and Cloud Customer Connect forums as well.
If you are interested in one on one trainings, or partnership, connect with me on LinkedIn.
Subscribe for videos on Oracle Cloud ERP and EPM. Connect with me on LinkedIn, Twitter and Cloud Customer Connect forums as well.
Oracle BI Publisher : Deep Links and Drill Through in BI Publisher
In this video, we learn how to include a deep link in a BI Publisher Report..
#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
#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
Просмотров: 134
Видео
Oracle BI Publisher : All About Date Parameters
Просмотров 410Месяц назад
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 Blo...
How to invoke a Pipeline from Pipeline in Oracle EPM
Просмотров 3422 месяца назад
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
Просмотров 6 тыс.5 месяцев назад
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?
Просмотров 2125 месяцев назад
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
Просмотров 5445 месяцев назад
Excited to share my latest RUclips 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
Просмотров 1,1 тыс.9 месяцев назад
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,3 тыс.11 месяцев назад
#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
Просмотров 68011 месяцев назад
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 тыс.11 месяцев назад
EPM Data Pipeline File Operations
Oracle EPM Data Pipeline Execute Options
Просмотров 2,4 тыс.Год назад
Oracle EPM Data Pipeline Execute Options
Cloud Miner: The SQL Developer Equivalent for Oracle ERP / HCM / SCM Cloud
Просмотров 815Год назад
Cloud Miner: The SQL Developer Equivalent for Oracle ERP / HCM / SCM Cloud
Oracle BI Publisher : Add a List of Values to the Parameter
Просмотров 2,6 тыс.Год назад
Oracle BI Publisher : Add a List of Values to the Parameter
Oracle BI Publisher : Add a Parameter to the Report
Просмотров 3,8 тыс.Год назад
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
Просмотров 6 тыс.Год назад
Oracle BI Publisher : Charts and Repeating Groups
Oracle BIP : Edit Layout and Add a New Report Layout
Просмотров 7 тыс.Год назад
Oracle BIP : Edit Layout and Add a New Report Layout
Oracle BIP : Create First Data Model
Просмотров 4,1 тыс.2 года назад
Oracle BIP : Create First Data Model
Oracle BIP Tutorial: Review Sample BIP Report and Data Model
Просмотров 5 тыс.2 года назад
Oracle BIP Tutorial: Review Sample BIP Report and Data Model
5 Oracle SmartView Tips for Oracle EPM and ERP Users
Просмотров 2,7 тыс.2 года назад
5 Oracle SmartView Tips for Oracle EPM and ERP Users
10+ Different Ways to Refresh Database in Oracle EPM Cloud
Просмотров 1,5 тыс.3 года назад
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
Просмотров 18 тыс.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,7 тыс.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,4 тыс.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
Просмотров 23 тыс.3 года назад
Oracle Integration Cloud (OIC) Tutorial: Create REST API
Oracle Fusion OTBI For Beginners - Part 12 Anatomy of a Dashboard
Просмотров 2,7 тыс.3 года назад
Oracle Fusion OTBI For Beginners - Part 12 Anatomy of a Dashboard
Que bom que te achei! Gostei bastante dos vídeos e vou reproduzir todos os relatórios no meu ambiente de teste. Estamos há 11 meses com a Oracle na instituição e como é difícil encontrar material de qualidade para estudar ainda mais para quem não é fluente no idioma inglês...Soube do customer connect há dias e estou explorando o ambiente, mas infelizmente não temos muito tempo de aprendizado, as solicitações por relatórios não param de chegar e encontrar esse canal foi uma maravilha. Agradeço muito por isso!!
Happy to hear. I do provide corporate training and one on one training as well. If there is any interest in that you can reach out to me on Linkedin - linkedin.com/in/sarunraj
really easy and to the point, well done and keep up the good work
Hi Arun, I want to ask whether we can invoke multiple pipelines from multiple EPM instances from one pipeline in one instance? Btw, you're creating great content. I appreciate your work.
I believe it is possible. Maybe i will create a video or blog on it
Awesome video Arun! Do you have a link to any Oracle documentation where the proper URL string is provided for other modules (i.e. Journals, Purchase Orders, etc..)?
Good question. I will post another video or article. Hopefully we are connected on LinkedIn.
Hello Arun , QQ , whats is the quickest way to export level0 data of ASO cube of all dimension with no filters on specific years or periods or any other dimensions??
Creating an EPM Export job is running forever and going to unknown state , will restapi works quick ?
Hi, 2 smalls questions 1. which is the use to invoke a pipeline from another? 2. you can associate a pipeline to card in the navigation flow?
I dont think you can associate a pipeline to a card. Something to try. One of the reasons you want to invoke is to perform a series of actions in a remote instance.
@@atarunraj it's not working ;( I don't know why, don't run the pipeline. Can you help me please! I really appreciate your help
Does this still work ? I can't open the site
Hi sir I have one doubt. I could see you have selected the 'file transfer style' for creating the integration. But in canvas page, its showing schedule orchestration. Both are same sir? Then in gen 3, there is option for 'file transfer style' sir?
I will start making videos for Gen 3.
Hi @Arun, thank you so much for this tutorial! I'm currently learning and developing BI Publisher reports, and this video has been incredibly helpful. One of the main challenges I’m facing is joining multiple tables, like GL transaction reports and P2P reports (requisition, purchase orders, good receipts, invoices, payments, GL). Thanks again
I will make few videos on this topic
@@atarunraj Thank you very much . Looking forward to update on masterclass BI Publisher course.
We are expecting videos on FlexFields & Bursting
Flexfields in BIP?
@@atarunraj Yes
Hi Arun, I am so happy to see you resumed making videos on BIP, got to know so much new about default values parameters.
Glad to know
so helpful tutorials thank you for your efforts, really appreciated!!
You are welcome 😊
You're an Underrated Gem 😇
Appreciate the kind words
@@atarunraj Expecting more fusion technical contents in future .... I Hope you will get more attention bro ❤
Let me know if you have suggestions for content. Thanks. It will help if you share the channel and videos with friends, colleagues, etc.
@@atarunraj Sure I will share with my friends
Nice Explanation!😍 Sir Ji
You are welcome
How do we practice sir! I am interested in learning. But I could able to sign in sir.
Do you have access to demo.oraclecloud.com?
@@atarunraj No Sir. shall create one?
You can try creating one
I am trying same but I am calling ERP REST API and it fails at the authentication. Not sure how to make it work.
Which rest api are you calling?
@@atarunraj /fscmRestApi/resources/11.13.18.05/invoices . Trying to get all invoices in ERP. But unable to authenticate. Same credentials work on postman.
Hi Arun, ESS job integration can we call through SOAP adapter?
Can you expand on your question?
Hello Arun, Would you please share the web service used for this purpose?
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
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?
You can reference substitution variables and pass values to the prompts / parameters for the pipeline
Please let me know if it will help me to create report now also in 2024?
Yes
Thanks for your reply. You are doing a great job indeed. @@atarunraj
Please Help me with formula its not working. Where I do mistake.
Without seeing what you did, it will be difficult to help.
Can't we install windows zip file and use, sir?
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.
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
You can download files using REST APIs. You cannot use a Groovy Business Rule and expect to download the file to your local system.
@@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?
How to do with schedule integration? Please help
Is your question how to schedule the integration?
@@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
Connect with me on LinkedIn. I am not clear on your requirement
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.
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 ?
You can provide a prompt for the filename.
@@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?
@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.
@@atarunraj Okay, thanks..
Thank you, this was really nice.
Thanks for the feedback
it work . thank you
STILL USING 11G
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.
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
Here you go my friend docs.oracle.com/en/cloud/saas/procurement/24c/oapro/deep-links-for-procurement.html
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?
Interesting question. Let me check on that b
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
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.
Why we need a virtual box env?
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
Which subject area are you using to create your analysis ?
thank you Sir
great sir👏
How do you register the instance. which part of url needed to be copied?
awesome thank you
thank you sir
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
Message me on LinkedIn please
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?
Yes sir. One of the items in my plan.
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? 😁
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.
Thank you, Arun Raj, for your insightful and very useful RUclips 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
You can invoke a pipeline from Groovy. The pipeline itself can have business rules in it. Let me know if that answers the question
@@atarunraj Hi, thank you, but when I tried to invoke a pipeline containing business rules the process failed.
What does the log file say??
@@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
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.
Yes we can. Let me make a quick video on that next
@@atarunraj Hello: Have you made a video on that. If yes, can you please share because this requirement is in many of our reports.
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
Hi @ArunRajTutorials, Is it possible to upload a file from the local directory to the DM inbox folder via the pipeline?
It's not. You will look at EPM Automate or REST APIs
Great job Alex! Looking forward for new releases
Data Fusing, SQL Connect,cloudminer
Data Fusing seem to be extremely slow. I have tried SQL connect and CloudMiner. Both are paid products, but helpful.
@@atarunraj for Production SQL Connect is best but for Dev connects Data Fusing is best
SQL connect is good. Data Fusing is too slow. I would rather use my own Jupyter Notebook than use Data Fusing.