OTBI
Discussion List
-
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H… -
Query to find out GL code combinations used in a bank account (LE and Org access Level)Summary: I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle do…Mansi1302 961 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Query to get customer profile historySummary: Query to get customer profile history Content (please ensure you mask any confidential information): We have a requirement where we are enabling Credit Limit at…
-
Adding approval history information to the reportHi, I designed a report that works the same as the standard notification with custom parameters. I would like to add the following field to the report, which comes in th… -
Can we move an asset from one work center to another work centerSummary Can we move an asset from one work center to another work center even if the work orders have been created on the assetContent Hi, Can we move an asset from one … -
Human Capital Management - Approval Notification Archive Real Time - Transaction ID missingSummary: Hi, I am trying to create a report using Human Capital Management - Approval Notification Archive Real Time subject area. I am unable to fetch transaction ID wh…
-
How to Restrict groupings with 0 from display in HR dashboard chartsSummary: Restrict groupings with 0 from display in HR dashboard charts Condition used in column Level: CASE WHEN "Workforce Trend"."Termination Headcount"Raman Singh 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current DateWe currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as o…Alex van Gulijk 272 views 14 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…Elliot Hall-Walker 58 views 3 comments 0 points Most recent by Risandu olitha Reporting and Analytics for ERP
-
Community of a learning course - OTBIDear all, We would like to report the community in which a COURSE has been integrated to. In my following example : for my COURSE "English language training", I would li…Jacqueline GRANDIN 31 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Learning Completion date of a course under specializationHi All, I am not able to get courses under a specialization to get its completion date. Any help is appreciated? Thanks-Praveen
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rick Jason 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Merge Lead Creation Date & Opportunity Creation DateSummary: We are having a scenario to populate total no of Leads & Opportunity created on Monthly basis. For FY2024, On monthly basis Jan'24, Feb'24 , Mar'24 etc . . It s…Vigneshwar 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report for Sales Orders Pending InvoicingSummary: We need a report showing us details of all sales order lines against which delivery is done but invoicing is not yet done, in real time. In other words a report…
-
Combining two rows of data into a single columnSummary: Combining two rows of data into a single column IF an employee has two degrees the expectation is to print it into a single row of data. For example Employee 12…Venkateswaran Murali-Oracle 235 views 15 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Not able edit the OTBI reports for developed by others usersSummary: Not able edit the OTBI reports for developed by others users. Can you please suggest Content (please ensure you mask any confidential information): Throwing an …Linga Murthy 11 views 5 comments 0 points Most recent by Linga Murthy Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Inherited Role Audit detailsSummary: Hi Team, Need a Role report that gives you the details for scenario: Role A is inherited by Role B(Employee Role) and assigned to Person A. Need to know below: …Arun Kumar Krishnan [AK] 31 views 3 comments 0 points Most recent by bobby.hussey Reporting and Analytics for HCM -
Passing real time binding parameter to OTBI as presentation variableContent I have a requirement to add OTBI report in Termination Page UI which will capture three Real-time Binding Parameters (Person ID, Termination Date & Termination N…User_2025-02-06-14-37-05-233 676 views 28 comments 0 points Most recent by GopalS Reporting and Analytics for HCM -
How can I create this formula for a custom column in OTBI?Summary: I'm attempting to create an asset replacement report with the ability to drill back to the replaced asset (DFF). I need to create a formula to compare two colum…Tasha Kretlow-Oracle 111 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI how to include manager department hierarchy in an analysisI have a need to include the Managers department hierarchy in an analysis. The managers department hierarchy does not appear to be a set of standard fields in any of the…Sharon Ferguson 55 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI users are able to edit the report when they have only Read permissionSummary: OTBI users are able to edit the report when they have only Read permission Content (please ensure you mask any confidential information): Version (include the v…Pablo Schenquerman 33 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba…User_2025-02-06-06-17-13-684 110 views 4 comments 3 points Most recent by Andres Hernandez Suarez Reporting and Analytics for ERP
-
Need help finding field in OTBI reportSummary: Hi Team, We have requirement to create a report to pull Progression Grade Ladder’s details. We created OTBI report using Workforce Management - Grade Rate Real …Saurabh_Mharolkar 61 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Custom ImagesHi all, Just a quick one I'm hoping someone knows the answer to! We've been using our own custom images for reporting and have noticed that the system allows us to uploa…MikeW 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
get earliest hire date by action typeSummary: Hello, I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case). The Analysis is to get “E…Alons 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Spend Authorization created by the user in the past is not visible in SA DashboardSummary: Spend Authorization created by the user in the past (Approved) is not visible in Employee's Spend Authorization Dashboard. But the user is able to see when he c…
-
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 132 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Merge Two OTBI Subject Area For PO receipt dateHi , We have a requirement to develop OTBI report for the following fields ( promised date, Requested Date and Receipt date) for po using two OTBI subject areas we are u…Prathyusha pari 122 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI Date Prompts for two analyses in order to compare data fieldsSummary: OTBI Date Prompts for two analyses in order to compare data fields. I used the instructions of this page OTBI HCM historical reporting (v-cdn.net) to set the da…Sa_De_Or 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM