BI Publisher
Discussion List
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 12 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… -
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 3.8K views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 11 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 22 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 55 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 333 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 21 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… -
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 331 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 151 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 13 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 11 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 23 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 601 views 11 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
1099k reportingSummary: As there is a requirement for suppliers to generate the 1099-K form, is it possible to handle 1099-K reporting within Oracle Fusion? If so, how can this be achi…Dhruba 61 views 6 comments 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management -
In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode)Summary: In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode) must be correctly aligned with the corresponding rows that contain the rel… -
We are building a custom report based on the Standard Uninvoiced Receipt Accrual ReportSummary: We are building a custom report based on the Standard Uninvoiced Receipt Accrual Report, and we need to include additional receipt‑related fields such as Receip… -
Restrict sending attachment in email burstingSummary: We have a requirement that client does not want email attachment to go to the end user and should not be part of the mail body as well. We created a deeplink fo…Abhilash K - Deloitte USI 22 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Table : Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloudSummary: Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloud Content (please ensure you mask any confidential information): Version (i…