BI Publisher
Discussion List
-
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 2.8K views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
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…
-
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…ManishaPatil 31 views 5 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
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 15 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 52 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 268 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 22 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use…
-
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 2 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 127 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 1 view 0 comments 0 points Started by Raluca Balan-Oracle Reporting and Analytics for SCM
-
How to process 1099 DIV, 1099 INT, 1099 K and 1099 S from Oracle FusionSummary: How can we process 1099 DIV, 1099 INT, 1099 K and 1099 S forms from oracle fusion? Content (please ensure you mask any confidential information): Version (inclu…Pranav7607 505 views 12 comments 2 points Most recent by S Akhtar Payables, Payments & Cash Management
-
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 10 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
-
Retro ReportsSummary Retro ReportsContent EDIT: The newer version, after few bug fixes, can be found hereAllen D'Souza-Oracle 259 views 8 comments 3 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 558 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 65 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…