BI Publisher
Discussion List
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need … -
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): https://us.v-cdn.net/6034893/uploads/S9IJ8KIYKON0/learning-query.txt I…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 41 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur…
-
Does any schedule process or reports show customer credit funding without enable credit management？Summary: Does any schedule process or reports show customer credit funding without enable credit management？ Content (please ensure you mask any confidential informatio…
-
SQL query to get Primary Instructor from Course level in Fusion HCMSummary: Recently we received a requirement from one of our customers to fetch Primary Instructor from Course level. After some R&D we were able to retrieve the required… -
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t…
-
Auto Refresh a BIP ReportSummary: How to refresh a BIP report after a certain period of time? Content (please ensure you mask any confidential information): HI, We want to show a report on a Dis…Zahid Rahim 123 views 2 comments 2 points Most recent by Rohit Kumar ACN Reporting and Analytics for ERP
-
sql query to fetch Total number of Overdue Trainings detailed reportSummary: sql query to fetch Total number of Overdue Trainings detailed report Content (please ensure you mask any confidential information): Version (include the version…
-
BI Publisher - RTF template - write a numeric value in lettersSummary Need to write in letters a numeric value from a BIP fieldContent Hello, I am creating a RTF template that I want to display as a report in BI Publisher. In this …Alice Gouzy 137 views 13 comments 1 point Most recent by Ravi Tilekar Reporting and Analytics for HCM
-
CertificatesSummary: How to create own certificates in Oracle Learning Cloud and tie them with course outcomes? Content (please ensure you mask any confidential information): We hav… -
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 121 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM
-
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 1.1K views 4 comments 0 points Most recent by User_NPE6A Reporting and Analytics for HCM -
How to get Request Id for Import Journals ESS Job using ImportBulkData Operation using REST API?I am invoking the importBulkData(Operation) REST API to run the Import Journals job for loading journal FBDI files. While I can retrieve the Request Id of the "Load Inte…Srinath Anbarasu 499 views 5 comments 0 points Most recent by Raluca Chivu-Oracle General Ledger & Intercompany
-
Purchase Order PDF report issueHi Team, We have customization in Purchase Order PDF report by adding customer logo and also setup the confirmation in configure procurement Functional business unit tas…Chanikya Neelam-Oracle 11 views 6 comments 0 points Most recent by Chanikya Neelam-Oracle Reporting and Analytics for ERP
-
Separate Remittance Advice sent as Email - formatting of email bodySummary: How can I generate the SRA in email with the formatting in place? Content (required): We have created a custom Separate Remittance Advice (SRA) format. When the…Niall McColl 141 views 3 comments 0 points Most recent by Bhawna Payables, Payments & Cash Management -
how to enable emailing for T4 Year End Report for canadahas anyone done this before, can you please share the steps ? We tried doing it in a similar fashion like Payslip emailing but incase of T4 the custom report never gets …
-
Customer registration number is not display in printed INVSummary: Customer registration number is not display in printed INV Content (please ensure you mask any confidential information): In the previous month, the "CUST_TAX_R…
-
How to Reset the BICC Extract To last run Date via APISummary: Hi Team, we have requirement to reset to the BICC extract to last run date based on any failures. Can some one please let me know if this is possible via any AP…
-
For the customized Print receivable transaction report, the ess job fails with errorSummary: As part of the Run , our Print Receivable Transaction Report job is failing and the ESS log message provides us the below error message AR_ESS_PLSQL_WRAPPER_PKG…
-
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …Opkey PA 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI publisher: EText Condition Fails with Slanted Apostrophe in XML TagsSummary: I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in …Sudeepto 21 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Project Comments in query output FormattingSummary: User created a comment on Project level (might have been copy pasted from some other source), when a sql is written to extract the information, it has all sorts…
-
Looking for a Custom Audit report showing old and new valuesClient is looking for a custom audit report build through BI which shows the old and new values.Meenakshi K 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.1K views 26 comments 1 point Most recent by User_C767R Reporting and Analytics for HCM -
Trial Balance Report data model errorHi, I'm trying to customize 'Trial Balance Report'. When I run TrialBalanceDm with relevant parameters, its throwing below error. ORA-20101: ORA-06512: at "FUSION.GL_TRI…Manavalan 304 views 5 comments 0 points Most recent by Lasantha Ranjana Bandara Payables, Payments & Cash Management
-
How can I edit parameter in standard ESS job?Summary: I want to edit (hide/remove/default to a specific value) the parameters of a standard ESS job. Please share steps to do it Content (required): Version (include …Priyal Pareek 721 views 3 comments 0 points Most recent by Sameer_Jain Reporting and Analytics for ERP
-
Mass addition approval notification is not showing details of assets in the groupSummary: We are uploading multiple assets with ADFDi. When the approver is getting the approval notification part of mass approval, he is able to see only the total amou…
-
Transaction being created while BIP report is runningSummary: We have created a custom BIP, the report takes 15 minutes to completed, while the report is running the users create additional transactions which were not ther…