BI Publisher
Discussion List
-
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 422 views 11 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP -
Sql query to get PO Change Order line Details.Summary: https://us.v-cdn.net/6034893/uploads/BATNEQXAX0VY/change-order-fields.docx Required sql query to get following PO Change Order line Details. Columns: Attribute …Praneeth Nalluri 793 views 2 comments 0 points Most recent by Sandeep Marka Reporting and Analytics for ERP -
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report …Sandy Suo-Oracle 291 views 9 comments 9 points Most recent by Sandy Suo-Oracle Reporting and Analytics for HCM -
I need to find a way to Audit who deleted a folder in Reports and AnalyticsWe are live on Oracle Fusion, and we have a bunch of Reports and Datamodels in Custom folder in Reports and Analytics. Someone deleted one of the folders and we need to … -
Receivables Aging by General Ledger Account Report Completed with error for as on date of 12/28/2024Summary: Use has submitted report : Receivables Aging by General Ledger Account Report with a ledger and as on date as 12/28/2024 and it is completed with Error and log … -
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…Opkey PA 1K views 5 comments 0 points Most recent by Sathyaseelan Chandran Reporting and Analytics for ERP -
Is there a way to view user role history in Oracle Fusion—specifically, to see which roles were assiHi Everyone, Is there a way to view user role history in Oracle Fusion—specifically, to see which roles were assigned to a user and when? Or Any suggestion for seeded re… -
Is there an Oracle standard report that lists the permissions for all folders in the BI Catalog?Summary: Is there an Oracle standard report that lists the permissions for all folders in the BI Catalog? Version : 25D -
Users Record History in fusion HCMSummary Users Record History in fusion HCMContent Hi Everyone, Do we have any diagnostics report where we can get user records history ,complete changes happened on user… -
Looking for guidance on custom email solution for Oracle Fusion - Receivables Print TransactionsSummary: We are currently using the standard Oracle bursting process (Job: Receivables Print Transactions) in Oracle Fusion Cloud Receivables to generate and email custo… -
Adding Prompts to BI Publisher Data Models that are based on OTBI ReportsContent Hello, We are implementing OLC and are making certificates in BI Publisher. To make it a little easier we've build the data model off an OTBI report, but we are …User_2025-01-31-00-25-12-234 120 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Learning Calendar is not working as expectedSummary: Hi Team, @Mandeep Gupta I'm trying to enable the Learning Calendar in the Administrator Dashboard. Currently, I'm facing an issue with the Learning Calendar OTB… -
Oracle table where i can get expected effort in hours of a ILT activity and the classroom type codeSummary: Could someone please guide me on which Oracle tables store the expected effort (in hours) for an ILT activity and the virtual classroom type code? I need to ext… -
How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI ReportSummary: How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI Report. Which parameters need to pass to this function. Content (please ensure you mask … -
Can Oracle provide listing of object changes to Journal and transaction Details Report after 25A?Hello, Our auditors are asking why the delivered Journal and Transaction Details report was modified on 4/4/2025. This is a delivered report so our company does not have…Jason Madden 11 views 2 comments 0 points Most recent by Jason Madden Reporting and Analytics for ERP -
Oracle HCM Fusion Table to find Business capability in Oracle content ItemsDear Team, We are trying to fetch the business capability field from below navigation: Navigator > My Client Group > Profile > Item Catalog > Search for Skills Library >… -
Manage Revenue contingency assignment rulesSummary: Hi Team, Need the backend table to build the sql query for the task Manage Revenue contingency assignment rules. Could you please provide me with the backend ta…Mounika Rani 2 views 1 comment 0 points Most recent by Mahesh Adivishnu-Oracle Receivables & Collections -
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…Ezhil 252 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Respond To Questionnaire Notification Report template is coming blank. 0kb file is downloading.I have to customize 'Respond To Questionnaire Notification Report' but unable to do so as report template is coming blank. When i am downloading rtf, 0 kb file is gettin… -
Redwood: Purchase Document E-mail ReportSummary: Redwood: Purchase Document E-mail Report Content (please ensure you mask any confidential information): Hi Team, We are getting new feature in 25D :Redwood: Use…Nidhi Chhajed 31 views 3 comments 0 points Most recent by Sireesha Y Reporting and Analytics for SCM -
Employee Access to Payroll Documents from Year-End Documents Page Not Recorded in PER_SENSITIVE_DATAWe have a requirement to build a BIP report that shows when employees view Payroll Documents. We are currently using PER_SENSITIVE_DATA_AUDIT, which records audit activi… -
query to get approvalSummary: we need a query to get the approval for PR or PO. Content (please ensure you mask any confidential information): Version (include the version you are using, if … -
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …Vasanthakumar Ravi 134 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need document on how to migrate Value Set from HCM Extarct to from one instance to another instanceSummary: Need document on how to migrate Value Set from one instance to another instance Content (please ensure you mask any confidential information): Hi Team, I am usi…Ketan-Oracle 22 views 1 comment 3 points Most recent by JayeshKori-Oracle Reporting and Analytics for HCM -
How to download all attachments from a Projects Invoice workflow transactionSummary: How to download all attachments from a Projects Invoice workflow transaction Content (please ensure you mask any confidential information): Approvers are attach… -
MilanMohanty 151 views 3 comments 0 points Most recent by Mohd Affan Ahmed Reporting and Analytics for HCM -
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 1K views 8 comments 7 points Most recent by Mohamed Elwan Reporting and Analytics for ERP -
how to extract One Time location entered in Ship to location on Purchase Orders using BIP reportWe want One Time location entered in Ship to location on Purchase Orders. Where it is stored? How we can extract using sql query. -
BIP Report is taking more time while Using Bursting, Without Bursting it completes in 10 minSummary: Custom BIP Report is running for more than an hours and it is not bursting output to FTP(secure) while using bursting query. But when we are running the same re…Sunil Saini 342 views 5 comments 0 points Most recent by Vijay_Huron Reporting and Analytics for HCM