BI Publisher
Discussion List
-
Report to show all employees who have not been paid in last 3 weeksSummary: Need a report to see the employee, assignment, last paid date and benefit termination date for the employees who have not been paid in last 3 weeks. Content (pl…Priyabrata Prusty 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to display XML tables in BI PublisherSummary: How to display XML tables in Word's BI Publisher add-in Content (please ensure you mask any confidential information): Hello. In my project, I am using Word's R…Keita Furuya 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
What role is required to Grant only Reports and Analytics Catalog in Oracle Cloud ?Summary: We have a requirement from Business. Business wants to Run only the OTBI Reports from Cloud. So, What role is required to Grant only Reports and Analytics Catal… -
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are… -
PER_EXT_PAY_EMPLOYEES_V2_UE won't retrieve INACTIVE person information regarding salary informationSummary: Hello, Customer Connect! I had developed an HCM Extract that fetch employee data such as some person/assignment information(person_name, assignment number, lega… -
Update Seeded oracle certificate template in LearningSummary: Update Seeded oracle certificate template in Learning Content (please ensure you mask any confidential information): Update Seeded Oracle certificate template i… -
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 11 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM -
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server… -
is there a way to send auto- generated email notifications to the users about unsubmitted claimsSummary: is there a way to send auto- generated email notifications to the users about unsubmitted claims within a specified timeframe like 3 days or 1 week..etc. Exampl… -
Periodic Payroll Activity Report bursting Based on LocationSummary: Hi I have a requirement to split Periodic Payroll Activity report based on location. I tried bursting option by creating a copy of globalreport data model and c… -
Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML FileSummary: Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML File Content (please ensure you mask any confidential information): We are …Christian Roxas 21 views 2 comments 0 points Most recent by Sunghpark Payables, Payments & Cash Management -
Unable to convert date in specific formatSummary: We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data …Arpit Dhalawat 11 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM -
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A… -
How can I access the candidate profile source via BI publisher?Summary: I need to access the source fields on the candidate profile. I have so far identified that I can access the application source via the IRC_SOURCE_TRACKING table… -
Enterprise Hire Date in BI PublisherSummary: Enterprise Hire Date in BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to create a BI Publisher report which cont…Barile Alberto 22 views 4 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Payroll Balance Real Time - Multiple Assignments Not showingSummary: Trying to pull a report with the Payroll Balance Real Time that brings in the multiple (primary & secondary) assignments with hours worked & payroll for each as…Rhonda Fischer 1 view 2 comments 0 points Most recent by Rhonda Fischer Reporting and Analytics for HCM -
Assigned Course not showing for Learners as an Admin?Summary: Assigned Course not showing for Learners as an Admin? Content (please ensure you mask any confidential information): Assigned Course not showing for Learners as… -
Need help on Long Running Custom BI Report - running more than 5 hours and failingSummary: The Custom bip report is running for long time(more than 5 hours) and erroring out saying that "Elapsed Time is exceeded" . Would you please help in tuning the …Rama123-Oracle 296 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Performance issue with BI ReportSummary: Dear All, We have an custom report which was built by Oracle Dev Team. Now we are seeing performance issues with Report. When we try to run(i.e. Schedule the re…Naresh313 121 views 2 comments 0 points Most recent by Mukesh Arora-1 Subledger Accounting & Accounting Hub -
What data applies to these receipt batch statuses?Specifically, what state are the following three receipt batch statuses in table "FND_LOOKUP_VALUES"? ・PENDING_APPROVAL ・PENDING_CONFIRMATION ・READY_TO_POST Thanks,REI TSUKAHAR-Oracle 11 views 2 comments 0 points Most recent by REI TSUKAHAR-Oracle Receivables & Collections -
Configuration of Entity in Saudi ArabiaSummary: We have a requirement to prepare for configuration of a new entity in Oracle Cloud/FCCS/EPBCS in Saudi Arabia. We will have GL,CM AR, AP, FA, etc. One of the re…Tina Valtchev 21 views 1 comment 0 points Most recent by Tina Valtchev Payables, Payments & Cash Management -
How to create report of Payroll check numbers with employee name and addressWe have a requirement to provide list of payroll checks with check date, amount, employee name, employee address. If it can be done using "Analysis", please advise on Su…Kit Stephenson 133 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
How to report in BI Publisher the Approval Date for Change Assignment TransactionSummary: How to report in BI Publisher the Approval Date for Change Assignment Transaction Content (please ensure you mask any confidential information): Hi, we configur…Barile Alberto 11 views 0 comments 0 points Most recent by Barile Alberto Reporting and Analytics for HCM -
Can we Display Rejection reason via Notification to user if Journal is auto rejectedHi Team, We have configured the Journal auto-rejection rule if the Attachment or Journal description is missing at the Journal Header level. When a journal is rejected, …Ashwini Naik 353 views 4 comments 0 points Most recent by Ravi Kanth Vuddagiri General Ledger & Intercompany -
Need OTBI subject area to fetch the Channel Revenue ManagementSummary: Need OTBI subject area to fetch the Channel Revenue Management Content (please ensure you mask any confidential information): I am new to SCM modules. Any input…