BI Publisher
Discussion List
-
COUNT function in e-Text Template in BI Publisher with HCM extractSummary COUNT function in e-Text Template in BI Publisher with HCM extractContent I used count function in e-text template ,the count function returns no data, any thing…G Madatala 444 views 8 comments 0 points Most recent by Anupam Rana-Oracle Reporting and Analytics for HCM -
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 13 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
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
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 381 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…
-
How to enable deep link in payment approval notificationSummary: How to enable deep link in payment approval notification? Content (please ensure you mask any confidential information): Hi all, We got a requirement to show in…Venkatesan 43 views 2 comments 0 points Most recent by User_W53WG Payables, Payments & Cash Management
-
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 131 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 143 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 42 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 23 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