biapps_7963_ex_user_guide_ma.zip - oracle business intelligence applications userÔÇÖs guide for...
TRANSCRIPT
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
1/174
Oracle Business Intelligence Applications Users Guide for
Manufacturing Analytics
Version 7.9.6.3 Extension Pack
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
2/174
Contents
Preface.................................................................................................................................................... 6
Audience........................................................................................................................................... 6
Documentation Accessibility.......................................................................................................... 6
Accessibility of Code Examples in Documentation................................................................ 6
Accessibility of Links to External Web Sites in Documentation........................................... 7
TTY Access to Oracle Support Services.................................................................................... 7
Related Documents.......................................................................................................................... 7
Conventions...................................................................................................................................... 7
Overview of Oracle Manufacturing Analytics................................................................................. 7
Facts Descriptions................................................................................................................................ 8
Subject Area Details........................................................................................................................... 11
Manufacturing Subject Area Details........................................................................................ 11
Inventory and Costing Subject Area Details........................................................................... 46
Planning - Subject Area Details.................................................................................................... 65
Discrete Quality Subject Area Details...................................................................................... 71
Process Quality - Subject Area Details........................................................................................ 93
Kanban Subject Area Details ........................................................................................................... 113
Kimball Matrix................................................................................................................................. 122
Manufacturing.............................................................................................................................. 122
Planning......................................................................................................................................... 136
Discrete Quality............................................................................................................................ 137
Process Quality............................................................................................................................. 138
Manufacturing Execution Dashboard........................................................................................... 138
VP Manufacturing Dashboard Page.......................................................................................... 138
Production Performance Report............................................................................................ 138
Production Cost Report........................................................................................................... 139
Inventory Report...................................................................................................................... 139
Quality Report.......................................................................................................................... 140
Cross Plant Analysis Report................................................................................................... 140
Key Category Tracking Report............................................................................................... 140
Production to Plan Summary Dashboard Page....................................................................... 141
Production to Plan Summary Report.................................................................................... 141
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
3/174
Production Cost Summary Dashboard Page........................................................................... 142
Cost Distribution Analysis Report......................................................................................... 142
Margin Analysis Report.......................................................................................................... 143
Resource Cost Variance Report.............................................................................................. 143
Material Cost Variance Report............................................................................................... 144
Overhead Cost Variance Report............................................................................................ 144
Inventory Summary Dashboard Page....................................................................................... 144
Inventory Turns Trend Report............................................................................................... 145
Inventory Turns by Category Report.................................................................................... 145
Quality Summary Dashboard Page........................................................................................... 146
Production Scrap Distribution Trend Report....................................................................... 146
Production Scrap Trend Report............................................................................................. 146
Service Level Summary Dashboard Page................................................................................. 147
Ship Date Compliance Report................................................................................................ 147
Promise Date Compliance Report.......................................................................................... 148
Request Date Compliance Report.......................................................................................... 148
**All the reports on the Service Level Summary Dashboard page require the licensing and
deploying of the Supply Chain and Order Management analytics module.................................... 148
Plant Manager Dashboard Page................................................................................................ 148
Production Cost Report........................................................................................................... 149
Production to Plan Report...................................................................................................... 149
Resource Efficiency Report..................................................................................................... 149
Trending Report....................................................................................................................... 150
Shop Floor Supervisor Dashboard Page................................................................................... 150
Overall Productivity Report................................................................................................... 150
Productivity by Resource Report........................................................................................... 150
Shop Floor Utilization Summary Report.............................................................................. 151
Lot Genealogy Dashboard Page................................................................................................. 151
Lot Genealogy Report.............................................................................................................. 151
Cost Controller Dashboard Page ..................................................................................................... 152
Cost Metrics Report................................................................................................................. 152
Total Cost Trend Report.......................................................................................................... 153
Manufacturing Cost Variance Report................................................................................... 153Cross Functional Dashboard Page............................................................................................. 153
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
4/174
Planning Dashboard ............................................................................................................................ 155
Plan Summary Dashboard Page ...................................................................................................... 155
Demand Schedule by Time bucket: ............................................................................................ 155
Demand Pegging Trend: .............................................................................................................. 156
Demand Fulfillment Performance:.............................................................................................. 156
Demand Fulfillment Distribution: ............................................................................................... 156
Supply Distribution: .................................................................................................................... 156
Supply Schedule by Time bucket: ............................................................................................... 156
Pegging Details Dashboard Page..................................................................................................... 156
Pegging Details Report............................................................................................................ 156
Demand Schedule Dashboard Page.......................................................................................... 157
Supply Schedule Dashboard Page............................................................................................. 158
Quality Dashboard .............................................................................................................................. 159
Quality Summary Dashboard Page........................................................................................... 159
Scrap by Product Category..................................................................................................... 159
Work Order Scrap Detail Report........................................................................................... 159
Scrap by Scrap Reason Report................................................................................................ 160
Quality Test Analysis Dashboard Page.................................................................................... 160
Test Conformance.................................................................................................................... 160
Test Distribution....................................................................................................................... 160
Test Conformance Details Report.......................................................................................... 160
Test Distribution by Product Category................................................................................. 161
Kanban Dashboard.......................................................................................................................... 161
Inventory and Costing Dashboard................................................................................................ 166
Inventory Management Dashboard Page ....................................................................................... 167
Cross Plant Analysis ..................................................................................................................... 167Cross Category Analysis .............................................................................................................. 168
Inventory Analysis ....................................................................................................................... 169
Manufacturing Cost ........................................................................................................................ 170
Manufacturing Cost Variance ..................................................................................................... 171
Excess & Obsolescence ................................................................................................................... 171
Excess Inventory.......................................................................................................................... 172
Obsolete Inventory ..................................................................................................................... 173
Obsolete Inventory by Lot ........................................................................................................... 173
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
5/174
Manufacturing Cost Detail .............................................................................................................. 174
Manufacturing Cost Details ........................................................................................................ 174
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
6/174
Preface
Oracle Business Intelligence Applications are comprehensive prebuilt solutions that deliver
pervasive intelligence across an organization, empowering users at all level, from front line
operational users to senior management, with the key information they need to maximizeeffectiveness. Intuitive and role-based, these solutions transform and integrate data from a
range of enterprise sources, including Siebel, Oracle, PeopleSoft, SAP, and corporate data
warehouses, into actionable insight that enables more effective actions, decisions, and
processes.
Oracle Business Intelligence Applications are built on Oracle Business Intelligence Suite
Enterprise Edition, a comprehensive next-generation BI and analytics platform.
This guide explains how to install, set up, configure, and customize Oracle Business
Intelligence Applications Version 7.9.6.3 Extension Pack.
Oracle recommends reading Oracle Business Intelligence Applications Release Notes beforeinstalling or using Oracle Business Intelligence Applications. The Oracle Business
Intelligence Applications Release Notes are available:
On the Oracle Business Intelligence Applications CD-ROM. On the Oracle Technology Network at
http://www.oracle.com/technology/documentation/bi_apps.html (to register for a free
account on the Oracle Technology Network, go to
http://www.oracle.com/technology/about/index.html).
AudienceThis document is intended for BI managers and implementers of Oracle Business
Intelligence Applications.
Documentation Accessibility
Our goal is to make Oracle products, services, and supporting documentation accessible,
with good usability, to the disabled community. To that end, our documentation includes
features that make information available to users of assistive technology. This
documentation is available in HTML format, and contains markup to facilitate access by the
disabled community. Accessibility standards will continue to evolve over time, and Oracle isactively engaged with other market-leading technology vendors to address technical
obstacles so that our documentation can be accessible to all of our customers. For more
information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/.
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The
conventions for writing code require that closing braces should appear on an otherwise
empty line; however, some screen readers may not always read a line of text that consists
solely of a bracket or brace.
http://www.oracle.com/technology/documentation/bi_apps.htmlhttp://www.oracle.com/technology/documentation/bi_apps.html -
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
7/174
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that
Oracle does not own or control. Oracle neither evaluates nor makes any representations
regarding the accessibility of these Web sites.
TTY Access to Oracle Support Services
Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within
the United States of America 24 hours a day, 7 days a week. For TTY support, call
800.446.2398. Outside the United States, call +1.407.458.2479.
Related Documents
For more information, see the following documents in the Oracle Business Intelligence
Applications Release 7.9.6.3 Extension Pack documentation set (available at
http://www.oracle.com/technology/documentation/bi_apps.html): Oracle Business Intelligence Applications Release Notes System Requirements and Supported Platforms for Oracle Business Intelligence Applications for
Oracle Data Integrator Users
Conventions
The following text conventions are used in this document:
Boldfacetype indicates graphical user interface elements associated with an action, orterms defined in text or the glossary.
Italictype indicates book titles, emphasis, or placeholder variables for which you supplyparticular values.
Monospace type indicates commands within a paragraph, URLs, codein examples, textthat appears on the screen, or text that you enter.
Overview of Oracle Manufacturing Analytics
Oracle Manufacturing Analytics is a prebuilt analytical solution that is compatible with
Oracle BI Applications. Pre built dashboards provide KPIs on planned vs. actual production,
production costing, inventory, manufacturing quality and related manufacturing executionactivities.
Use Manufacturing Analytics to analyze manufacturing performance on the following Key
Performance Indicators (KPIs):
Production to Plan: Compare Actual production values with planned productionvalues.
On-Time Production: Find out the percentage of on-time production to totalproduction.
Production Backlog: View the cumulative value for all the open jobs.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
8/174
Backlog %: Find out the percentage of open jobs to total number of jobs taken intoproduction.
Past due Backlog %: Find out how many jobs are currently running late. Cost Variance %: View standard and actual costs for all the jobs and resulting cost
variances (standard costs include material, resource, outside processing, andoverhead costs.)
Resource Utilization: Find out how many hours of available resources were actuallyutilized.
Scrap %: Compare the scrap value with production value and find out the percentageof scrap for all jobs.
Service Level Compliance %: Find out how many work orders are completed on timewith respect to the sales order lines pegged to the work order.
Inventory Value: Find out how much inventory is maintained by the manufacturingorganizations (including On-Hand, Intransit & WIP). Discrete Quality Test Results and Result Conformances.
Manufacturing Analytics references information from the following application areas of
Oracle E-Business Suite:
Oracle Advanced Supply Chain Planning Oracle Work in Process Oracle Inventory Oracle Order Management Oracle Process Manufacturing Oracle Cost Management Oracle Bills of Material Oracle Discrete Quality Oracle Process Quality
Facts DescriptionsThe measures and KPIs of Manufacturing Analytics are grouped under the following facts:
Fact - Inventory Balance
This fact contains measures related to the
inventory maintained by an organization. The
measures are spanned across different inventory
types and also show how the inventory position
changed over a period of time.
This Fact is analyzable by Time, Product, Item
Inventory Product, Plant, Plant Location, Storage
Location and Lot.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
9/174
Fact - Material Analysis
This fact contains measures related to actual and
planned material usage. This fact is analyzable by
Plant, Product, Item Inventory Product,
Component Product, Component Inventory
Product and Work Order dimensions.
Fact - Production Costs and Variances
This fact contains measures on manufacturing
performance compared to the standard cost. This
fact is analyzable by Time, Plant, Product, Item
Inventory Product and Work Order Dimensions.
Fact - Production Performance and
Backlog
This fact contains measures on manufacturing
performance compared to production plan. This
fact is analyzable by Time, Plant, Product, Item
Inventory Product and Standard Operations
dimensions.
Fact - Profitability*
This fact contains measures on cost effectiveness
of manufacturing. This fact is analyzable by Time,
Customer, Product, Item Inventory Product and
Plant Location dimensions - This fact requires
licensing and implementation of Financial Analytics
module
Fact - Quality/Yield
This fact contains measures related to quality
aspect of manufacturing. This fact is analyzable by
Time, Plant, Product and Inventory Product
dimensions.
Fact - Resource Analysis
This fact contains measures on Resource
Efficiency and Resource Utilization. This fact is
analyzable by Time and Plant dimensions.
Fact - Service Levels*
This fact contains measures on manufacturing
performance compared to demand requirements.
This fact is analyzable by Product, Plant,
Inventory Product, Customer and Timedimensions - This fact requires licensing and
implementation of Supply Chain and Order
Management Analytics module.
Fact Lot Genealogy
This fact contains the genealogy of quantity
produced. For a given work order completion
quantity, this fact contains metrics that trace
through ten levels of WIP Issues, WIP
Completions and Purchase Order Receipts that
contributed to the final work order completion.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
10/174
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
11/174
Subject Area Details
Manufacturing Subject Area Details
The following document provides the details of the subject area present for Manufacturing
Analytics.
Presentation Table Presentation Column Description
Time Date Date
Time Month Month
Time Quarter Quarter
Time Year Year
Time Week Week
Time Enterprise Year Fiscal year number
Time Enterprise Quarter Fiscal quarter number in the fiscal year
Time Enterprise Period Fiscal month number in the fiscal year
Time Enterprise Week Fiscal week number in the fiscal year
Customer Account Base Currency Base currency in use by account
Customer Account Location Location of account
Customer Account Loyalty Actual cost per consumer orders
Customer Account Loyalty Group
Based on the number of interactions in the
last one year, the rank and group of the B2B
customers.
Customer Account Name Name of the account
Customer Account Organization
Name of the organization associated with the
account
Customer Account Region Region where the account is situated
Customer Account Status Status of the account, e.g. Active
Customer Account Value Account Value
Customer Agency Contract Date Agency Contract Date
Customer Agency Flag Agency Flag
CustomerAlternate CustomerNumber
This is an alternate number assigned to thecustomer
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
12/174
Presentation Table Presentation Column Description
Customer Annual Revenue Annual Revenue
Customer Annual Revenue Category Annual Revenue Category
Customer Base Level Current Login Base Level Current Login
Customer Birth Date
This is an individual's date of birth.
Organizations can also use this to reflect the
date of registration.
Customer Branch Flag Branch Flag
Customer City City where account is situated
Customer Client Flag Denotes whether an account is a client or not
Customer Core Account Region Core Account Region
Customer Country Country where account is situated
Customer Created Date Created date of account
Customer Current Assets Current Assets
Customer
Customer Alternate Phone
Number
This is the customer's optional secondary
phone number.
Customer Customer Category
This identifies the category to which the
customer belongs.
Customer Customer Category Name
This is a detailed description of the customer
category.
Customer Customer City Customer City
Customer Customer Country Customer Country
Customer
Customer Direct Marketing
Flag
This flag identifies whether the customer has
explicitly requested no direct marketing
contacts.
Customer Customer Email Address This is the email address of the customer.
Customer Customer Family Name
For individuals, this is the family name/last
name. For organizations that are part of a
larger group, this is the group (family) name.
Customer Customer Fax Number This is the customer's facsimile number.
Customer Customer Individual Gender
This is an individual's gender. Examples
include: Male, Female, and Not Declared.
CustomerCustomer Individual MaritalState
This is an individual's marital state, also knownas marital status. Examples include: single,
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
13/174
Presentation Table Presentation Column Description
married, divorced, and widowed.
Customer Customer Individual TitleThis is an individual's title. For example Mr.,Mrs., or Sir.
Customer
Customer Internet Home
Page
This is the home page of the
individual/organization.
Customer Customer Key
Uniquely identifies the person who purchases
the organization's products or services. This is
a surrogate key assigned by Oracle BI
Applications. It is used as a primary key.
Customer Customer Legal Name
This is the full name of the customer, as legally
required for contracts and documentation.
Customer Customer Legal Structure
A classification that defines the legal structure
of the registration of the organization. For
example, partnership, corporation, etc.
Customer
Customer Legal Structure
Name
This provides a detailed description of the
legal structure of the registration of the
organization.
Customer Customer Mobile Number
This is the mobile/cellular number of the
customer.
Customer Customer Name This is the name of the customer.
Customer Customer Number
This is the customer number that is unique for
each customer.
Customer Customer Other Name
For individuals, this is the middle (or other)
name. For organizations, this is the marketing
name.
Customer Customer Pager Number This is the customer's pager number.
Customer Customer Phone Number This is the customer's primary phone number.
Customer Customer Preferred Name
This is the customer's preferred name. This is
generally a first name for individuals and an
acronym or short name for organizations
Customer Customer SIC Code
This is the Standard Industry Classification for
the organization
Customer Customer SIC Name
This is a detailed description of the Standard
Industry Classification code.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
14/174
Presentation Table Presentation Column Description
Customer Customer Solicitation Flag
This flag defines whether the customer has
specifically requested that no marketing
material be sent to them or that no illegal
contacts are permitted.
Customer Customer State Customer State
Customer Customer Street Address Customer Street Address
Customer Customer Type This code identifies the customer type
Customer Customer Type Name
This is a detailed description of the customer
type
Customer Date Formed Date account formed
Customer Exchange Loc Exchange Loc
Customer Expertise Expertise
Customer Facility Type
Type of loan facility, either ""New"" or
""Renewal"""
Customer Financing Method Financing Method
Customer Freight Terms Freight Terms
Customer Frequency Category Frequency Category
Customer Gross Profit Gross Profit
Customer Growth % Growth %
Customer Growth Horizon Growth Horizon
Customer Growth Objective Growth Objective
Customer Hierarchy Based Login Hierarchy Based Login
Customer Industry Name Industry Name
Customer Key Competitor
Denotes whether an account is a key
competitor or not
Customer Legal Form Legal Form
Customer Line of Business Account's line of business
Customer Main Phone Number Account's main phone number
Customer Margin Vs. Industry Margin Vs. Industry
Customer Market Cap Preference Market Cap Preference
Customer Market Potential Market Potential
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
15/174
Presentation Table Presentation Column Description
Customer Market Type Market Type
Customer Medical Procedure Medical Procedure
Customer Monetary Category Name Monetary Category Name
Customer Monetary Category Code Monetary Category Code
Customer Net Income Net Income
Customer Non- Cash Expenditure Non- Cash Expenditure
Customer
Number of Employees
Category
Number of Employees Category
Customer Operating Income Operating Income
Customer Parent Account Name Parent Account Name
Customer Partner Name Partner Name
Customer Party Type Code Party Type Code
Customer Postal Code Postal code where account is situated
Customer Price List Name Price list associated with the account
Customer Primary Market Primary Market
Customer Prospect Flag Prospect Flag
Customer Recency Category Recency Category
Customer Revenue Growth Category Revenue Growth Category
Customer State State where account is situated
Customer Street Address Street address where account is situated
Customer Team Owner Login Team Owner Login
Customer Top Level Current Login Top Level Current Login
Plant Plant Name Name of the Inventory Organization
Plant Location Plant Location Number
Identifies the location number of the business
location.
Plant Location Plant Location Name Identifies the name of the business location.
Plant Location Plant Location Region Identifies the regional code for the location.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
16/174
Presentation Table Presentation Column Description
Plant Location Plant Location State
Identifies the state in which the location is
located.
Plant Location Plant Location CityIdentifies the city in which the location islocated.
Storage Location Inventory Locator Number
Identifies the inventory locator number with
which the storage bin/shelf is associated.
Storage Location Inventory Locator Name
Identifies the inventory locator name with
which the storage bin/shelf is associated.
Storage Location Storage Location Number
Identifies the location number of the business
location.
Storage Location Storage Location Name Identifies the name of the business location.
Storage Location Storage Location Region Identifies the regional code for the location.
Storage Location Storage Location State
Identifies the state in which the location is
located.
Storage Location Storage Location City
Identifies the city in which the location is
located.
Product Product Number Product Number
Product Product Name This is a detailed description of the product
Product Product Category Product Category
Product Product Group
This is the product group code. Products with
similar attributes can be grouped. For
example, a product can belong to the chemical
group, paints group or general stores. Product
hierarchies can be define based on productgroups.
Product
Product Hierarchy 1
Number
This column is provided by Oracle BI
Applications for storing a hierarchy code.
Product Product Hierarchy 1 Name
This column is provided by Oracle BI
Applications for storing the description that
corresponds to the hierarchy code.
Product
Product Hierarchy 2
Number
This column is provided by Oracle BI
Applications for storing a hierarchy code.
Product Product Hierarchy 2 Name This column is provided by Oracle BI
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
17/174
Presentation Table Presentation Column Description
Applications for storing the description that
corresponds to the hierarchy code.
Product
Product Hierarchy 3
Number
This column is provided by Oracle BI
Applications for storing a hierarchy code.
Product Product Hierarchy 3 Name
This column is provided by Oracle BI
Applications for storing the description that
corresponds to the hierarchy code.
Product
Product Hierarchy 4
Number
This column is provided by Oracle BI
Applications for storing a hierarchy code.
Product Product Hierarchy 4 Name
This column is provided by Oracle BI
Applications for storing the description that
corresponds to the hierarchy code.
Product
Product Hierarchy 5
Number
This column is provided by Oracle BI
Applications for storing a hierarchy code.
Product Product Hierarchy 5 Name
This column is provided by Oracle BI
Applications for storing the description that
corresponds to the hierarchy code.
Product
Product Hierarchy 6
Number
This column is provided by Oracle BI
Applications for storing a hierarchy code.
Product Product Hierarchy 6 Name
This column is provided by Oracle BIApplications for storing the description that
corresponds to the hierarchy code.
Product Product Type Code
This code identifies the product type.
Examples includes 'raw materials' 'finished
goods' or ' trade'.
Product Product Type Description
This is the description portion of the product
type code.
Product Product Group Description
This is the description of the product group
code.
Product Division
This code identifies the division. Products can
be classified by the division code to determine
their sales or business area.
Product Make Buy Flag
This indicates whether the product is made in
the organization or bought by the
organization. Possible values includes 'M', 'B'.
Product Brand
This is the brand to which the product
belongs.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
18/174
Presentation Table Presentation Column Description
Product Color This identifies the color of the product.
Product Configurable Product Flag
This indicates whether the product is
configurable or not.
Product Configuration Category This code identifies the configuration category
Product Discontinuation Date
This is the date on which the product was
discontinued from the market.
Product Product Repurchase Period
This is the expected period between the
purchases of a product. It is used for
sensitivity and profile styles of analysis. The
repurchase period is stored in monthly units.
Product Sales UOMThis is a sales unit of measure code tomeasure the product sold.
Product Shelf Life This is the shelf life of the product
Product Source Of Supply
A field for determining any unique sources of
supply for the product - internal or external.
Product Standard UOM Code
This is the Standard unit of measure code in
which the product is managed.
Item Inventory
Product Product Number
Product Number
Item Inventory
Product Inventory Category
Inventory Category
Item Inventory
Product
Manufacturing Product ABC
Flag
Indicator that classifies a material as an A, B,
or C part according to its consumption value.
Item Inventory
Product
Manufacturing Product
Back flush Flag
Determines whether the back flush indicator is
set in the production order.
Item Inventory
Product
Manufacturing Product Bulk
Item Flag
Bulk item Indicator
Item Inventory
Product
Manufacturing Product
Buyer
Buyer Code
Item Inventory
Product
Manufacturing Product
Buyer Name
Buyer Name
Item Inventory
Product
Manufacturing Product
Commodity
Commodity Code
Item Inventory Manufacturing Product Commodity Name
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
19/174
Presentation Table Presentation Column Description
Product Commodity Description
Item Inventory
Product
Manufacturing Product
Commodity UOM
Unit of measure of commodity
Item Inventory
Product
Manufacturing Product
Commodity UOM Name
Unit of measure of commodity
Item Inventory
Product
Manufacturing Product
External Procurement Time
Time needed to obtain the material or service
if it is procured externally.
Item Inventory
Product
Manufacturing Product
External Storage Location
External storage location Code
Item InventoryProduct
Manufacturing Product
External Storage LocationName
External storage location description
Item Inventory
Product
Manufacturing Product
Fixed Lot Size
Fixed lot size
Item Inventory
Product
Manufacturing Product
Forecast Period
Forecast period (Like Weekly , Monthly etc)
Item Inventory
Product
Manufacturing Product
Internal Manufacturing
Time
Internal manufacturing time
Item Inventory
Product
Manufacturing Product
Internal Storage Location
Internal storage location Code
Item Inventory
Product
Manufacturing Product
Internal Storage Location
Name
Internal storage location description
Item Inventory
Product
Manufacturing Product
Issue UOM
Unit of measure in issues
Item InventoryProduct Manufacturing ProductIssue UOM Description Description of unit of measure in issues
Item Inventory
Product
Manufacturing Product
Loading Type
Loading type Code
Item Inventory
Product
Manufacturing Product
Loading Type Name
Loading type Name
Item Inventory
Product
Manufacturing Product Lot
Ordering Cost
Cost of ordering a lot
Item InventoryProduct
Manufacturing Product LotSize
Lot size Code
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
20/174
Presentation Table Presentation Column Description
Item Inventory
Product
Manufacturing Product Lot
Size Name
Lot size description
Item InventoryProduct
Manufacturing ProductManufacturing UOM
Unit of measure in manufacturing
Item Inventory
Product
Manufacturing Product
Manufacturing UOM
Description
Description of unit of measure in
manufacturing
Item Inventory
Product
Manufacturing Product Max
Lot Size
Maximum lot size
Item Inventory
Product
Manufacturing Product Max
Stock Level
Maximum stock level
Item Inventory
Product
Manufacturing Product Max
Storage Days
Maximum storage period in days
Item Inventory
Product
Manufacturing Product Min
Lot Size
Minimum lot size
Item Inventory
Product
Manufacturing Product
MRP Group
Planning group Code
Item Inventory
Product
Manufacturing Product
MRP Group Description
Planning group description
Item Inventory
Product
Manufacturing Product
MRP Profile
Planning profile Code
Item Inventory
Product
Manufacturing Product
MRP Profile Description
Planning profile description
Item Inventory
Product
Manufacturing Product
MRP Time Fence
Planning time fence
Item Inventory
Product
Manufacturing Product
MRP Type
Planning type Code
Item Inventory
Product
Manufacturing Product
MRP Type Description
Planning type description
Item Inventory
Product
Manufacturing Product
Place Of Manufacture
Place of manufacturing
Item Inventory
Product
Manufacturing Product
Planner
Planner Code
Item Inventory
Product
Manufacturing Product
Planner Name
Planner Name
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
21/174
Presentation Table Presentation Column Description
Item Inventory
Product
Manufacturing Product
Procurement Type
Procurement Type Code
Item InventoryProduct
Manufacturing ProductProcurement Type Name
Procurement Type Description
Item Inventory
Product
Manufacturing Product
Profit Center Name
Profit center name
Item Inventory
Product
Manufacturing Product
Profit Center Number
Profit center number
Item Inventory
Product
Manufacturing Product QA
Inspection Flag
QA Inspection Indicator
Item Inventory
Product
Manufacturing Product
Reorder Point
Reorder point quantity (If the stock falls belowthis quantity, the system flags the material for
requirements planning).
Item Inventory
Product
Manufacturing Product
Repetitive Manufacturing
Flag
Repetitive manufacturing Indicator
Item Inventory
Product
Manufacturing Product
Special Procurement Type
Special Procurement Type Code
Item Inventory
Product
Manufacturing Product
Special Procurement Type
Description
Special Procurement Type Description
Item Inventory
Product Plant Safety Stock
This is a product's safety stock level for a
plant. The safety stock level helps to maintain
sufficient on hand inventory to prevent stock-
outs during replenishment cycles.
Component
Product Product Number
Component Product Number
Component
Product Product Name
Name of the Component Product
Component
Product Product Type
Type of the Component Product
Component
Product Product Type Code
This code identifies the Component Product
Type
Component
Product Product Type Description
This is the description portion of the
Component Product Type Code.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
22/174
Presentation Table Presentation Column Description
Component
Product Product Group
This is the Component Product Group code.
Component Products with similar attributes
can be grouped.
Component
Product Product Group Description
This is the description of the Component
Product group code.
Component
Product
Product Hierarchy 1
Number
This column is for storing a hierarchy code
Component
Product Product Hierarchy 1 Name
This column is for storing the description that
corresponds to the hierarchy code.
Component
Product
Product Hierarchy 2
Number
This column is for storing a hierarchy code
Component
Product Product Hierarchy 2 Name
This column is for storing the description that
corresponds to the hierarchy code.
Component
Product
Product Hierarchy 3
Number
This column is for storing a hierarchy code
Component
Product Product Hierarchy 3 Name
This column is for storing the description that
corresponds to the hierarchy code.
Component
Product
Product Hierarchy 4
Number
This column is for storing a hierarchy code
Component
Product Product Hierarchy 4 Name
This column is for storing the description that
corresponds to the hierarchy code.
Component
Product
Product Hierarchy 5
Number
This column is for storing a hierarchy code
Component
Product Product Hierarchy 5 Name
This column is for storing the description that
corresponds to the hierarchy code.
Component
Product
Product Hierarchy 6
Number
This column is for storing a hierarchy code
Component
Product Product Hierarchy 6 Name
This column is for storing the description that
corresponds to the hierarchy code.
Component
Product Brand
Brand of the Component Product
Component
Product Color Color of the Component Product
Component
Product Configurable Product Flag
This indicates whether the Component
Product is configurable or not.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
23/174
Presentation Table Presentation Column Description
Component
Product Configuration Category This code identifies the configuration category
ComponentProduct Discontinuation Date
This is the date on which the ComponentProduct was discontinued from the market.
Component
Product Division This code identifies the division
Component
Product Make Buy Flag
This indicates whether the Component
Product is made in the organization or bought
by the organization. Possible values includes
'M', 'B'.
Component
Product Product Repurchase Period
This is the expected period between the
purchases of a Component Product. It is used
for sensitivity and profile styles of analysis.
The repurchase period is stored in monthly
units.
Component
Product Sales UOM
This is a sales unit of measure code to
measure the Component Product sold.
Component
Product Sales UOM Desc Description of the Sales UOM Code.
ComponentProduct Shelf Life This is the shelf life of the Component product
Component
Product Source Of Supply
A field for determining any unique sources of
supply for the Component Product - internal
or external.
Component
Product Standard UOM Code
This is the Standard unit of measure code in
which the Component Product is managed.
ComponentInventory Product Product Number Component Inventory Product Number
Component
Inventory Product
Manufacturing Product ABC
Flag
Indicator that classifies a material as an A, B,
or C part according to its consumption value.
Component
Inventory Product
Manufacturing Product
Back flush Flag
Determines whether the back flush indicator is
set in the production order.
Component
Inventory Product
Manufacturing Product Bulk
Item Flag Bulk item Indicator
ComponentInventory Product
Manufacturing ProductBuyer Buyer Code
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
24/174
Presentation Table Presentation Column Description
Component
Inventory Product
Manufacturing Product
Buyer Name Buyer Name
ComponentInventory Product
Manufacturing ProductCommodity Commodity Code
Component
Inventory Product
Manufacturing Product
Commodity Description Commodity Name
Component
Inventory Product
Manufacturing Product
Commodity UOM Unit of measure of commodity
Component
Inventory Product
Manufacturing Product
Commodity UOM Name Unit of measure of commodity
ComponentInventory Product
Manufacturing ProductExternal Procurement Time
Time needed to obtain the material or serviceif it is procured externally.
Component
Inventory Product
Manufacturing Product
External Storage Location External storage location Code
Component
Inventory Product
Manufacturing Product
External Storage Location
Name External storage location description
Component
Inventory Product
Manufacturing Product
Fixed Lot Size Fixed lot size
Component
Inventory Product
Manufacturing Product
Forecast Period Forecast period (Like Weekly , Monthly etc)
Component
Inventory Product
Manufacturing Product
Internal Storage Location Internal manufacturing time
Component
Inventory Product
Manufacturing Product
Internal Storage Location
Name Internal storage location Code
Component
Inventory Product
Manufacturing Product
Internal Manufacturing
Time Internal storage location description
Component
Inventory Product
Manufacturing Product
Issue UOM Unit of measure in issues
Component
Inventory Product
Manufacturing Product
Issue UOM Description Description of unit of measure in issues
Component
Inventory Product
Manufacturing Product
Loading Type Loading type Code
Component Manufacturing Product Loading type Name
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
25/174
Presentation Table Presentation Column Description
Inventory Product Loading Type Name
Component
Inventory Product
Manufacturing Product Lot
Ordering Cost Cost of ordering a lot
Component
Inventory Product
Manufacturing Product Lot
Size Lot size Code
Component
Inventory Product
Manufacturing Product Lot
Size Name Lot size description
Component
Inventory Product
Manufacturing Product
Place Of Manufacture Unit of measure in manufacturing
Component
Inventory Product
Manufacturing Product Max
Lot Size
Description of unit of measure in
manufacturing
Component
Inventory Product
Manufacturing Product Max
Stock Level Maximum lot size
Component
Inventory Product
Manufacturing Product Max
Storage Days Maximum stock level
Component
Inventory Product
Manufacturing Product
Manufacturing UOM Maximum storage period in days
Component
Inventory Product
Manufacturing Product
Manufacturing UOM
Description Minimum lot size
Component
Inventory Product
Manufacturing Product Min
Lot Size Planning group Code
Component
Inventory Product
Manufacturing Product
MRP Group Planning group description
Component
Inventory Product
Manufacturing Product
MRP Group Description Planning profile Code
Component
Inventory Product
Manufacturing Product
MRP Profile Planning profile description
Component
Inventory Product
Manufacturing Product
MRP Profile Description Planning time fence
Component
Inventory Product
Manufacturing Product
MRP Time Fence Planning type Code
Component
Inventory Product
Manufacturing Product
MRP Type Planning type description
Component Manufacturing Product Place of manufacturing
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
26/174
Presentation Table Presentation Column Description
Inventory Product MRP Type Description
Component
Inventory Product
Manufacturing Product
Planner Planner Code
Component
Inventory Product
Manufacturing Product
Planner Name Planner Name
Component
Inventory Product
Manufacturing Product
Procurement Type Procurement Type Code
Component
Inventory Product
Manufacturing Product
Procurement Type Name Procurement Type Description
Component
Inventory Product
Manufacturing Product
Profit Center Name Profit center name
Component
Inventory Product
Manufacturing Product
Profit Center Number Profit center number
Component
Inventory Product
Manufacturing Product QA
Inspection Flag QA Inspection Indicator
Component
Inventory Product
Manufacturing Product
Reorder Point
Reorder point quantity (If the stock falls below
this quantity, the system flags the material for
requirements planning).
Component
Inventory Product
Manufacturing Product
Repetitive Manufacturing
Flag Repetitive manufacturing Indicator
Component
Inventory Product
Manufacturing Product
Special Procurement Type Special Procurement Type Code
Component
Inventory Product
Manufacturing Product
Special Procurement Type
Description Special Procurement Type Description
Lot Lot Number Number identifier assigned to the Lot
Lot Supplier Lot Number
Applicable for procured item, it is the lot
number assigned by the supplier.
Lot Description Description of the Item Lot
Lot Item Size Item Size
Lot Grade Code Grade Code of the Item Lot
Lot Color Color of the Item Lot
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
27/174
Presentation Table Presentation Column Description
Lot Length Length specification of the Lot
Lot Thickness Thickness specification of the Lot
Lot Volume Volume specification of the Lot
Lot Width Width specification of the Lot
Lot Length UOM Length specification of the Lot
Lot Origination Date Date when the lot was manufactured
Lot Thickness UOM Unit of Measure for thickness
Lot Volume UOM Unit of Measure for volume
Lot Width UOM Unit of Measure for width
Project Project Name
User-defined name that uniquely identifies the
project.
Project Project Number
The project number that uniquely identifies
the project. The project number can be user-
entered or system-generated as defined in the
implementation options.
Project Project Type Name
The name of the project type that classifiesthe project and defaults project information
upon project entry.
Project Project Status Name The status name of the project
Project Project Start Date
The date on which the project starts;
expenditure items with item dates before the
start date cannot be entered for the project.
Project Project Close Date
The date that the project was closed by
changing the project status to Closed.
Task Actual Finish Date
Actual Finish Date of the Project task for which
quality plan is defined.
Task Actual Start Date
Actual Start Date of the Project task for which
quality plan is defined.
Task Scheduled Finish Date
Scheduled Finish Date of the Project task for
which quality plan is defined.
Task Scheduled Start Date Scheduled Start Date of the Project task for
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
28/174
Presentation Table Presentation Column Description
which quality plan is defined.
Task Task Completion Date Task Completion Date
Task Task Name
Name of the Project task for which quality
plan is defined.
Task Task Number Task number for which quality plan is defined.
Task Task Start Date Task Start Date
Task Task Status Name
Status of the task for which quality plan is
defined.
Task Task Type
Type of the task for which the quality plan is
defined.
Resource Resource Name Name of the Resource
Resource Resource Description Resource Description
Resource Department Code
Identifier of the Department which owns the
resource.
Resource Department Name
Name of the Department which owns the
resource.
Resource Resource Group
Identifier of the Resource Group which owns
the resource.
Resource Resource Group Description
Name of the Resource Group which owns the
resource.
Resource Resource Type Type of the resource
Sales Order Promise Date
Date which was promised to the customer for
Sales Order execution.
Sales Order Request Date
Date which was requested by the customer for
Sales Order execution.
Sales Order Sales Order Number Sales Order number
Sales Order Scheduled Ship Date
Date on which the Sales Order is scheduled to
be shipped.
Scrap Reason Reason CodeReason code assigned when item wasscrapped
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
29/174
Presentation Table Presentation Column Description
Scrap Reason Reason Code Description Description of the scrap reason code
Work Order Work Order Number Work Order Number
Work Order Parent Work Order
The Work Order which led to the creation of
the present Work Order.
Work Order Work Order Status Status of Work Order
Work Order Work Order Type Work Order Type
Work Order Work Order Class Work Order Class
Work Order Bom Revision BOM revision for the primary assembly
Work Order Actual Start Date Actual Start Date of the Work Order
Work Order Actual Completion Date Actual Completion Date of the Work Order
Work Order Alternate Bom Designator Alternate bill of material used in a job
Work Order
Alternate Routing
Designator Alternate routing used in a job
Work Order Bom Revision Date
Date of assembly item revision used to
explode the bills of material used in the job.
Work Order Planned Start Date Planned Start Date of the Work Order
Work Order Due Date Due date for the Work Order
Work Order Planned Completion Date Planned Completion Date of the Work Order
Work Order Closed Date Date when the Work Order is closed
Work Order Actual
Completion Date Year
Year, per Gregorian Calendar, when the Work
Order is actually completed. It is derived from
the Actual Completion Date for the Work
Order.
Work Order Actual
Completion Date Quarter
Quarter, per Gregorian Calendar, when the
Work Order is actually completed. It is derived
from the Actual Completion Date for the Work
Order.
Work Order Actual
Completion Date Month
Month, per Gregorian Calendar, when the
Work Order is actually completed. It is derived
from the Actual Completion Date for the Work
Order.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
30/174
Presentation Table Presentation Column Description
Work Order Actual
Completion Date Week
Week, per Gregorian Calendar, when the
Work Order is actually completed. It is derived
from the Actual Completion Date for the Work
Order.
Work Order Actual
Completion Date Date
Date, per Gregorian Calendar, when the Work
Order is actually completed.
Work Order Actual
Completion Date Enterprise Year
Year, per Enterprise Calendar, when the Work
Order is actually completed. It is derived from
the Actual. Completion Date for the Work
Order
Work Order Actual
Completion Date Enterprise Quarter
Quarter, per Enterprise Calendar, when the
Work Order is actually completed. It is derivedfrom the Actual Completion Date for the Work
Order.
Work Order Actual
Completion Date Enterprise Period
Period, per Enterprise Calendar, when the
Work Order is actually completed. It is derived
from the Actual Completion Date for the Work
Order.
Work Order Actual
Completion Date Enterprise Week
Week, per Enterprise Calendar, when the
Work Order is actually completed. It is derived
from the Actual Completion Date for the Work
Order.
Work Order Actual
Start Date Year
Year, per Gregorian Calendar, when the Work
Order is actually started. It is derived from the
Actual Start Date for the Work Order.
Work Order Actual
Start Date Quarter
Quarter, per Gregorian Calendar, when the
Work Order is actually started. It is derived
from the Actual Start Date for the Work Order.
Work Order Actual
Start Date Month
Month, per Gregorian Calendar, when the
Work Order is actually started. It is derived
from the Actual Start Date for the Work Order.
Work Order Actual
Start Date Week
Week, per Gregorian Calendar, when the
Work Order is actually started. It is derived
from the Actual Start Date for the Work Order.
Work Order Actual
Start Date Date
Date, per Gregorian Calendar, when the Work
Order is actually started.
Work Order ActualStart Date Enterprise Year
Year, per Enterprise Calendar, when the WorkOrder is actually started. It is derived from the
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
31/174
Presentation Table Presentation Column Description
Actual Start Date for the Work Order.
Work Order ActualStart Date Enterprise Quarter
Quarter, per Enterprise Calendar, when the
Work Order is actually started. It is derivedfrom the Actual Start Date for the Work Order.
Work Order Actual
Start Date Enterprise Period
Period, per Enterprise Calendar, when the
Work Order is actually started. It is derived
from the Actual Start Date for the Work Order.
Work Order Actual
Start Date Enterprise Week
Week, per Enterprise Calendar, when the
Work Order is actually started. It is derived
from the Actual Start Date for the Work Order.
Work Order Closed
Date Year
Year, per Gregorian Calendar, when the Work
Order is actually closed. It is derived from the
Closed Date for the Work Order.
Work Order Closed
Date Quarter
Quarter, per Gregorian Calendar, when the
Work Order is actually closed. It is derived
from the Closed Date for the Work Order.
Work Order Closed
Date Month
Month, per Gregorian Calendar, when the
Work Order is actually closed. It is derived
from the Closed Date for the Work Order.
Work Order Closed
Date Week
Week, per Gregorian Calendar, when the
Work Order is actually closed. It is derived
from the Closed Date for the Work Order.
Work Order Closed
Date Date
Date, per Gregorian Calendar, when the Work
Order is actually closed.
Work Order Closed
Date Enterprise Year
Year, per Enterprise Calendar, when the Work
Order is actually closed. It is derived from the
Closed Date for the Work Order.
Work Order Closed
Date Enterprise Quarter
Quarter, per Enterprise Calendar, when the
Work Order is actually closed. It is derived
from the Closed Date for the Work Order.
Work Order Closed
Date Enterprise Period
Period, per Enterprise Calendar, when the
Work Order is actually closed. It is derived
from the Closed Date for the Work Order.
Work Order Closed
Date Enterprise Week
Week, per Enterprise Calendar, when the
Work Order is actually closed. It is derived
from the Closed Date for the Work Order.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
32/174
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
33/174
Presentation Table Presentation Column Description
Planned
Completion Date
Order is planned to be completed.
Work Order
Planned
Completion Date Enterprise Year
Year, per Enterprise Calendar, when the Work
Order is planned to be completed. It is derived
from the Planned Completion Date for the
Work Order.
Work Order
Planned
Completion Date Enterprise Quarter
Quarter, per Enterprise Calendar, when the
Work Order is planned to be completed. It is
derived from the Planned Completion Date for
the Work Order.
Work Order
PlannedCompletion Date Enterprise Period
Period, per Enterprise Calendar, when the
Work Order is planned to be completed. It is
derived from the Planned Completion Date forthe Work Order.
Work Order
Planned
Completion Date Enterprise Week
Week, per Enterprise Calendar, when the
Work Order is planned to be completed. It is
derived from the Planned Completion Date for
the Work Order.
Work Order
Planned Start Date Year
Year, per Gregorian Calendar, when the Work
Order is planned to be started. It is derived
from the Planned Start Date for the Work
Order.
Work Order
Planned Start Date Quarter
Quarter, per Gregorian Calendar, when the
Work Order is planned to be started. It is
derived from the Planned Start Date for the
Work Order.
Work Order
Planned Start Date Month
Month, per Gregorian Calendar, when the
Work Order is planned to be started. It is
derived from the Planned Start Date for the
Work Order.
Work Order
Planned Start Date Week
Week, per Gregorian Calendar, when the
Work Order is planned to be started. It is
derived from the Planned Start Date for the
Work Order.
Work Order
Planned Start Date Date
Date, per Gregorian Calendar, when the Work
Order is planned to be started.
Work Order
Planned Start Date Enterprise Year
Year, per Enterprise Calendar, when the Work
Order is planned to be started. It is derivedfrom the Planned Start Date for the Work
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
34/174
Presentation Table Presentation Column Description
Order.
Work Order
Planned Start Date Enterprise Quarter
Quarter, per Enterprise Calendar, when theWork Order is planned to be started. It is
derived from the Planned Start Date for the
Work Order.
Work Order
Planned Start Date Enterprise Period
Period, per Enterprise Calendar, when the
Work Order is planned to be started. It is
derived from the Planned Start Date for the
Work Order.
Work Order
Planned Start Date Enterprise Week
Week, per Enterprise Calendar, when the
Work Order is planned to be started. It is
derived from the Planned Start Date for the
Work Order.
Standard
Operations Operation Code Standard Operation Code
Standard
Operations Operation Description
Description assigned to the Standard
Operation
Operation
Sequence Number
Operation Sequence
Number
Sequence Number assigned to the Operation
in routing.
Fact - Inventory
Balance Available Quantity
Quantity of inventory available for
consumption.
Fact - Inventory
Balance Available Amount
Amount of inventory available for
consumption.
Fact - Inventory
Balance In Transit Quantity Quantity of inventory lying in Transit
Fact - Inventory
Balance In Transit Amount Amount of inventory lying in Transit.
Fact - Inventory
Balance Wip Amount
Amount of inventory issued to WIP
transaction and not yet consumed.
Fact - Material
Analysis
Standard Material Usage
Quantity
Quantity of material planned for consumption
as per BOM and routing definition.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
35/174
Presentation Table Presentation Column Description
Fact - Material
Analysis
Standard Material Usage
Value
Value of material planned for consumption as
per BOM and routing definition.
Fact - MaterialAnalysis
Actual Material UsageQuantity
Actual Quantity of material consumed duringproduction.
Fact - Material
Analysis
Actual Material Usage
Value
Actual Value of material consumed during
production.
Fact - Material
Analysis
Standard Usage Quantity
for Actual Production
Standard Usage Quantity for Actual
Production
Fact - Material
Analysis
Standard Usage Value for
Actual Production Standard Usage Value for Actual Production
Fact - MaterialAnalysis
Actual Assembly ProductionQuantity Actual quantity of Item produced
Fact - Material
Analysis
Planned Assembly
Production Quantity Quantity of Item planned for production
Fact - Material
Analysis
Material Usage Variance
(Value)
Difference between the Planned and Actual
material usage (value terms).
Fact - Material
Analysis
Material Usage Variance
(Quantity)
Difference between the Planned and Actual
material usage.
Fact - Production
Costs and Variances Material Cost Standard The material cost planned to be incurred.
Fact - Production
Costs and Variances Material Cost Actual Actual material cost incurred.
Fact - Production
Costs and Variances Material Cost Variance
The difference between the planned and
actual material cost.
Fact - Production
Costs and Variances Material Cost Variance %
The percentage of planned material cost
which was incurred out of plan
Fact - Production
Costs and Variances
Material Overhead Cost
Standard
The material overhead cost planned to be
incurred.
Fact - Production
Costs and Variances
Material Overhead Cost
Actual Actual material overhead cost incurred.
Fact - Production
Costs and Variances
Material Overhead Cost
Variance
The difference between the planned and
actual material overhead cost.
Fact - Production
Costs and Variances
Material Overhead Cost
Variance %
The percentage of planned material overhead
cost which was incurred out of plan.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
36/174
Presentation Table Presentation Column Description
Fact - Production
Costs and Variances
Outside Processing Cost
Standard
The cost planned to be incurred due to some
Outside Processing activity.
Fact - ProductionCosts and Variances
Outside Processing CostActual Actual Outside Processing cost incurred.
Fact - Production
Costs and Variances
Outside Processing Cost
Variance
The difference between the planned and
actual Outside Processing cost.
Fact - Production
Costs and Variances
Outside Processing Cost
Variance %
The percentage of planned Outside Processing
cost which was incurred out of plan.
Fact - Production
Costs and Variances Overhead Cost Standard The Overhead cost planned to be incurred.
Fact - ProductionCosts and Variances Overhead Cost Actual Actual Overhead cost incurred.
Fact - Production
Costs and Variances Overhead Cost Variance
The difference between the planned and
actual Overhead cost.
Fact - Production
Costs and Variances Overhead Cost Variance %
The percentage of planned Overhead cost
which was incurred out of plan.
Fact - Production
Costs and Variances Resource Cost Standard The Resource cost planned to be incurred.
Fact - ProductionCosts and Variances Resource Cost Actual Actual Resource cost incurred.
Fact - Production
Costs and Variances Resource Cost Variance
The difference between the planned and
actual Resource cost.
Fact - Production
Costs and Variances Resource Cost Variance %
The percentage of planned Resource cost
which was incurred out of plan.
Fact - Production
Costs and Variances Manufacturing Cost Actual
Total manufacturing cost planned to be
incurred within a period.
Fact - ProductionCosts and Variances
Manufacturing CostStandard Actual manufacturing cost incurred.
Fact - Production
Costs and Variances
Manufacturing Cost
Variance
The difference between the planned and
actual manufacturing cost.
Fact - Production
Costs and Variances
Manufacturing Cost
Variance %
The percentage of planned manufacturing cost
which was incurred out of plan.
Fact - Production
Costs and Variances
% Chg Month Ago Material
Cost
This metric is computed as (Difference
between Material Actual and Month Ago
Material Cost/Month Ago Material Cost)*100.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
37/174
Presentation Table Presentation Column Description
Fact - Production
Costs and Variances
% Chg Month Ago Material
Overhead Cost
This metric is computed as (Difference
between Material Overhead Actual and Month
Ago Material Overhead Cost/Month Ago
Material Overhead Cost)*100.
Fact - Production
Costs and Variances
% Chg Month Ago Outside
Processing Cost
This metric is computed as (Difference
between Outside Processing Actual and
Month Ago Outside Processing Cost/Month
Ago Outside Processing Cost)*100.
Fact - Production
Costs and Variances
% Chg Month Ago
Overhead Cost
This metric is computed as (Difference
between Overhead Actual and Month Ago
Overhead Cost/Month Ago Overhead
Cost)*100.
Fact - Production
Costs and Variances
% Chg Month Ago Resource
Cost
This metric is computed as (Difference
between Resource Actual and Month Ago
Resource Cost/Month Ago Resource
Cost)*100.
Fact - Production
Costs and Variances
% Chg Quarter Ago Material
Cost
This metric is computed as (Difference
between Material Actual and Month Ago
Material Cost/Quarter Ago Material
Cost)*100.
Fact - Production
Costs and Variances
% Chg Quarter Ago Material
Overhead Cost
This metric is computed as (Difference
between Material Overhead Actual and Month
Ago Material Overhead Cost/Quarter Ago
Material Overhead Cost)*100.
Fact - Production
Costs and Variances
% Chg Quarter Ago Outside
Processing Cost
This metric is computed as (Difference
between Outside Processing Actual and
Month Ago Outside Processing Cost/Quarter
Ago Outside Processing Cost)*100.
Fact - ProductionCosts and Variances
% Chg Quarter AgoOverhead Cost
This metric is computed as (Difference
between Overhead Actual and Month Ago
Overhead Cost/Quarter Ago OverheadCost)*100.
Fact - Production
Costs and Variances
% Chg Quarter Ago
Resource Cost
This metric is computed as (Difference
between Resource Actual and Month Ago
Resource Cost/Quarter Ago Resource
Cost)*100.
Fact - Production
Costs and Variances
% Chg Year Ago Material
Cost
This metric is computed as (Difference
between Material Actual and Month Ago
Material Cost/Year Ago Material Cost*100.
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
38/174
Presentation Table Presentation Column Description
Fact - Production
Costs and Variances
% Chg Year Ago Material
Overhead Cost
This metric is computed as (Difference
between Material Overhead Actual and Month
Ago Material Overhead Cost/Year Ago
Material Overhead Cost*100.
Fact - Production
Costs and Variances
% Chg Year Ago Outside
Processing Cost
This metric is computed as (Difference
between Outside Processing Actual and
Month Ago Outside Processing Cost/Year Ago
Outside Processing Cost*100.
Fact - Production
Costs and Variances
% Chg Year Ago Overhead
Cost
This metric is computed as (Difference
between Overhead Actual and Month Ago
Overhead Cost/Year Ago Overhead Cost*100.
Fact - Production
Costs and Variances
% Chg Year Ago Resource
Cost
This metric is computed as (Differencebetween Resource Actual and Month Ago
Resource Cost/Year Ago Resource Cost*100.
Fact - Production
Costs and Variances
Chg Month Ago Material
Cost
Difference between Material Actual and
Month Ago Material Cost.
Fact - Production
Costs and Variances
Chg Month Ago Material
Overhead Cost
Difference between Material Overhead Actual
and Month Ago Material Overhead Cost.
Fact - Production
Costs and Variances
Chg Month Ago Outside
Processing Cost
Difference between Outside Processing Actual
and Month Ago Outside Processing Cost.
Fact - Production
Costs and Variances
Chg Month Ago Overhead
Cost
Difference between Overhead Actual and
Month Ago Overhead Cost.
Fact - Production
Costs and Variances
Chg Month Ago Resource
Cost
Difference between Resource Actual and
Month Ago Resource Cost.
Fact - Production
Costs and Variances
Chg Quarter Ago Material
Cost
Difference between Material Actual and
Quarter Ago Material Cost.
Fact - Production
Costs and Variances
Chg Quarter Ago Material
Overhead Cost
Difference between Material Overhead Actual
and Quarter Ago Material Overhead Cost.
Fact - Production
Costs and Variances
Chg Quarter Ago Outside
Processing Cost
Difference between Outside Processing Actual
and Quarter Ago Outside Processing Cost.
Fact - Production
Costs and Variances
Chg Quarter Ago Overhead
Cost
Difference between Overhead Actual and
Quarter Ago Overhead Cost.
Fact - Production
Costs and Variances
Chg Quarter Ago Resource
Cost
Difference between Resource Actual and
Quarter Ago Resource Cost.
Fact - Production
Costs and Variances Chg Year Ago Material Cost
Difference between Material Actual and Year
Ago Material Cost.
Fact - Production Chg Year Ago Material Difference between Material Overhead Actual
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
39/174
Presentation Table Presentation Column Description
Costs and Variances Overhead Cost and Year Ago Material Overhead Cost.
Fact - Production
Costs and Variances
Chg Year Ago Outside
Processing Cost
Difference between Outside Processing Actual
and Year Ago Outside Processing Cost.
Fact - Production
Costs and Variances
Chg Year Ago Overhead
Cost
Difference between Overhead Cost Actual and
Year Ago Overhead Cost.
Fact - Production
Costs and Variances Chg Year Ago Resource Cost
Difference between Resource Cost Actual and
Year Ago Resource Cost.
Fact - Production
Costs and Variances Month Ago Material Cost Material Cost of the work order last month
Fact - Production
Costs and Variances
Month Ago Material
Overhead Cost
Material Overhead Cost of the work order last
month.
Fact - Production
Costs and Variances
Month Ago Outside
Processing Cost
Outside Processing Cost of the work order last
month.
Fact - Production
Costs and Variances Month Ago Overhead Cost Overhead Cost of the work order last month
Fact - Production
Costs and Variances Month Ago Resource Cost Resource Cost of the work order last month
Fact - Production
Costs and Variances Quarter Ago Material Cost Material Cost of the work order last quarter
Fact - Production
Costs and Variances
Quarter Ago Material
Overhead Cost
Material Overhead Cost of the work order last
quarter.
Fact - Production
Costs and Variances
Quarter Ago Outside
Processing Cost
Outside Processing Cost of the work order last
quarter
Fact - Production
Costs and Variances Quarter Ago Overhead Cost Overhead Cost of the work order last quarter
Fact - Production
Costs and Variances Quarter Ago Resource Cost Resource Cost of the work order last quarter
Fact - Production
Costs and Variances
Quarter Ago Manufacturing
Cost
Manufacturing Cost of the work order last
quarter
Fact - Production
Costs and Variances Year Ago Material Cost Material Cost of the work order last year
Fact - Production
Costs and Variances
Year Ago Material
Overhead Cost
Material Overhead Cost of the work order last
year
Fact - Production
Costs and Variances
Year Ago Outside
Processing Cost
Outside Processing Cost of the work order last
year
-
8/14/2019 Biapps_7963_Ex_User_Guide_MA.zip - Oracle Business Intelligence Applications Users Guide for Manufacturing Analytics Release 7.9.6.3 Extension Pack
40/174
Presentation Table Presentation Column Description
Fact - Production
Costs and Variances Year Ago Resource Cost Resource Cost of the work order last year
Fact - ProductionCosts and Variances Year Ago Overhead Cost Overhead Cost of the work order last year
Fact - Production
Performance and
Backlog Actual Production Quantity Actual Production Q