BI Publisher
Discussion List
-
OTBI Report showing multiple Parent Position Codes for a recordSummary Display the current parent position code in the OTBI analysisContent I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and…User_2025-02-04-08-51-08-912 35 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Benefit Eligibility CriteriaContent Hi All, When we click on the Eligibility profile able to see View hierarchy and Eligibility criteria. Can you please share inputs in which Table/OTBi subjetc are… -
tables that stores the submission of BI Publisher reports which are not scheduledSummary tables that stores the submission of BI Publisher reports which are not scheduledContent Hello, Are there any tables that stores the submission of BI Publisher r… -
Conditional format image - The file type is invalid, only .png .jpeg .jpg .gif and .bmp files are suContent I am trying to add a image if a condition holds true but I am getting this error message trying to upload an image. I confirmed the image format I am trying to u…User_2025-02-10-08-27-16-805 10 views 6 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
HDL - Element Entry IDContent Hello, I'm trying to update recurring element entries but am not sure where to find the ElementEntryID so that we can refer the HDL to a specific element entry. … -
Account Reference InformationSummary Provide account reference to customers requesting on accounts looking to add businessContent We have customers on a regular basis coming to us asking for referen…User_J9K1Y 52 views 1 comment 0 points Most recent by User_2025-02-05-00-10-05-674 Receivables & Collections -
Create Automated Regression TestsSummary Looking for your experience with 'Create Automated Regression Tests'Content Hi everyone, As per 20D documentation there is a section on 'Create Automated Regress… -
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere…Vinay Soni 262 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h…User_2025-02-06-09-41-56-955 431 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …David McLellan 42 views 4 comments 0 points Most recent by David McLellan Reporting and Analytics for HCM -
Eligibility Profile Validation Report for BenefitsSummary A lot of time customer requests to validate Or have the Benefits Eligibility Matrix handy as to query for each plan and combinations using UI is a cumbersome pro…
-
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!User_2025-02-10-08-27-16-805 23 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
What steps are required for using a custom bank statement?Summary What steps are required for using a custom bank statement?Content Hi, We have a requirement to use a custom Bank Statement. Could someone please explain the step…Richard Lang 48 views 4 comments 1 point Most recent by Richard Lang Payables, Payments & Cash Management -
Need to link between Learning outcomes and Learning CourseContent Hi All, We are creating a report where we need to fetch all the competency details (Learning outcome) tagged against learning course. We know the learning tables… -
Intercompany (AGIS) AutomationContent Basically current steps : 1. When AP capture Invoice in Entity A with Entity B Interco chargeback dimension (last 3 digits) 2. Interco Module : Interco Team will… -
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 132 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534 Reporting and Analytics for HCM -
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 26 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…Monica Fundak 51 views 3 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the …Valerio Curzi 49 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BIP Report Jobs IssueContent Hi all, I asked a couple of weeks ago about changing the privacy of Report Jobs from Private to Public which was answered here: https://cloudcustomerconnect.orac… -
'Batch Source' Field From Subledger Journal Line required (Table and Field Name required)Content Hi Community, We require the Batch Source (see sreenshot) field from the Subledger Journal Lines for reporting purposes. Can anyone advise what table and field t…Kunal Daya-175386 35 views 6 comments 2 points Most recent by alexey.shtrakhov Subledger Accounting & Accounting Hub -
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne…Kiran Kancherla 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Instance identifier in BIP reportSummary We need specific report to run only if it is on specific instance (say Test POD).Content We need specific report to run only if it is on specific instance (say T…Priyanka More-Oracle 186 views 5 comments 1 point Most recent by Priyanka More-Oracle Reporting and Analytics for HCM -
Funds Check SQL or APISummary Is there a way to do a funds check via API or SQLContent Looking for a Funds Check SQL or API. Before we import the journal, posting a journal, planning to check… -
Table for Attachments under position profileContent Hi, Can someone help me with the table contains the attachment information under position profile? Regards, NivyaNivya Mathire 88 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM