BI Publisher
Discussion List
-
Suppliers are not receiving remittance adviceSummary: I've a customer who moved to 24C in August, since then remittance notices are not being received by suppliers - they are all reporting not receiving them, not j…Maria Smith- de Novo Solutions 657 views 7 comments 0 points Most recent by Shashidhar AM Payables, Payments & Cash Management -
List of all Agents created in OTBISummary Ability to report on scheduled AGENTS - Listing of Agent, Report Recipient and Frequency (schedule)Content The Payroll/HR department is lookin for a report that …Raz Baboorian 884 views 10 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
User entity or data base item of learn moduleSummary: Hi all, I have a requirement to fetch course and it's assignee/learner data but unable to find any learn module user entity or database item. Can someone please…
-
HRT_PERSON_PERF_RATINGS_V shows all performance ratings not just talent ratingsSummary: When querying the HRT_PERSON_PERF_RATINGS_V table, values from incomplete performance documents will show. How do we otherwise restrict this table to show only … -
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t…
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.4K views 5 comments 9 points Most recent by User_FCP05 Reporting and Analytics for HCM
-
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any …
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
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 113 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 618 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 582 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 327 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 54 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 14 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 12 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 63 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