OTBI
Discussion List
-
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 1 view 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 87 views 7 comments 0 points Most recent by kamal_sethia_ Reporting and Analytics for HCM -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 219 views 15 comments 0 points Most recent by Bhaskar Konar 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 111 views 11 comments 0 points Most recent by Ilmars K. Reporting and Analytics for HCM
-
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one…AjayKumar Maddipati 171 views 5 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 399 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 21 views 1 comment 0 points Most recent by James McBride General Ledger & Intercompany -
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 1K views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM -
OTBI field results cut offSummary: When I run the attached XML in OTBI, the field results in the vendor name are being cut off. https://us.v-cdn.net/6034893/uploads/MND2YD7J3DWH/element-entries-w…Julie Mandel 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However…Valerio Curzi 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Which table stores material transaction history of a work order?Summary: Which table stores material transaction history of a work order? Content (required): Hi, there! I'm building a report to get material transaction history becaus…Andres De la Ossa-Oracle 1.1K views 3 comments 0 points Most recent by Jose Zuria-Oracle Manufacturing -
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti… -
Audit Trial for Workforce Compensation Approval taskSummary: Content (please ensure you mask any confidential information): Hello experts, when approving compensation plan (Approval task) the name of the last approver alw…
-
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask…Karen Settembrino 11 views 0 comments 0 points Started by Karen Settembrino Reporting and Analytics for HCM -
Extracting data from project management pvos and linking them to build an external reporting model.I need to extract data out through Project PVO's in order to fullfil an external reporting requirement. I am trying to find the PVO to bring below information together a…
-
Need a SQL query to list suppliers with access to the Supplier Portal in Oracle FusionSummary: Need a SQL query to list suppliers with access to the Supplier Portal in Oracle Fusion Content (please ensure you mask any confidential information): Hi everyon…
-
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF… -
Unable to Only Return Rows Relevant to the User Running the Agent using more than one subject areaContent Hello, We have a bursting agent to let our managers know that they have a new hire which was working previously. We've recently added the personal email into the…User_2025-01-31-00-25-12-234 26 views 12 comments 0 points Most recent by AvinashP Reporting and Analytics for HCM -
Reporting on Publish End Dates on Course or Offering LevelContent We have a dashboard report with various filters. One includes a dropdown with selection of the various courses. Some of them are not applicable/useable anymore a… -
How to capture a field with blank spaces at the end?Summary: We are trying to create an audit report that will identify email addresses that have extra spaces in them. Any idea how to capture those outliers in a report? C…CGardner01 31 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM
-
How can I populate longitude and Latitude in OTBI report?Summary: Hello, I am here to inquire about 25B new feature by the name: New Address Attributes Added to Worker and Location Dimensions. I am trying to create an OTBI rep…Vaishnavi Katiyar 21 views 4 comments 0 points Most recent by Vaishnavi Katiyar Reporting and Analytics for HCM