For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
This product alert is published by Oracle OTBI Product Development.
Release 13.18A Factory BI Catalog Lockdown
To minimize upgrade regression, an enhancement has been introduced in the 13.18A release to permanently make the shipped BI catalog content read-only. If users attempt to modify the shipped BI catalog content including folder permissions, they will receive an alert "You are not allowed to modify factory content. Save your own content in /Shared/Custom." Customers that upgrade from R12 to R13 will no longer be able to make changes to the delivered BI catalog even with BI Administrator role. Starting with R13.18A, BI catalog folders will behave as follows:
Hi All,
Is there a way to identify OTBI report and BI Publisher reports that are using a particular column, for example department_name.
Regards,
Pavan.
Hello There,
I would like to know how can I get the below output using BI Publisher for Excel.
I have three groups in the xml file.
G_1 -> G_2 -> G_3
Below expected output:
G_1 | G_2 | G_3 | |||
---|---|---|---|---|---|
Segment1 | Creation_Date | Line_Num | Item_ID | Quantity_Ordered | Quantity_Delivered |
10001008 | 08 11 2019 | 10 | 300000013603844 | 200 | 100 |
20 | 300000013612944 | 300 | 200 | ||
30 | 300000013615636 | 10 | 5 | ||
40 | 300000013626474 | 20 | 1 | ||
50 | 300000013676169 | 2 | 2 | ||
10001009 | 22 11 2019 | 10 | 300000014432708 | 11 | 11 |
20 | 300000014437123 | 25 | 25 | ||
30 | 300000014434715 | 6 | 6 | ||
The output I am getting now is as below:
G_1 | G_2 | G_3 | |||
---|---|---|---|---|---|
Segment1 | Creation_Date | Line_Num | Item_ID | Quantity_Ordered | Quantity_Delivered |
10001008" rowMark="2 | 2019-11-08T04:35:17.000+00:00" rowMark="2 | 10" rowMark="3 | 300000013603844" rowMark="3 | 200 | 100 |
20" rowMark="3 | 300000013612944" rowMark="3 | 300 | 200 | ||
30" rowMark="3 | 300000013615636" rowMark="3 | 10 | 5 | ||
40" rowMark="3 | 300000013626474" rowMark="3 | 20 | 1 | ||
50" rowMark="3 | 300000013676169" rowMark="3 | 2 | 2 | ||
10001009 | 22 11 2019 | 10" rowMark="3 | 300000014432708" rowMark="3 | 11 | 11 |
20" rowMark="3 | 300000014437123" rowMark="3 | 25 | 25 | ||
30" rowMark="3 | 300000014434715" rowMark="3 | 6 | 6 | ||
Please find attached the sample xml, output and the excel template file for your reference.
Look forward to hearing from you.
Thank you & regards,
Donald
Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, customers, etc...
The print job is still running and it keeps printing the physical paper at the printer at our office, i have two questions.
1. Where can we see the list of Print requests from cloud to our On-Premise printer.
2. How can abort the pending requests on cloud as our IT Operations team has confirmed that they don't see the queue in the local printer.
We have a requirement to display the Instance name as watermark in some of the BI Publisher report, (i.e) DEV, TEST etc... based on the instance name/URL. And also change the email/print logic based on the instance name (Prod vs Non-Prod)
We have some details in SYS_CONTEXT, what is the best way to get this information...
I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Lines. The trouble is DRs are CRs are resulted in 2 separate rows. I wonder if anyone have attempted to result the data in a single row albeit in separate columns?
The below is the SQL issued for this OTBI Report. Concatenated Segments field hols Accounting KFF values.
If so please advise.
--------------------------------
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Apps Document Currency Code" s_1,
"Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Expenditure Comment" s_2,
"Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Expenditure Item Date" s_3,
"Project Costing - Actual Costs Real Time"."Expenditure Item"."Expenditure Item" s_4,
"Project Costing - Actual Costs Real Time"."Expenditure Type"."Resource Type Name" s_5,
"Project Costing - Actual Costs Real Time"."General Ledger Account"."Account Type" s_6,
"Project Costing - Actual Costs Real Time"."General Ledger Account"."Concatenated Segments" s_7,
"Project Costing - Actual Costs Real Time"."Original Source References"."Transaction Source Name" s_8,
"Project Costing - Actual Costs Real Time"."Processing Details"."Expenditure Item Expenditure Group Name" s_9,
"Project Costing - Actual Costs Real Time"."Project"."Project Name" s_10,
"Project Costing - Actual Costs Real Time"."Project"."Project Number" s_11,
"Project Costing - Actual Costs Real Time"."Task"."Task Name" s_12,
"Project Costing - Actual Costs Real Time"."Task"."Task Number" s_13,
DESCRIPTOR_IDOF("Project Costing - Actual Costs Real Time"."General Ledger Account"."Account Type") s_14,
DESCRIPTOR_IDOF("Project Costing - Actual Costs Real Time"."Task"."Task Name") s_15,
"Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Raw Cost in Transaction Currency" s_16
FROM "Project Costing - Actual Costs Real Time"
ORDER BY 1, 10 ASC NULLS LAST, 9 ASC NULLS LAST, 5 ASC NULLS LAST, 12 ASC NULLS LAST, 11 ASC NULLS LAST, 14 ASC NULLS LAST, 16 ASC NULLS LAST, 13 ASC NULLS LAST, 6 ASC NULLS LAST, 4 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 7 ASC NULLS LAST, 15 ASC NULLS LAST, 8 ASC NULLS LAST
FETCH FIRST 500001 ROWS ONLY
-----------------------------------------------
Hi All
we have BICS on Paas which is not implemented yet and Oracle recommend to migrate to OAC. We need to know do we really need to migrate to OAC or we can use existing Fusion Saas reporting tools like OTBI, financial studio, publisher,.. to develop all needed role based dashboards and reports. Please advise as we need to decide on this asap
Thanks
Mahgoub
The folder is empty.
A duty role exists for it, BI_EXT_REPORTING_DUTY, but unlike the other folders, the permissions on this folder have not been updated so that only people with that role see this folder.
I had been doing the following configuration to assign folder reporting duty roles to role
Custom BI Webcat Reporting Duty
CONFIGURE NEW BI REPORTING DUTY ROLES TO HIDE THE FACTORY CATALOG FOLDERS
Cloud Readiness Common Technologies and User Experience
https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19D/19D-common-wn.htm#F10098
Nathan
Please Note: This notice does not affect BI Publisher SQL data models and reports.
Customers are strongly advised to save BI Answers Direct Database Query SQL definition before 19D Upgrade
After 19D upgrade, you can continue to execute existing BI Answers Direct Database Query reports but you can no longer create, edit new reports or view report criteria. You are strongly advised to review existing BI Answers Direct Database Query reports and save SQL definition for reports that need to be recreated in OTBI or BIP before 19D upgrade.
Before 19D upgrade, you are strongly advised to save Direct Database Query SQL by using the following methods:
After 19D upgrade, you can no longer open Direct Database Query report criteria and can retrieve SQL from the report log file by using the following methods:
You must use this method to save BI Answers direct database query report definition before 20A upgrade as you will no longer be able to run BI Answers Direct Database Query after 20A upgrade.
If you have comments and concerns, please provide your feedback on this short OTBI customer survey. Thank you for your time!
Ling Xiang
Oracle OTBI Product Management
Heard that Oracle is planning is to restrict the access to Oracle Fusion cloud tables via BI Publisher data models? If that is true we will not be able to perform direct query on the SaaS Tables. Already OTBI Direct query access has been revoked.
Has anyone got this news? If this is true, what options we will have to perform any query on the Transactional tables for data validations and how can we create a custom reports and what will happen to existing custom BI Publisher reports that are built on custom data models?