1. Customer Contact Center
a. Build Customer Contact
2. Service Request
a. Service Request Creation
b. Task Creation
c. Knowledge Management
3. Task Dispatch
a. Dispatch Scheduling
b. Parts Request
4. Task Debrief
a. Material
b. Labor
c. Overheads
5. Charges
a. Warranty
b. Revenue
will post screen shots with some Mandatory setup steps
The user types invalid serial number while transacting a move order during pick release.
User type serial number ABC116 of item ABC but they want to dispatch Serial number ABC161. Now the order is picked and ready to ship, but the wrong serial number is associated to the order.
Here are the steps to correct the serial number:
1. Go to shipping transactions form.
2. Set shipped quantity to 0.
3. Go to Inventory > Transactions > Sub inventory transfer:
4. Sub inventory transfer the correct serial number from your warehouse to your staging sub inventory.
5. Sub inventory transfer the wrong serial Number ABC116 from the staging sub inventory to the warehouse.
6. Return to the shipping transactions form.
7. Change sales order to the amount shipped and 0 backordered
8. Go to the Inventory Details tab or Tools > Serial Numbers.
9. Choose the Correct Serial Number ABC161
10. Perform sales order issue order.
Reference Metalink.Oracle.com
Run following query by connecting User APPS
SELECT id_flex_structure_code structure_code,
DECODE (dynamic_inserts_allowed_flag,
‘Y’, ‘OK: Dynamic’,
‘ERROR: No Dynamic’
) dynamic,
DECODE (freeze_flex_definition_flag,
‘Y’, ‘OK: Freezed’,
‘ERROR: No Freezed’
) freeze,
segment_num seg_number, segment_name seg_name,
DECODE (required_flag,
‘Y’, ‘OK: Required’,
‘ERROR: No required’
) required,
DECODE (fvs.flex_value_set_name,
NULL, ‘NULL’,
fvs.flex_value_set_name
) value_set,
DECODE (fvs.validation_type,
‘N’, ‘OK: No validation’,
‘ERROR: ‘ || fvs.validation_type
) VALIDATION,
DECODE (fvs.uppercase_only_flag,
‘N’, ‘OK: No’,
‘ERROR: Uppercase Only’
) uppercase_only,
DECODE (alphanumeric_allowed_flag,
‘Y’, ‘OK: Allowed’,
‘ERROR: Not Allowed’
) alphanumeric,
DECODE (numeric_mode_enabled_flag,
‘N’, ‘OK:Not justified’,
‘ERROR: Justified’
) right_justify,
DECODE (format_type,
‘C’, ‘OK: Char’,
‘ERROR: ‘ || format_type
) format_type
FROM fnd_id_flex_structures_vl ffst,
fnd_id_flex_segments_vl ffsg,
fnd_flex_value_sets fvs
WHERE ffst.application_id = 401
AND ffst.id_flex_code = ‘MKTS’
AND ffst.enabled_flag = ‘Y’
AND ffst.application_id = ffsg.application_id
AND ffst.id_flex_code = ffsg.id_flex_code
AND ffst.id_flex_num = ffsg.id_flex_num
AND ffsg.enabled_flag = ‘Y’
AND fvs.flex_value_set_id(+) = ffsg.flex_value_set_id;
Following query returns Demand and reservation information used in Available To Promise, Planning and other Manufacturing functions.
There are three major row types stored in the table
· Summary Demand rows
· Open Demand Rows
· Reservation Rows.
SELECT SUBSTR (md.demand_id, 1, 8) ID,
SUBSTR (demand_source_header_id, 1, 8) demand_source_header_id,
SUBSTR (parent_demand_id, 1, 8) parent_demand_id,
SUBSTR (demand_source_line, 1, 10) demand_source_line_id,
SUBSTR (demand_source_delivery, 1, 10) demand_source_delivery,
SUBSTR (inventory_item_id, 1, 10) “Item Id”,
(SELECT UNIQUE msi.description
FROM mtl_system_items_b msi
WHERE msi.inventory_item_id =
SUBSTR (md.inventory_item_id,
1,
10
)) “Item Description”,
SUBSTR (inventory_item_id, 1, 10) item_id,
SUBSTR (organization_id, 1, 5) organization_id,
SUBSTR (reservation_quantity, 1, 5) reservation_quantity,
SUBSTR (primary_uom_quantity, 1, 5) primary_uom_quantity,
SUBSTR (reservation_type, 1, 5) reservation_type,
SUBSTR (requirement_date, 1, 10) requirement_date,
SUBSTR (subinventory, 1, 10) subinventory,
SUBSTR (serial_number, 1, 10) srl_num,
SUBSTR (lot_number, 1, 10) lot_num
FROM mtl_demand md
What are MTO and MTS in Oracle E-Business Suite and what are there decision factor?
Make to Order (MTO)
Some manufacturing units manufacture products only against customer orders in other words job is directly associated with Sale order.
This is an example of make to order scenario. In case of make to order products manufacturing lead time need to be low enough to meet the customer requirements. Organizations may stock sub assemblies / Factory made items used in multiple finished products to enable them to satisfy customer demand within a reasonable time.
Make to Stock (MTS)
Some time Products are manufactured in advance expecting future customer orders.
This is the example of make to stock scenario. Organizations making make to stock products are almost totally dependent on planning forecast. In such cases forecast accuracy is a very important factor to maintain cost effective operations.
There are manufacturing units which has both MTO and MTS type of products
MTO & MTS Decision Factors
Depending on different factors like manufacturing lead time, product cost, market demand, competitor’s capability, storage space, change over time, change over cost etc. manufacturing organizations decide to operate the plant as MTO or MTS. The item parameters are to be set accordingly so that the recommendations provided by Advance Supply Chain Planning support MTO or MTS strategy.
Following are Interface and there respective tables Used in Oracle BOM and WIP
Oracle Bill of Material
Open Bills of Material Interface
1. BOM_BILL_OF_MTLS_INTERFACE
2. BOM_INVENTORY_COMPS_INTERFACE
3. BOM_REF_DESGS_INTERFACE
4. BOM_SUB_COMPS_INTERFACE
5. MTL_ITEM_REVISIONS_INTERFACE
Open Bills of Material Tables
1. bom_bill_of_materials
2. bom_inventory_components
3. bom_reference_designators
4. bom_substitute_components
5. mtl_item_revisions
Oracle Routing
Open Routing Interface
1. BOM_OP_ROUTINGS_INTERFACE
2. BOM_OP_SEQUENCES_INTERFACE
3. BOM_OP_RESOURCES_INTERFACE
4. MTL_RTG_ITEM_REVS_INTERFACE
Open Routing Tables
1. bom_operational_routings
2. bom_operation_sequences
3. bom_operation_resources
Order Import is an open interface that consists of open interface tables and set of API’s. By using order import you can New, updated, or changed sales orders from other applications.
Order Import can do following things for you
1. Validations
2. Defaulting
3. Processing Constraints checks
4. Applying and releasing of order holds
5. Scheduling of shipments
Order management checks all the data during the import process to ensure its validity with Order management So be prepare for anything horrible. Valid Transactions then converted into orders with lines, reservations, price adjustments, and sales credits in the OM base tables.
Following are Prerequisites for order Import
1. Setup Order Management
2. Customer Should Be Created along with bill to and ship to
3. Pricing Should Be Defined for all those items which are part of upload
4. Item Should be assigned to Inventory organization
5. Define Order Import Source
6. Payment Terms Should be Setup
7. Currency should be setup if order currency is different from SOB currency then conversion rate and conversion type should be defined
Reports on parts, expenses, and labor for a task assignment and ultimately results in updates to Inventory, Installed Base, and Charges. Reports on Counters.
From Field Service Debrief you can easily access the Capture Counter Reading functionality from Oracle Service to capture counter readings.
Offers direct access to specific Spares Management functionality such as Parts Requirements and View On hand Quantity.
Offers direct access to Notes, Calendar, or Service Request and a Pro Forma invoice
Connect to Database by user APPS and Run the Following query this will return all documents of Type AP_INVOICES
SELECT fadf.seq_num, fdctf.NAME “Catagorey Name”, fdtf.file_name,
fdltf.long_text media_data_text
FROM fnd_attached_documents fadf,
fnd_documents fdf,
fnd_documents_tl fdtf,
fnd_document_categories_tl fdctf,
fnd_documents_long_text fdltf
WHERE fadf.document_id = fdf.document_id
AND fadf.document_id = fdtf.document_id
AND fdctf.category_id = fdf.category_id
AND fdtf.media_id = fdltf.media_id
AND fdctf.user_name = ‘Invoice Internal’
AND fadf.entity_name = ‘AP_INVOICES’
AND fadf.pk1_value = ‘63227′;
