BI Publisher
Discussion List
-
SQL query/Table to get Selection Criteria In Learning InitiativeIn Learning Initiative while selecting learners we can choose criteria. the values in it are Organization Chart Criteria, Learning Assignment Criteria, or Person Criteri… -
How to get AR billing transaction note plain text without html tag ?Hi All, I'd like to build a customer report about AR billing which contains note. While I found the note in backend table contains html tags. Note in the UI: SQL result… -
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 112 views 3 comments 0 points Most recent by User_2F7TP Reporting and Analytics for SCM
-
A bip query is running very long timeBelow query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was wor…
-
Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP CloudSummary: Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP Cloud Content (please ensure you mask any confidential information): I wo…
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 249 views 7 comments 0 points Most recent by Bisweswar Goud-Oracle Reporting and Analytics for HCM -
BIP delivery destination to MS Sharepoint or OneDriveSummary: Hi, If I need to deliver the report directly to MS Sharepoint or OneDrive, what delivery channel should I use? For example, HTTP, WebDAV? Thanks, Adam Content (… -
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 347 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Approval notification for LearningSummary: How is it called the report related to the approval flow when an employee requests an enrollment to a course? We need to customize this notification, so we need…
-
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re…Valerio Curzi 522 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I modify existing seeded workflow notification template?Content I have a requirement to modify existing seeded template for Workflow notification(Transfer Report). I have found the template and copied it in custom folder and …User_2025-02-06-14-37-05-233 287 views 6 comments 0 points Most recent by Kotakonda.Balasubramanyam-Oracle Reporting and Analytics for HCM -
How can we identify the list of BIP/scheduled reports that are currently being transmitted to FTPSummary: We need a list of reports from Fusion that are currently being transmitted to the FTP server as part of the requirement to transition to a more secure SFTP serv…Naga Peddiraju Chennu 51 views 3 comments 0 points Most recent by Viraj Padwal-Oracle Reporting and Analytics for ERP
-
XSLT Template Add Day to DateSummary: XSLT Template Add Day to Date, There is a date to which we need to add two business days (excluding weekends) and display in the output. in XLST Template only. …Rajdeep Chavda 11 views 2 comments 0 points Most recent by User_VQTGR Reporting and Analytics for HCM
-
how to fix #VALUE! error in excel templateSummary: i am using DATEVALUE function to convert text to date in excel template.However incase of blank date i an getting #VALUE!. Can anyone please help to reslve the …minati_behera-Oracle 14 views 3 comments 0 points Most recent by MJ_ Reporting and Analytics for HCM
-
Need to display all workflow completed transactions as well as approver detailsSummary: Need to display all completed transactions as well as approver details Content (please ensure you mask any confidential information): We have a requirement to d…
-
Expense Approval Tables to create custom BIP reportSummary: We need to build a custom BIP report that allows us to see the Approval Flow/Path ( Approval Hierarchy) for the Expense Report that has been Submitted or Expens…
-
Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked,Summary: i Found out we cannot write this query in the BI Publisher and it can be done in the OTBI only if yes what is the reason and if possible please help us to fix t…
-
Do we have any option to download CSV File - rather than getting displayed in browser output ?Hi team, Do we have any option to download CSV File - rather than getting displayed in browser output ? Our data output file size is more than 100 MB , we want to downlo…Sridhar Gupta Yerram-Oracle 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Requirement to customize the Payables Selected Installments Selection data model to add new columnSummary: We have a requirement to customize the Payables Selected Installments Selection report data model to add new column, but the customize option is not available f…Shailender Ahuja-Oracle 61 views 6 comments 0 points Most recent by Kunal Vatyani Payables, Payments & Cash Management
-
Retrieve all positive and negative balance associated with a customer.Hi Team, We have a requirement to generate a list of all customers whose accounts have either a positive or negative balance. Could you please provide a detailed explana…Harshini Amancha 21 views 0 comments 0 points Most recent by Harshini Amancha Receivables & Collections
-
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can we find Customer Details from VAT ID in Oracle ERPSummary: How can we find Customer Details from VAT ID in Oracle ERP Content (please ensure you mask any confidential information): Version (include the version you are u…Rajnish Kumar Dallas 1 view 0 comments 0 points Most recent by Rajnish Kumar Dallas Receivables & Collections
-
We want to create a BIP report for the Approval Delegations.Oracle has a delivered report, Employee Vacation and Delegation Rules Report. We need to know the tables behind this report so we can add more fields to the report. Does… -
I need to find who created or updated a BIP or an OTBI report and whenSummary: We need to find details like who created a BIP report or a Dashboard or an OTBI report and when. Content (please ensure you mask any confidential information): …
-
how to invoke ESS Job Set from webservicesSummary: Trying to use SOAP WSDL and submitESSJobRequest Service. I am able to submit ESS Job but While submitting Job Set I am not able to.Please throw some lights arou…Aditi Agrawal2650 181 views 2 comments 0 points Most recent by AnanyaR-Oracle General Ledger & Intercompany
-
How do i know which field in the fusion frontend is related to which table column in backend?Hi Experts I am new to BIP report development. Customer sometimes just give screenshot from fusion and ask to create report with those field . Is there any way where i c…Mainur-Oracle 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.Prince Choudhary 161 views 12 comments 0 points Most recent by Nimesha Yatigammana Reporting and Analytics for ERP
-
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font …HarishVummidi 1 view 0 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM