BI Publisher
Discussion List
-
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca… -
Table to find instance name/Environment NameHi Team, Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD. I have already checked the ASK_DEPLOYED_DOMAINS table…Swapnil Kashid 591 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Installments Associated with Collection Documents Listing Report for Brazil not worksSummary: There is a Report available in the Scheduled Process: "Installments Associated with Collection Documents Listing Report for Brazil" I tried to run in many diffe…
-
AR print commercial documents burstingSummary: There is a bursting query in print commercial documents process. We have understood that emails can't be send through this process, wanted to check if FTP or an… -
actual vs budget bi publisher based on COASummary: Hi, is there a BIP report where we can extract initial budget and adjusted amount for chart of accounts 1-3. Content (please ensure you mask any confidential in…
-
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 796 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
can we have different Font style for e-sign on offer letter templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…YOGESH SAMPANGI 1 view 0 comments 0 points Most recent by YOGESH SAMPANGI Reporting and Analytics for HCM
-
Need a Bell notification when a course is assigned to the employee by their managerSummary Need to create a custom alert when the manager has assigned a course to his employeesContent Hi Experts, We have a requirement to enable a custom bell notificati… -
BIP or OBTI Auditing Users making changes to their own HCM/Payroll DataSummary: Does anyone have or know of any current reports that will give details on Oracle HCM users who have made data changes to their own Global HR/Global payroll info…
-
There is requirement on BIP for learningSummary: when the learner course is due date past 7 days email notification should go to manager 's manager. How can we write BIP report to generate notification Content…
-
How to fetch Resignation details, which include Resignation reason,,Summary: This is the resignation page in Me tab. How to fetch all These details using SQL?Aryan Yadav 41 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur… -
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
Show original transaction's Remit To address on Credit MemoSummary: We'd like to have the Remit To address shown of the original transaction on all credit memos. We have one single remit-to address for each country set up, but i… -
PVO and Oracle Base Table for Fixed Assets approvalsWe have approval hierarchies enabled for Fixed Assets, for that to reflect in BI report we need related PVO & Base table which I am not able to find it anywhere. Please …
-
PVO and Oracle Base Table for Project approvalsSummary: We have approval hierarchies enabled for Projects Module, for that to reflect in BI report we need related PVO & Base table which I am not able to find it anywh…
-
What does the following code in an RTF table cell actually do (if@cell:position()...)?Summary: Hi, I wondering if someone can explain to me what the following code might do. I found it in an BIP RTF report within a table cell. The code was introduced besi…Frank.Steinjan 62 views 8 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
Unapplying Credit Memo does not update AR_RECEIVABLE_APPLICATIONS_ALL.applied_customer_trx_idSummary: We tried deleting a credit memo through Manage Credit Memo Application so we are expecting that the ar_receivable_application_all. applied_customer_trx_id will …
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
OTBI - Read Only ModeSummary: I have a service account that is set to Read Only Mode within Fusion, however when navigating into OTBI the account is no longer in read only mode and can edit,…
-
Need Oracle SQL query to get the Office number for Location details from Assignment pageSummary: Need Oracle SQL query to get the Office number for Location details from Assignment page Content (required): Need SQL Version (include the version you are using… -
Query to get the final approver of AP InvoiceSummary: Hello, We have a requirement to fetch only final approver details along with Invoice/Requisition in a Invoice and requisition workflow report. Current report is…Sushmitha G 141 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 11 views 1 comment 0 points Most recent by Daniel S.-Oracle Reporting and Analytics for ERP
-
How to format date column in Excel Template without adding another columnSummary: I am able to format date column in excel by adding another column and using =DATEVALUE function as suggested in below link, but I want to format date in current…Meer Muzafar Ali 31 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
OTBI Report data issueSummary: OTBI Report data issue Content (please ensure you mask any confidential information): Hi All, We developed OTBI report with Workforce Management - Worker Assign…
-
Why BU is a mandatory parameter in ESS job of Uninvoiced Receipts Accrual ReportWe have a business requirement to run Uninvoiced Receipts Accrual Report for all the BUs. But using the ESS job we can select only one BU at a time. Tried to execute or …DebasmitaDas123 21 views 3 comments 0 points Most recent by DebasmitaDas123 Reporting and Analytics for ERP
-
Bursting Email attachment with a constant attachment.Summary: Is there is any possible way to add an extra constant attachment (pdf) to send an email bursting along with report attachment? If it is Possible please help me …Goutam5555 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Query to retrieve manager assignment numberSummary: Content (please ensure you mask any confidential information): Hello experts, we need for each employee to retrieve the line manager assignment number. Do you h…Valerio Curzi 273 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI - add a graph to show the number of candidates by locationSummary: I've created an analysis using Recruiting - Recruiting Real Time Subject area and have been trying to add a graph to show the number of candidates by location, … -
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 71 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections