OTBI
Discussion List
-
How to use/review Oracle predefined data models ?Summary: Hi, I am facing an issue which is i am not able to see some of the predefined reports/data models. For instance "Work order material transaction e-record report… -
How to fetch the Opening and Closing balances(quantity and value)Summary: We are trying to develop a report where we can fetch the Opening and Closing Balance(quantity and value) over a period of time. We are not able to find the requ…
-
Unable to use deep link to navigate to view journal page through OTBI.We want to use Deep links in our OTBI report for journals. By using that deep link we should be able to navigate to view journal page in the application. However we have…KanikaGupta 629 views 1 comment 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How can I see the Goal Tasks details of inactive employees in the Analysis report?Hi, I am preparing an analysis report from the Workforce Goals- Goal Tasks Real Time subject area and I have added 'Display Name' , 'Task Name' and 'Comments' fields to …Cansel Karasoy 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report that shows what OBTI is attached to an InitiativeSummary: We need to run a report that shows what OBTI Analysis is attached to an initiative, so we know which are currently in use. Content (required): Learning Initiati…
-
Reporting on specialization sub statusesSummary Reporting on courses below specialization levelContent Hello We have a number of 'induction' specializations containing a number of courses and we are having two…
-
attachment in bursting not addingSummary: requirement is to add attachment using data model for custom report, in bursting section we have added email bursting and adding attachment but we are receiving…Rehber Hussain 104 views 5 comments 0 points Most recent by Rehber Hussain Reporting and Analytics for HCM
-
Is there a way to pull in current assignments from Person Profile Real Time?Summary: Subject Area: "Workforce Profiles - Person Profile Real Time" Content (required): Hi All, We have been attempting to pull only the current active assignment fro…William_Johnson 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Pull current assignment only from Workforce Profiles - Person Profiles Real Time subject area?Summary: Subject Area: Workforce Profiles - Person Profiles Real Time Pull only most recent, current assignment - NOT past assignment data Content (required): Hi All, *R…William_Johnson 61 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Workforce Talent Review - Talent Review Tasks Real Time administrator view of all tasks in system?Summary: Subject Area: Workforce Talent Review - Talent Review Tasks Real Time HR View All security assigned to report creator Content (required): Hi All, For the Workfo…William_Johnson 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
SQL to take out alternating rows for Risk and Impact?Summary: Subject Area: Workforce Profiles - Person Profile Real Time Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss" Content (required): Hi A…William_Johnson 54 views 10 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
What is Rating Model 1, Rating Model 2, Rating Model 3 in Person Profile Real Time subject area?Summary: Subject Area: "Workforce Profiles - Person Profile Real Time" Columns: "- All Profile Content"."Rating Model 1", "- All Profile Content"."Rating Model 2", "- Al…William_Johnson 21 views 0 comments 0 points Started by William_Johnson Reporting and Analytics for HCM
-
History of Requisition/ Negotiation view or download of attachment?Summary: Is there a way to get a history of a Requisition or Negotiation of the users who viewed the transaction or who downloaded a attachment of the requisition or neg…
-
Why Miscellaneous Receipts not considered in the Receivable to Ledger reconciliation report.Summary: Why Miscellaneous Receipts not considered in the Receivable to Ledger reconciliation report. Content (required): Version (include the version you are using, if …
-
We need to fetch the latest record only in OTBI how can we achieve this requirement ?Summary: Hi Team, in below attachment filled by Hr team for employee in multiple times of records creating and report also fetching three records, but Business wants to …AjayKumar Maddipati 482 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
ORC-OTBI Report we have used two subject areas but report still searching modeSummary: Hi Team, I have developed OTBI report by using recurting real time and recurting real time we used but no out after long time also. Please find attachement of i…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Need list of Item EFF attributes used in existing OTBI reportsSummary: We need to identify the Item EFF attributes not being used in any of the OTBI report defined in the instance and disable the BI enabled flag for them. Since we …sudheer.movva 151 views 2 comments 0 points Most recent by sudheer.movva Product Master Data Management
-
Secure Reporting on Person Special Category DataSummary: In 23B we see there is a new feature to secure reporting on Ethnicity, below is the detail. We also require this capability for other sensitive categories such … -
Is there any subject area to get the Module to which each object belongs toSummary: What is the equivalent Subject Area for this table - adf_extensible_table_usage Content (required): 'adf_extensible_table_usage' has a column - 'Application_nam…Venkateswari 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Reporting on element entry Correction - getting new and former values?Summary: There is a need to report on changes made to an element entry record of a person, where the 'Correct' editing option was used (not Update). We are seeking to ge…Shant Sarkissian_NES 51 views 7 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Missing Bank Details for Rehires and Global Transfers not linked to latest Personal Payment MethodsSummary: Bank Details for Employees who have transferred from one Legal Employer to another or for Rehires are not updated against their new Personal Payment Methods. Co…GJ79 82 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
OTBI Analysis - Pulling the latest effective dated recordSummary only want to see the record with the latest effective dateContent I am in need of assistance to create a filter to include only the latest date record in my anal…Shelly Feyerherm 857 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Element Entry Changes ReportSummary Copying an existing BI Publisher versionContent Hi, I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the re…User_2025-02-05-22-44-35-842 104 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Query to get blanket purchase agreements and all their detailsSummary: I can't find a query to get the Blanket Purchase Agreements for oracle cloud fusion report. Content (required): I need to get the Blanket Purchase Agreements in…
-
OTBI HR Help Desk Reports Not Returning Data, Security MappingSummary: Creating a all module reporting role, and added all the transactional duty roles specified to HR help desk. Additionally, have added DSPs to view all Service ty…
-
Is it possible to route Project budget approvals to PM supervisor?Summary: Content (required): I am trying to setup budget approval rules to be sent to project manager supervisor but I can't seem to find the supervisor attribute in the… -
How to Generate a BIP Report in xlsx Format with 90+ Report FieldsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 71 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
hcm bi report - how to schedule report on every end of monthSummary hcm bi report - how to schedule report on every end of monthContent Hi, I wonder how to schedule HCM BI report on every end of month. I wasn't able to find the o…