Andres, The "Browse Catalog" button in Tools work area "Reports and Analytics" is pretty much just a link to anlaytics OTBI. So what happens if you go direct in your browser to OTBI instead of using this button. This will help debug if the issue is with the application page in the work area or in OBI. So in your browser…

Praveen, The "error" part of the message is already in english "This file requires drag and drop framwork" - the first bit just says "an unexpected condition has occurred (internal diagnostic message: Error:..." Assume this is a reference to the application development framework user experience component. Sorry i could…

Hi, Are you using the correct subject area? Review the user guide for your subject areas. Go to your docs for HCM then top task Analyze and Report https://docs.oracle.com/en/cloud/saas/human-resources/23a/analyze-and-report.html then Review Subject Areas You are using Subject area "Workforce Management - Absence Real Time"…

A OTBI report with a data model uses a different service. REST API BIP​ https://docs.oracle.com/middleware/bi12214/bip/BIPAP/index.html​ Java API BIP​ https://docs.oracle.com/middleware/12213/bip/BIPJD/toc.htm

FYI Regards "Thanks for the reply, this is in OTBI." BOTH publisher "report" "data model" (yellow) and an "analysis" (blue) are both in OTBI which is a suite of products. So you did not answer the question. The syntax of SQL is a bit different if doing a logical query in an analysis versus a publisher report data model in…

Use an OR. You can do this in a physical query or a logical query. where ((account = 500) or (account <> 500 and balance <> 0))

Hi, or is it you want to know the path in the OTBI catalog that someone has entered when they added something to the list in tab Reports and Analytics on a work area such as Project Management. If you select More rather than View it will go to the object in the catalog showing you the path.

Thanks Mihaela, I will give it a go :)

Hi, What link in PPM? Where is the link? What in OTBI do you wish to link to? Possibly you mean the other way? From OTBI to a page in the application? If so, in one of your analysis, select analysis, select Edit, select Criteria, on the presentation column with the link, select column properties, select Interaction, on an…

No probs. Here is a solution I think. Create a dashboard page. Put your analysis on that dashboard page. Or put the folder you analysis is in on the dashboard page. Make that page a favourite instead of the analysis. As an author the analysis will be open on the page when you select the page favourite.. And when you select…

Hi Mike, Why do you have this expectation that favourites will open, rather than edit, for an "author"? What is not having this feature stopping you from achieving. Why would it be useful for this to happen? For more information see Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition…

Yes. Select the AND to toggle to OR.

Hi, As a contractor I worked for multiple companies over time and sometimes at the same time. So my oracle.com / cloud customer connect account is registered with my own email rather than the email of the company I currently worked for. That way my history / points etc moves with me. Originally I had used a different…

Hi, Why do you think it will only return for people who have submitted expenses? Is that an assumption? If you ran the OTBI analysis above I think you will find it will return default expense accounts for all persons whether or not they have done expenses items/reports in the expenses module. As you can see from the…

FYI Field default expense account on a person assignment employment information IS available in subject area "Expenses - Expense Transactions Real Time" select all 0 s_0, "Employee"."Employee Number" as "Person Number", "Employee"."Employee Default Expense Concatenated Segments" as "Default Expense Account Code",…

Hi, If a user can use an analysis from a subject area, the query does execute, it successfully returns zero rows no data found, without throwing a database connection error, then the user must have been granted the correct role. Job roles do not give you data access. If you look at the physical query in the session log…

Hi Rahul, Now you are talking about an OTBI report? I assumed you had built an OTBI Analysis. So did you build it using an OTBI Analysis (blue) not an OTBI Report (yellow) - the colors of the icons in the list of values when you select menu "Create"? If you built it as an OTBI report was it that your data model is logical…

BTW I think the field "Reference Number" is physical table column IBY_PAYMENTS_ALL.PAYMENT_REFERENCE_NUMBER. So if you cant find this mapped to a subject area you can instead build it in a data model with an OTBI report.

So I think you want to try subject area "Payables Payments - Disbursements Real Time". Assume to get screen shot you did select Navigator, select Show More, in group Payables select work area Payments, select Tasks, select Manage Payments, expand section Search, select Advanced if Basic, enter criteria, select Search,…

Hi, What did you click to get this screen shot. Is this Procurement, Payables, Receivables? Which navigator group did you expand, which work area did you select, which task did you you to go to a manage page? In any case you must look at your data lineage in your user guide. This tells you what source transaction fields…