OTBI
Discussion List
-
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 51 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 22 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 471 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 52 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 843 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 103 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…
-
Query for unearned revenue in oracle fusion from RA_CUST_TRX_LINE_GL_DIST_ALL tableSummary: we have Oracle fusion cloud services and we need to develop a report for unearned revenue how Can I identify the unearned revenue from RA_CUST_TRX_LINE_GL_DIST_…Shameer Muhammed P M 511 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
We have new requirement in my workforce page how find which subject area available ?Summary: HI Team, we have new requirement in my workforce page > additional person info group. which subject area available . Any one help me on . Thanks. Ajay Content (…AjayKumar Maddipati 51 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Need Table or Subject area with "Assessable Value"Summary: We need to retrieve the information that is on column "Assessable Value" on the PO Lines. Content (required): Cannot find "Assessable Value" on any OTBI Subject…
-
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim…Faizan Rashid 853 views 3 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Relationship between TAX tablesGood afternoon, Would any friend know which table makes the link between the ZX_RATES_B tables and the GL_CODE_COMBINATIONS? -
Is there a way to enter a prompt date and show this date in a column within the report?Summary: Enter an effective date of 01/05/2023 in a prompt Display this date within a column in the output of the report Content (required): If I user enters a prompt ef…
-
Creating Asset Cost Summary Report in OTBISummary: Creating Asset Cost Summary Report in OTBI Content (required): I created "Asset Cost Summary Report" in OTBI, however, I am not getting back the balances as the…
-
Standard Oracle depreciation report.Summary: Hi All, Thank you in advance for your help and time. I am just wondering if there is a standard Depreciation report that we can use in the Asset module (Oracle …