BI Publisher
Discussion List
-
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 781 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 21 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
-
Payslip - Other Deductions Section is showing doubled amountSummary Need help in determining if the issue is just with the BI Report or if the dataset is pulling in the wrong informationContent An employee had his garnishment (In…User_2025-02-04-08-51-08-912 53 views 2 comments 0 points Most recent by Saisandeep Nutheti Reporting and Analytics for HCM -
Validate cross validation combination set in a BIP reportSummary: We have developed a BI Publisher report to validate the account combinations against the cross validation rules (CVR) using the PL/SQL API fnd_flex_ext.get_cvr_…
-
Deep link documentation for GL (and Financials)Summary: Where can we find the documentation for deep links for GL? Content (please ensure you mask any confidential information): Where is the detailed documentation fo…TyskJohan 488 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…Angela Grace 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Why BIP audit report missing data ?We have audit requirement that we know who and when report have been modified. When using the Audit report for Product: Oracle Business Intelligence Enterprise Edition, …Francois Desjardins 51 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
What is the Retention policy for BIP Jobs run in Fusion ERP Cloud?Summary: What is the Retention policy for BIP Jobs run in Fusion ERP Cloud? Do we have more information on maximum value/minimum value for retention? Also Is there a cos…Abhilash K - Deloitte USI 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Is there a way to modify the configuration so that the link to its own cell is displayed?Summary: When downloading information from a report, clicking on the link of any of the cells always displays the link to the cell corresponding to the first row. Is the…Manuel Riobóo Córdoba 31 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we …Manuel Riobóo Córdoba 31 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can someone help on how to setup to print directly from Oracle to a network printer?Summary: We want to print some reports directly from Oracle. Is there a way to use a printer in the network to have the output of the report print to a printer? Content …Boying 41 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
RTF XDO_METADATA setup not working despite mirroring other setup that is workingSummary: We have customized an RTF to where the results are broken out into different tabs. We used the same for each loop as the other tabs, but the new tab is putting …Alex Glose 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to create and submit BIP reports by batch (request set)Summary: How to create and submit BIP reports by batch (request set) Content (please ensure you mask any confidential information): There is a client requirement to run …Babasaheb Bhujbal 22 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need to generate and include a sequence number in custom BI publisher eText template for non paymentSummary: Need to generate and include a sequence number in custom BI publisher eText template for non payment Content (please ensure you mask any confidential informatio…Ishtiaque AHmed 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…Sankhya 21 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create deep link for Items in Product Information Management module?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Uploading PGP keys in BI Administration failed with errorSummary: Uploading PGP keys in BI Administration failed with error 'Importing public key file .asc failed: reason=key file could not be imported: exit value=2' in 24D. I…Vidhya Nadarajan-Oracle 76 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle HCM Extract
-
What role/duty/privilege is needed to run Custom GL batch Delegation BI report with BPM tablesSummary: What role/duty/privilege is needed to run Custom GL batch Delegation report with BPM tables Content (please ensure you mask any confidential information): we ar…Jude Franco 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany