BI Publisher
Discussion List
-
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 1.5K views 8 comments 1 point Most recent by SureshRamanujam Receivables & Collections -
How to sum at highest level of grouping on rtfSummary: I need to sum at the highest level of grouping in my rtf Content (please ensure you mask any confidential information): I am building a rtf template for a repor… -
Question Mark is appearing after each row in etext outputContent Hi, Question Mark is appearing after each row in etext output. How to remove? Thanks in advance. Regards, NivyaNivya Mathire 121 views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 97 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
I want joins for ap_terms_tl and FND_SETID_SETS tabSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sushmita Nagaraj Doddamani 11 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
BIP Bursting to object StorageSummary: We have a requirement where we want to schedule BIP report output and store it to object storage . Is it possible burst BIP report to object storage. Also,We do…Mandar -Oracle 601 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How do we pass multiple input values for a parameter from Payroll flow to a Bi report.Summary: We have a requirement where in we want to pass multiple input values for a parameter from payroll flow to a bi report. How do we achieve it. We have created a B…User_ANH3E 101 views 9 comments 0 points Most recent by Eknath Kayasri Reporting and Analytics for HCM -
Learning Communities - Database SchemaCan anyone confirm how I would go about reviewing the Database schema for Oracle? I have some basic SQL knowledge that I have been able to leverage in OTBI/Data Models b… -
24C New BIP report Journal and Transaction Details Report Unable to Select From & To Period ParameteSummary: 24C New BIP Report: Journal and Transaction Details Report: Unable to Select From & To Period Parameters Content (please ensure you mask any confidential inform… -
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 41 views 8 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM -
Can we run a BIP report with REST API datasource in Payroll Flow pattern?Summary: Dear Folks, I'm trying to call REST API method from BIP report to trigger a method in OIC. So, I created a BIP report with REST API endpoint URL as data source.…User_BRCI5 61 views 5 comments 0 points Most recent by Eknath Kayasri Reporting and Analytics for HCM -
unable to load competencies due to QualifierId2Summary: I've tried to load Talent Profile Competencies multiple times, but no luck. First time around I tried with no QualifierId2/QualifierCode2 column and then second… -
Error - An assertion failure was detected at location ProcReportPayAct.childRequestSSummary: Extract error at BIP stage - An error occurred. An assertion failure was detected at location ProcReportPayAct.childRequestS. Contact your help desk Content (re… -
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I… -
We Need a table for the Default Values Configure Worksheet Display -Detail TableSummary: Hi We need a table for the below fields under Configure Worksheet Display -Detail Table in workforce compensation plan Content (please ensure you mask any confi…Opkey PA 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to Unmask Bank Account Details when Masking and Encryption is EnabledSummary: Hello Everyone, In Oracle Fusion Applications, we have enabled "Bank Account Encryption" and also "Bank Account Number Masking (last 4 digits)" through System S…Bharath2712Automus 137 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
BIP Bursting to Email:Output sent as URL:Ability to Change the Position of the URL in the Email BodySummary: BIP Bursting to Email: Output sent as URL: Ability to Change the Position of the URL within the Email Body Content (please ensure you mask any confidential info… -
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…User_2025-02-11-06-57-37-559 172 views 7 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 21 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 51 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…Manoharan 562 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
What is the functional difference b/w fusion_ora_ess.request_history and fusion.ess_request_historySummary: What is the functional difference between fusion_ora_ess.request_history and fusion.ess_request_history and please explain ErrorType codes present in fusion.ess… -
How to schedule BIP report with increment date and timestamp?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…Lalit Sinkar 231 views 5 comments 0 points Most recent by Angela Valcelli Reporting and Analytics for ERP -
How does Group Notification Configuration works-Send One email containing all email addresseshttps://us.v-cdn.net/6034893/uploads/L3VF2N09KV4L/bpm-group-notification-configuration.docx Summary: We are trying to update the Notification Settings for the Invoice Ap…Baskara Sateesh-Oracle 21 views 0 comments 0 points Most recent by Baskara Sateesh-Oracle Payables, Payments & Cash Management -
Feedback center manager email and BPM notification content mismatchHad an issue in Notifications content display - We have enabled and customized the template - /Shared Folders/Human Capital Management/Workflow Notifications/NoteSentToM…Challa Ramya-Oracle 11 views 0 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM -
how can i get last date when customer was printed in final mode for a customer in oracle fusionHow can I get the last date when statement was printed in final mode for a customer in oracle fusion. Is that value stored in any table or is there any API that can be u… -
PO PDF Template Conditional Regions by Purchasing CategorySummary: We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the tem…