-
Any Subject Area in OTBI to achieve employee wise fixed cost CTC based on selected month
Hi, We have a requirement to display the sum of CTC of all employees for that particular month selected via month input parameter. Please find the below sample requirement screenshot and assist if we have any subject area available to achieve the ask. Thanks, Chetan
-
How to Join DOO_HEADERS_ALL table with PO_HEADERS_ALL or PO_LINES_ALL table?
I need Order number from DOO_headers_all, then item description from PO_LINES_ALL, also I need receipt_number and invoice number. HEADER_ID is not matching with PO_HEADER_ID or SEGMENT1.
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real Time
Hi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area : Procurement-Purchasing Real Time and Procurement-Requisitions Real Time…
-
OTBI Prompt - Last Day of the Previous Month 23:59:59
Hi all, Hope you are keeping well. So far, within a Prompt we are using the following code and this does indeed bring back the Last Day of the Previous Month successfully: SELECT TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) FROM "Workforce Management -…
-
OTBI Question: comparing columns from two subject areas
Hi All, I have a question on creating a filter using columns from two subject areas. For example, "Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."Effective Start Date" < "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Notified Termination Date" results in…
-
How to build an Analysis on OTBI to show every colleague's default expense account?
Summary: Need report to show all colleague's default expense accounts. Content (required): I need to create a report to show every colleague's default expense account so we can review and update colleague's who have moved to different departments within the company. Currently I cannot find a way to build a report like…
-
Duplicate rows in Active Employees Report
When running the Active Employees Report I am getting duplicate rows for only a few of the employees. What is the best workaround for this?
-
Equivalent table in cloud fusion for the EBS standard table fnd_responsibility
Dear Experts, I am trying create a OTBI report using a simple query as shown below using standard EBS table 'fnd_responsibility'. But it throws an error 'ORA-00942: table or view does not exist'. Kindly advise what is the equivalent table in cloud fusion for fnd_responsibility. This is the navigation we are following to…
-
How to get list of custom OTBI Reports run Details in Fusion
Hi All, I am looking to extract the list of OTBI reports run details like report run date, who/when submitted, report path, report name etc.. Could you please help me where we need to get those details in backend? Thank you.
-
Query that link Legal Employer to Reporting Establishment
Hello! Good morning/afternoon/evening ! I am in a need of a query that can list all the Reporting Establishment for a Legal Employer. Does anyone have it or know if it's possible? I tried here but I couldn't find any way to do it
-
Is there any specific Privilege to restrict To See/edit Scheduled Report Jobs From Other Users
BI Admin Unable To See/edit Scheduled Report Jobs From Other Users ( Doc ID 2497964.1 ) - This document ID referring to have BI Admin role, BI Admin is an admin role so we cant add this role all users. We are looking for specific Privilege to restrict view / edit scheduled report Jobs from Other Users
-
Report on usage of OTBI reports
We are reviewing our reports in OTBI, please can you provide the following: A list of folders that have not been run in the last 14 months? Can you please confirm whether we can pull the report either from BIP or OTBI?
-
How to find if a specific day falls between two dates - OTBI
Trying to create a formula to show yes/no if the 12th of the month falls between {"Payroll Period"."Start Date"} and {"Payroll Period"."End Date"} I attempted a simple formula: CASE WHEN DAY("Payroll Period"."Start Date") <= 12 and DAY("Payroll Period"."End Date") >=12 THEN 'Yes' WHEN DAY("Payroll Period"."End Date") = 12…
-
Restrict visibility on self data on a OTBI report
Hello, How can I restrict the visibility on self data for a user? in an OTBI report. For exemple : A HR representative opens a report. He will see all the population, except himself. It is sometimes automatic, with the security in the system but not on all reports. Thanks, Jacqueline
-
how compess the fields
-
How can we add date parameters through advance SQL in OTBI?
Hi All, We have a custom OTBI report that in which we want to add some date prompts, Can anyone guide me how to add date prompt from advance sql? How we refer parameter from advance sql query to OTBI prompts?
-
How to pass parameters through agents in OTBI?
Hi All, We created a fully customized OTBI report to fetch balance details, all the customization is done through advance sql/XML, the report is running fine manually, but when we try to schedule the report(Through agent), we don't see any option to pass the parameters. Please assist. Regards, Sushant
-
No data from User System Usage subject area
We're using this analysis from the start of the implementation to know how many users are accessing the system. However, the data was stopped at October 2023 and I'm pretty sure that there must be data for the current year. Is there any scheduled process that I need to run? Thank you!
-
Roles to Create and Schedule an OTBI Agent
Good Day, Just want to ask what roles should be given to the user to be able to create and schedule an OTBI Agent. Thank you.
-
What is the logic to add while creating the prompt in the Logical sql query in OTBI
Suppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as a Prompt on which user will enter dates as required. What will be the logic for that in the Logical sql query? And what else we have to add while creating…
-
How to create a report/Analysis in OTBI to have details with respect to Security Audit?
I need to create report with fields listed as below: User Name, User Email, Role Name, Role Provisioned date, Role provisioned by What are the steps/Subject areas/ SQL?
-
How to plugin OTBI analysis into Microsoft PowePoint (PPT) ?
We have a requirement where we need to be able to pull individual OTBI analysis (with graphs) to be pulled into a slide in PPT. I looked on the documentation, there is no plugin available for PPT. Could somebody help on this topic ? Thanks, Prasad
-
Add restrictions to the subject area General Ledger - Transactional Balances Real Time
Hello everyone, First of all, thank you for taking the time to study my question. I use General Ledger - Transactional Balances Real Time to create a GL report to identify discrepancies. However, discrepancies were noted because the GL report takes into account adjusted payments and revaluation entries. So I would like to…
-
Oracle Mobile Application Designer (MAD) Deprecation
In the April 2024 Release (24B), the Oracle Mobile Application Designer (MAD) feature is disabled in Oracle Transactional Business Intelligence. If you wish to enable the Mobile Application Designer feature, the administrator can set the Enable Mobile App Designer property to true in the Publisher Runtime Configuration…
-
Use a Oracle Data Base as a Data Source For Reporting
Hello Our customer is looking for a solution for a reporting app. At the moment they have some products for Oracle Fusion Cloud Application which include the tool OTBI. Also they use Oracle E-Business Suite (On Premise) for the other applications. My idea is to use CLOUD OTBI as a reporting tool for the On Premise…
-
Event Date field generates too multiple rows for the same job req phase OTBI
Hi experts, we have created an OTBI analysis with the following fields taken from the 2 subject areas: Recruiting real time and Recruiting event real time. We have seen that the Event Date column generates too many rows for the same event phase code. Is it possible to remove all those multiple rows? thanks in advance.…
-
Combining Recruiting - Recruiting Real Time and Recruiting - Recruiting Event Real Time
Hi All, I have created a report using 'Recruiting - Recruiting Real Time' and one of the column Rejection/Withdrawal Reason("Recruiting - Recruiting Events Real Time"."Job Application History - Event Details"."Reason Name") is in 'Recruiting - Recruiting Event Real Time' which I tried to fetch but the result is blank.…
-
Candidate Job Submission With Requisition in OBIEE
Hi All - We are trying to extract report in OBIEE for Job Submission we have created the report with all the candidate fields on the application and added filters Submission is complete and applied main filters on Requisition Creation Date is the main criteria filter for us to extract. Fields also has requisition id and…
-
Not getting email from BI Agent
Hi Team, I have created a BI Agent using a condition, have selected an analysis in the condition section of the agent, analysis is basically giving the results of controls and incidents and respective investigators for the incidents. And in the recipients tab have enabled the 'Get Recipients from the Analysis Used in the…
-
How to Resize the Column in OTBI Report Views
Tried to apply Additional Formatting Options (width, height, etc. fields) and also applied Column Properties too ,which doesn't work as expected, is there any other way we can Resize columns ?
