Category 385
Discussion List
-
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…AatifSiddiqui 14 views 1 comment 0 points Most recent by Jeetendra Achary-Oracle Receivables & Collections -
How to remove username as the report owner in the BI Publisher reports.Currently user ABC is owner of /shared folders/custom so most of the content under /shared folders/custom showing ABC as owner. How to remove ABC name as the report owne…Saikumar Konduru 8 views 0 comments 0 points Started by Saikumar Konduru Reporting and Analytics for ERP
-
Does anyone have a BI report query available that extracts data in the 834 ANSI HIPAA format?With template it would be nice to have. -
Customizing Data Model for GL and Subledger Account Analysis Report – Add/Remove ColumnsHi Everyone, Has anyone customized the data model for the General Ledger and Subledger Account Analysis Report in Oracle Cloud ERP? I'm looking to add new columns and po…Pratiksha Sawandkar 9 views 0 comments 0 points Started by Pratiksha Sawandkar Reporting and Analytics for ERP
-
Is there any table that stores user categories and password policy in fusion ERP?Hi, Can I create a BI report where I would be able to fetch the User Categories and Password Policy details in Oracle Fusion. Regards, JahnaviJahnavi Konduru 16 views 4 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre ManagerHi All, I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both: The Notifications table…
-
Unable to burst a BIP report for data model based on web service?I have created a data model based on web service which I have created in OIC(exposed a SOAP based web service). This pulls data from ATP database based on parameters sen…Shikha Charadva 36 views 4 comments 0 points Most recent by Saptadip Datta DXB Reporting & Analytics for Fusion Service
-
Does BICC query returns live data?Using the 'EXTERNAL" keyword, does the following BICC query returns live data from Oracle ERP? or uses an offline extracted source? select distinct TransactionEntitySour…SHAHRAM SALAMI 5 views 0 comments 0 points Started by SHAHRAM SALAMI Reporting and Analytics for ERP
-
Need SQL Query to Extract Seeded and Custom Audit Report DetailsHi Team, I would like to extract details for both seeded and custom audit reports in Oracle Fusion. Specifically, I’m looking for a SQL query that can provide the follow…Karthikeyan s-Oracle 19 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Rest API/SOAP API to check if particular folder exists on analytics catalogHi Team, I am searching for API to check 1.if a particular folder exists on particular path 2.to upload/replace a folder in BIP Please help me out if there are any?Aditi Agrawal2650 3 views 0 comments 0 points Started by Aditi Agrawal2650 Reporting and Analytics for ERP
-
Need to fetch user preferred date format for excel templatesDescription: We need to incorporate the user-preferred date format in Excel reports. Please refer to the attached screenshot of the UI from which the date format needs t…
-
Issue with Retrieving "Workforce Scheduling - Workforce Schedule Real Time" subject area in OTBIHi , We have a client requirement to identify the scheduled number of working days using OTBI. For this purpose, we are utilizing the subject area: Workforce Scheduling …Nithin Nannuri 7 views 0 comments 0 points Started by Nithin Nannuri Reporting and Analytics for HCM
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Nannuri 14 views 2 comments 0 points Most recent by Nithin Nannuri Reporting and Analytics for HCM
-
Need API or Scheduled Process to Submit "Request Time Change" Regularizations in Oracle Fusion HCMWe are currently using the Oracle HCM REST API (/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests) to create time change regularizations for employees. While the…
-
Timecard calculated time SQL report showing unexpected resultsSummary: I have written a SQL query which is intended to show the period of a timecard for a given user, that user's calculated times for that week broken out by expendi…
-
Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Currently if the orientation is changes to 90 degree, it shows like below:Shreya Agarwal-Oracle 7 views 0 comments 0 points Started by Shreya Agarwal-Oracle Reporting and Analytics for ERP
-
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 9 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 19 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 9 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 8 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 56 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…