BI Publisher
Discussion List
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank … -
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
CertificationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Vijay Kumar Reddy 6 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 6 views 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can anyone please share the best practice to create BIP Report template having more than 50 columnsSummary: Can anyone please share the best practice to create BIP Report having more than 50 columns I have a requirement to develop a BIP report having 54 columns and he…Kundan Kumar17 23 views 0 comments 0 points Started by Kundan Kumar17 Reporting and Analytics for HCM
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma…Dhilip Kumar P. 29 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
Is it possible to report on Alert History?Summary: Need to see alert history in easy to read format Content (required): We have quite a few alerts running and would like visibility to what is sent and when to he…Janine Brown 422 views 10 comments 4 points Most recent by Murali Togaru Reporting and Analytics for HCM -
Need an help for SQL querySummary: Content (please ensure you mask any confidential information): I want to extract report for Manage Legal Reporting Unit Registrations, however I have a SQL whic…Shilpa Dam 85 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 298 views 3 comments 11 points Most recent by Shyam Patel Reporting and Analytics for HCM -
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a…Parag Hiremath 10 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How can I see all chart types in Fusion Data Intelligence (FDI)?Summary: How can I see all chart types in Fusion Data Intelligence (FDI)? Content (please ensure you mask any confidential information): I need to know what kind of char…Stefano_Mazzocca 36 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 77 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_…Consultant Ian 36 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Query to get the details of Project Cost Transfer status in Time card details in OTL.For a reporting purpose we want the details of Project Cost Transfer Status from Additional Statuses with in Time Card Details for a particular date range. Please find t…
-
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
BI Publisher or OTBI Reporting on field used for ADP Workforce Now integrationHi, we do payroll in ADP Workforce Now and run a daily integration from Oracle. We want to know if it possible to report on this field used for the ADP integration only.…Evelina Hobson 6 views 0 comments 0 points Started by Evelina Hobson Reporting and Analytics for HCM
-
Sample SQL Query for IBANHi, we have to develop a report with the Employee's Personal Payment method Details like IBAN and bank account info etc. Please share if any sample SQL query to capture …
-
OTBI - Static PDF attachment in email notificationSummary Is there any option to attach PDF in email notificationsContent Hello, We have a requirement to send email notification to new joiners along with user guides att…User_2025-02-05-07-43-29-505 74 views 8 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM -
Oracle Report Rendering IssueHi All, When I try to run a report post mapping the fields using BI, the excel output is not generating. Getting the below issue.. But when I try to download the same in…Dhilipkumaar-Oracle 17 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 526 views 5 comments 0 points Most recent by Madhavi Achyuta-Oracle Reporting and Analytics for HCM
-
Query to get costing and Element linkSummary SQL Query to get costing segment columns and element link name columnContent Hi All, I want to pull the costing segments along with credit, debit amounts and ele…User_C7E7N 752 views 4 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM
-
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! -
Find Missing Registered Nurse LicenseSummary: Does anyone have a report to share that identifies active persons who are missing an RN License. Details: A person can have multiple different licenses. Using a…
-
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: … -
emergency contacts reportsSummary: Hello, I've created report to get emergency contacts for employee below this only part of it. I'm getting error message that subquery return more then one row. …
-
SQL query or Table for Manage Knowledge User Groups in HelpdeskSummary: Hi we need a table where the Manage Knowledge User Groups information stored Need a columns "user group name, reference key, department under the setup Manage K…
-
Query to fetch the CURRENT and PROPOSED manager for failed transactions in BIP reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can anyone tell which table has USER_PERSON_TYPE column?Summary: I need to access data under USER_PERSON_TYPE column for a report query, the same information we can see from Person Management screen, can anyone tel me which t…
-
Pending worker conversion date in OTBISummary: Pending worker conversion date in OTBI Content (required): Hi, we would like to know where (Subject Area - Folder - Field) we can have the possibility to extrac…