BI Publisher
Discussion List
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser… -
BI Publisher prompt on date to refresh other parametersHello, I built a BI Publisher report with a prompt on 'as of date' which I want to reflect on other prompts so they refresh the available values. I read that it's not ye…Alice Gouzy 33 views 2 comments 1 point Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Why would a report not reflect the updated data model?We had an issue wherein the report did not reflect the updated data model. The fix was then to duplicate the report itself without any changes. The duplicated report the…Hazelle 63 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Procedures in AP_INVOICES_PKGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Consultant2025 7 views 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
Generating Record 0150 (Participants/Suppliers) in SPED Fiscal (Bloco K) via LACLS_SpedInvBlocoKHi everyone, I have a question regarding the Brazilian Localization for EFD ICMS/IPI, specifically concerning the generation of Bloco K (Inventory and Production Control… -
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 15 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Print Receivables Transactions completes with errorSummary: When attempting to run the "Print Receivables Transactions" process for a single invoice, we are getting below error: The bill-to customer email address for tra…
-
Set last year as default value on BIP parameterSummary: Content (please ensure you mask any confidential information): I have a BIP report with parameters. One of parameters is year. I know that last day of last year…Stefano_Mazzocca 14 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Specific user assigned with Payroll Administrator cannot view the Reports tab in UI Dashboard.Hi Experts, Does anyone have experienced that there is a specific user which was assigned by Payroll Administrator role but cannot view the Reports tab when clicking the…
-
why the BIP Report does not consider the template while generating the output in CSV Format ?Req : Generate CSV output format with specific column names. Hi Team, I have designed an Etext template for the purpose of generating output in CSV format. Etext Templat…Sridhar Gupta Yerram-Oracle 25 views 2 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
Is it possible to restrict the users to create the AR invoice with a particular source ?Summary: Hi Team, Is it possible to restrict the users to create the AR invoice with a particular source which has type as Manual. Content (required): Is it possible to …Ayyappa-Oracle 54 views 3 comments 0 points Most recent by Himanshu Mahajan Receivables & Collections
-
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 341 views 6 comments 0 points Most recent by Dairy Land Reporting and Analytics for ERP
-
Solution for Fixed Asset Rollforward (Asset and Tax Books)Summary: My Company has put a lot of effort and resources into developing a Fixed Asset rollforward in Oracle, which is a standard fixed assets report utilized across al…
-
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… -
Do we require Expense License to load the dummy credit card transactionsDo we require Expense License to load the dummy credit card transactions which can be utilized for BIP reporting
-
BIP Report to Track “Synchronize from Position” UpdatesSummary: Hello, Is there a BI Publisher (BIP) query or report that captures all attributes updated by the “Synchronize from Position” action on a daily basis? Any pointe…Explorer 24 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
How to enable the Learning Administrator dashboardsWe had a requirement to enable the Learning Administrator dashboards in the Fusion environment. I need to know how to enable the hidden dashboards and side panel of the …
-
How to give access to Report Job History (scope all Histories) without BI Admin roleSummary: How to give access to Report Job History (scope all Histories) without BI Admin role Content (please ensure you mask any confidential information): Version (inc…Sonali Sethi 11 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 335 views 10 comments 0 points Most recent by SudiptaDey-Oracle Reporting and Analytics for HCM
-
How to pull data in Power BI from Oracle Fusion/ATP TablesSummary: How to pull data in Power BI from Oracle Fusion Content (please ensure you mask any confidential information): We are looking to pull data in Power BI from Orac…Abhishek Sinha 163 views 2 comments 0 points Most recent by User_DXIFI Reporting & Analytics for Sales
-
Link to Linkedin CourseHi, we need to send the Oracle Course Catalog to an external system, for Linkedin Courses we want that users of external system will access direclty to Linkedin wihout p… -
SQL query for Fusion Subledger Accounting Hub with Channel Revenue ManagementHello, we need to create an SQL query where we have ChRM Program details, Accrual and Journal Batch Transaction Details: Debit/Credit from Accounting Hub. Can you please…Raluca Balan-Oracle 18 views 0 comments 0 points Started by Raluca Balan-Oracle Reporting and Analytics for SCM
-
Error from SQL type DFF in applied receipt to get information from DFF in the applied transactionI want to transfer information for a DFF in receivable transaction to the receipt when applying it So i have created a DFF type SQL at AR_RECEIVABLE_APPLICATIONS, and en…Ammar.Sultan 17 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Receivables & Collections
-
Extract the customer credit limit detailsSummary: We have requiremnet to extract the customer credit limit details. Content (please ensure you mask any confidential information): We need a report or query to ex…Mamdouh Ahmed 25 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for ERP
-
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 611 views 11 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM