BI Publisher
Discussion List
-
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a … -
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont… -
Expense approval report is turning into ADF page while doing customizationSummary: We are currently customizing the Expense Approval Report BPM notifications. When submitting expense approvals for Non-sponsored, Sponsored, or Cost Share projec…
-
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer…
-
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact…G. Class-Peters 11 views 0 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
Please help us understand if we can use 'JPMPOSITIVEPAY.xsl' file for generating XML output for BankAfter designating JPMPOSITIVEPAY.xsl (Standard Oracle Template) as the default template for the "Disbursement Positive Payment File" XDO, we are unable to generate the X…User_VBEPN 21 views 0 comments 0 points Most recent by User_VBEPN Payables, Payments & Cash Management
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 662 views 5 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
Need SQL Query to fetch Course and Course CommunitySummary I need to create one BIP Report where i need to fetch Courses and the Course communityContent I need to create one BIP Report where i need to fetch Courses and t…
-
Only 3 formatting rules from excel template will be used when run the BI reportSummary: In BI Excel template, we define 5 formatting rules When we run the BI report, we can see only 3 rules are using. Is anyone know how to resolve it or it is a bug…Yeung Shing Keith 11 views 2 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for HCM
-
Issue with "Take Again" Button VisibilitySummary: We have encountered an issue in our Oracle Learning implementation where the "Take Again" button continues to be visible to learners, even though the profile op…
-
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 7.2K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,…
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 202 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM
-
QR Code Redirect Not Differentiating Learner Offering Pages – Always Redirects to Same URLSummary: We have developed a custom report that generates a QR code link for learners. When scanned, it should redirect each learner to their specific offering enrollmen…
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): https://us.v-cdn.net/6034893/uploads/S9IJ8KIYKON0/learning-query.txt I…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 41 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur…
-
Does any schedule process or reports show customer credit funding without enable credit management？Summary: Does any schedule process or reports show customer credit funding without enable credit management？ Content (please ensure you mask any confidential informatio…
-
SQL query to get Primary Instructor from Course level in Fusion HCMSummary: Recently we received a requirement from one of our customers to fetch Primary Instructor from Course level. After some R&D we were able to retrieve the required… -
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t…
-
Auto Refresh a BIP ReportSummary: How to refresh a BIP report after a certain period of time? Content (please ensure you mask any confidential information): HI, We want to show a report on a Dis…Zahid Rahim 125 views 2 comments 2 points Most recent by Rohit Kumar ACN Reporting and Analytics for ERP
-
sql query to fetch Total number of Overdue Trainings detailed reportSummary: sql query to fetch Total number of Overdue Trainings detailed report Content (please ensure you mask any confidential information): Version (include the version…
-
BI Publisher - RTF template - write a numeric value in lettersSummary Need to write in letters a numeric value from a BIP fieldContent Hello, I am creating a RTF template that I want to display as a report in BI Publisher. In this …Alice Gouzy 139 views 13 comments 1 point Most recent by Ravi Tilekar Reporting and Analytics for HCM
-
CertificatesSummary: How to create own certificates in Oracle Learning Cloud and tie them with course outcomes? Content (please ensure you mask any confidential information): We hav… -
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 182 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM
-
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 1.1K views 4 comments 0 points Most recent by User_NPE6A Reporting and Analytics for HCM -
How to get Request Id for Import Journals ESS Job using ImportBulkData Operation using REST API?I am invoking the importBulkData(Operation) REST API to run the Import Journals job for loading journal FBDI files. While I can retrieve the Request Id of the "Load Inte…Srinath Anbarasu 507 views 5 comments 0 points Most recent by Raluca Chivu-Oracle General Ledger & Intercompany
-
Purchase Order PDF report issueHi Team, We have customization in Purchase Order PDF report by adding customer logo and also setup the confirmation in configure procurement Functional business unit tas…Chanikya Neelam-Oracle 11 views 6 comments 0 points Most recent by Chanikya Neelam-Oracle Reporting and Analytics for ERP