-
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
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
Public Sector
Oracle Education
-
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)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
My IdeasMarketing, Sales, and Service
-
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
- 1-8 of 8
Topic posted March 11, 2019 by Mohammad Alhindawi
, tagged Asset Tracking, BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Configure to Order-CTO, Costing, Dashboards, DVCS, Geneology, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, OBIEE Answers, Order Management, OTBI, Procurement, Product Development, Product Information Management-PIM, Public Sector, Quality – Inspections, Quality – Issues and Actions, Report Scheduling, Reporting and Analytics, Sample Reports, SCM, Setup/Administration, SQL in Reporting and Analytics for SCM publicTitle:Customization on the AP invoiceSummary:Customization on the AP invoiceContent:Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on filling of other fields?
Version:Oracle Fusion- Topic posted February 12, 2019 by Mohammed Kaja Nawaz L J
, tagged BICS, OTBI, Product Development, Product Information Management-PIM in Reporting and Analytics for SCM publicTitle:How to Identify Physical table name for EGO_ITEM_EFF_B tableSummary:How to Identify Physical table name for EGO_ITEM_EFF_B tableContent:Hi all,
I am using Oracle BICS Data Sync to get data from Oracle Fusion SaaS (Product Hub module). I got physical table name mapping from the below post:
https://cloudcustomerconnect.oracle.com/posts/7643f26ffd
However, I couldn't identify the physical table name for EGO_ITEM_EFF_B (Extensible FlexField) to query it from Oracle BICS Data Sync.
Any pointers would be highly helpful.
Thanks,
NawazVersion:BICS,Data Sync - Topic posted April 14, 2017 by Tu Lam, tagged Costing, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, Order Management, OTBI, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Quality – Issues and Actions, SCM, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM publicTitle:R12 SCM and PRC OTBI subject areas to database tables mapping spreadsheetsSummary:R12 SCM and PRC OTBI subject areas to database tables mapping spreadsheetsContent:
These spreadsheets are published by Oracle OTBI Development. These spreadsheets document Procurement and Supply Chain Management OTBI subject areas and the corresponding View Objects and database tables and columns. Customers can use these spreadsheets to search for reporting fields in OTBI subject areas or trace the lineage from subject areas to database tables, columns and view objects or vice versa.
The spreadsheets apply to Fusion PRC and SCM Release 12.
Please note In R12 users can search for a field in a subject area in OTBI.
Document: - Topic posted August 18, 2017 by Tu Lam, tagged Asset Tracking, Costing, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, OBIEE Answers, Order Management, OTBI, Pricing, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Quality – Issues and Actions, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM publicTitle:R13 SCM and Procurement OTBI subject area Description documentationSummary:R13 SCM and Procurement OTBI subject area Description documentationContent:
This documentation is published by Oracle OTBI development. This document provides users a functional understanding of SCM and Procurement subject areas - what they contain, key business questions that can be answered with the analyses built using the subject areas, the primary navigation paths in the application UI that contain information related to specific subject areas, and other useful information. This document also contains information on the duty and job roles that provide access to each subject area.
The spreadsheets apply to SCM and Procurement R13.Document:Document: - Topic posted August 18, 2017 by Tu Lam, tagged Asset Tracking, Configure to Order-CTO, Costing, Geneology, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, Order Management, OTBI, Pricing, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Quality – Issues and Actions, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM publicTitle:R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary:R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent:
This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents Fusion SCM and Procurement OTBI subject areas, the corresponding View Objects and database tables and columns. Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.
This spreadsheet also documents subject area security duty roles and job roles for 17D and 18A.Document:Document: 
Topic posted October 9, 2018 by Hemant Gupta, tagged Business Intelligence, Costing, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, Order Management, OTBI, Pricing, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM publicTitle:R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary:R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent:This spreadsheet is published by Oracle OTBI Development.
Release: R13.19A, R13.19B, R13.19C, R13.19D
Information Covered:
- Documents Fusion SCM and Procurement OTBI subject areas, the corresponding View Objects and database tables and columns.
Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.
Document:Document:Document:Document:- Topic posted February 16, 2017 by Tu Lam, tagged Asset Tracking, Configure to Order-CTO, Costing, Dashboards, Geneology, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, Order Management, OTBI, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Quality – Issues and Actions, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM publicTitle:SCM and PRC OTBI Subject Area DescriptionsSummary:SCM and PRC OTBI Subject Area DescriptionsDocument:
- Topic posted June 5, 2019 by Kevin Johnson, tagged BI Publisher Reports, Inventory, Product Information Management-PIM in Reporting and Analytics for SCM publicTitle:Zero and negative item on hand balancesSummary:Need a report to capture zero and negative on hand balances for inventory itemsVersion:19B