BI Publisher
Discussion List
-
Enable Audit Log/System PerformanceHello All, We are interested to enable the Audit log files in Production and we want to know that what is the impact on system performance audit log is enabled once. We…Linga Murthy 41 views 1 comment 0 points Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP -
Embed BIP report in the Application UI pagesSummary Embed BIP report in the Application UI pagesContent Hi, OTBI Report can be embedded in the UI using page composer. But can we achieve the same for BIP report? I …Manoj.Gupta 608 views 10 comments 8 points Most recent by Sai Revanth-Oracle Reporting and Analytics for HCM -
Master data historySummary: Looking for an Audit query, which shows old and new values of master data. Content Hi I am looking for a query to track changes in Master data (Position, Locati…
-
EXM Table that includes the TokenSummary: Does anyone know of an EXM table that includes the Token? Content (required): The bank I am working with sent some rows where the Card Holder Details are comple… -
Error Message from RTF Template - Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001Content Hi Please can someone assist witht the below error: Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001 This error is recvieved when running custom templ…User_2025-01-30-20-23-15-920 418 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…
-
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …Rishita 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to use "Replace" function in BIP Report Excel TemplateSummary How to use "Replace" function in BIP Report Excel TemplateContent Hi Experts, How to use "Replace" function in BIP Report Excel Template. Could you please sugges…Bala Kasineedi 355 views 11 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
Added new delivery options at Element Result Report but output is not available once we runSummary: Added new delivery options at Element Result Report but output is not available once we execute Run Element Result Register flow Content (required): Added new d…
-
Embed BIP report on Employment Info Responsive UISummary: Embed BIP report on Employment Info Responsive UI Content (required): Developed a BIP report and used Assignment_id as parameter. We have placed it as Hyperlink…Kammasavala Ramadevi 111 views 3 comments 0 points Most recent by Kammasavala Ramadevi Reporting and Analytics for HCM
-
How to restrict All subject area Access from Line manager roleSummary: We wanted remove all subject area analysis from line manager role. We are able to remove some subject are by deleting the transaction analysis privileges . Rest…Aditya Jena 113 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to pass 10K records in IN clauseHi, I would like to pull journal information for 10K batches. I have 10K journal batches in the csv file and need to pull journal information(creation date, category, et…
-
I'm new to E-text template, how can I learn and How can we develop in Bi reportsSummary: Hi Team, I'm new to E-text template,how can I learn and How can we develop in Bi reports. Any suggestions . Thanks, Ajay Content (required): Version (include th…AjayKumar Maddipati 42 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How long are the report jobs and outputs retained on the server?Summary: How long are the BIP Report Jobs and output files are retained on the server? Content (required): N/A Version (include the version you are using, if applicable)… -
NULL value creating duplicates in UNION queryAfter adding NULL value to some columns , it is showing Duplicates in UNION query. Like: AUTHORIZATIONCODE, JOBDESCRIPTIONDATE, JOBEVALUATIONDATE.Dona Das-Oracle 11 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
how can start and learn oracle extracts in hcm ?Summary: Hi Team, Please help and Guide me on to learn Extracts. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): Code Snippe…
-
OTL Approval workflow data - Current manager for approval, Submitted by, SubmissionSummary: Does anyone have an SQL for OTL Approval workflow data - Current manager for approval, Submitted by, Submission? Content (required): I am looking to develop a B…Neena S 32 views 2 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Need to attached FF:Summary: Hi Team, We have a requirement in Oracle cloud recruitment where we need to attach FF for only US and Polad country. could someone help me to get this FF. Will …
-
How to call a BI report when email id is created?Summary: How to call a BI report when email id is created? Content (required): Hi All, We got a requirement to send notifications to new joiners when their work email is…Venkatesan 42 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Create an analysis report to see the workflow for a specific Job RequisitionSummary: Create an analysis report to see all job requisition workflow Content (required): Does anyone know how to create an analysis to see all workflow for a specific …
-
Table that holds ESS Job Display nameSummary: Hi We are trying to create a bip to fetch ESS job details. we looked into ess tables for display name but looks like they store only short name. fusion_ora_ess.…Susmitha R 2.6K views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Parameter's label in two different languages.We have a requirement to display the parameter's label as per the language who logs in. The actual requirement is to display the label as per the users who logs in . If …
-
How to get the position level of a position from the top using OTBISummary: We have a requirement to get the position level of a position from the top. eg: CEO is the top position and should be at level 1, 2 directors reporting to CEO s… -
How to provide read only access on all fusion tables (not cloud app pages) for a user accountSummary: We have a requirement from external auditor to provide them with the access of read only , able to query and get exact counts ( just the counts and not the real…
-
How to query return transaction id from AP invoice tables?Summary: How to query return transaction id from AP invoice tables? Content (required): We have the requirement to get return transaction id of debit memo. But the AP in…Lucy.liu 523 views 1 comment 0 points Most recent by Cesar Tepetla Corte Payables, Payments & Cash Management -
Talent Profile: How can I make CLOB fields visible in a report?Summary: Talent Profile: How to make Job responsibility, - description and - qualifications visible in an analysis? Content (required): Dear all I need to create a repor…Matthias Essrich 72 views 4 comments 0 points Most recent by David Pham-Oracle Reporting and Analytics for HCM -
Customizing Journal Workflow and Invoice Workflow Notification in ERP Fusion CloudSummary: We have a requirement to customize the notifications from Workflow from Journal approval/Invoice Approval. We wanted to add a table to show the list of approver…Abhilash K - Deloitte USI 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 950 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
How to map one parameter value to the multiple columnsHi, I have a table like as mentioned in the screenshot. I would like to pull the rows based on the parameter value. Data Model Query select * from supplier where usage1 …