Hi, Yes a person may have many assignments at the same point it time and for each assignment id many instances (updates) of that assignment id over time including multiple update in the same day. Peron assignment is unique on 5 cols; PER_ALL_ASSIGNMENTS_M_PK ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE,…

In OTBI exist 4 roles out of the box; BIConsumer, BIAuthor, BIPDataModelDeveloper, BIAdministrator. In summary with the out of the box default configuration Consumer lets you interact with existing analytics and reports in OTBI (role code "BIConsumer") Author lets you build new content like new prompts, analysis, agents,…

ROWNUM is a reserved name. You cannot alias a column ROWNUM. Change it from "as RowNum" to as "r" or something then change the last line to where dtable.r=1.

Hi, OTBI is "Oracle Transactional Business Intellignece" part of "Oracle Fusion Cloud Applications". OTBI = the patform "Oracle Business Intelligence (OBI) suite (Enterprise Edition EE)" + inside OBI our prebuilt analytics and reports and subject areas in the metadata repository database for each application. I have never…

Hi Yes that was why I posted the 3 links. If a subject area exists you can build an analysis in OTBI (or a report in OTBI using bi as a data source). If the tables and views exist in one of the data sources in your data model then you can build a report in OTBI. If you know the table or view but need to know if a subject…

Hi, What is OTM? Oracle Transportation Management (OTM)? Is this a module that is part of Oracle Fusion Cloud Applications? Is OTM in SCM? OTBI is for Oracle Fusion Cloud Applications https://docs.oracle.com/en/cloud/saas/index.html. If you go to the following page you get the list of subject areas at the bottom…

Hi, For the data access bit you need a data role with security profiles (in addition to as per your screenshot the role with data security polices). So go to page "Manage Data Role and Security Polices" then create a data role on top of the job role required for teh subject area in this case Human Resource Analyst (or on…

Hi, That is likely the expected result - no data found. A duty role does NOT give data access. All a transaction analysis duty role does is stop the system throwing a database connection error when you issue a query to that subject area in the metadata repository database. The expected result of a user who does have…

Hi, Why do you state that non HCM users can access HCM Reports? Do you have an example? I think that out of the box only HCM users can see HCM reports. That security is already in place. Do you agree? I guess we need to agree on what is you definition of a human resources user? The reason I seek clarity is because security…

No but you can add a union to select a constant from a subject area that you know will only return 1 row. (select all 0 as s_0, "presentation table"."presentation column" as s from "subject area" ) union all (select all 0 as s_0, 'xx' as s from "subject area" ) for example i added the 1999 row "from dual" SELECT saw_0,…

Have you tried to archive a snapshot of the catalog in OTBI, then unarchive it to a local instance of the same version of OBI that you have installed on your own machine on-premise (like a virtual machine on your laptop), then use catalog manager to report?

Hi, That is not an error. That is a successful query returning zero rows. This is the expected result if you do not have any data access. If you go to manage sessions to view the log you will see the where clause that was added at runtime to prevent you seeing any data becasue you have not granted any data access. Roles do…

Here is a solution. For a subject area go to your user guide to get the list of job roles Oracle Fusion Cloud Project Management Subject Areas for Transactional Business Intelligence in Project Management F77994-01 23B https://docs.oracle.com/en/cloud/saas/project-management/23b/faopm/index.html#COPYRIGHT_0000 for example…

BTW Please confirm what you mean by run the "Contract Analysis Report". Which role is it that both users have? Describe the exact steps the user takes in the system to execute it? For example, which work area do you go to in the navigation menu do you use to get to this? Can you provide a screen shot to help us replicate…

Hi, When you say "some can execute the contract report and others cannot" I assume you mean they can in fact both go execute it without error but one of them gets results and the other gets no data found? It is expected that 2 people with the same job role get different results. Roles do not provide access to data in ERP.…

Hi I think you refer to business process 04 Order Fulfillment 03 Bill Customers 05 Present Bill Oracle Fusion Business Process Models: 04 Order Fulfillment (Doc ID 1578139.1) For more information see Oracle Fusion Cloud Financials Using Receivables Credit to Cash F77966-02 23B Manage Customer Billing Present Billing Print…

Hi, I think you refer to business process 04 Order Fulfillment 03 Bill Customers 05 Present Bill Oracle Fusion Business Process Models: 04 Order Fulfillment (Doc ID 1578139.1) For more information see Oracle Fusion Cloud Financials Using Receivables Credit to Cash F77966-02 23B Manage Customer Billing Present Billing Print…

Yes OTBI has the capability to get data from additional information fields. When you configure the descriptive flexible field you must set "BI Enabled" = True. You must also run the biextender scheduled process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" with parameter HCM so that the…

Hi, You have not posted the logical query. It is a zero bytes empty file. But in any case for any analysis if you need to know what is going on then look in your session log. So go to the issue sql page at /analytics/saw.dll?issuerawsql. Cut paste your logical sql from the advanced tab of your analysis with any where…

Hi, Try a pivot table. You will need a column that says whether each row is type Skill or type Certificate. Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 12.2.1.3.0 E80922-02 November 2017…