OTBI
Discussion List
-
Making Role-Specific Custom InfoletsWe’re working on implementing custom infolets in Oracle Fusion and are particularly interested in making them role-specific—so that only users with relevant roles see th… -
Report for Work Order VariancesSummary: Content (required): Client is looking for a report where they can see the split up of total variance cost. At distribution level system sums up variance cost (E…
-
Instruction: Add a (DFF) to a specific Value Set for additional COA attributesSummary Add a context sensitive DFF to a value set (COA)Content One of the requirements for my organization was to add DFF's to the value sets of our chart of accounts, …Bobby Choate 378 views 4 comments 3 points Most recent by Jakee_Agarwal-Oracle General Ledger & Intercompany -
Add custom font to OTBI reportsSummary Can we add custom fonts to OTBI reports?Content I did upload a ttf file and created font mapping in Administration page but the font is not reflected in the OTBI… -
Subledger Accounting-Journals Real Time Subject area in OTBI not showing Supporting Reference DataSummary: From the "Subledger Accounting - Journals Real Time" subject area in OTBI, we are not able to pull actual data in any of the Supporting Reference 31 to 60 colum…Jay Chandran 111 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for SCM
-
How can I display user chosen from and to dates in OTBI?Is there way to show the dates a user has selected in the output of the report? Date run can be shown in the title, but I want the user to enter a from and to date and t… -
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar…Elavarasan S 11 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Where can I find HCM Extract user entity to database lineage mapping?Where can I find HCM Extract user entity to database lineage mapping?
-
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 131 views 13 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM -
What is the OTBI Subject Area to get data from PER_LOCATION_LEG_F tableSummary: Which Subject Areas should i use to get the details from PER_LOCATION_LEG_F table. Should we need to any process to add those fields to the Subject Areas ? Cont…Jagdish Varadraj 1 view 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Supplier site id details with APIWe have a requirement to get the largest existing supplier site ID for a given supplier and procurement BU, as well as a lookup value that is stored in Saas Lookups. We …
-
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…Vaigu_27 62 views 1 comment 1 point Most recent by Dinesh Krishna Mamilla Reporting and Analytics for ERP
-
Can anyone please share OTBI dashboards for procurement?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Sample Report: Project Financial Management Cloud: Project Budget vs. ActualSummary This dashboard displays Budget details for a specific project.Content The attached sample dashboard displays budget vs. actual cost and commitment details for a …Dustin Grabowski-Oracle 1.2K views 23 comments 11 points Most recent by HarshitBa Project Management -
Missing folder in BI Catalog under Custom/Human Capital Management - Reports and AnalyticsHi Team, One of the folder "Talent Management" is missing under /Shared/Custom/Human Capital Management/ and we could not replicate what happened to the folder and when?…
-
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected…
-
Validation Status from AP InvoiceSummary: I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status. Content (please ensure you …
-
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi…Karlie Backman 161 views 7 comments 1 point Most recent by Felix_fei Reporting and Analytics for HCM -
OTBI Report shows wrong annualized salary and annualized full-time salarySummary: OTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensat…Vincent T 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Candidate Marital status and extra information reportSummary: Candidate Marital status and extra information report Content (required): Candidate Marital status and extra information report Version (include the version you… -
Need to have Inventory Location details in the OTBi reportSummary: Hello, We have a requirement where we need to have all the Location Name, Code and ID in one of the report. But I am umable to find it in the Inventory subject …Krupesh Mukesh Joshi 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
OTBI reportOTBI reportVineet Srivastava Graviton 21 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP
-
SQL Query to Extract Accurate Last Login Date for Active Users in Oracle Cloud SCM PlanningDear Oracle Experts, We are seeking assistance in generating a report from the PROD environment that provides a list of all active users across the following Oracle Clou…Nagaraj A 91 views 2 comments 0 points Most recent by Nagaraj A Supply Chain Planning and Collaboration
-
Modify Actual Effort in hoursSummary: Can the "Actual Effort in Hours" field be modified after a training has been completed?: I am very confident that this EE did not spend 2300 hours to complete t…
-
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac…
-
Capturing the Learning outcome from the Learning Record Real Time subject area- OTBISummary: Content (required): hi there, we have as learning outcome a custom certificate. The certificate has a name, issued by field and issued date. I wonder if this ca…Bobby Jourdan 32 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM