OTBI
Discussion List
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…Naga Varma 185 views 6 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for SCM -
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
How can I export procurement contract rules?Summary: I need a SQL query to export procurement contract rules Content (please ensure you mask any confidential information): Version (include the version you are usin…
-
What are the tables to view the Invoice Account Coding ID 2507811.1Summary: Which fusion table will have information of Initiate Account Coding, to write a SQL query Content (please ensure you mask any confidential information): Initiat…Ravi Kumar N 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Billing Dashboard OTBI AnalysisSummary: Can one of you share the OTBI Analysis shown in screenshots in new feature (23B) documentation (link below) ? Content (please ensure you mask any confidential i… -
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 582 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
R13 How to generate a Trial Balance from OTBISummary R13 How to generate a Trial Balance from OTBIContent Hello : I was wondering if you can share with me any document how to create a trial Balance from OTBI . As f…gabriel kinovisques-163562 138 views 3 comments 3 points Most recent by TBIRD1 General Ledger & Intercompany
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…KDR 297 views 6 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Can conditional formatting be applied to the total cell in BIP pivot layout?Summary: Can conditional formatting be applied to the total cell in BIP pivot layout? Content (please ensure you mask any confidential information): Hi Experts, I could …Volodymyr Faranosov 1 view 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Chart of Accounts Hierarchy Sort Order Field NameSummary: I'm building a custom BIP data model and report and I'm looking for the User-Defined hierarchy Sort Order field name info (table, field) schema = FUSION Content…Emile Helegbe 51 views 3 comments 0 points Most recent by Emile Helegbe General Ledger & Intercompany
-
People Group Segments Subject AreaSummary People Group Segments Subject AreaContent Hi All, In which subject Area I can find assignment people group segments while creating analysis ? Thanks.
-
Unable to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (please ensure you mask any confidential information): The…Sudhir Behera 11 views 1 comment 0 points Most recent by Yann Consolin-Oracle Supply Chain Planning and Collaboration -
The supervisor hierarchy should be displayed in the report as a graphical representation.Summary: The supervisor hierarchy should be displayed in the report as a graphical representation. Content (please ensure you mask any confidential information): Require…
-
Dashboard prompt dependentSummary: Creation of a Dashboard prompt with Job Family, Job Function and Job Profile field dependent from each other. Content (please ensure you mask any confidential i… -
Remove Null value from Dependent LOV prompt in OTBISummary: When we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL param…
-
Using SET VARIABLE PARAM_EFFECTIVE_DATESummary I'm trying to default the "SET VARIABLE PARAM_EFFECTIVE_DATE=" back 3 daysContent I'm trying to set the "SET VARIABLE PARAM_EFFECTIVE_DATE=" prefix. I want to us…Chris Campbell 1.1K views 7 comments 0 points Most recent by Bharat Mandloi Reporting and Analytics for HCM
-
Prompt filtering based on another promptSummary: Hi, I have 2 prompts as presentation variables and I need them to connect between each other. For example when I selected a specific country on the first filter…
-
Has anyone created a custom role for staff outside of HR to access other staff addresses?Summary: Content (please ensure you mask any confidential information): I am still figuring out how to create custom job roles for HCM, but I am hoping someone that has …
-
Issue in adding Ethnicity Column.Summary: Hi All, I have an OTBI report that tends to fetch all the performance details of an employee, we are trying to add ethnicity column in the report with formula: …Sushant95-Oracle 11 views 0 comments 0 points Started by Sushant95-Oracle Reporting and Analytics for HCM
-
Need inputs to handle NULL values in OTBISummary: Need inputs to handle NULL values in OTBI Content (required): In case if an employee doesn't have Visa permit record then we are getting value as 00--0 in the O…
-
OTBI Report - Advanced Query - presentation variable is null, how to handle?Summary: In OTBI Report, I have used Advanced Query to combine multiple subject areas. As a parameter I'm using presentation variable. If the presentation variable is pa…
-
Reports on Generative AI Usage and AuditsSummary: Reports to get data on Generative AI Usages and feedback. We are implementing Gen AI for feedback generation but need reports to understand GenAI feedback and U…
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…Ian.Gooderham 21 views 7 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
while creating the custom roles, getting unwanted subject areas in analysisSummary: Hello Experts, Our client has a requirement to create a custom role for restricted access to business users. While doing so, we could see in reports and analyti…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to give Unarchive option in Custom folder which is read only for a user in BI Catalog?Summary: We have a custom role which gives read only access to the Shared Folders > Custom folder. We also want to provide Unarchive access under the Custom folder. The …Bishal Dutta 45 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi…Abhilash K - Deloitte USI 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Procurement - reporting purchase order paid amountsSummary: Reporting on PO/PO line payment amounts Content (required): Hi, we have a financial audit requirement to be able to report PO/PO order lines to payment amounts …
-
FTP Files of BI Publisher Report Via Bursting > Defining The Bursting QuerySummary: FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query Content (required): Hello All, We would like to send a report generated in CSV forma…