BI Publisher
Discussion List
-
We need a query to retrieve the AR remittance batch approver's name and approval dateHi, We have arequirement to retrieve the approver name and approval date for a remittancebatch. Could you please confirm if there’s an existing table, column, or queryth… -
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE…Lucas B Maciel 21 views 3 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Learning Content reportingSummary We could not find information on Learning content in OTBIContent Hi Team, Could you please help us to find in OTBI the information listed in these tables: wlf_li… -
Error on Payables Payment Register Data ModelSummary: Error on Payables Payment Register Data Model Content (please ensure you mask any confidential information): We have customized the seeded report/data model for…
-
Need table where Learning Outcome Details are storedSummary Need table where Learning Outcome Details are storedContent Hi, I am trying to find out the table where Learning Outcomes are stored but could not succeed. Can y… -
Embed BI Publisher report without Fusion HeaderSummary: Hi - I am trying to embed a BI Publisher report into a page for our Learning admin to use but when I embed the report using the link provided within the catalog…
-
Health and Safety incident photo table fieldSummary: How can I query a photo inserted on a Healthy and Safety incident? Content (please ensure you mask any confidential information): Hi, I have inserted the follow…Matteo Pacchiana 21 views 3 comments 0 points Most recent by Glen Walton-Oracle Human Capital Management
-
During the Merge process, where the impacted Transactions are getting stored?Hi, We have an option to merge one customer (ABC) with another (XYZ). After the Customer Merge Process, the Merged customer (XYZ) is reflected in the already created tra… -
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI…Kanishka DIas 32 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need SQL query to display HCM Extract results and output file namesSummary: Need SQL query to display HCM Extract results and output file names Content (required): We developed custom HCM Extract and it is having multiple delivery optio…
-
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Extract gives an error in work relationship for terminated employeesSummary: We are using this extract from a couple of months ago. It works for all other employees. Now the client requirement to add terminated employees is in the extrac…
-
Send Dunning Letters log says contact information is missing for customer, we require SQL queries.Summary: Send Dunning Letters log says contact information is missing for customer; we require SQL queries to create custom report to add these error detail of the custo…
-
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 34 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
How to create an OTBI report to pull information on learning assignment deleted date?Summary: How to create an OTBI report ( or what are the subject areas ) that helps to pull information regarding learning assignment deleted date? As part of 24 C New fe…
-
Tables to fetch activity evaluation detailsHi Team, I am trying to fetch activity evaluation details in BIP report , please let me know which table I should be looking into. Navigation: Learning > Courses > Offer…
-
DocumentsOfRecordEO psValue Meaning/ MappingSummary: Mapping/ Meaning for DocumentsOfRecordEO psValue Content: Support doc https://support.oracle.com/epmos/faces/DocumentDisplay?id=2692905.1 refers to different fu…Jan Barz ACN 72 views 1 comment 1 point Most recent by Ravinder Namsani-Oracle Human Capital Management
-
SQL Query to retrieve employee evaluation in performance documentSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query retrieving the employee overall rating in performance d…Valerio Curzi 944 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Payment Process Request Status Report: Supplier Bank Account not populatedSummary: Hi, In the Seeded Payment Process Request Status Report , Supplier Bank Account is not populated although the supplier bank account is present on the invoice in…Shashank Shekhar 3 views 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
Unique Learner Record - Learning Records Real TimeSummary: I am needing to produce results that provide a unique set of learner records for each training title in the analysis. I need the formula to produce the record t… -
SQL query to fetch the list of values for each value setSummary: Business requirement is to fetch the list of active values for each value set code in excel. Need to develop SQL query to fetch Each segment Value set code valu…Badripalli Archana-Oracle 3.4K views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
SQL Behind the package JEFR_JELINES_RPT_PKGWe are trying to write the custom SQL for creating a custom report, in order to fetch the details in BIP report. In order to achieve the same, could someone please assis…Mohd Saqib 52 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Fusion Ap Invoice Workflow TablesHello Support, We have a requirement to get and build a report of the data stored in WF_NOTIFICATIONS tables of Oracle EBS system to Oracle Fusion System. In EBS we have…Nalsoft Pvt Ltd 125 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 261 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 64 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
SQL to retrieve all learner records with community and course taken detailsHi, How to generate a report with all learner learning records along with their course taken details and the associated Category Community and Topic Community? I am unab…
-
How to Fetch Data from SCORM Assessments in Oracle Fusion HCMHi, I am working on a report in Oracle Fusion HCM where I need to fetch data related to SCORM assessments. Specifically, I want to retrieve information such as patterns … -
Can we exclude Public Holidays when scheduling processesSummary: Our client has a requirement to exclude weekends and public holidays when scheduling, for some of the finance processes. We are able to see an option to exclude…Snehal H 41 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales