-
Is it possible get the query for oracle.apps.financials.payables.shared.publicView.ReportsPayeePVO
Hi, I would thank for any help to know how to get the query below ESS job LIST OF VALUES (not by hand, or googling). Examples: or oracle.apps.financials.payables.shared.publicView.ReportsPayeePVO I would like to know some "automagic" way,. Note: BICC vo's have been already investigated, this PVOs are not in BICC view…
-
Find Performer of the action plan on 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
-
How to return only the max ID grouped by selected column (SQL)?
I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for using this method is specific to the type of report I am working to build, which is joining information from a pending worker relationship (worker assignment real time) with the allocated checklist table (checklist real time).…
-
Workers with Active Profiles
Hi, We can see a column Count of Profiles in Workforce Profiles – Person Profile Real Time having values 1 and 0. What exactly oracle is considering for giving 0 and 1 for workers. Workers with active profiles is having count of profiles =1 . How we can confirm this in FA side. Please clarify . Regards, Hitha
-
OTBI Reporting for Personal Corporate Card Transactions
I need to build an OTBI report that shows all corporate card transactions that have been identified as "Classify as Personal". How can I do this?
-
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?
I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manager is HR, they should not have operations employees in the hierarchy. So I need to see the job family for the top level manager as well as the employee below, and…
-
We are not able to find the field 'Default Expense Account' which is available in Assignment Details
We are not able to find the field 'Default Expense Account' which is available in Assignment Details. we have tried PVO 'HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentPVO' and found ID column here. but, we are looking for string which is GL code combination so that we can get into FAW subject areas
-
BIP Report with Custom Font
Hi can some please share steps to implement a BIP Docx report using custom fonts. Customer uses a custom font (Lusail) and want to create a report with Lusail Font.
-
Scheduled OTBI Reports Missing Records
We have a couple of OTBI Scheduled jobs that run monthly. We're not sure why, but when two of the scheduled agents run they are missing records. Example: One of the scheduled jobs produced 304 records. When we ran the report manually it returned 623 records. Has anyone else encountered this issue? Do you have any…
-
Project Number for Payables Invoices in Journals
Good Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - General Ledger - Journals Real Time - Subledger Accounting - Journals Real Time - Payables Invoices - Transactions Real Time I tried using Project Number…
-
Deep Links (23B) the complete overview (all of them)
We all know that you can create Deep Links from your OTBI / BI Publisher (incl notifications), otherwise check here Creating Analyses and Dashboards in Oracle Transactional Business Intelligence There's a kind of (a not very informative) overview in the 'Deep links' page in Fusion Apps (under Tools) I composed attached…
-
Can you share a KPI via agent directly as html to an email? (FUSION OTBI)
We created a dashboard that has kpis (inside kpi watchlist) and it looks fine via web. However when we create an agent to send it directly to execs emails (as HTML) everything shows except the kpi watchlist. Is there a way to go around it?
-
How to track the last run details of the OTBI report?
Need to find the Last Run details of the OTBI report user wise.
-
How to make prompts optional in Logical SQL based OTBI analysis
Hi Experts, We are trying to build OTBI analysis using logical SQL approach and there are few prompts required which are not a part of Select statement so we are trying to add the prompts in the SQL. When trying to access the same, if we pass the prompt value then it is returning the output for the prompt selected, but…
-
Comma separated value input in presentation variable - OTBI report Issue
Hello Team, We have a requirement to have a comma separated order numbers as an input variable and have data filter criteria driven by this input to help them manage Order backlog. We are currently utilizing presentation variable and adding below SQL criteria to implement this requirement, but facing issues during report…
-
Channel Details from "User System Usage" subject area not returning any value in OTBI Analysis
Hi, Please suggest a solution to see the Channel Details from "User System Usage" subject area in my OTBI Analysis Report. After adding "User System Usage"."Channel"."Channel Name" in the criteria, it is returning null value. Please share the information, if anyone worked on the same requirement.
-
Fusion Applications BIP SOAP webservice calls - Other authentication options needed
Fusion Applications BIP SOAP webservice calls - Other authentication options needed: Please share any other authentication mechanism available other than Basic authentication. If yes, please share additional documentation. Please share any best way to BIP SOAP webservices other than basic.
-
Getting Users Assets information from Oracle Fusion
Hello, We have an assets report that show the IT assets assigned to each user in the organization. This report was developed from Oracle E-business on premise version. Recently, we migrated from Oracle E-business to Oracle Fusion and need to update or create a new report from Oracle Fusion. The E-business report output is…
-
Why user with only Employee role can see OTBI report and share the same permission as BI Consumer
As we are assigning user roles and trying to limit their access to certain reports using the OTBI permission, noticed that a user who only assigned with "employee" role (or the customized role copy based on the default employee role) can see OTBI report if the report was set to be read or higher permission with the "BI…
-
How to add DFF from customer account to standard Receivables Create Transaction page using Sandbox?
Hello, We have added several DFFs on the customer account level. Customer would like to see one of them on the invoice header. I started to follow community link below (Enabling Oracle Fusion BIP report output on Fusion Standard Page by using Dashboard) :…
-
OTBI Subject area new cogs and Gross margin real time cogs -present un-recognized while recognized
Hi, i have created report based on subject area "new cogs and Gross margin real time" and i found sale order which was fully recognized while in the report is null , in addition the "revenue recognition" amount is the bill amount and not the recognized amount which done in the RMCS. Could you please advice?
-
recruiting - recruiting event real time
Hello Expert, I need your help. recruiting - recruiting real time recruiting - recruiting event real time I'm using above mentioned two subject areas to get the recruiting details. I wanted to get posting details. Like Internal Career Sites, External Career Sites, LinkedIn, etc. "Recruiting - Recruiting Real Time"."Source…
-
HR_LOCATIONS_ALL is not availbel in BICC View Objcet List
HI Team, HR_LOCATIONS_ALL table is not availbel in BICC View Objcet List, Please sugect to me how to extract the HR_LOCATIONS_ALL Table Data in BICC?
-
Workforce Compensation Plan - Submit for Approval Comment field missing?
On the Workforce Compensation Plan landing page, how to we turn on the Comment field in the 'Submit for Approval' popup? We had it last year and now its gone. Not seeing it anywhere in the configuration.
-
OTBI dashboard prompt daily rate
Hi, I am trying to create prompt "presentation variable" and insert under "default selection" the below SQL which should return the Rate amount (in BIP i can see the value) ,but after insert the SQL to the prompt i didn't get any value , please advice? SQL: select gd.conversion_rate from gl_daily_rates gd where…
-
Candidate Source Tracking
HCM does not appear to have full UTM functionality available. UTM Medium & UTM Source are the only parameters that seem to be available in our environment. What options are available to track specific campaigns, media types, etc?
-
OTBI AP ACCRUAL REPORT
hi, AP ACCRUAL is based on 2 different areas "Payables" and "receipt accounting." , can i create the report by cross-subject area report (not union) ? I will be happy to get an example via a Copy of SQL (copy from the advance tab in the report).
-
OTBI DAILY RATE CONVERSION TABLE
Hi all, I didn't find a subject area for the "DAILY CONVERSION RATE TABLE" . In my report, I want to create a calculated field that translates the "AR invoice amount" from EUR to USD based on the closing rate. Could someone help me?
-
OTBI anlysis results from diemensions withinn the same subject area aren't matching
We have a specific report that retrives the person demographic information. We are referring to the "Workforce Management – Person Real Time" under which the information entered in the demographic info section of Personal Details page of UI is divided into different dimensions. However, when add the respetctive columns to…
-
I need to generate .xlsx template with xml mapping through HCM Extract.
we need to generate .xlsx template with xml mapping through HCM Extract. Here We are using HCM Extract to get the data and required .xlsx Template with xml mapping. We need to get the XML/ XML Schema (XML Schema Defination) in the Source tab of the Excel template. Is Anyone knows the answer how would I get my required…
