-
Which BI Role is required to develop OTBI Agent
Hi, Can you please suggest which BI Role is required to develop OTBI Agent? Do we need BI Admin Role to create or schedule OTBI Agent? Thanks in Advance.
-
Monitoring and analyzing HCM workflow email bounces
--Please advise if this post belongs in a different forum-- As we know, bursting emails is possible in BIP, and OTBI provides bursting via agents. Recipients receive messages from xxxxx.sender@workflow.email.us-ashburn.ocs.oraclecloud.com via agents/OTBI or from whatever vanity emails specified in BIP bursting setting.…
-
Reporting on Incomplete Applications
We are working with our Management Service team to create an Incomplete Applications report in BIP. Is this possible and if so, what fields do we need to pull? Thanks, Mark
-
How to add return button in error page of OTBI
I added return button on the result page in OTBI report using Javascript but that return button is not visible when error comes or in scenario of no data found. How can we add return button on the error page as well?
-
Can we update Tax Name in Oracle Fusion?
Hi Everyone, I would appreciate your insights on whether it’s possible to update the Tax Name of an existing tax in Oracle Fusion Financials. If direct modification isn’t supported, could you please suggest any alternate approaches we can consider to achieve this change? Your guidance would be greatly appreciated.
-
What is the procedure to configure the SSL certificate in oracle apex?
Hi, We are planning to enable the SSO to the oracle apex application. As a prerequisite to enable the SSO, we need the URL which we use should be in https (as a secure). Currently the URL is in http. Can someone please help to collect the details that are required to configure the SSL in oracle apex like and help on how to…
-
Error joining subledger and general ledger
Hello, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real Time and General Ledger: Journals Real Time. It works fine up to the point I add the a supplier DFF from the Journals Real Time subject area. The error message is as follows — Details: ADFException-3007: The View Object…
-
Not able to get department and position details in Worker Assignments Real Time Subject Area
Hello All, When I am trying to get the employee details like person number and name from Worker folder then it is visible but when trying to fetch department or position details along with employee details then getting No Results Message. Data is perfectly visible with employees having HR or Line Manager Role. the issue is…
-
Hi Community, I am seeing that multiple select options in OTBI is not working perfectly. Why?
Hi Community, I am recently seeing that multiple select options in OTBI is not working perfectly and the report jobs are getting failed. Is someone else facing this issue? What is the reason behind this issue and what is the fix?
-
How to retain column order when exporting a report in OTBI?
Hi, Is there a way that I can retain the report's column order when exporting in CSV file? I have been researching and all I can see was it is not supported by the OTBI application, and they are suggesting to just export it via Excel, but I have a requirement that it should be in CSV format because it will be used in Power…
-
all reports created in HCM with creation date
we have audit and security reconsilation requirement. to full fill this we need all reports crated in HCM with creation date or get the all the reports careated after certion date passed as parameter. checking each report manully for cration date is very complex as we have around 1000 reports and multiple teams migrate the…
-
Clarification on Oracle Standard Report for Natural Account Audit Details
Hello Everyone, We would like to confirm whether Oracle provides a standard report that includes details regarding the creation date and last update date of Natural Accounts in the system. This information is required for audit purposes, and we would appreciate your guidance on whether such a report is available within…
-
Deep links not working for Awards
I'm exploring using deep links in a variety of OTBI reports for PPM, and I've had a lot of success using them with Projects. However, when I attempt to use one for Awards, it isn't working properly. I'm using the following documentation for reference:…
-
Why is Employee BU not indexed in PFM subject areas?
For most reports, the Project Business Unit is an important filter condition and that works very well with most subject areas provided within the PFM module. However, there are reports that require filtering by the Employee Business Unit and not the Project BU. Consider US as a BU and Mexico as another BU. For tracking all…
-
What are the tables in the Time module
Hello! Can anyone help me? What are the tables that contain the information in the Time module?
-
can we build a link to a dashboard - but get the result directly as pdf
Summary: We use a link based on fndOverview to place a link on a page to go to a dashboard. The user then export to pdf to get the pdf. But the user wants to get the pdf. Can we add some kind of a tag to the fndOverview link to tell the otbi to export the dashboard into pdf ? Content (please ensure you mask any…
-
Need help in creating Waterfall Chart Using OTBI and to use it in Dashbaord
Hi team, I am creating a Dashboard, in the dashboard, one part includes creating a Waterfall Chart. I have pasted the waterfall chart below. This is basically about the headcount. In the dashboard I have three paramters as Payroll Period, Payroll Name and Concept. and the three will be applicable to this chart, based on…
-
How to hide the report filter from the user
Hi ! How to hide the report filter from the user
-
Table that stores working hours and days
Hello! I need to find the table that stores the information on this screen. Does anyone know?
-
API for Automating the OTBI Report download
Hello Experts, I have a data model and a report created from that data model. I need to automate the report download through an API call. Later, I need to run a Python script for post-processing. Can anyone please share an API endpoint that I can use for this purpose? Thanks, Sam,
-
Needing help with syntax for a Date filter
Hi, We picked up an old catalog file report from CC to do with Assignment Change. Unfortunately when we load it into our catalog it doesnt recognise the Subject area. However we can still run it somewhat to our needs but we just cant edit it properly. We would like to hard code a filter so it looks at returning data on the…
-
Rehired Employees are Unable to retrieve employment letter using the current user name
* ---- For example: Person Number: 187775 Current Username: A187775 (Results in an error) Old User Name: uakhokh (Fetches data correctly or could download the letter using this old user name)---- Query Segment with Possible Issue: The following part of the query (at the end) seems to be refencing the and papf.PERSON_ID =…
-
Updates to performance goals
Within the database itself, is it possible to see how often a goal is updated? Does the database create a new row when a performance goal or goal measure is updated? (Is it always in correction mode and won't be update mode?)
-
How to remove or hide the actions of a report so that the user cannot modify it
Hi! How to remove or hide the actions of a report so that the user cannot modify it
-
Check who has received an agent
Summary: Content (please ensure you mask any confidential information): Hi there, is there a way to see who has received an agent that I have set? Thanks Bobby Version (include the version you are using, if applicable): 24D Code Snippet (add any code snippets that support your topic, if applicable):
-
OTBI - Using custom images in HTML
Hello Experts, Is there any way to reference the images uploaded to the catalog via HTML? I've uploaded images to the catalog and would like to use them in HTML that I'm adding to a dashboard. I noticed when adding a Link/URL object to a dashboard I can select images from the catalog and it references it using…
-
How to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard
Hi Team, We are building a custom OTBI analysis in Fusion, need to know how to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard. Please share any info. if anyone worked on the same requirement. Regards, Sravan
-
How to set Ownership of /User Folders to SYSTEM ACCOUNT
Problem Description --------------------------------------------------- In PROD, ownership is currently set at Authenticated User In OTBI Catalog, within the ADMIN view the Catalog Root > User Folders directory we are unable to set /User Folder ownership set to System Account. Would like to know how we can set all User…
-
How to add row number (fixed order) in analysis?
Summary How to add row number (fixed order) in analysis? Content Hello Oracle Team, Is there a way to add row numbers in analysis? When I used RCOUNT(1), the row number will change when other columns are being sorted. Is there a way to lock row number so it does not change when other columns are sorted? Thank you. Jon…
-
"Security - Roles and Privileges Real Time" doesn't return inherited privileges
We need a OTBI report which does the same as Security Console Export Privileges and Roles. We tried out subject area Security - Roles and Privileges Real Time for Roles it gets similar results but for privileges it doesn't return inherited privileges. How we can get the data the same as under Security console, it is time…
