OTBI
Discussion List
-
Adding Count in OTBI which Uses Custom Logical SQL QuerySummary: I have created OTBI Report using Logical SQL Query using multiple table Subject areas and Outer Joins , Need to add Report Data Count in the report . Is there a… -
OTBI Redwood Receiving CommentsWe have a requirement from users that they be able to see comments on RSSP Redwood Receipts (formerly before 24D in Notes). We are attempting to create am OTBI report wh…
-
What is the subject area of Project Definition DFF on OTBI on Projects module?Summary: We cannot find Project Definition DFF on OTBI. What is the subject area of this attribute on Projects module. DFF is BI enabled, we run "Import Oracle Fusion Da…
-
Trouble Querying For PO Delegation DetailsI am trying to query for delegation details of a PO. Currently only able to query for the approver name for each PO, but cant seem to join delegations table to properly …
-
Join XCC_BALANCES with PO tablesContent Hi all, I need to retrieve the budget available amount (see screenshot below) I found the amounts in the table XCC_BALANCES. But I can't find a way to join it wi…
-
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 51 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service
-
I need to return the latest component subinventory and locator in a work definition in an OTBI queryI'm looking to extract out the the latest version of a work definitions, the components within a work definition and the subinventory and locators. I curently have an OT…
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 1 view 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Reporting/Managing on Goal Plan EligibilitySummary Can goal plan eligibility be managed like Performance documents can?Content I've been searching the forums but haven't found a clear answer. I have a lot of ques… -
Generate Employment Letter from Employee Self ServiceSummary: Hello Experts, We have a requirement to develop the Employment Letter from the system from the employee self service. We have checked in the delivered Document …Jaydeep.More 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HR Action / Termination Action in Manage Work RelationshipSummary HR Action / Termination Action in Manage Work RelationshipContent Hi - We are trying to move all of our BI Publisher reports to Analysis and encountered an issue…Roy Paolo Paunlagui 197 views 13 comments 1 point Most recent by Anjaneyulu Reporting and Analytics for HCM
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 121 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 212 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se…
-
How to Reprice the Sales Orders after Pick ReleaseSummary: How to Reprice the Sales Orders after Pick Release Content (please ensure you mask any confidential information): We have a requirement to reprice the Sales Ord…
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Hi All can anyone help me to print these columns item and description in my transaction report.Summary: Please help me to print these columns in my transaction detail report please provide sql or tables where i can find these columns data. These are present under …
-
Any OTBI Report/table to get Multiperiod Accounting Transactions AHCSDo we have any tables or oracle Reports BI or OTBI to get the list of Multiperiod transactions posted and future transactions other than table XLA_MPA_DISTRIBUTIONS.Chetan007 2 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
OTBI Report (Dashboard) Security Not Mirroring FusionContent My understanding of the OTBI security is that security applied in Fusion will also be applied when running reports. You'll see the same data. However, if additio…Rebecca L Smith 66 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 31 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 201 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre…Sakthi priyanka B-Oracle 251 views 3 comments 1 point Most recent by GPOtimization Reporting and Analytics for HCM
-
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 101 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to clear Data in Budgetary Control Application before loading data from EPM PlanningSummary How to clear Data in Budgetary Control Application before loading data from EPM PlanningContent We are running into an issue, we have pushed Budget data from Ora…
-
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM…
-
OTBI Report is working very slow when fetching the Assessment DetailsSummary: Hi Team, I am currently working on developing reports in OTBI, but I am encountering significant performance issues. The reports are taking an unusually long ti…