OTBI
Discussion List
-
Annualized Full-Time Salary the same value as Annualized Salary for those with <1.0 FTESummary: Within the Compensation - Salary Details Real Time there is an option to pull in both the Annualized Salary and Annualized Full-Time Salary. When checking this … -
What is the OTBI item for "Organization" (under PO schedules)?We are trying to create a report that pulls the Ship-to location, PO number, and receiving organization (see above) to see where we have mismatching values (Ex: NATHW sh…
-
How do we get the Pay Period Month , Year , Max Gross Pay MTD in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…Alan-Oracle 1.2K views 14 comments 16 points Most recent by Mohamed Attia-Allah Reporting and Analytics for ERP -
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeHow to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time We are trying to create a Analysis report based on General Ledger-Tra…Pradeep Kumar Reddy V 1 view 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Is there a way to limit access to the worker assignment real time subject area?Summary: Hello, We have a "Learning Course Owner View All" data role that is essentially a learning admin. They have access to view all learning data including courses, …Tommy Sullivan 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…
-
Presentation variable based on another presentation variableSummary: I would like to print the Negotiation Title of the selected Negotiation Number in the Header. I have the Negotiation number in a presentation variable (pb_negot…VDM_IM 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to access Data Model via API?Summary: How to access Data Model via API? Content (please ensure you mask any confidential information): Hi, our customer have external dashboards, using PowerBI, and t…Max Prestes 128 views 2 comments 0 points Most recent by Max Prestes Reporting & Analytics for Sales -
Does anyone have a Leadership Hierarchy prompt or guidance on how to create one?Hello Does anyone have a leadership hierarchy prompt? If so can you share some guidance on how it was created? I want to be able to add a leadership hierarchy onto our d… -
Point in Time Headcount with Salary report - isolated doubling of salarySummary Our "point in time" report is mostly working. For a very small percentage, the salary amount is being doubledContent We have a report that is working fairly well…Cheryl Burwell 110 views 7 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
pass parameter in formula in otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…lbodeddula 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue occurring that seems to double values in certain fields e.g. FTE and SalaryContent We're experiencing an issue whereby assignment information in certain fields is multiplying; giving us inaccurate data. It's not occurring in the majority of cas… -
Custom role can't view people using analysis reportHi all, The users with custom role after adding the group members using the "Analysis Report Criteria" , they are unable to see the recipients when accessing the criteri…
-
About OTBI, BI and EXTRACTSummary: Use cases for OTBI, BI and EXTRACT. When we use Extract, when we use BI and when we use OTBI Content (please ensure you mask any confidential information): Hi T…
-
Display date in a pivot table (both for OTBI and BI Publisher)Summary: Display a date in a pivot table (OTBI and BI Publisher) Content (please ensure you mask any confidential information): Hi, I wish to create a pivot table like s…
-
Viewing reports history submitted by the userSummary: Our target is to see the reports history submitted by all the users in the fusion HCM. Please advise accordingly how can I retrieve this information. Content (p…Azhar SIDDIQUI 5 views 1 comment 0 points Most recent by Azhar SIDDIQUI Reporting and Analytics for HCM
-
Certain talent dashboard is unable to fetch data for talent admin role in Redwood 25B InstanceSummary: In one of the 25B Redwood non-prod instances(eg. instance A) ,the below issue is encountered. There are multiple Talent reports and all are working as expected …
-
SQL query to create value set for Manage Organization Tree Node namesSummary: We need to establish a value set to define the node names under Manage Organisation Tree. Do we have any SQL query to get to get the Node Name? If not please te…
-
Supplier Registration DFFs after Next-Gen Supplier Self-service Registration ImplementedSummary: After implementing the Security Policies against Value-sets linked to Supplier Registration Descriptive Flexfields, these flexfields are no longer available in …
-
Career StatementsSummary: Creating a Career Development's analysis report and I am unable to locate Career Statement in the subject area. Content (required): Looking to add Career Statem…
-
Reporting on Career StatementsSummary Enhanced Talent Profile & Reporting on Career StatementsContent Hi, Prior to upgrading to the Enhanced Talent Profile we used the following subject area and colu…Karen Waddell 89 views 7 comments 0 points Most recent by kamal_sethia_ Reporting and Analytics for HCM -
Any pointer on how PGP enabled Report output naming worksReport bursting logic is having fileName.txt, file is generated and delivered to SFTP as expected. We enabled PGP encryption and can see file name is still Filename.txt … -
OTBI Report does not show Person Legislative information DetailsSummary: Our business has created few reports where they are capturing personal details of users and it includes person legislative info but in OTBI the data is coming b…AbhishekLahoti 144 views 11 comments 0 points Most recent by Ilmars K. Reporting and Analytics for HCM
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 472 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP
-
Which table has attachment operation?Summary: In which OTBI table the operation attachment is saved for maintenance work orders? Content (please ensure you mask any confidential information): Version (inclu… -
OTBI report unarchive from one instance to another instance is not workingSummary: We are facing an issue with OTBI report migration between environments. A report (e.g., Account Analysis) developed in one instance was archived and then unarch…Farooq Syed, CPA, PMP, CISA, TOGAF 33 views 1 comment 0 points Most recent by James McBride General Ledger & Intercompany