BI Publisher
Discussion List
-
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".Immanuel Aruldoss 51 views 2 comments 0 points Most recent by Eric Geddes Reporting and Analytics for HCM -
I am not able to get an etext output without Special charactersSummary: I am getting special characters in my etext output. I tried using UTF-8 character set, that still didnt help. I used save as encoding UTF-8 on rtf template. Tha…RohithGundreddy 11 views 0 comments 0 points Started by RohithGundreddy Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 271 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
OTBI does not generate all lines.Hi everyone. I'm generating a report in OTBI and not all the lines that should be generated are being returned in the report. Is there a limit to the number of lines tha… -
How a certificate can be changed according to the score in learning cloudSummary: I have a scenario where in client wants 3 diff certificates for a single course. Depending on the score we have achieved for assessment learner should get eithe…
-
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What table(s) joins the converted work assignment to the pending work assignment?Summary: I am seeking information on what table(s) joins the converted work assignment to the pending work assignment? Use case is that information stored on job offer a… -
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
How to report the 'Attachment Count' of a DoRSummary: How to report the 'Attachment Count' of a DoR Content (please ensure you mask any confidential information): Hi, we created a Document Of Record. The employee h…Barile Alberto 21 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to debug BIP report that has dataset based on Procedure as a SQL type?Summary: I have an issue with a BIP report that use a complex plsql code as a dataset. I am looking for suggestion to debug procedure used in dataset. The data set confi…Vijayaragavan Ramasamy 11 views 0 comments 0 points Started by Vijayaragavan Ramasamy Reporting and Analytics for ERP
-
Manage Delegations ReportSummary: Is there a seeded report that would list all the active employees that are able to create expense reports for employees? There is not a way to download to excel…
-
Schedule process runs on working daysHello, Is there a way we can schedule a process for a BIP report which runs first 8 business days on hourly basis and from 9th day to end of month to run daily basis. Pl…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 385 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 132 views 2 comments 0 points Most recent by DanWoodward Reporting and Analytics for HCM
-
How can I add custom columns and layout to a seeded report in Oracle Fusion?Hi everyone, I’m working with a seeded report (Funds Capture Authorization and Settlement Formats) in Oracle Fusion Receivables, and I need to add custom columns to the …
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 71 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …SARAVANA KUMAR T-Oracle 141 views 5 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How to disable "Import Payable Invoices Report" generating for every Import Payables ESS Job run?Our client uses another system to process their AP Invoices. They validate the invoices triggering the web service for Invoice Import (7.5-10k per day). This process is …Camilo Botín-Oracle 51 views 1 comment 0 points Most recent by dwalia-Oracle Payables, Payments & Cash Management -
Where to find the client channel data (i.e., the payment initiation method) in ERPHi, The requirement is to identify where the client channel data (i.e., the payment initiation method, such as H2H or J.P. Morgan Access) is stored in Oracle Fusion, and…Keerthana Sekar 11 views 2 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
can not see all records in AP_IDR_INVOICE_TRACE_DYD tableSummary: Table - AP_IDR_INVOICE_TRACE_DYD, this table is used in standard invoice document recognition tracking report. But when we have queried the table, we can not se…Rama Krishna T 52 views 2 comments 0 points Most recent by Rama Krishna T Payables, Payments & Cash Management
-
Setup PrinterHi, I need to print a receivables report directly to a printer in another physical location. 1. Is there any functional setup I need to do? 2. How could I make this work…Cleton Carvalho 22 views 2 comments 0 points Most recent by Gal_Var-Oracle Receivables & Collections
-
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc…
-
Send Payslip to Printer For Teminated employeesSummary: Hi Everyone, We have one requirement that we need to send Payslip for only terminated employees to Printer. I have created different template and add in deliver…Krishna Manmohan 11 views 1 comment 0 points Most recent by Krishna Manmohan Reporting and Analytics for ERP -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 183 views 9 comments 0 points Most recent by User_O1LQ5 Reporting and Analytics for ERP
-
Request for REST API Details for SLA Accounting Journals (AR/AP)Hi Team , We are unable to locate the REST API name related to SLA accounting journals (e.g., AR, AP) in the Oracle documentation. This information is required to develo…Tasweer ur Rehman 11 views 0 comments 0 points Started by Tasweer ur Rehman Subledger Accounting & Accounting Hub
-
How to move OTBI & BIP reports from one instance to anotherSummary: How to move OTBI & BIP reports from one instance to another instance? Looking for the easiest way to achieve this. Content (please ensure you mask any confident…