Reports
Discussion List
-
Assignment Changes including Effective SequenceSummary: Hi - I have a logical SQL built that is looking for changes in a DFF field that do not take place on a Sunday. It is supposed to capture the changes between row… -
Pivot table column blankSummary: Content (required): Hi, I've created an OTBI report using the Workforce Performance - Performance Rating Real Time subject area, with a Pivot for the Manager Ra…Joe Dorrian 21 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 12 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
Security views for disciplinary and grievances reportSummary: Security views for disciplinary and grievances report Content (required): Hi All, Is there any secured views available for disciplinary and grievances report? I…Venkatesan 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…Donald 219 views 4 comments 0 points Most recent by Chandra Kiran Ushakoela Reporting and Analytics for ERP
-
HCM Extract completing with Alerts with no output generated when using aggregate conditionSummary: Hi Team, We have a requirement to get the sum of the attribute conditionally in HCM extract by using it as a summary element. When I am trying to make use of th… -
Mid Year Check In ReportSummary: Hi All, We have a requirement to fetch both the employee's & manager's responses to the questions for the 2022 Mid-Year Check In. Looking for a report which cov…Peeyush Chandel 41 views 4 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual…
-
Schedule running of 'Workflow Transactions Listing'Summary: Can we schedule the running of the report 'Workflow Transactions Listing' and send an email to all the approvers included on the result of the run? Content (req…
-
Oracle NR connectivity to Oracle ERP datasources and non Oracle data sourcesSummary: Oracle NR connectivity to Oracle ERP data sources and non Oracle data sources Content (required): From the documentation, we see the available Data Source conne… -
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…Johnna Balane 122 views 3 comments 0 points Most recent by User_Sathishkumar Sundaresan Reporting and Analytics for HCM
-
Can I have text as an input for an intersection and use it in Narrative Reporting ReportsCan I have text as an input for an intersection and use it in Narrative Reporting Reports from a source system like epbcs? I know we have the smart list but that is from…
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…Morten Graae 541 views 4 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
NEW Reports module open on a different Smartview workbook instead of under a new Excel TabSummary: Content (required): Hi All It seems that the new REPORTS module opens reports on a separate WorkSheet every time we open new Fully formatted reports. We want th… -
usage of < and > conditions in the formula bar in reportSummary: Currently we are developing reports in narrative reporting/reports where we have formula which is using conditions like < or (less than and greater than) , and …
-
Adding unique Sequence number and system date in EPCM ReportsSummary: We are building a journal entry (WebADI) report for one of the transfer pricing flows using EPCM. Report contains two columns with GL/posting date and transacti…Anantha Krishnan 41 views 1 comment 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
Intercompany Transaction SecuritySummary Reconcile all tranasction for ICPContent Hello FCCS Expertise, I have the following case : 1- I assigned security per each entity each user assigned to the autho…Hussein Mahmoud 116 views 2 comments 0 points Most recent by soile.alm Financial Consolidation and Close -
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…Alberto Americi 111 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 21 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Batching of BooksContent Hi, Has anyone found a method to either schedule or batch books so that each book doesn't have to be run manually? My customer has almost 40 books they run each …Leslie P. 72 views 17 comments 0 points Most recent by Peter Doyle - Equator EPM Narrative Reporting
-
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal …Clifford Trett 24 views 1 comment 0 points Most recent by Chris Ford Reporting and Analytics for HCM
-
eText Templates seeded sample templatesHi , From where can we download some of the seeded eText Templates used in Oracle for payment formats. Can anyone please share the exact path in the BI catalog. Thanks V…