BI Publisher
Discussion List
-
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an… -
Skip HCM Extract schedule if there is no data to process but its showincompleted with alerts statusSummary: We have a requirement to upload Promotion letters to DOR and also send email notifications along with Promotion letter as attachment. We want to skip the runs o…
-
Way to restrict the options in Output Tab during BI Report SchedulingSummary: Content (required): Hi All, Is there a way to restrict the options in Output tab not to be modified during BIP Scheduling? Example - if bursting is enabled in r…Ramanathan Sockalingam 41 views 5 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Query to get salesrep assigned to the customer accountSummary: Hi, I am looking for the tables/query to get the salesrep number and name attached to the customer account in Oracle Fusion Cloud. Content (required): Version (…Ram Bala 001 685 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Unable to edit Data Model post Deployment using Oracle SOAP ServicesSummary: Unable to edit Data Model post Deployment using Oracle SOAP Services. Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dll?SoapImpl=…Ardhendu Santra 90 views 4 comments 0 points Most recent by Ardhendu Santra Reporting and Analytics for ERP
-
Limiting access to folders in custom folderSummary: We want to provide access to only expense folders to expense auditors/expense managers within Custom/Financials and to AP Managers to AP folder and so on. AP Ma…Dibyanshu_Shekhar 36 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Document of Record HCM Extract report getting generated but is not visible in front endSummary: We have a requirement to create a document of record Hcm extract for payroll run results. I have created it and the extract is running successfuly and in the re…
-
Dynamic text values in Body/Subject when using Email Delivery Option - HCM ExtractSummary: Need to trigger email and upload promotion letter to DOR using HCM Extract. Both are working fine but we need to display person name and person number dynamical…
-
Restrict Security Groups available under Content Server DestinationsSummary: When running an HCM report through BIPublisher, you can send the output to the Content Server. We would like to remove the ability to pick these options from th…Terri Woodard-TI 31 views 2 comments 0 points Most recent by Terri Woodard-TI Reporting and Analytics for HCM
-
Automate data extraction for Capex Plan standard reportSummary: Content (required): For Capex Plan, Oracle Fusion has a standard reports like 'What-If Depreciation Analysis Report' & 'FHH Fixed Assets Register Report' to fet…
-
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 42 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 439 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 135 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 53 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 175 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