Category 385
Discussion List
- 
             Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…Ketan- 59 views 5 comments 0 points Most recent by Velidi Supraja Reporting & Analytics for Fusion Service Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…Ketan- 59 views 5 comments 0 points Most recent by Velidi Supraja Reporting & Analytics for Fusion Service
- 
             Unable to see and run "Input Tax Gain and Loss Report for Singapore"As per suggestion given on "https://docs.oracle.com/en/cloud/saas/financials/25b/ocuar/input-and-output-tax-gain-loss-reports-for-singapore.html#Frequently-Asked-Questio… Unable to see and run "Input Tax Gain and Loss Report for Singapore"As per suggestion given on "https://docs.oracle.com/en/cloud/saas/financials/25b/ocuar/input-and-output-tax-gain-loss-reports-for-singapore.html#Frequently-Asked-Questio…
- 
             Which table holds audit data or historic LC Expiration date under supplier master business class...Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren… Which table holds audit data or historic LC Expiration date under supplier master business class...Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren…
- 
             What Subject Area is used to create a report for Item Batches and their overall statusWhat Subject Area is used to create a report for Item Batches and their overall status The purpose of the report is to see how many item batches are: Completede/In Progr… What Subject Area is used to create a report for Item Batches and their overall statusWhat Subject Area is used to create a report for Item Batches and their overall status The purpose of the report is to see how many item batches are: Completede/In Progr…
- 
             Absence workflow approval notificationsTeam, we want to customize and hide attachments from approval workflow notification for absence approval. We want to customize the seeded template to hide the attachment… Absence workflow approval notificationsTeam, we want to customize and hide attachments from approval workflow notification for absence approval. We want to customize the seeded template to hide the attachment…
- 
             Is it possible to register BICC Jobs in an ESS Job Set?Is it possible to register BICC Jobs in an ESS Job Set? Is it possible to register BICC Jobs in an ESS Job Set?Is it possible to register BICC Jobs in an ESS Job Set?
- 
             Difference in Accounts Shown Between Trial Balance Extract Report and SmartViewWe have a doubt regarding the Trial Balance. When we run the Trial Balance Extract Report from the Schedule Processes, the output is missing some accounts. However, when…Mukesh Sirigiri 32 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany Difference in Accounts Shown Between Trial Balance Extract Report and SmartViewWe have a doubt regarding the Trial Balance. When we run the Trial Balance Extract Report from the Schedule Processes, the output is missing some accounts. However, when…Mukesh Sirigiri 32 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
- 
             Can we club multiple elements into one single line so that the payslip generated is not very long?We have a requirement where in we want the multiple elements (elements and their retros) to get clubbed in one single line along with their contributions summed up too. …Kanak Maheshwari 11 views 3 comments 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI) Can we club multiple elements into one single line so that the payslip generated is not very long?We have a requirement where in we want the multiple elements (elements and their retros) to get clubbed in one single line along with their contributions summed up too. …Kanak Maheshwari 11 views 3 comments 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
- 
             Capture AP MetricsTo accurately capture Accounts Payable clerk metrics in a scenario where any clerk can fix or process any invoice, the 'last updated' field is insufficient for identifyi… Capture AP MetricsTo accurately capture Accounts Payable clerk metrics in a scenario where any clerk can fix or process any invoice, the 'last updated' field is insufficient for identifyi…
- 
             How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, NagendraNagendra Chitra-Oracle 15 views 3 comments 0 points Most recent by Pandit Yaashi Reporting & Analytics for Fusion Service How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, NagendraNagendra Chitra-Oracle 15 views 3 comments 0 points Most recent by Pandit Yaashi Reporting & Analytics for Fusion Service
- 
             SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 1.5K views 13 comments 1 point Most recent by Ashish_Goyal_MPC Applications Security SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 1.5K views 13 comments 1 point Most recent by Ashish_Goyal_MPC Applications Security
- 
             Issue with PO PDF Layout in Oracle FusionWhile customizing the Purchase Order PDF layout in Oracle Fusion, I encountered an issue with the standard data model. When the PO is in "Draft" status, all line details… Issue with PO PDF Layout in Oracle FusionWhile customizing the Purchase Order PDF layout in Oracle Fusion, I encountered an issue with the standard data model. When the PO is in "Draft" status, all line details…
- 
             Total Outstanding Amount and Current Amount in FDI are retrieving incorrect information.I am working on an AP analysis in FDI and I am using the fields Total transaction Amount (AP Invoices), Total Outstanding Amount (AP Aging) and Current Amount (AP Aging)…Maria F Covarrubias-Oracle 11 views 0 comments 0 points Started by Maria F Covarrubias-Oracle Payables, Payments & Cash Management Total Outstanding Amount and Current Amount in FDI are retrieving incorrect information.I am working on an AP analysis in FDI and I am using the fields Total transaction Amount (AP Invoices), Total Outstanding Amount (AP Aging) and Current Amount (AP Aging)…Maria F Covarrubias-Oracle 11 views 0 comments 0 points Started by Maria F Covarrubias-Oracle Payables, Payments & Cash Management
- 
             Can Custom PVO be created on any Table or Query for BICC?Summary: Can Custom PVO be created on any Table or Query for BICC? Content (please ensure you mask any confidential information): If seeded PVOs are not matching to our …Sreeram Tadepalli 293 views 4 comments 0 points Most recent by Sreeram Tadepalli Reporting & Analytics for Fusion Service Can Custom PVO be created on any Table or Query for BICC?Summary: Can Custom PVO be created on any Table or Query for BICC? Content (please ensure you mask any confidential information): If seeded PVOs are not matching to our …Sreeram Tadepalli 293 views 4 comments 0 points Most recent by Sreeram Tadepalli Reporting & Analytics for Fusion Service
