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- 28 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting & Analytics for Fusion Service -
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?
-
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 20 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 17 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…
-
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 18 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.3K 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…
-
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 13 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 242 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…
-
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 10 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 16 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 25 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…
-
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 7 views 0 comments 0 points Started by Vairasundar_1997-Oracle Reporting and Analytics for ERP
-
Facing Error while generating Fixed Assets Data in OTBIHello, We have around 30 Asset Books, For my user all the Asset Book access given. I'm trying to do an analysis in OTBI by using the Fixed Assets Depreciation Real Time …
-
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 25 views 1 comment 1 point Most recent by Andrew Townes BI Publisher Learning Center
-
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…
-
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 3 views 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 8 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 25 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…
-
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…
-
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
-
Dynamic Deep Link URL in BI Publisher Report not workingSummary: I have a RTF template that shows details of AR Invoices. I have inserted a link on Invoice Number to take the user to the transaction in the application using D…