BI Publisher
Discussion List
-
BICC Extract Failures with "Error occurs while calling remote service ADFService11G" after 26CUpdateSummary: We have been experiencing intermittent failures with several BICC extracts following the Oracle Fusion Cloud Applications 26C update. The failures started appea… -
Display a Document of Records Image in a BIP ReportSummary: Hi All We have a requirement to display photos stored in Documents of Record within a BI Publisher (BIP) report. Has anyone implemented this before or can provi…ARFusion 25 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Oracle HCM Reporting - Disable or Hide Parameter Based on Selection of Another ParameterSummary: We have two report parameters, Payroll Name and Consolidation Set, and need to make them mutually exclusive. When a value is selected for Payroll Name, the Cons…HariPrasad$24 38 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Is there a way to identify if the business unit name is hardcoded in extracts or reports in hcmWe renamed the Business unit and this will have an impact on the seeded/custom reports and extracts so we wanted to do a global search using the string/hardcoded value l…
-
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti…Phani Sajja 332 views 9 comments 1 point Most recent by Consultant Ian Reporting and Analytics for HCM -
Unable to get data in HCM Extract linked BI report after 21D updateSummary: I have created a dummy extract, and have linked a BI report to the Extract delivery option (as we need to use autoload parameter in HCM extracts, data is coming… -
Sql to get the Administrative section in Learning offeringSummary: We are struggling to identify the table name for Administrative section in Offering details page in Learning module Content (please ensure you mask any confiden…
-
Display a Document of Records Image in a BIP ReportHi all, My customer has a requirement where they need to see a report that includes a Document of Record image (passport photo) in a BIP RTF report. Has anyone managed t… -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
What entitlement and roles do I need to be able to create and run query using sqls in BI report.Summary: What entitlement and roles do I need to be able to create and run query using sqls in BI report. I can access Person Management from the UI. But I want to creat…Sunny G 47 views 8 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
HCM Profile-> Set Preference-> LanguagesI want table to get data from Profile-> Set Preference-> Languages. and want joins to create relation between profile and language. profile-> Set Preference-> Languages …Rajdeep_Chavda 34 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Can we use SQL table field in alert composer templateSummary: Hello experts, How can we use SQL table field in alert composer template? we are using SQL in filtering condition to pull our population and want to use SENIORI…
-
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma…Velidi Supraja 543 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM
-
Issue with bursting queryHi, Facing some issue with custom email notification for overdue learning in the learning module. Have developed a SQL query with bursting but employees are receiving mu… -
Replicating a few dozen Fusion tables to ADB for heavy reporting: what worked and what brokeThere was an error rendering this rich post.ANTHONY DANSO-LARTEY 13 views 0 comments 0 points Started by ANTHONY DANSO-LARTEY Reporting and Analytics for ERP
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 85 views 12 comments 0 points Most recent by User_H0GYP Reporting and Analytics for HCM -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 259 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for HCM
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…
-
BI Publisher empty column missing from csv outputSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Shruthi Sadanand 17 views 1 comment 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…Lydia Jayasingh 213 views 8 comments 0 points Most recent by Vinoth_BI Reporting and Analytics for ERP
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …ScottLCIS 58 views 5 comments 0 points Most recent by Pankaj Toshniwal-Oracle Reporting and Analytics for HCM
-
Unable to Access OTM BISummary: I have configured my user and given the access in IDCS - Service Administrator and I`m able to access the BIP in Test environment but when I try to access BIP i…P_Parth-Oracle 27 views 0 comments 1 point Started by P_Parth-Oracle Reporting and Analytics for SCM
-
Need SQL query to get the learner feedback in OLC self paced video learning catalog itemNavigation : learning Catalog > select self paced online item > Rules > Completion Section > Collection Method: Evaluation > Evaluation. Need SQL query to get the column…
-
Unable to Identify Join Between WLF_LI_ACTIVITIES_F and HRQ_QUESTIONNAIRES_B for Evaluation DetailsSummary: We need to retrieve evaluation details in our report. We are able to identify the evaluation records in the WLF_LI_ACTIVITIES_F table where the ACTIVITY_TYPE = …
-
Implement Badging in Oracle Learning Cloud and Integrate with talent profileSummary: We are looking to implement badges in Oracle Learning Cloud Content (required): Hi All, Our client is looking for implementing Badging functionality in Oracle L…
-
Required Table or SQL query to get Phase details for the ORC moduleSummary: Hi, Required Table or SQL query to get Phase details uder the task: Candidate Selection Process Configuration for the ORC module Content (please ensure you mask…Opkey PA 79 views 2 comments 0 points Most recent by Rhonda Tuchek Recruiting, Opportunity Marketplace
-
OTBI Graph: Maintain Same Color for Multiple Measures of the Same SupplierHi, I'm working on an OTBI Analysis in Oracle Fusion and have a requirement to display both Invoiced Quantity and % of Quantity in a stacked vertical bar chart. Currentl…sakthi.paramasivam 13 views 2 comments 0 points Most recent by Abbas Sibai Reporting and Analytics for SCM
-
“Connection is either null or invalid” Error Only for HR Specialist (Custom Role)Summary: We have a BI Publisher report in the Custom folder. When I run the report using my implementation user, it works correctly and generates output. But when we log…Raghavendra M 30 views 5 comments 0 points Most recent by Abbas Sibai Reporting and Analytics for HCM
-
How to create a custom table in Oracle fusion SAASSummary: How to create a custom table in Oracle fusion SAAS Content (please ensure you mask any confidential information): How to create a custom table in Oracle fusion …Tapas_Sathua 29 views 2 comments 0 points Most recent by Abbas Sibai Reporting and Analytics for ERP