BI Publisher
Discussion List
-
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 61 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 142 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 244 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 72 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
When the employee open a report we need to send one email to same employeeSummary: When the employee open a report we need to send one email to same employee Content (please ensure you mask any confidential information): Hi Team, We have a req…
-
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat…Vasanthakumar Ravi 2.7K views 8 comments 1 point Most recent by Dev V Reporting and Analytics for HCM -
Customizing Payables Period Close Exceptions ReportSummary: My client is looking to customize the Payables Period Close Exceptions Report. They need additional fields in both the report parameters and the report output. …PengXu 51 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Subledger Accounting & Accounting Hub
-
Generate an OTBI or BI report that notes mileage or kilometer distance from home zip to work locatioSummary OTBI or BI Publisher SQLContent Does any one know of a way to get, for each Employee, the distance in miles or kilometers from the worker's home zip to work loca…User_2025-01-28-21-53-32-678 46 views 2 comments 2 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
Columns Missing from the Subject Areas in OTBIwe have 3 OTBI reports showing error in the output, when i checked, some of the column headings are in the report like 1.Deduction Developer DF_QUALIFYING_PEN_SCHEME 2.D…Global Support Desk 42 views 3 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
table record to use for non benefits employees to new benefitsSummary: Hi, Writing a report to check the list of employees who are newly enrolled in the benefits. please share the table name which give the field name to separate th…
-
HIDE THE FACTORY CATALOG FOLDERSContent Hi We are in 19D and we have removed one of the role which is(Extension Folder Reporting Duty) from Custom BI Webcat Reporting Duty to hide the Extension folder …
-
How to retrieve the filters applied to an existing profile plan?Summary: Hi all, Is there a way to retrieve filters applied to an existing profile type? After analyzing the Oracle HCM tables, I couldn't find any attribute that would …
-
BIP Query to list 'Data Security Policies' tied to a job roleSummary: Client has a requirement to list ALL the Inherited Roles, Privileges and 'Data Security Policies' tied to a job role. We are able to list the Inherited Roles, P…Shrikant Gupta 877 views 8 comments 0 points Most recent by inoappsms Reporting and Analytics for HCM -
Can we schedule a BI Report run and place the generated file in an SFTP location?Summary: Can we schedule a BI Report run and place the generated file in an SFTP location? How can we do this?
-
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
Is ABA format supported for payment file generation in Oracle Fusion?Summary: Is ABA format supported for payment file generation in Oracle Fusion? If yes, could you please provide some docs or analysis. Content (please ensure you mask an…Stephen Sushanth Alexander 41 views 2 comments 1 point Most recent by Nauman Khan Payables, Payments & Cash Management
-
How to link absence details and payroll detailsSummary: Hi all We need a report that provides absence details along with the payroll elements processed based on those absences. Specifically, for the OFFICIAL TRIP abs…Shameer Muhammed P M 72 views 0 comments 0 points Started by Shameer Muhammed P M Reporting and Analytics for HCM