BI Publisher
Discussion List
-
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 661 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 195 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 122 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 137 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 157 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 502 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 16 views 6 comments 0 points Most recent by Chanikya Neelam-Oracle Reporting and Analytics for ERP
-
Separate Remittance Advice sent as Email - formatting of email bodySummary: How can I generate the SRA in email with the formatting in place? Content (required): We have created a custom Separate Remittance Advice (SRA) format. When the…Niall McColl 141 views 3 comments 0 points Most recent by Bhawna Payables, Payments & Cash Management -
how to enable emailing for T4 Year End Report for canadahas anyone done this before, can you please share the steps ? We tried doing it in a similar fashion like Payslip emailing but incase of T4 the custom report never gets …