Category 385
Discussion List
-
Report for ET Final Payout with 403b deductionWe've been asked by auditors for a report of all terminated employees in 2024 that were paid out 'Earned Time Final Payout' and what was deducted for 403b in those paych…Greg Aulson 7 views 1 comment 0 points Most recent by Tiff Dickson-Oracle Reporting and Analytics for HCM -
Embed new UAE dirham currency symbol in oracle query or PDF reports (Fusion BI Publisher)Dear All, we need to embed the new UAE dirham currency symbol in all our report outputs. So far what we know is no Unicode or AASCI character is available for the same. …
-
What is the Vacation Delegation Table in fusionWhat is the Vacation Delegation Table in fusion and what is different between FA_FUSION_SOAINFRA.WFUserVacation and PER_DELEGATED_ROLES I am encountering an error (ORA-0…Mohamed Shaaban 14 views 2 comments 1 point Most recent by Mohamed Shaaban Fusion Applications Administration
-
We need PVO's for the following tables in BICC but we couldn't find these in Lineage Sheet.Summary: We need PVO's for the following tables in BICC but we couldn't find these in Lineage Sheet. CMP_RANGE_DIFF_VALUES_F CMP_RANGE_DIFFS_F_TL Can you please help me …Janardhana Kondaveeti 5 views 0 comments 0 points Started by Janardhana Kondaveeti Reporting and Analytics for HCM -
Where can I configure the Reporting Context parameter?The user is about to generate the "Receivables Aging by General Ledger Account Report" and in the process details there are no values to be selected in "Reporting Contex…Joyce Gutierrez 3 views 0 comments 0 points Started by Joyce Gutierrez Reporting and Analytics for ERP
-
Audit Data for Custom Fields on Service RequestsHi, we currently have the following query: SELECT DISTINCT SR.SR_NUMBER, CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE, OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDE…Martina Di Battista 1 view 2 comments 0 points Most recent by Martina Di Battista Reporting & Analytics for Fusion Service
-
OTBI display duplicates while query don'tHi everyone, We use OTBI to extract some data in Excel to feed an home-made FBDI requisition process. The report included 11 queties, linked by their record_number to ge…Francois Robineau 7 views 1 comment 0 points Most recent by Francois Robineau Reporting and Analytics for ERP
-
How to find user timezone in BIPI am trying to build a query where I can find which user has what timezone assigned to them under profile settings. user_menu>Set Preferences>Regional>Time Zone I found …
-
Oracle fusion FDI in data actions How to provide the authentication for REST APII'm trying to get the invoice attchemnt url in FDI using data actions type HTTP API by call the REST API. but facing an issue to authenticate the REST API. We have enabl… -
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …Nikhil_Samudrala 55 views 4 comments 0 points Most recent by Nikhil_Samudrala Reporting & Analytics for Fusion Service
-
Clarification on Delivery Status Storage in Receivables – AR_BPA_DELIVERY_DETAILS Table BehaviorWe are currently investigating where the delivery status is stored in Oracle Receivables. During our analysis, we identified the table AR_BPA_DELIVERY_DETAILS as a poten…
-
Seeded report for ESS Job/BIP Reports running historyDoes Oracle has any seeded BIP reports or OTBI subject area to see below 1. ESS Jobs History 2. Scheduled BIP Report History
-
FDI create a custom subject area using the PVO'sWe have a requirement to print the AP invoice attachment URL and the attachment file name in the FDI report. Currently ap invoice subject area don't have these attribute…
-
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464…
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …venkat chaladi 21 views 0 comments 0 points Started by venkat chaladi Reporting and Analytics for ERP
-
In case of SCFO context in AR invoice, how to get fullfillment line id?In oracle fusion, I want an sql query to find fullfillment line id in case of Supply Chain Financial Orchestration (SCFO). For DOO we are getting this from interface_lin…ManuYal 11 views 2 comments 0 points Most recent by Victor Martin Supply Chain Planning and Collaboration
-
Feasibility of Using PDF with Embedded Tags Instead of RTF TemplateCan we modify the PDF document to include tags/tokens such as P_SIGNER within the PDF itself and upload it in place of the existing RTF templateAprajita Gokhale 1 view 0 comments 0 points Started by Aprajita Gokhale Reporting and Analytics for ERP
-
how to customize FusionApproveRejectLinksHi, anyone knows how to customize FusionApproveRejectLinks for the approvals? Thanks
-
Issue with Bursting Setup in Print Receivable Transactions – Job Stuck in RetryingHi team, We have a requirement to customize the Import Print Template. As part of this customization, we have updated the template and modified the existing data sets to…
-
Issue with OTBI – General Ledger Journal Real Time DashboardWe are currently experiencing an issue with the OTBI – General Ledger Journal Real Time Dashboard. Specifically, some of the accounting segments are not visible in the d…Kinjal Patel-Oracle 41 views 2 comments 3 points Most recent by User_UMQS3 Reporting & Analytics for Fusion Service
-
OTBI - How to link Learning Management & Learning Records Real TimeHello everyone, I am currently working on an OTBI analysis for specific Learning Items. Most of the required data is available in the Workforce Learning – Learning Manag…
-
Administer Salary Notification template modificationThe approval workflow for administer salary includes - current HRBP-> Second Level Manager -> AROC_COMPENSATION_ROLE EXCEPTION: if the person receiving the salary increa…
-
Query to fetch approvers listWe are trying to customize performance seeded report and trying to fetch the list of approvers/managers who has approved the document. We are trying to get the details f…
-
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 …
-
BICCSummary: Initial synchronization for large tables using BICC Content (please ensure you mask any confidential information): Our implementation involves several large tab…SunilRamankutty 31 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Looking for report listing users and assinged user role with start and end date of role assignmentSummary: Report listing active users and current and past assigned roles Content (please ensure you mask any confidential information): Client is looking for a report th…
-
In Source to Settle InfoletIn some cases, drilling down is not an option (i.e. the pie chart displaying the supply base). I am unable to drill down on the 21%.
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…
-
Join required between exm_expenses and pjc_exp_items_all tablesHow do I join from exm_expenses and pjc_exp_items_all tables in Fusion. Do I need to join through other tables also to get this link? Thanks Scott
-
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