Hi Anjan, You cannot run a report in OTBI from BI Answers. You have probably built an analysis in OTBI not a report in OTBI. After you saved it as a file in a folder in the catalog is it a blue or yellow icon. I assume it is blue? BI Answers is the blue "Analysis" option in the list of values on menu Create. You can use…

So my proposal was to add to your query 3 columns which will may link a pipeline to a standard and vice versa cast("Job Requisition - Basic Information"."Pipeline Requisition ID" as character)"Job Requisition - Basic Information"."Pipeline Requisition Number""Job Requisition - Basic Information"."Pipeline Requisition Title"

Hi, Regards the action suggested for the system administrator. Make sure you do that first "Reload Files and Metadata" But if that does not fix it. What is the problem column? So looks like you are selecting n columns from one subject area "Product Management - Cross Reference Item Real Time". What are the yellow "measure"…

Hi This error does not look like it is from the dashboard. It looks to me like it is thrown from the database query. Sounds like something to do with a number is a string. It is hard to tell because you forgot to expand the details before posting the screen shot. And you have not shared the query. So If we assume this is…

FYI Assume this is the action you did to create a "linked requisition"? Oracle Fusion Cloud Talent Management Using Recruiting F92723-02 24B Create a Standard Job Requisition Linked to a Pipeline Job Requisition…

Hi, This look like something to do with a job requisition. So we are I assume in a work area in talent management in Human Capital Management HCM from "applicant lifecycle" business process "Recruit to Onboard". If you want to build, an analysis in OTBI or a report in OTBI with data model data source Oracle BI EE/analysis,…

Hi, Here is I think a solution NOTE I used count distinct rather than a running aggregate. I used ethnicity code since it is more likely unique just in case 2 ethnicity have the same name. I included a fact since all queries must have a fact in them if you have selected multiple dimensions. If you include ethnicity as…

Hi Ameya, For any aggregate function like sum count min max avg then using BY in function in your select clause will not change how many rows you get. To do that you need will need to aggregate across a "yellow" measure column or include a GROUP BY. The problem here is that the formula is based on 2 "blue" attribute…

Hi, Meta data of definitions of analytics and reports is not stored in database. When you create analysis or report in OTBI you create on the middleware application server a file. You do not insert a row into a table in the database. But you can read the presentation catalog using API or you can unarchive your custom…

Hi, Yes you can query the view object the view log to see the physical sql(s) on the application database tables and views. To do this ask you bi administrator to use page manage privileges to grant your user or a role you have or inherit privileges issue sql directly and manage sessions. Now go to page issue sql…

Hi To get the data viewed as IT Security Manager in Tools work area Security Console… If you run the scheduled process "Import user and role application security data" aseimportusersandrolesjob you can query the ASE tables and views ase_user_b ase_role_b/ase_role_tl ase_privilege_b/ase_privilege_tl ase_user_role_mbr…

Hi, In your analysis or data model for a report in OTBI write SQL to query this subject area This will give you the subledger transaction ledger accounting XLA journal header and lines. This may or may not give you the transaction data you need from the child subledger transaction tables. For example, it does have…

Hi, This forum is for "real time" analytics and reports in Oracle Transactional Business Intelligence OTBI in Oracle Fusion Cloud Applications. Oracle Analytics Cloud OAC is NOT part of OTBI. Please ask the moderator to move your question to the correct forum. For example,…

Hi Uyen, That is not possible in OTBI. OTBI is read only. Because we are using the hosted Software as a Service version of Oracle Business Intelligence in Oracle Transaction Business Intelligence OTBI in Oracle Fusion Cloud Applications. In our version the feature in OBI to allow "writeback" has been turned off on purpose…

Hi Prabhjeet, The latency is determined by the non functional supplemental requirements you have gathered from your consumers regards how out of date the data can be before it impact the business process. You can schedule as often as choose as a trade of between what your data extract consumers need versus what all the…

As Mandeep said you can do it using delimiter-based (EDI templates) eText template to build a CSV using a template. That way you only have the cols you need in your CSV. Oracle® Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher 12c (12.2.1.2.0) E77722-02 December 2016 "Creating eText…

Hi, BICC is the recommended approach for "bulk extracts" (lots of rows). Using the SOAP or REST API or reports in OTBI is not recommended approach for "bulk extracts" (but lots of customers prefer this method). For more information see Oracle Fusion Cloud Applications Creating a Business Intelligence Cloud Extract…

Ivony, Output format Data CSV and Data XML ignore your selected layout template. They will always get all columns in your data model in the order in your data model diagram no matter what you have done in any of your layout templates. The only thing you can do is set the data model property for pruning which for example…

Hi Ravinat, You are mistaken. Your question IS about enterprise contracts. The "customer" contracts that you manage using for example work area Contracts in navigation menu Contract Management from which you associate none or one or many contract lines from one or more contracts to your projects and/or tasks that you…

Hi Ravinat, It is because contracts is not in Projects or Financials or Procurement nor even in ERP. It is in Customer Experience (Sales). So Enterprise Contracts is used for Sales Contracts in CX but also for terms and conditions in Purchase Documents in Procurement and for intent to buy Supplier Contracts (Payables) and…