OTBI
Discussion List
-
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use… -
Recurring Learning Assignment subject area in analysis reportSummary: Hi, Post 26A upgrae Learning Assignment got upgraded to redwood. Now as per the Oracle doc Learning initiative got replaced with Assignment profile.In assignmen…
-
Looking for report that shows state from tax jurisdictions cardSummary: We have run our first payrolls with USOPTE and are running into a case with tax jurisdiction cards having the wrong state in a particular circumstance. We want …Dana Lockwood 11 views 2 comments 0 points Most recent by Dana Lockwood Reporting and Analytics for HCM
-
Unable to retreive metadata from data model- OTBI ErrorSummary: HI Team, We created an OTBI for an Inventory On hand stock report. Am getting the following error when I try to edit the report. Any idea what could be the issu…Mano_Oracle-Oracle 22 views 2 comments 0 points Most recent by Mano_Oracle-Oracle Inventory Management
-
How to give access to Report Job History (scope all Histories) without BI Admin roleSummary: How to give access to Report Job History (scope all Histories) without BI Admin role Content (please ensure you mask any confidential information): Version (inc…Sonali Sethi 2 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Incremental extract for EFF BICC PVOs (FulfillLineBIEffEFFBIFlattened , HeaderBIEffEFFBIFlattened )Summary: We are Unable to run incremental extract for BICC PVOs (FulfillLineBIEffEFFBIFlattened , HeaderBIEffEFFBIFlattened ) There isn't a suitable column (like a last …
-
Facing an Error when changing the ware house in the Order Fulfillment Lines. How to resolve this?Selected shipping method is not available. Already added the required Inventory org to the Shipment method. Still error is populating. How to solve this? -
Sold To party vs Bill To and Ship To party on sales orderSummary: There are three fields for party on Sales Order header Customer (aka buying party aka sold to) Bill-to Customer Ship-to Customer What is the significance of Cus…
-
Veteran StatusSummary PER_PEOPLE_LEGISLATIVE_F ;PER_PERSON_LEGISLATIVE_DATA_LEG_DDF'Content Can someone please help on attribute mapping from the application screen(i.e Armed Forces S…User_2025-01-29-01-31-31-940 497 views 10 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode)Summary: In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode) must be correctly aligned with the corresponding rows that contain the rel…
-
Table : Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloudSummary: Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloud Content (please ensure you mask any confidential information): Version (i…
-
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca…Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How to use another method of authentication for HTTP Connection in BI AdministrationSummary: We have currently setup an HTTP connection with Basic authentication. But Client is not convenient using Basic auth for REST API call to OIC. OAuth was not an o…Abhilash K - Deloitte USI 1 view 0 comments 0 points Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to schedule report in working hours from Monday to FridaySummary: Schedule oracle standard report in working hours morning 10AM to 7 PM from Monday to Friday Content (please ensure you mask any confidential information): Sched…Tapas_Sathua 12 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
What is the subject area of Project Definition DFF on OTBI on Projects module?Summary: We cannot find Project Definition DFF on OTBI. What is the subject area of this attribute on Projects module. DFF is BI enabled, we run "Import Oracle Fusion Da…
-
Unable to get OTBI column value for 'Request to Resubmit' Approval actionSummary: We are unable to fetch OTBI column value for 'Request to Resubmit' Approval action on Supplier Registration Request page which is impacting us to develop one ne…
-
Trying to report on future dated Job code keying and Grade Rate keyingSummary: We're trying to report on future dated Job code keying and Grade Rate keying but can only obtain current effective data. Is there any way to report on future da…Georgia Puddifoot 11 views 0 comments 0 points Most recent by Georgia Puddifoot Reporting and Analytics for HCM -
Traversing Department Tree in Reports with a ParameterSummary The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individuallyConten…User_2025-01-25-00-51-33-059 146 views 8 comments 1 point Most recent by fareed basha Reporting and Analytics for HCM
-
OTBI Custom Prompt for Company Fiscal Period, Quarter, and YearSummary: We have a need to report out on our fiscal calendar dates vs. the standard out of box calendar month dates. I was hoping there was a way to set-up our own fisca…CGardner01 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Drill Down for AR_Transaction does not work with VIEW actionSummary: OTBI Drill Down for AR_Transaction does not work with VIEW action. It works with the EDIT action. It shows in Deep Links (under Tools) that it's a valid action.…Chris Diltz-Oracle 21 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Accounts Payable OTBI AnalysisSummary: Adding a field to an "Analysis" Content (please ensure you mask any confidential information): I would like to add the Oracle assigned file number to the list o…b nightingale 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Table to use to get the project and task details under Supply and PlanningHi, We have created a SQL query to get some details under the Supply and Planning. We are almost done but we get stuck on the project and task column. We already checked…Rohan Gonsalves 4 views 3 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing
-
OTBI subject area - Attribute to get the no. of Hours spent on each learning itemSummary: Hi Team, We need OTBI subject area and attribute details to fetch the no. of hours spent on each learning item. Content (required): Version (include the version…
-
How to include fields in the bell/email notifications?Summary: In external learning requests, there is a field to include the course URL. I would like to include this field in the notifications that come to the bell/email: …