-
SQL query for Review Cost Accounting Distributions information tab details in detail
Hi Support, SQL query for Cost information tab details in detail Review Cost Accounting Distributions - Could anyone help me to get the SQL query to get cost component wise amount. SQL query for Cost information tab details in detail CST_LAYER_COSTS - Table hold amount in summary level not in detail. Please provide the sql…
-
SQL query for Review Cost Accounting Distributions information tab details in detail
Hi Support, SQL query for Cost information tab details in detail Review Cost Accounting Distributions - Could anyone help me to get the SQL query to get cost component wise amount. SQL query for Cost information tab details in detail CST_LAYER_COSTS - Table hold amount in summary level not in detail. Please provide the sql…
-
OTBI analyses on shipping Real Time Subject Area does not display correct Fulfillment line
For split lines Fulfillment details are not cauputed correctly. Currently only Shipment lines are captured based on the Shipment Id. On the SR raised SR 3-36563504801, I was informed that it was verified during OWC, It's kind of requirement. Summary: ======== 1.Customer using OTBI reports for shipping Real Time Subject…
-
Credit Memo Template
Our user requested to edit the quantity amount in the Credit Memo template into 2 decimal place. How can I make the Quantity Shipped data into 2 decimal place? Thank you!
-
EKMT3FK5: Error Message After Pivot Column In OTBI
We need to pivot column 'Balance Name' in Subject Area Payroll - Payroll Balances Real Time but this error message below: After several tests, seems like pivot table won't accept result more than 500 records? I'm wondering how to increase this limitation. Thank you, Yiming
-
Project receivable invoices payment status
Is there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the manage project invoices area in Project Execution management , it already tracks the Payment Status , so I need to know if there's any subject area or…
-
Query to fetch employee's eligibilty for performance document.
Hi, I want to create a report of eligibility of all performance document for all employees available in system but currently I can only fetch data for any one user in OTBI. Thank you
-
EKMT3FK5: Error Message of Pivot table
-
OTBI Formula/SQL solution
Hi, Wondering if someone can help my colleagues and I out, we have an issue with our date range on our Absence by Directorate report. We have a SQL statement that would work in BI Publisher but were wondering if it's possible to recreate this in OTBI. SELECT *FROM absences WHERE start_date <= TO_DATE('2024-06-30',…
-
OTBI conditional count
Hello, My problem is the following: I would like to have a customized metric with that counts the number of learners that have "General Information"."Enrollment Record Substatus Code" <> 'ORA_ASSN_REC_NOTSTARTED' AND "General Information"."Enrollment Record Status Code" = 'ORA_ASSN_REC_ACTIVE' (counting everything less a…
-
OTBI conditional count
Hello, My problem is the following: I would like to have a customized metric with that counts the number of learners that have "General Information"."Enrollment Record Substatus Code" <> 'ORA_ASSN_REC_NOTSTARTED' AND "General Information"."Enrollment Record Status Code" = 'ORA_ASSN_REC_ACTIVE' (counting everything less a…
-
Need sample SQL to extract all reports in Fusion BI/OTBI reports along with permissions.
We would like to get help in sample sql to create a report in non-prod environment that extracts all the existing reports including Custom and Seeded ones and permissions associated to those reports.
-
OTBI Generating Multiple Rows Per Employee, How to Compress to One Row?
I am trying to report on the Talent Profile and it looks like each section of the profile creates a row per employee. How do I compress this into one?
-
Libro Giornale
Summary What report are people using for the Libro Giornale? Content I have a requirement from our Italian Office that they require a report called the 'Libro Giornale' Italian report required by law - Libro Giornale We need to be able to export a report from the system that is required by Italian law called the Libro…
-
How to export Price List by OTBI report?
Dear Oracle Comunity members, I would like to ask the method to export Price List of item in Oracle Can I use OTBI report? If yes, which data set should I choose? Thank you
-
Can we restricted Report data on a users basis?
Dear , We need to restrict reports data to a user base. Some user see all data which have been in report and some users see only his data. How can we do this . we need to gave access only for reports Thanks
-
Does BIPublisherDesktop64.exe (version 12.2.1.) support silent install?
I need to install BI Publisher Desktop through Microsoft inTune which require a silent install command. I have tried these silent install switches /S /v/qn which failed.
-
How do I add Target Attributes to the Import Objects field to conduct an upload to update address?
I need to upload address changes. I went to Tools> Import Management> Import Objects I only see three Import Object Details, and when I click through them, I don't see any of the Address Line # Attributes. It appears I need to add each address line attribute, but I'm unsure of the specific steps to start. I have done many…
-
How to find the information of different view objects using same table
Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spreadsheet showed below VOs: FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVO FscmTopModelAM.FinGlJrnlEntriesAM.JournalLineExtractPVO…
-
OTBI Report
is there any report for the showing the employee with missing personal information like address missing , pin code missing , department missng
-
Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.
-
OTBI Report Using Learning Records Real Time and Worker Assignment Real Time
Has anyone been able to successfully build a report combining data from Workforce Learning - Learning Records Real Time and Workforce Management - Worker Assignment Real Time? I have tried including several different metrics to get the relationship to work but have been unsuccessful. I have a report request that needs data…
-
Cross Subject Area join between Checklists and Helpdesk Request Subject Areas
There are Checklists created for certain Helpdesk Service requests. We need the data from both checklist and helpdesk on an OTBI Analysis cum Dashboard. Is it possible? Can we join Helpdesk Requests Summary Real Time with Checklists Real Time subject area. We need the Service Request details along with the checklist…
-
Performer of the Action Plan [Talent management] information in BI publisher tables
I'm looking for this information in the bi Publisher tables: I looked through its tables: HRT_TASK_USERS, HRT_TASKS, HRT_TASK_OBJ_RELATIONS, but I didn't find it, do you know where this information is located in the oracle tables? thank you in advance Sincerely
-
My approved AP invoices OTBI Analysis
How do I default in an OTBI Analysis invoice approver to be the User running the report? Or at least have in the Approver drop down list a single available value: my name (the name of the user running the report/logged in) ? Thank you !
-
Employer Insurance Cost
Hello! I am trying to pull a report of insurance cost to the employer per pay per month for a specific business unit. I have several fields pulled into the report but the Amount measure isn't giving me any results. I very well could be using the wrong SA/Measure. Any thoughts? Cody
-
MAX EMAIL ADDRESS in one row
How to display in one row the Work email (if exists) or home email if the work email is null? this function does not work MAX(CASE WHEN "Person Email Addresses"."Email Type Code"='W1' THEN "Person Email Addresses"."Email Address" WHEN "Person Email Addresses"."Email Type Code"='H1' THEN "Person Email Addresses"."Email…
-
Filtering OTBI report off of the current system date?
I am building a report that pulls counts of total Development goals from "Workforce Career Development - Development Goal Overview Real Time." Looking to filter the population by both the "Start Date" column, and "Target Completion Date" column both found in the Development Goals Folder. I would like it to be "Is less than…
-
Migrated 3 custom AR reports, 1 returning an error (All has DFFs)
I have migrated 3 AR OTBI reports from one instance to another and earlier I was not able to find those DFFs in OTBI though it was configured but post running the program 'Import Oracle Fusion Data Extensions for Transactional Business Intelligence', it was reflecting correctly. Now, when I run the three reports, 2 works…
-
Disable More > Export/Print of an OTBI Report
Client requested if there's a way to disable the option to export/print the OTBI Analysis from the Catalog's view. They only want to keep the option to open and run the analysis first, before user can choose the option to export.
