OTBI
Discussion List
-
Subject area to pull checklist questionnaire in OTBISummary: We are trying to develop reports on questionnaires that have been configured for checklist. But when we are using "Workforce Management - Checklist Real Time", …Priyanka Ray 61 views 4 comments 0 points Most recent by Priyanka Ray Reporting and Analytics for HCM -
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can … -
How to change currency code language in Manage Project Budget?In manage project budget page, under Overview option, budget amount is showing in Arabic currency instead of English (as SAR). Please guide me how to change the currency…
-
How to apply "Group By" Condition on a column - in OTBI Analyis?Content Hello Everyone, I have a requirement to apply "Group By" condition on OTBI analysis. I am applying this condition in under Advanced tab - Advanced SQL Clauses. B…Anil Pillaresetty 901 views 6 comments 1 point Most recent by gclampitt Reporting and Analytics for HCM -
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 201 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
report otbi general balances real time with hierarchieshow can i create a report balances with hierarchies in subject area? i can t see hierarchy
-
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma…Smitashree Pradhan 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to auto-increment the accounting period on Trial balance report in BIPSummary: We have General Ledger Trial Balance in BIP and every month, end user needs to change the accounting period. Is there a way to auto-increment the accounting per…TBIRD1 12 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Supplier PO Acknowledgment email customizationWe have implemented Supplier PO Acknowledgment email notifications via the BPM Worklist Task (DocumentAcknowledgmentRequestForAction). This task works as expected, but w…
-
Custom OTBI report under "Open Table, Graph or Tile Set"Summary: Need the ability to view a custom OTBI report under "Open Table, Graph or Tile Set" Content (please ensure you mask any confidential information): I can see the…starsniper_11 12 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
"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 184 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 541 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 253 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 52 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 12 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 …