- 
             Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se… Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
- 
             How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end…Jared Custer 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end…Jared Custer 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany
- 
             How do we achieve this calculation to be implemented in FDI/OAC classic Report.Hi Team, There is this caculation requirement in P&L report. Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report. For ex…Rasagna Repaka-Oracle 12 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service How do we achieve this calculation to be implemented in FDI/OAC classic Report.Hi Team, There is this caculation requirement in P&L report. Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report. For ex…Rasagna Repaka-Oracle 12 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle FDII have enabled the preview feature EPM Planning and Budgeting Data Export I have successfully created and tested connection to the EPM source. I cannot successfully crea…tismithhuron 27 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle FDII have enabled the preview feature EPM Planning and Budgeting Data Export I have successfully created and tested connection to the EPM source. I cannot successfully crea…tismithhuron 27 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
- 
             How to fetch FA Approval details with BPM Worklist Task NumberHow to fetch Fa_Mass_Transactions and other FA additions,retirements,adjustment and transfer tables FA Approval details with BPM Worklist Task Number for Mass Transactio… How to fetch FA Approval details with BPM Worklist Task NumberHow to fetch Fa_Mass_Transactions and other FA additions,retirements,adjustment and transfer tables FA Approval details with BPM Worklist Task Number for Mass Transactio…
- 
             OTBI Subject Area: Fixed Assets - Asset Depreciation Real Time data mismatchIn UI, Asset's Initial units were 100, And 66 units were partially retired and then Transferred out on Oct-24. So the current active units are 34 and the Depreciation Re…Vairasundar_1997-Oracle 2 views 0 comments 0 points Started by Vairasundar_1997-Oracle Reporting and Analytics for ERP OTBI Subject Area: Fixed Assets - Asset Depreciation Real Time data mismatchIn UI, Asset's Initial units were 100, And 66 units were partially retired and then Transferred out on Oct-24. So the current active units are 34 and the Depreciation Re…Vairasundar_1997-Oracle 2 views 0 comments 0 points Started by Vairasundar_1997-Oracle Reporting and Analytics for ERP
- 
             BI publisher parameter bugHi, My colleagues and I have been experiencing a bug where some of the parameter list of values don't work when selected, we know they do when we try to schedule the rep… BI publisher parameter bugHi, My colleagues and I have been experiencing a bug where some of the parameter list of values don't work when selected, we know they do when we try to schedule the rep…
- 
             Oracle Fusion Cloud Database Schema Export for AI contextI am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can prov…Grant Abbondanza 29 views 1 comment 2 points Most recent by Andrew Townes BI Publisher Learning Center Oracle Fusion Cloud Database Schema Export for AI contextI am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can prov…Grant Abbondanza 29 views 1 comment 2 points Most recent by Andrew Townes BI Publisher Learning Center
- 
             Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 41 views 5 comments 0 points Most recent by User_26T18 Reporting and Analytics for ERP Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 41 views 5 comments 0 points Most recent by User_26T18 Reporting and Analytics for ERP
- 
             Assistance Required to Identify Root Cause of Number Format Issue in Custom RTF TemplatesHi Team, We’re experiencing an issue with custom RTF templates where a predefined number format behaves inconsistently—working correctly for some users, but displaying i…Baswanth Kumar Reddy-Oracle 1 view 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Assistance Required to Identify Root Cause of Number Format Issue in Custom RTF TemplatesHi Team, We’re experiencing an issue with custom RTF templates where a predefined number format behaves inconsistently—working correctly for some users, but displaying i…Baswanth Kumar Reddy-Oracle 1 view 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Can we create event base value set?At customer site level user have enabled one DFF value for SALESREP_ID which display LOV of all the SALESREP email ids through one value set. Now they are asking if we c…Nishat2402 3 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Can we create event base value set?At customer site level user have enabled one DFF value for SALESREP_ID which display LOV of all the SALESREP email ids through one value set. Now they are asking if we c…Nishat2402 3 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             how to display the date set in the user preference date format in BIP reportUser has set date format in Oracle fusion "General Preferences: Regional" settings. The requirement is to print the date in excel output as per that setting. The setting…Munish Kumar Mittal-Oracle 22 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service how to display the date set in the user preference date format in BIP reportUser has set date format in Oracle fusion "General Preferences: Regional" settings. The requirement is to print the date in excel output as per that setting. The setting…Munish Kumar Mittal-Oracle 22 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Financial Reporting Oracle Fusion not able to view sum of Balance amountI have created a report in FRS studio, i can view all the data every time. But same report is run by any other user, they can only see left column account details. Accou… Financial Reporting Oracle Fusion not able to view sum of Balance amountI have created a report in FRS studio, i can view all the data every time. But same report is run by any other user, they can only see left column account details. Accou…
- 
             Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Unable to add security permissions for HCM seeded report folderWe need to give customized access to seeded HCM report folders in the Reports and Analytics page but unable to edit security permissions for the same. We have copied the… Unable to add security permissions for HCM seeded report folderWe need to give customized access to seeded HCM report folders in the Reports and Analytics page but unable to edit security permissions for the same. We have copied the…
- 
             Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…Sri Sai Kiran Tekumudi 21 views 0 comments 0 points Started by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…Sri Sai Kiran Tekumudi 21 views 0 comments 0 points Started by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP