BI Publisher
Discussion List
-
How to include a pdf attachment in a custom NotificationSummary: How to include a pdf attachment in a custom Notification Content (please ensure you mask any confidential information): Hi, we created a BI custom notification.…Barile Alberto 79 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Cannot access name on errored out EssBIPJobSummary: 24C version The errored out process name is not displayed, when i check from Report job history page, not able to check the details of this ess bipjob, can anyo…Shahid Qureshi 31 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
API to run financial reportSummary: We have the following query, we need to call a financial report using a web service, we have tried using the WSDL (/xmlpserver/services/ExternalReportWSSService…Arin 13 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
SaaS BIP reports in waiting for long timeWe have kicked off BIP Report in SaaS/Oracle Financials Cloud and its in waiting mode for 2 hours 40 mins before it started executing.Pradeep Challa 53 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 304 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
XMLP Server - Security & User AccessSummary Testing security and user access of XMLP ServerContent Hi All, We are looking to restructure our Reporting Catalogue for our HR users where they will use a dashb…User_2025-02-05-05-51-12-049 29 views 10 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
sample query to check Invoice/Credit Memo has been posted to GL?Hi Team, Need sample sql query to check Invoice/Credit Memo has been posted to GL or not in oracle cloud. -
Is it possible to include Null values in BIP Report Parameter?I'd like to pull null values within my report. Is it possible to run the report with 'null value' parameter? -
Report on User Actions in Oracle HCMSummary: Good evening, I need to extract a report with all the actions performed in the system by users (e.g., hiring an employee, entering Performance Goals, etc.). Is …Guido Masciello 21 views 2 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
Can anyone explain scecurity being used on seeded DM?Summary: The business looking to add security to a custom version of EmploymentCreateProcesses, like the security being used on seeded /shared/Human Capital Management/W…
-
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanksAhmed Abdelaziz 31 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
BIP Account query to get the rollup data in a a rowSummary: BIP Account query to get the rollup data in a a row Content (please ensure you mask any confidential information): Account 1 has rolled up to child 8, child 8 r…NarenInova 23 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Conditional Formatting to display field in redHi, In the PO template if the amountMohammed Rafi 21 views 1 comment 2 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for ERP -
how to use get_variable in IF condition in RTF templateHi Team, We have a requirement to display the data in report based on net sal, to get this done we are using below tag in RTF template and its not working, we tried diff…Suresh Gandla-Oracle 521 views 4 comments 0 points Most recent by Arun Raj Reporting and Analytics for HCM -
Extract FTP Shows succesful but file missing on serverSummary: Extract FTP Shows succesful but file missing on server Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed that … -
ORA-06512: at "SYS.XMLTYPE", line 169Summary: Hi, i have created the AR Invoice Auto Mail by taken the reference of "Print receivable transactions", if i schedule the report the report should send the invoi…Siva BVP-Oracle 102 views 1 comment 1 point Most recent by Daniel S.-Oracle Receivables & Collections -
Business Unit Name ER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine… -
We need REST API for Manage formats in Fusion FinanceSummary: HI Team, Do we have any API to get data for the setup "Manage formats". We wanted to get format names Content (please ensure you mask any confidential informati… -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the …Raghavendra M 789 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
While the ESS job names are visible in the ui, they are only partially displayed in the BIP ReportSummary: While the ESS job names are visible in the user interface, they are only partially displayed in the BIP Report, with approximately 50% of the job name informati… -
HCM table to fetch eligibility status of compensation plan.Looking for HCM table to fetch eligibility status of compensation plan as "Eligible" or "Limited".Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Add regular page number and section(journal) page number in the same report outputSummary: Hi Team, We are printing a journal report. we have a requirement to print 2 sets of page numbers Regular page number and Section(Journal) Page number expected o…Praveen3015-Oracle 31 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Is there any REST API to get the information of Key Flexfield Segments?Summary: Hi Team, Is there any API to get the information of Key Flexfield Segments under "Manage Key Flexfield Structures". We need the fields in below attached screens…Opkey PA 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Progression Ladder for a bi_query_reportSummary: how to join rates to per_grade_ladder_f and per_grade_steps_f for a bi_query_report to show Progression Ladder > Grades that belong to Ladder > Steps in Grade >… -
Collections Dashboard - Expected Amount and Expected Data table detailsSummary: Need to know the source table that holds the below marked fields - Expected Collection Amount and Expected Collection Date. Able to get the Unpaid Reason from t… -
BI tables to retrieve Compensation Plan Status and track compensation plan approval flowSummary: Content (please ensure you mask any confidential information): Hello experts, we need to track manager compensation plan status (i.e Submitted; Work In Progress…Valerio Curzi 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA… -
Alert Composer - ${AlertUtils.empManager(learnerLearningRecords.assignedToId).WorkEmail}Summary: Hi team We need to know if when we use this tag ${AlertUtils.empManager(learnerLearningRecords.assignedToId).WorkEmail} for the manager to receive the notificat… -
GET_VALUE_SET FF function is instableSummary: Hi Community, For some reason, GET_VALUE_SET FF Function is not returning date for all employees that it should, but interestingly though, it returns for some. … -
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…Sainatha B 21 views 1 comment 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM