-
Forums
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
-
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
DashboardSupply Chain Planning & Collaboration
Reporting and Analytics for SCM
Internet of Things
-
Reporting and Analytics
Reporting and Analytics
DashboardSolutions for Applications (OTBI)
- Reporting & Analytics for HCM
- Reporting & Analytics for Taleo Enterprise (TEE)
- Reporting & Analytics for Taleo Midsize (TBE)
- Reporting & Analytics for Taleo Learn
- Reporting & Analytics for ERP
- Reporting & Analytics for SCM
- Reporting & Analytics for Sales
- Reporting & Analytics for B2C Service
- OBIEE for Applications
Business Analytics
- Applications Security
-
More
More
-
Infrastructure (IaaS)
and Platform (PaaS)Infrastructure (IaaS) and Platform (PaaS)
DashboardContent and Experience
Business Analytics
Security
System Management
-
Partners
OPN Technical Assistance Forums for Partners
BUILD: Partner Technical Assistance
For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
SERVICE: Partner Technical Assistance
For partners that provide implementation or managed services around Oracle Cloud Applications
- Announcements
-
-
Ideas
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
Marketing, Sales, and Service
-
Human Capital Management
Human Capital Management
-
Enterprise Resource Planning
Enterprise Resource Planning
-
Supply Chain Management
Supply Chain Management
-
Reporting and Analytics
Reporting and Analytics
Reporting and Analytics
-
Platform (PaaS)
Platform (PaaS)
-
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
Topic posted September 30, 2019 by Amitabha Dutta
, tagged Fusion Procurement reporting, OTBI in Reporting and Analytics for ERP publicTitle:"Apps Document Currency Code" in Procurement - Procure To Pay Real TimeSummary:"Invoice Currency" missing in Procurement - Procure To Pay Real Time Subject Area.Content:In 19B version, the invoice currency seems to be missing in Procurement - Procure To Pay Real Time Subject Area (Procurement - Procure To Pay Real Time -> Invoice Additional Attributes -> Invoice Currency). There is "Apps Document Currency Code" instead but the documentation does not have any information about this, logical sql provides source as "Procurement - Procure To Pay Real Time"."Invoice Additional Attributes"."Invoice Currency". Is there any specific significance for this column "Apps Document Currency Code"?
- Topic posted January 9, 2018 by Ravikiran K P, tagged Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP publicTitle:Access OTBI Data without Job RolesSummary:For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content:
Hey Guys,
We were checking to see if there is a way for OTBI Admins to access the reports/data as a Super User without having the Specific Job roles (like Inventory Manager, Warehouse Manager etc) assigned.
We tried assigning all the %TRANSACTION_ANALYSIS_DUTY roles, but aren't able to access the data without Job Roles assigned. Any thoughts?
Thanks,
- Topic posted December 10, 2018 by Lak, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP publicTitle:Add Account Parmeter to Custom BI Puslisher ReportContent:
Hi Friends,
I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create parameter. Could you please let me know the process for adding account(GL_CODE_COMBINATIONS - SEGMENT1to7) parameter to custom BI Publisher report.
Appreciated your quick help..!
Thanks
Lak
Version:ORACLE CLOUD ERP R13 
Topic posted July 12, 2019 by Senthilrajan Vaithianathan
, tagged Fusion Procurement reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP publicTitle:Adding extra filters to Infolets (Order Management - Seeded Infolets)Summary:Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'Content:Currently the system allow users to filter and view Infolet data based on the values you can select in 'View By' prompt (Source System) in Order Management landing page, we want to add additional filter criteria's like Buyer, Business Unit, Supplier, Sales Channel etc...
Navigation
Oracle Fusion --> Spring Board --> Order Management --> Order Management --> Filter data in Infolets by selecting 'View By' prompt.
- How to add a new filter in the Order Management landing page to filter the existing infolet data based on 'Sales Channel' similarly like existing filter 'Source System' under 'View By' filter tab?
- Do we have any other option to filter the Infolet data with these additional filters?
- Where the Infolets are stored and can we edit those Infolets ?
Version:Oracle Cloud Application 19B (11.13.19.04.0)Image:
Topic posted November 3, 2017 by MShrini
, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP publicTitle:After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleSummary:After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleContent:After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11. Please help us with solution if you are faced the same in R12 upgrade.- Topic posted March 22, 2017 by Matt Falkai, tagged Fusion Procurement reporting, Fusion Project reporting in Reporting and Analytics for ERP publicTitle:AP Aging reportSummary:AP Aging reportContent:
Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current day (e.g. if run on 03/22 will only show the AP Aging @ 03/22).
Thanks in advance.
Thanks.
Matt
- Topic posted March 28, 2019 by Maria Trejo, tagged Fusion Financial reporting, Fusion Procurement reporting, Reports in Reporting and Analytics for ERP publicTitle:Approval Workflow ReportSummary:Completing an audit of approval workflow for expenses, procurement and budget transactions.Content:
I am completing an audit of our approval workflow setup for expenses, procurement and budget. Our naming convention is Dept ##### Fund Manager. Some rules are out of numerical order by department. For example, we have Dept 19900 followed by Dept 19799.
I am trying to see all the rules that we have setup but the rules under Task Configuration only shows 5 lines and we have over 346 rules setup.
Is there a report that can be run to view all the rules available?
Image:
- Topic posted March 22, 2017 by Matt Falkai, tagged Fusion Financial reporting, Fusion Procurement reporting in Reporting and Analytics for ERP publicTitle:Basic GL detail report requestSummary:Looking for a basic GL detail report with supplier nameContent:
Looking for a basic GL detail report with supplier name and no blank lines in between rows, does this exist anywhere or does it need to be built as a custom report? If so are these types of reports easy to create?
Attached is an example.
Thanks in advance.
Matt
Document: - Topic posted March 29, 2018 by Brad Stefanoni
, tagged BI Publisher, Fusion Procurement reporting, OBI Answers, Reports in Reporting and Analytics for ERP publicTitle:BI Analysis and/or Report for Specific Fiscal Year per Specific Account CodeContent:I am needing to prepare either a report and/or analysis to show all purchase orders from a specific account code over a specific time period (ex: FY16). I have zero experience with Oracle's Business Intelligence reporting tool. Any suggestions for help and/or resources to help create such a report/analysis, please?
Thank you.
Topic posted August 1, 2018 by Nishanth B Jain
, tagged BI Publisher, Fusion Procurement reporting in Reporting and Analytics for ERP publicTitle:BPA ApprovalSummary:BPA Approval Email notification report issueContent:Hi,
I was trying to customize the BPA approval email notification seeded template(from Purchase Document E-Mail Report) available in application.
But when i opened that rtf template, it contains one line like "Review the purchasing document and any files that are attached to the message."
Am not sure whether its completely built rtf or its still under development.
Any comments on this?
Thanks,
Image: