OTBI
Discussion List
-
how to find organization id(Master or any inventory org) value using OTBI or any other waySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
oracle query for Organization Card/social securityHi, I'm looking for a way to get this information from the following image in an Oracle Fusion queryjesus pacheco ortiz 1 view 0 comments 0 points Started by jesus pacheco ortiz Reporting and Analytics for HCM -
Issue with Incorrect 'Burdened Cost in Provider Ledger Currency' Values while using in OTBI ReportHi Team, I am facing an issue with the 'Burdened Cost in Provider Ledger Currency' column while using the 'Filial Segment Value' column in the "Project Costing - Actual …Karthikeyan s-Oracle 1 view 1 comment 0 points Most recent by Dustin Grabowski-Oracle Project Management -
Customizing Payables Withholding Tax ReportSummary: I am looking to customize the Payables Withholding Tax report by adding another column to it. Whenever the report is moved to a different folder it flags the er… -
USING SUBSTRING IN CASE STATEMENTSummary: Trying to extract Working Hours from ORC Requisition Internal Description using SUBSTRING in a CASE statement Content (please ensure you mask any confidential i…Richard Kemp-Eyre 21 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Should the License Plate Number field be available within the seeded Expenses subject area?Summary: I cannot find the License Plate Number field within the 'Expenses - Transactions Real-Time' subject area. This is a seeded field which can be enabled by using t… -
OTBI learning Report issueSummary: I have imported Learning OTBI report from instance to another In Instance 1 the OTBI report for Learning is working fine Instance 2 OTBI is not fetching any dat… -
No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: Hello, I'm trying to create a learning report showing employee's division, branch, department. I get results I need except from the 3 criteria. I have both HR A… -
Looking for backend Planning column table nameSummary: Hi Team, We are looking for the back table name for below columns Safety_stock_planning_method , Days of Cover and Category_set_name with catalog and descriptio…LOKESH K MI 1 view 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration -
How to rearrange row in OTBI report?Summary: Hello, I need some help. I want to rearrange the performance tasks according to the order below per employee but every time I sort, the entire column sorts. Wor… -
Create OTBI analysis for Procurement Contracts based on Logged In userSummary Want to Create OTBI analysis for Procurement Contracts based on Logged In user Content (please ensure you mask any confidential information): We need to create a… -
Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi… -
New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a… -
How to fetch content ID generated after running the Mass Create Printable Page Performance DocumentsWe are migrating the performance documents form an old fusion environment to a new one since we cannot load the item level ratings we are planning to load print of the e… -
calculated measure by multiplying 2 columnsSummary:multipying revenue amount with ledger amount is giving incorrect results. Content (please ensure you mask any confidential information): project billing revenue … -
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o… -
talent profileSummary: hi, Could I get the pending transaction data (includes items data) which is under approval for employee talent profile. Content (please ensure you mask any conf…User_L2S8E 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Oracle Help desk tables and Queries to develop a reportHi All, I need to develop a custom BI or OTBI report related to the columns below. Please guide me on this Assigned To Assigned to: Email Category Name Channel Name Crea… -
How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report?Summary: Could you please help us on explaining the logic on how Receivables Begin Balance/Non Receivable Begin Balance is calculated in OOTB Receivables to Ledger Recon… -
Person Security Profile not Working in OTBISummary: We have created a Employee custom role and attached a person security profile to employee. Employee can only view his own record in UI. We have created an OTBI …Hassan M. RG 11 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Add Date and Timestamp in OTBI Analysis NarrativeSummary: I did not see this anywhere on the forum, in case anyone else is interested, we preferred to add a timestamp here versus the Title "Started Time" option as this… -
How to duplicate a page in the dashboard?Summary: Hello, how to duplicate a page in the dashboard? I want to copy a page in existing dashboard so I could have the same layout. Thanks! Content (please ensure you… -
Ways to securely send OTBI reports through agents?Summary What are the ways to securely send OTBI reports through agents?Content I think this has been asked a few times in the past, but just wondering what are the ways … -
How to create OTBI for Compliance checklist questions and responses in Procurement moduleSummary: We have the Compliance checklist created which is now in the Completed status. How can we create an OTBI report to view the Questions and responses for all the … -
list of standard reports related to Maintenance ManagementHello, can someone share a list of the available reports? many of the reports were standard in EBS R12, now I couldn't find them on Cloud. Please advise. Thank you
-
Goals Subject Areas returning no resultswe have created a simple OTBI report using SA like "Goals Review" or "Development Goal Real Time" with only two columns 1. Person Number, 2. Development Goal Name. It is…RahulMore 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Changing GL Segment value Description not reflected in OTBI ReportsChanging GL Segment value Description not reflected in OTBI Reports I thought it should update straight away.PhillipJ 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany