OTBI
Discussion List
-
OTBI Subject AreaSummary Grade Progression Subject AreaContent Hi, Is it possible to extract Progression Grade Ladder, Grade and Grade step, rates values with an OTBI report? If yes, whi…Catherine Varvaressos 77 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
In OTBI - the Position Name by Position Code is not historical - is this correct behaviour?Summary: The Position Name Field in the Position Folder in both the Compensation - Salary History Details Real Time and Workforce Management - Worker Assignment Event Re…Robert Craske 41 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Store signature in cloud (employee DOR or somewhere) to be used in the reportSummary: In EBS we used to be able to store the employee signature in the DOR, then we used the image in the PDF reports (like tax certification). We wanted to do the sa… -
Without Data Access set, how can a Project Manager with seeded "Project Manager" Role view Data ?Summary: Need to know, how can a Seeded "Project Manager" Role assigned to Project Manager for a project can have all the access without any Data Access set assigned at …SRIRAMULA RAJKUMAR 11 views 2 comments 0 points Most recent by SRIRAMULA RAJKUMAR Project Management -
How to get when candidate moved to next step or status - BI TaleoSummary: I have a report request to show list of submissions indicating submission date and date moved to next step or status. This data extract shall show the submissio…SAMSONODU 22 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM -
Costing of PositionContent Hi All, I am trying to get the Costing of position in SQL query. Does any have the SQL which can give the costing details of position. Thanks,Misbahul Khair-266763 453 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is the Workforce Learning - Learning Management Real Time subject area being deprecated, and when?Can you help me understand if this SA is being deprecated in OTBI or if it will remain? This Customer connect article seems to indicate it was announced in 2021 that it …CJALSPAC 11 views 1 comment 0 points Most recent by CJALSPAC Reporting & Analytics for Fusion Service -
Promotion and Demotions Report not pulling the intended dataSummary: Promotion filter pulls in Job change code change data as well which creates duplicates when actually there was only one promotion. Content (please ensure you ma…Usif Ahmed 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM -
Due Date field in Receivables Transaction Real Time is not displaying any valueSummary: Even though we tried with the most basic fields but the Due Date value is not getting displayed (Screenshot 1). Only when we are adding due date field from Rece…Rahul Kumar Gupta.-Oracle 31 views 4 comments 0 points Most recent by Rahul Kumar Gupta.-Oracle Receivables & Collections -
Numbers Format Issue Standard Purchase Order ReportDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 21 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP -
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 131 views 3 comments 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM -
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 22 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM -
How to get Category Name attribute into Where Used tabSummary: How to get Category Name attribute into Where Used tab. We have other OOTB attributes of General Information section of Item into where used tab like uom, item … -
Is there an advanced official source about the map view feature in OTBI?I would like to try using the map view in OTBI and followed the guide below for configuration, but only the background map is displaying. https://docs.oracle.com/en/clou…Andy K W, SO 31 views 2 comments 1 point Most recent by Andy K W, SO Reporting and Analytics for ERP -
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …Srikanth Dodla 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
IDR Image Processing Status automatic emailIs there a delivered or modified approach that teams have identified to automatically send an email to the sender of an IDR email to confirm that an invoice has been cre…ThomasScott 81 views 5 comments 0 points Most recent by Sourav Parbat Payables, Payments & Cash Management -
How to get Collective Agreement detail from Workforce Management - Worker Assignment Event Real TimeThere was an error rendering this rich post. -
Can we access dashboard prompts value in URL as Dynamically in BIP Report?Summary: Hi Experts, We are having a requirement, whenever user clicks on count then it should redirect to the detail report for those specific values selected in Dashbo… -
Absence Calendar page to add Absence BalancesSummary: Hello, Please assist on the following… I am using the Line Manager dashboard → Absence Calendar page → Workforce Management - Absence Calendar Details Real Time… -
Work Confirmation with Invoice details reportSummary: PO Work Confirmation with Invoice details report Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
OTBI Report: Worker Number nullSummary: In a custom OTBI report, starting from this month, suddenly the Worker Number, from "Workforce Management - Work Relationship Real Time"."Work Relationship Deta…Gian Luca Triglia 11 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Person Identifiers for External ApplicationsSummary: For some employees we have updated payroll id under Person Identifiers for External Applications in person management. Content (required): If I need to take tha…Ayesha Iroshani 581 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
In person HCM Cloud OTBI Workshop at Oracle Reading UKContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t…Julian Challenger-Oracle 54 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep Chavda 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
Error while loading LearningRecord.dat fileHi Team, While loading the below HDL, I'm getting the following error:…Saurav R-Oracle 13 views 3 comments 0 points Most recent by Keerthi Masireddy-Support-Oracle Learning -
HELP - Hierarchical Columns - Query not returning dataSummary: When I query multiple folders within the Recruiting - Sourcing Real Time subject area no results are returned. Security is working correctly. Content (please en…Michael Grant 31 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
HardCode a Value in OTBISummary HardCode a Value in OTBIContent Hi Team, How can we hardcode an LOV value of a field in OTBI analysis? Any samples or query with case? Thanks much. Regards, Kaly…Kalyani Koylada 106 views 2 comments 0 points Most recent by Raquel Herrera Reporting and Analytics for HCM -
Invoice NotificationSummary: Is there an option to enable notification to requestor when invoice is uploaded to the supplier portal. Content (please ensure you mask any confidential informa…