-
Forums
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
HCM ANNOUNCEMENT: Deadline Approaching Responsive UX - Urgent Action Required! -
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
Dashboard -
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
Forums
Use our discussion forums to pose questions, explore ideas, and discuss Oracle Applications. -
-
Ideas
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
My IdeasCustomer Experience
-
Human Capital Management
Human Capital Management
My Ideas -
Enterprise Resource Planning
Enterprise Resource Planning
My Ideas -
Supply Chain Management
Supply Chain Management
My Ideas -
Reporting and Analytics
Reporting and Analytics
My IdeasReporting and Analytics
-
More
More
My IdeasPublic Sector
Oracle Education
-
Platform (PaaS)
Platform (PaaS)
My Ideas
Ideas
Share your ideas on product enhancements, vote, and comment on your favorite ideas. -
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
Topic posted September 28, 2019 by Rahul L
, tagged BI Publisher Reports in Reporting and Analytics for SCM publicTitle:Grouping web service and sql Query type Data model.Summary:Unable to add the web service data group in rtf along with Sql Query DMContent:Hi,
I have a requirement to invoke data coming from web service along with other groups created using Sql Query. I see the grouping is not working and cannot invoke the service output in rtf between other groups. Can we handle this in BI report. If Not, may i know the other around.
Note: It is only coming in the output when we call the web service group at the beginning of the template.
Can someone help me on this.
Thanks
Rahul
Version:11.1.1.9.0
Topic posted September 25, 2019 by Dev Thota
, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, General Ledger, How-To, Manage Procurement Catalog, Notifications, Orders, OTBI, Payables, Public Sector, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, Web Services in Procurement > Purchasing publicTitle:Terminated users are getting removed on requisition even though the user is PO requester and the user is on inactive stateSummary:Terminated users are getting removed on requisition even though the user is PO requester and the user is on inactive stateContent:Hi all,
Terminated users are getting removed on requisition even though the user is PO requester and the user is on the inactive state.
Report Subject Area: Procurement - Purchasing Real Time.
Thanks,
Dev Thota.
Version:19C- Topic posted September 18, 2019 by Nidhi Chhajed
, tagged BI Publisher Reports in Reporting and Analytics for SCM publicTitle:Supplier Registration or Profile Change Approval DetailsContent:Hi ,
I want to prepare a SQL which will have supplier and approver details.
I know we have below workflow and supplier tables:
fa_fusion_soainfra.wftask
fa_fusion_soainfra.wftaskhistory
POZ_SUPPLIER_REGISTRATIONS
POZ_SUPPLIERS
But I am struggling to find correct details.
Can someone please help me here.
Regards
Nidhi...
Topic posted September 17, 2019 by Koteswararao Yenikepalli
, tagged BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Dashboards, OTBI, SQL, Supply Chain Planning, Tip, Upgrades, White Paper in Reporting and Analytics for SCM publicTitle:How to print the amount in words in the etext templateSummary:How to print the amount in words in the etext templateContent:How to print the amount in words in the etext template
we have used the below syntax in the etext template
<?xdofx:to_check_number(12345.67, 'EUR', 'CASE_LOWER', 'DECIMAL_STYLE_WORDS')?>
But it is not giving the expected output and at this moment we have the only XML we cont have the data model access for this
Please suggest the possible ways to achieve this requirement
Thank You.
Version:19C- Topic posted September 14, 2019 by Koteswararao Yenikepalli, tagged BI Publisher, BI Publisher Reports, Business Intelligence, Report Scheduling, Reporting and Analytics, SQL, Tip, White Paper in Reporting and Analytics for SCM publicTitle:Is it possible to send two attachments in single bursting?Summary:Is it possible to send two attachments in single bursting?Content:
We had a requirement to send same output with two different formats (Ex: Excel and PDF). we need to send two different formats in single email not different emails..
Please suggest, is there any possibility to achieve it.
Version:19C - Topic posted September 13, 2019 by Amar, tagged BI Publisher, BI Publisher Reports, Business Intelligence, White Paper in Reporting and Analytics for SCM publicTitle:Unable to select Data Source from Data ModelSummary:Unable to select Data Source from Data ModelContent:
All --> I am facing issue with OTM BIP cloud Catalog.
Issue: Not able to choose/select Data source from Data Model.Is this due to Role?
Also can anyone provide Shipment Manifest tables.?
- Topic posted September 10, 2019 by Harshal Agrawal
, tagged BI Publisher Reports, OTBI in Reporting and Analytics for SCM publicTitle:Reports needed as per the customer languageSummary:Manual reports need to be generated in customer languageContent:Hi All,
We are facing requirement from customer side that they want reports need to be generated in there language.
For eg : We are creating custom reports in English language, but some of the customer are using swedish language so we need report in Swedish language for Swedish customer, and other reports in there language.
So how and what setups are needed to achieve this ?Thanks,
Harshal 
Topic posted September 4, 2019 by Harshith Eshwar Shaila
, tagged Agreements, Approvals, BI Publisher Reports, Business Intelligence, Create Requisition, Financials, General Ledger, Orders, Payables, Requisition Processing, Setup, Tip, Web Services, White Paper in Procurement > Purchasing publicTitle:How Purchasing Module interacts with other Oracle modules.Content:Hi all,
Is there any Doc IDs/Link/ whitepapers or any other Detailed Documentation on understanding how Purchasing Module interacts with other Oracle modules in Procurement, SCM, Financials..etc, from data flow perspective.
Regards,
Harshith E S
- Topic posted August 28, 2019 by Koteswararao Yenikepalli, tagged Asset Tracking, BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Configure to Order-CTO, OBIEE Answers, OTBI, Pricing, Procurement, Sample Reports, SCM, SQL, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning, Tip, White Paper in Reporting and Analytics for SCM publicTitle:Need A SQL query to get the supplier contact address detailsSummary:Need A SQL query to get the supplier contact address detailsContent:
Need A SQL query to get the supplier contact address details
Here I have attached the screenshot for the better understanding
Version:19 CImage:
Topic posted August 27, 2019 by Caio Zioli, tagged BI Publisher, BI Publisher Reports, Dashboards, OTBI, Reporting and Analytics, Tip in Reporting and Analytics for SCM publicTitle:Is it possible to create new/custom infolets ?Content:Is it possible to create new/custom infolets ?
Version:19C