OTBI
Discussion List
-
Where can we find bank account suffix from Supplier site bank account Subject area?Summary: Supplier bank account suffix in OTBI Content (please ensure you mask any confidential information): The Account Suffix is located under Additional Information i…Uma Scherer 1 view 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
pension reason for leaving qualifying schemeSummary: Report on Employees who have opted out of a pension scheme. Content (please ensure you mask any confidential information): Hi All. Trying to create a report tha…
-
How doo_headers_all and por_requisition tables are related .Summary: We need to write query to connect doo_headers and requisition to get po_number and receipt . or it can be connect from PO or RCV tables? how can i form query wi…
-
Cannot select attributes from 2 different folders in same Subject AreaSummary: I select "- Negotiation Header Detail"."Negotiation Number" and "- Supplier List Detail"."Trading Partner Id", 2 columns from same Subject Area and 2 different … -
How do we access OTBI reports in redwood inventory?Summary: In the Classic UI users are able to access OTBI reports from the drawer on the right of the screen. How do users access OTBI reports in Redwood Inventory? Conte…
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da…Tapas_Sathua 22 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…Muhammad_Saad 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to insert Linefeed or carriage return between two Attributes?Summary: I would like to concatenate 2 attributes and have the second attribute print on the next line. This formula doesn't achieve that: "- Negotiation Header Detail".…VDM_IM 34 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get procurement supplier number from supply planHi CCC, My requirement is to get supplier number for the suppliers in the supply plans. I could see the order_number in MSC_SUPPLIES but for some it is empty. SUPPLIER_I…VishnupriyaSelvakumar 21 views 3 comments 0 points Most recent by Sebastian Thomas Supply Chain Planning and Collaboration
-
Has anyone been able to edit seeded data model that uses XML file as a dataset instead of sql query?Summary: I need to edit the Electronic Record for Ship Confirm Report to include custom data. The data model for this report uses an XML file as a dataset instead of an …ajudge 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…
-
How to export three reports output into a single pageHi Team, I have merged three reports into a single page. Out of the three, two are OTBI reports & one is a BIP report. When I am trying to export data, only two OTBI rep…
-
Fixed asset YTD deprecation Value IssueIn Fixed Assets, the depreciation data displayed in the application is different from the data stored in the Oracle database tables (FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL…
-
Account Analysis Drill down -Subledger-Real TimeSummary: The requirement is to have all the transactions (Invoices/Credit Memo's) listed in tabular form once we click on particular balance sheet account for the period…Kinjal Patel-Oracle 21 views 2 comments 4 points Most recent by Kinjal Patel-Oracle Reporting & Analytics for Fusion Service
-
Print Receivables Transactions but don't emailSummary: Hello, We want to be able to run the aforementioned request but rather than have email the documents out, simply generate a PDF document. I know that we can rec… -
Looking for the PVO that exposes the ATTRIBUTE_CHAR12 column from the DOO_HEADERS_EFF_B tableLooking for the PVO that exposes the ATTRIBUTE_CHAR12 column from the DOO_HEADERS_EFF_B table in Oracle fusion. We need this for DA in FDI.
-
Key Flexfield Segments Not Appearing in OTBI Subject Area "Budgetary Control - Balances Real TimeDear all, I am writing to request assistance with Key Flexfield structures and their visibility in Oracle Transactional Business Intelligence (OTBI). Issue: I have creat… -
Journey Template reportSummary: Does anyone have a sample of a report that pulls all the configuration details related to a journey template? Content (please ensure you mask any confidential i…Shanna Oppenheim 2 views 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
In OTBI Multiple home email address to show in Single columnSummary: In OTBI, there is a requirement to display multiple home email addresses in a single column. In my case, two home email addresses need to appear in separate col…Shubham Kadam 31 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to Refresh this analytics view MSC_ANALYTIC_FACT_ORD_V in Oracle fusion cloudSummary: Hi, We have created a custom report based on the analytics view MSC_ANALYTIC_FACT_ORD_V, however not all the plan records are retunred in this view. What proces…Gurujothi D 11 views 1 comment 0 points Most recent by Sebastian Thomas Supply Chain Planning and Collaboration -
Tools for generating the Income Statements and Balance Sheet “out of the box"Is there any tool provided by Oracle for generating the Income Statements and Balance Sheet “out of the box”. If FRS is going to be sunset ->is there a tool already in t…twinkle talreja 11 views 0 comments 0 points Started by twinkle talreja Reporting and Analytics for ERP
-
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…JessSantos 21 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to display different email address types in separate columnsSummary: We have a requirement to display separate columns for work email address and home email address, one row of data per employee. Content (required): From reading …User_2025-01-29-23-50-34-285 61 views 10 comments 1 point Most recent by Shubham Kadam Reporting and Analytics for HCM -
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 1 view 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 323 views 4 comments 1 point Most recent by SR_1234 Reporting and Analytics for ERP
-
line manager DashboardSummary: In Line manager dashboard, we are getting head count from "Workforce Management - Worker Assignment Real Time" subject area. I am able to see all records in thi…Niharika123 233 views 17 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
User is unable to see distribution details for more than 30 lines in this sandbox through UIA sandbox is created to fetch and display Invoice distribution Lines. This distribution tab is created on the invoice inquiry screen on UI by calling a OTBI. OTBI is abl…Sifat Shaikh 11 views 0 comments 0 points Started by Sifat Shaikh Payables, Payments & Cash Management
-
OTBI Analysis filter by max date valuesSummary I want to filter a subject area, where I get only the max date, as the record is duplicated for different datesContent How to do below in OTBI Analysis, Data Set…