OTBI
Discussion List
-
Oracle BI Catalog ReorganizationWe are planning a reorganisation of the Oracle BI Catalog folder structures and will much appreciate knowing about any standard processes or best practices that are in p…ks1075 11 views 2 comments 1 point Most recent by Clare Murtagh Reporting & Analytics for Fusion Service -
how to display latest message in reportSummary: We are building a Service Request Dashboard , in that want to display the messages also. When we combine the SR subject Area and SR Messages Subject are , it is…Anusha716 21 views 1 comment 0 points Most recent by Clare Murtagh Reporting & Analytics for Fusion Service
-
How to setup a Canada Tax Rule for AP invoices only HST for New Brunswick (NB) Supplier Address?Summary: How to setup a Canada Tax Rule for Manual AP invoices only HST for New Brunswick (NB) ? Content (please ensure you mask any confidential information): Hello We …
-
OTBI scheduling agentsCan we use agents to deliver a url to prompt user to log into the system? We have reports which need to be delivered to recipients with varying AORs. e.g. JML for staff …Clare Murtagh 11 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 812 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can i find the workOrder Approval report which is to be releasedSummary: where can i identify the below attached notification report Content (please ensure you mask any confidential information): Version (include the version you are …
-
Can we edit fonts on OTBI Analysis Reports?Hi, We are reviewing our OTBI suit and wanted to know whether it is an option to change the font to meet business guidelines - is this a possibility? Thanks! Katie
-
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work…Vibha Pandey - Oracle 366 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM
-
which subject area contains the name column of transaction console of oracle hcmSummary: which subject area contains the name column of transaction console of oracle hcmContent (please ensure you mask any confidential information): Version (include …Sneha815353 51 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
How To Use SQL To Return Audit Of Supplier Bank Account Changes ?Summary: How To Use SQL To Return Audit Of Supplier Bank Account Changes ? Content (please ensure you mask any confidential information): Hello We have enabled the Suppl…Cesar Saveedra 301 views 2 comments 0 points Most recent by User_25PXG Payables, Payments & Cash Management
-
Total Compensation Statement - AnalyticsSummary: Hi All, We have completed generating the Total Compensation Statements for our employees. However; we would like to know if is there any way to get the analytic…Santhosh Bachu 12 views 2 comments 0 points Most recent by Santhosh Bachu Reporting and Analytics for HCM -
how to make goals dashboard embedded on the goals screen in fusion to take parameters from the goalsCustomer has created OTBI Analysis report based on the Workforce Goals - Goal Status Overview Real Time subject area. A graph has been created based on this analysis. Th…ElTawil 52 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting & Analytics for Fusion Service
-
Validate employee and Manager hierarchy analysis - How to write?Summary: I am trying to write an analysis in OTBI which would provide an output of Employee and a Managers Level 2,3,4,5 Department. The aim of the analysis is to use as…Scott_Turner_ 32 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM -
If the learner has course which is not being completed and it is being assigned manuallySummary: If the learner has course which is not being completed, and it is being assigned manually from Learning Assignment or Learning Initiative, If the same course is…
-
What is the best way to prepare a consolidated Trial Balance of two business Units?Summary: What is the best way to prepare a consolidated Trial Balance of two business Units? Content (please ensure you mask any confidential information): There are man…Kirtee Jeetah-Naran 31 views 3 comments 0 points Most recent by Kirtee Jeetah-Naran Reporting and Analytics for ERP
-
Need to allow holds resolution routing for system invoice Hold codeSummary Need to allow holds resolution routing for system invoice Hold codeContent Hi, For our user case, we need to allow holds resolution routing for system invoice Ho…Mohamed jouini 254 views 4 comments 1 point Most recent by AmitGoel Payables, Payments & Cash Management
-
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
During which process the Unit cost will get updated in the Costing back end tableSummary: Hello Oracle Experts! Recently we faced an issue in fetching the Unit cost from the back end costing table. When we do an Intransit receipt for a particular ite…
-
We cannot download PO Pdf for all POs in Bulk. How can we download all POs pdf in one shotSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23D Code Snippet (add any code snippe…
-
Is there a subject area with the "Allow Offset Taxes" field?Summary: We need to build a report that presents the "Allow Offset Taxes" information. Is there any subject area that has this information? Content (please ensure you ma… -
How to fetch only One record for Expected Effort in OTBI Learning Subject AreaSummary: Hi Team, I'm trying to fetch the employee who has having max number of hours in the OTBI report. I can fetch the Sum of hours for each employee individually but…
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
How to limit values prompt values when using choice list values from SQL ResultsSummary How to limit values prompt values when using choice list values from SQL ResultsContent Hi All, In a dashboard Prompt we are using column prompts we want to limi…
-
Unable to see 'Costing - Inventory Valuation Real Time' under OTBI subject areaSummary: I am unable to see 'Costing - Inventory Valuation Real Time' under OTBI subject area. Here is the document I am referring to. I do have Cost Accountant role tha…