BI Publisher
Discussion List
-
How to identify when a person no longer sits within a person criteria for a Learning InitiativeSummary: We have a requirement to identify when a person no longer sits within a person criteria for a Learning Initiative (although they have completed the training) an… -
How to use BIP schedule trigger.Summary: I want to notify only when the number of detected cases under specific conditions is 1 or more, but please tell me what kind of SQL should be set for the event …Maki,Tomofumi 51 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Why am I unable to report on the ratings given within a completed performance document?I need to be able to report on the ratings given by the manager for a pre-assigned performance document. I am using the Workforce Management - Performance Rating Real ti…Helen Tilling 61 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables?Summary: Content (required): Hello experts, are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables? If so, could you share t…Valerio Curzi 41 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Share report on Observation ChecklistSummary: Does anyone have an example of a report they built to show any data from observation checklists? We would like to be able to get a least a report for completion…
-
Document Record Deep Link in SQL Query - use parameter regarding uploaded document record IDSummary: There is a requirement for BI report to have direct / deep link to a document record for persons Content (required): I found the Deep Link URL and several of it…Shant Sarkissian_NES 431 views 3 comments 1 point Most recent by Balaji Vijayakumaran Reporting and Analytics for HCM
-
BI Report or OTBI report - create Bell Icon Notification via BI Publisher scheduler or AgentSummary: How can one trigger the creation of a notification in the Bell Icon, so a BI Publisher BI report or OTBI appear there? Content (required): Want BI to be able to…Shant_Sarkissian_WJG 133 views 3 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…Mickel.Rmeily 51 views 4 comments 0 points Most recent by Mickel.Rmeily Reporting and Analytics for ERP -
How To Successfully Customize the "Disbursement Payment Process Request Status Report Formats"Summary: We are turning on payment approvals but the approvers do not like the seeded layout of the Disbursement Payment Process Request Status Report. I was attempting …Brian Burns 462 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Specialization progressSummary Progress of specialization(no of completed mandatory courses/no. of mandatory courses)Content Hi, I need mappings for specialization progress ie.(no of activitie…
-
Audit on Termination DataSummary: Audit on Termination Data Content (required): Hi All, Greetings! Is there any report available based on audit for termination data for the employees? We'd need …Parag Hiremath 123 views 4 comments 0 points Most recent by Daniel McMillian Reporting and Analytics for HCM -
Where can we find the Add to Calendar link in BI Reporting?Summary: We would like to add the Add to Calendar link in one of our BI reportings but are unable to find the variable in the tables. Content (required): How / where can…
-
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…
-
Audit ability for OTBI fields and BIPSummary: Is there any ability to audit on who has created and run a BIP report or OTBI analysis that include specific folders/fields such as from Workforce Management - … -
What are the standard reports available for Brazil localization?Summary: We wanted to know if Brazil tax is implemented through a tax partner in Oracle, then what are the monthly tax compliance reports readily available to use? Conte…
-
Unable to get the Ar receipt statusSummary: We are developing the OTBI Report, unable to fetch the Receipt status. Instead we are getting the application status. Content (required): Version (include the v…
-
I can't see absence approvers in transaction tableHello, I am preparing a report to see who approved or denied the absences for the absence records in the transaction console. However, I cannot access the approver infor…
-
Query to extract Candidate Attachments URLSummary: Content (required): Hello experts, please, could you provide the SQL Query to extract Candidate Attachments URL? Our customer should retrieve Candidate Curricul…Valerio Curzi 161 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can somebody assist. on how to get the "Seniority Date" calculation date in OTBI subject report?Summary: How to include Seniority Date calculation date in OTBI subject area report (Please refer the screenshot 1 for reference)? How to include Seniority Date transact…
-
Time zone in BIP .xpt templateSummary: How can we add the user preferred time zone along with Date and time in the BIP .XPT template? I am aware of the tags for RTF template but the requirement is to…Debkanya 41 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
AP Check print BIP report output to be printed from 2 different printers using PCL .Summary: Actually, we have a requirement on AP Check print report in which the page 1(contains the Cheque) which needs to be printed from printer 1 and other pages must …
-
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 311 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
How to Generate XML and Modify the Payment Process Request Status ReportSummary: I am trying to customize the payment process request status report but am unable to generate an xml of the report in order to either make a new layout or edit t…Brian Burns 353 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
SQL Query to extract Skill and Qualification Attachment URL?Summary: Content (required): Hello experts, please, could you provide the SQL Query to extract the attachment URL loaded in Skill and Qualification page? Is it possible …Valerio Curzi 136 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
SQL query to extract Candidates ResumeSummary: Content (required): Hello experts, we need to recover candidates resume URL. Is it possible to retrieve this information? Which table store resume URLs. Is ther…Valerio Curzi 515 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BIP Security - Need to restrict user from modify and deleting the reportsSummary: Hello Everyone, All the users in our environment have BI consumer role. So they are able to navigate to different folders and they have ability to modify and de…Oracletechnofunctional 241 views 4 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP
-
Asset Transactions Real Time'. Which subject area can be joined to get the project informations.Summary: Hello Team, I am using this subject area to get the asset transactional details. I need project information. Which subject area can we join so that we can get t…Suhitha K-Oracle 21 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
Excel generated from RTF template is giving wrong valuesSummary: Excel generated from RTF template is giving wrong values Content (required): I have developed a query to get TransactionDr field from GL Lines table. For a spec…Jaeyshree K K 112 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome…Anders W. Langholm 51 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP