Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, August 5, 2012

Oracle R12 Inventory Changes


1.      Overview

This document describes new or changed features of the Oracle E-Business Suite Release 12 Inventory compared to those of Release 11i. It consists of information intended to assist in understanding the technical delta changes of R12 with respect to prior releases.

2.      Business process

i)                    On hand availability (Material Workbench) changes :

             This form has the major changes. Now here you can also view the Inbound and receiving quantity. Earlier you were able to view only quantity lying in inventory. Lot of new criteria’s are added to query the data. User can see item quantity across multiple operating units.

ii)                  New concept of Lot and Sub lot :

    Now you can have parent lot and child lot. Earlier you can have only lot but not child lots.

iii)                New feature of Grades :

Now you can define grades for the items and you can reserve the material against a grade in sales order.

iv)                Reservation against Serial numbers :
     
       Now you can reserve specific serial numbers. Earlier you were only able to reserve the quantity and not the serial numbers but now you can reserve the serial numbers also.

v)                  Lot level conversions :
     Now in R12 you can define UOM conversions specific to a particular lot.

vi)                Dual Unit of Measure
              Now from R12 you have Dual UOM feature where you can stock and transact in dual unit of measure.

vii)              New concept of Material Status :
You have new concept of Material status. Using it you can restrict certain operations like Subinventory transfer, Miscellaneous issue etc for specific subinventory, lot, locator etc.  
  
        viii)       Pick release rules now shared across organizations.

2.1.   Changes in the forms


Following forms are changed :
i)On-hand availability (Material Workbench) :
On-hand AvailabilityàOn-hand Quantity

New feature has been added where you can save your query which you fire frequently.New tabs are added for      search .additional view by options provided such as Serial, Grade, Lot. Also for inbound type you can view purchase order number
ii) Master Items
ItemsàMaster Items





Several new attributes are added in the item definition screen shown in above screen shots . A completely new tab as Process Manufacturing is added in the item definition screen.


iii) Organization Parameters
SetupàOrganizationsàParameters



Several New attributes are added in Organization Parameter screen which are shown in screenshots above.

iv) Reservation Window
On-hand AvailabilityàReservations
Now on reservation screen reservations can include cross dock by selecting (Include cross dock) field.Cross dock allows warehouses to increase its operational efficiency by transferring inbound material directly to an outbound area. It bypasses the inventory-holding function of a warehouse while still allowing it to serve its consolidation and shipping functions.




v) Subinventory form
SetupàOrganizationsàSubinventories
New attributes are added as shown in above screenshots.
vi) Miscellaneous transactions
Transactionsà Miscellaneous transactions
New attributes are added in the Miscellaneous transactions screen
viii)            Lots Screen
Onhand AvailabilityàLots
many new attributes are added in the find screen as well as result screen such as Retest date,maturity date,hold date, grade code,status etc.

2.2.   Changes in reports

Sr.No.
Report Name
Description Of the report
Changes Made In R12
1
Serial Number Transaction Register
Navigation:->View View  RequestàSubmit New RequestàSingle Request
This report is used for audit serial number
transactions for a specified time interval, location or group of locations,reason or group of reasons, or other criteria.

A new parameter as Organization is added in the report to retrieve serial data for the organization. If this field is blank,
the report retrieves serial data for all organizations.

2
Transaction Historical Summary Report
View  RequestàSubmit New RequestàSingle Request
The Transaction Historical Summary Report is used to report past item quantities, past item
value, or past inventory balances.

A new parameter  as Include Consigned is added in the report giving options whether user want to include consigned inventory in this report.

3
Item Definition Detail

View  RequestàSubmit New RequestàSingle Request
to view comprehensive
information for items. Use this report to verify items have been classified in conformance with decisions you have made regarding how
the parts are to be planned, costed, and located.

Three new parameters are added as the base table for item is changed. Three new parameters are as
Process Manufacturing Item Attributes
Service Item Attributes
Web Item Attributes
User can select Yes if want to print these attributes.


4
Cycle Count Entries and Adjustments Report
View  RequestàSubmit New RequestàSingle Request
Cycle Count Entries and Adjustments Report is used  to monitor inventory accuracy. The report shows counts and adjustments for the items and calculates the monetary value of the adjustments to
inventory value.

A new parameter is added as Approved Cycle Counts Only user can select Yes  to indicate whether the report includes only approved cycle counts.
5
Item Quantities Summary Report
View  RequestàSubmit New RequestàSingle Request

This report is used  to report just the item and the quantity. The report is useful to provide a fast list of the items in the inventory.
A new parameter is added as Negative Quantities Only user can select Yes  to indicate whether the report includes only Negative Quantities.
6
Supplier Lot Trace Report
View RequestàSubmit New RequestàSingle Request
The Supplier lot trace report enables you to view the lot number, and associated vendor lot number for an item.
The name of this report is changed to
Vendor Lot Trace Report.

2.3.   Changes in Tables

In R12 in several Tables New columns are added. Following are  some important tables with the changes in them.

Table Name Along with Description of changes
Changes In R12(Newly Added Columns)
MTL_MATERIAL_TRANSACTIONS
Changes in table is related to new concept of Deferred COGS which is now possible in 12. Now just after ship confirm no need to recognize COGS directly we can defer it and put it to the Deferred_COGS_Account set at the organization level. Flag to mark if the transaction is costed or not (for Process Organizations).
MTL_MATERIAL_TRANSACTIONS.SO_ISSUE_ACCOUNT_TYPE should be '2' if the Sales Order line is set for deferred revenue recognition.


COGS_RECOGNITION_PERCENT
SO_ISSUE_ACCOUNT_TYPE
OPM_COSTED_FLAG
MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_MATERIAL_TRANSACTIONS_TEMP
is the gateway for all Material transactions.
Records are processed from this table into Inventory through the transaction processor. All Inventory transaction forms write directly to this table.
Outside applications must write transaction  records to
to MTL_TRANSACTIONS_INTERFACE be processed through MTL_MATERIAL_TRANSACTIONS_TEMP
and the transaction processor by the
Transaction Worker concurrent program.
RELIEVE_HIGH_LEVEL_RSV_FLAG - Indicates whether to check for high level reservations that needs to be relieved during transaction processing.
RELIEVE_RESERVATIONS_FLAG - Indicates whether to relieve the reservations during transaction processing

RELIEVE_HIGH_LEVEL_RSV_FLAG
RELIEVE_RESERVATIONS_FLAG
SOURCE_LOT_NUMBER
TRANSFER_PRICE
TRANSFER_SECONDARY_QUANTITY
TRANSFER_SECONDARY_UOM
MTL_CYCLE_COUNT_ENTRIES
Stores the actual counts of a cycle count. A row in this table without a count is considered to be a count request. Oracle Inventory uses this information to determine and store cycle count adjustments, recounts, and approval requirements. As we know from R12 Secondary UOM concept is introduced so in this table all the changes are related to secondary UOM of inventory.

COUNT_SECONDARY_UOM_CURRENT
COUNT_SECONDARY_UOM_FIRST
COUNT_SECONDARY_UOM_PRIOR
SECONDARY_ADJUSTMENT_QUANTITY
SECONDARY_SYSTEM_QTY_CURRENT
SECONDARY_SYSTEM_QTY_FIRST
SECONDARY_SYSTEM_QTY_PRIOR
SECONDARY_UOM_QUANTITY_CURRENT
SECONDARY_UOM_QUANTITY_FIRST
SECONDARY_UOM_QUANTITY_PRIOR
MTL_INTERFACE_ERRORS
MTL_INTERFACE_ERRORS is used for error tracking of all items that the Item Interface fails. Message type to differentiate the message.

MESSAGE_TYPE
MTL_ITEM_LOCATIONS
MTL_ITEM_LOCATIONS is the definition table for stock locators.The associated attributes describe which subinventory this locator belongs
to, what the locator physical capacity is, etc.
.The locator is a key flexfield. The Flexfield Code is MTLL.
AVAILABILITY_TYPE - Subinventory availability code
INVENTORY_ATP_CODE - Inventory available to promise code
RESERVABLE_TYPE - Hard reservation eligibility
ALIAS - Short Alias for the Locator name

ALIAS
AVAILABILITY_TYPE
INVENTORY_ATP_CODE
RESERVABLE_TYPE
MTL_LOT_NUMBERS
MTL_LOT_NUMBERS stores the definition and expiration date of all lot
numbers in inventory.
Since the primary key consists of LOT_NUMBER, ORGANIZATION_ID, and
INVENTORY_ITEM_ID, a lot number could exist in more than one
organization or for different items.
SAMPLING_EVENT_ID - This is the latest OPM Quality sampling event tested against the lot.
AVAILABILITY_TYPE
EXPIRATION_ACTION_CODE
EXPIRATION_ACTION_DATE
HOLD_DATE
INVENTORY_ATP_CODE
ORIGINATION_TYPE
PARENT_LOT_NUMBER
RESERVABLE_TYPE
SAMPLING_EVENT_ID
MTL_MATERIAL_STATUS_HISTORY
MTL_MATERIAL_STATUS_HISTORY stores the status update history for subinventory, locator, lot and serial.

AVAILABILITY_TYPE - Inventory available to promise code
RESERVABLE_TYPE - Hard reservation eligibility
AVAILABILITY_TYPE
GRADE_CODE
INVENTORY_ATP_CODE
PRIMARY_ONHAND
SECONDARY_ONHAND
RESERVABLE_TYPE
MTL_MATERIAL_STATUSES_B
MTL_MATERIAL_STATUSES_B is the base table for the inventory statuses. It contains all the attributes which are not translated and don't vary by language. The defined status can be assigned to Subinventory, locator, lot and serial to restrict certain transaction types.

AVAILABILITY_TYPE - Inventory available to promise code
RESERVABLE_TYPE - Hard reservation eligibility
AVAILABILITY_TYPE
INVENTORY_ATP_CODE
RESERVABLE_TYPE


MTL_PARAMETERS
MTL_PARAMETERS maintains a set of default options like general ledger accounts; locator, lot, and serial controls; inter-organization
options; costing method; etc. for each organization defined in Oracle
Inventory.
Each organization's item master organization (MASTER_ORGANIZATION_ID)and costing organization (COST_ORGANIZATION_ID) are maintained here.
You specify which manufacturing calendar the organization will use
(CALENDAR_CODE), as well as the set of exceptions to this calendar
(CALENDAR_EXCEPTION_SET_ID).
NEGATIVE_INV_RECEIPT_CODE indicates whether this organization will
allow negative balances in inventory. It is used in the transaction
system to ensure, for example, that you do not over-issue a particular
item (if you have indicated that negative balances are not allowed).
For lot number and serial number auto-generation, you can specify
whether you want the numbers generated from defaults defined at theorganization level or the item level (LOT_NUMBER_GENERATION,SERIAL_NUMBER_GENERATION). You can also specify uniqueness
constraints for lot numbers (LOT_NUMBER_UNIQUENESS) and serial numbers
(SERIAL_NUMBER_TYPE).
Among the accounting defaults that can be defined here are valuation
accounts, receiving accounts, profit and loss accounts, and inter-
organization transfer accounts.

So all the new columns added here are the new attributes added in R12 to the organization parameter form. We have one column for each of the attribute.
ALLOW_DIFFERENT_STATUS
CHILD_LOT_ALPHA_PREFIX
CHILD_LOT_NUMBER_LENGTH
CHILD_LOT_VALIDATION_FLAG
CHILD_LOT_ZERO_PADDING_FLAG
COMMERCIAL_GOVT_ENTITY_NUMBER
COMPANY_PREFIX
COMPANY_PREFIX_INDEX
COPY_LOT_ATTRIBUTE_FLAG
CREATE_LOT_UOM_CONVERSION
DEFAULT_CROSSDOCK_CRITERIA_ID
DEFERRED_COGS_ACCOUNT
ENFORCE_LOCATOR_ALIS_UNQ_FLAG
EPC_GENERATION_ENABLED_FLAG
GENEALOGY_FORMULA_SECURITY
LABOR_MANAGEMENT_ENABLED_FLAG
PARENT_CHILD_GENERATION_FLAG
RULES_OVERRIDE_LOT_RESERVATION
TRADING_PARTNER_ORG_FLAG
YARD_MANAGEMENT_ENABLED_FLAG
MTL_SECONDARY_INVENTORIES
MTL_SECONDARY_INVENTORIES is the definition table for the
subinventory. A subinventory is a section of inventory, i.e., raw
material, finished goods, etc. Subinventories are assigned to items
(in a many to one relationship), indicating a list of valid places
where this item will physically exist in inventory.
Other attributes include general ledger accounts, demand picking
order, locator type, availability type, and reservable type.
You can also specify whether this subinventory is an expense or asset
subinventory (ASSET_INVENTORY), or whether quantities are tracked (QUANTITY_TRACKED).

ENABLE_LOCATOR_ALIAS - Indicates whether Locator Aliases are enabled for this Subinventory
ENFORCE_ALIAS_UNIQUENESS - Flag to Enforce Locator Alias Uniqueness in the Subinventory
ENABLE_LOCATOR_ALIAS
ENFORCE_ALIAS_UNIQUENESS



MTL_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS stores the definition and current status of all serial numbers in Oracle Inventory. These serial numbers are also
used in other areas of Oracle Manufacturing.
A serial number can have one of four statuses:
-Defined but not used
-Resides in stores
-Issued out of stores
-Resides in intransit

.
The serial generation program populates this table, given the number
of serial numbers to create and the starting number and prefix.

AVAILABILITY_TYPE - Subinventory availability code
RESERVABLE_TYPE - Hard reservation eligibility
DEPENDENT_ASSET_FLAG - Dependent asset flag -- Used by EAM
AVAILABILITY_TYPE
DEPENDENT_ASSET_FLAG
INVENTORY_ATP_CODE
OPERATIONAL_LOG_FLAG
OPERATIONAL_STATUS_FLAG
PARENT_LOT_NUMBER
RESERVABLE_TYPE
RESERVATION_ID
MTL_SYSTEM_ITEMS_B
As we know in R12 on the Item Master form lot of new fields are added like retest interval, Expiration Action,Process Manufacturing is the new tab and all its attributes so related to that this table is affected. All the new columns are added with respect to each new item added on the form in table also.

ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
CAS_NUMBER
CHARGE_PERIODICITY_CODE
CHILD_LOT_FLAG
CHILD_LOT_PREFIX
CHILD_LOT_STARTING_NUMBER
CHILD_LOT_VALIDATION_FLAG
COPY_LOT_ATTRIBUTE_FLAG
DEFAULT_GRADE
EGO_MASTER_ITEMS_DFF_CTX
EXPIRATION_ACTION_CODE
EXPIRATION_ACTION_INTERVAL
GRADE_CONTROL_FLAG
HAZARDOUS_MATERIAL_FLAG
HOLD_DAYS
LOT_DIVISIBLE_FLAG
MATURITY_DAYS
OUTSOURCED_ASSEMBLY
PARENT_CHILD_GENERATION_FLAG
PREPOSITION_POINT
PROCESS_COSTING_ENABLED_FLAG
PROCESS_EXECUTION_ENABLED_FLAG
PROCESS_QUALITY_ENABLED_FLAG
PROCESS_SUPPLY_LOCATOR_ID
PROCESS_SUPPLY_SUBINVENTORY
PROCESS_YIELD_LOCATOR_ID
PROCESS_YIELD_SUBINVENTORY
RECIPE_ENABLED_FLAG
REPAIR_LEADTIME
REPAIR_PROGRAM
REPAIR_YIELD
RETEST_INTERVAL
SUBCONTRACTING_COMPONENT
MTL_RESERVATIONS
This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).
CROSSDOCK_CRITERIA_ID
CROSSDOCK_FLAG
DEMAND_SHIP_DATE
DEMAND_SOURCE_LINE_DETAIL
EXCEPTION_CODE
ORIG_DEMAND_SOURCE_HEADER_ID
ORIG_DEMAND_SOURCE_LINE_DETAIL
ORIG_DEMAND_SOURCE_LINE_ID
ORIG_DEMAND_SOURCE_TYPE_ID
ORIG_SUPPLY_SOURCE_HEADER_ID
ORIG_SUPPLY_SOURCE_LINE_DETAIL
ORIG_SUPPLY_SOURCE_LINE_ID
ORIG_SUPPLY_SOURCE_TYPE_ID
PROJECT_ID
SECONDARY_DETAILED_QUANTITY
SECONDARY_RESERVATION_QUANTITY
SECONDARY_UOM_CODE
SECONDARY_UOM_ID
SERIAL_RESERVATION_QUANTITY
SUPPLY_RECEIPT_DATE
TASK_ID
MTL_TRANSACTION_TYPES
MTL_TRANSACTION_TYPES contains seeded transaction types and the user
defined ones. USER_DEFINED_FLAG will distinguish the two. The table
also stores the TRANSACTION_ACTION_ID and TRANSACTION_SOURCE_TYPE_ID
that is associated with each transaction type
.
Location_required_flag - Flag to indicate whether the Location is mandatory for the given Transaction.
LOCATION_REQUIRED_FLAG
MTL_UNIT_TRANSACTIONS
MTL_UNIT_TRANSACTIONS stores a record of every material transaction of
a serialized unit in Inventory. Records are inserted into this table
through the transaction processor.
.
.
.
Many serial numbers may be specified for a given transaction record.
TRANSACTION_ID joins to MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID when
only under serial control. TRANSACTION_ID joins to
MTL_TRANSACTION_LOT_NUMBERS.SERIAL_TRANSACTION_ID when also under lot

control. New columns all are related genealogy.
PARENT_ITEM_ID
PARENT_OBJECT_ID
PARENT_OBJECT_ID2
PARENT_OBJECT_NUMBER
PARENT_OBJECT_NUMBER2
PARENT_OBJECT_TYPE
PARENT_OBJECT_TYPE2

Following tables are newly added in R12 Inventory
INV_DIAG_MSN_TEMP
MTL_ACTIONS_B
MTL_ACTIONS_TL
MTL_CHILD_LOT_NUMBERS
MTL_COGS_RECOGNITION_TEMP
MTL_CONSUMPTION_TXN_TEMP
MTL_CROSS_REFERENCES_TL
MTL_CROSS_REFERENCES_B
MTL_GEN_TEMP
MTL_GRADES_B
MTL_GRADES_TL
MTL_INV_PACKSLIPS
MTL_INV_PICKING_RULES
MTL_ITEM_ATTRIBUTES_SEED_INFO
MTL_ITEM_BULKLOAD_RECS
MTL_ITEM_STATUS_TL
MTL_ITEM_TEMPLATES_B
MTL_ITEM_TEMPLATES_TL
MTL_LOT_CONV_AUDIT
MTL_LOT_CONV_AUDIT_DETAILS
MTL_LOT_ERES_GTMP
MTL_LOT_GRADE_HISTORY
MTL_LOT_UOM_CLASS_CONVERSIONS
MTL_LPN_ATR_QTY_GT
MTL_MOQD_BACKUP
MTL_MWB_GTMP
MTL_ONHAND_LOCK_TEMP
MTL_PICK_SLIP_NUMBERS
MTL_PO_PACKSLIPS
MTL_RMA_SERIAL_TEMP
MTL_SERIAL_NUMBERS_GT
MTL_TRANS_REASON_SECURITY
MTL_UOM_CONVERSIONS_ERES_GTMP
MTL_VMI_QUANTITIES_TEMP
WMS_CARTONIZATION_TEMP

2.4.   Changes in Interfaces

Following interfaces tables are changed in R12.
Interface Table Name
Changes In R12(Newly Added Columns)
MTL_ITEM_CATEGORIES_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE table temporarily stores data about inventory item assignments to category sets and categories before loading this information into Oracle Inventory.
This table contains user friendly columns which allow you to easily enter your data. Inventory items, category sets and categories participating in an assignment can be entered as corresponding ids or values. If ids are not entered, Oracle Inventory will convert column values to ids. For example, you enter the ORGANIZATION_CODE, ITEM_NUMBER, CATEGORY_SET_NAME, CATEGORY_NAME and Oracle Inventory will fill in the corresponding ORGANIZATION_ID, INVENTORY_ITEM_ID, CATEGORY_SET_ID, CATEGORY_ID for you. After performing the proper validation Oracle Inventory will insert a record into the MTL_ITEM_CATEGORIES table.
Description of newly added columns :
SOURCE_SYSTEM_ID - Source System Identifier(PIM)
SOURCE_SYSTEM_REFERENCE- Source System Reference (PIM)
CHANGE_ID- Change Identifier(PIM)
CHANGE_LINE_ID- Change Line Indentifier (PIM)
CHANGE_ID
CHANGE_LINE_ID
SOURCE_SYSTEM_ID
SOURCE_SYSTEM_REFERENCE
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE temporarily stores revision levels for an
inventory item before loading this information into Oracle Inventory.
This table contains user friendly columns which allow you to easily
enter your data as well as the corresponding foreign keys. Oracle
Inventory will derive column values you do not enter, after
performing the proper validation. For example, if you enter the
ORGANIZATION_CODE, Oracle Inventory will fill in the corresponding
ORGANIZATION_ID. You will need to specify the ITEM_NUMBER
column, which is the concatenation of the sytem item segments with
the correct delimiter in between. This table is used by the item
interface program in conjunction with the MTL_SYSTEM_ITEMS_INTERFACE
table.

Description of newly added columns :

SOURCE_SYSTEM_ID - Source System Identifier(PIM)
SOURCE_SYSTEM_REFERENCE- Source System Reference (PIM)
CHANGE_ID- Change Identifier(PIM)
CHANGE_LINE_ID- Change Line Indentifier (PIM).
Template_id - ItemTemplate Identifier
TEMPLATE_NAME - Item Template Name
CHANGE_ID
INTERFACE_TABLE_UNIQUE_ID
SOURCE_SYSTEM_ID
SOURCE_SYSTEM_REFERENCE
TEMPLATE_ID
TEMPLATE_NAME
MTL_SERIAL_NUMBERS_INTERFACE
This is the open interface table of serial information corresponding to
material transactions posted to Oracle Inventory.
The records in this table have a corresponding
parent record in MTL_TRANSACTIONS_INTERFACE. The records in this table
will be picked up and validated by the Transaction Manager and
then transferred to their respective temporary table for processing.
In R12 we have genealogy related enhancements also. From Serial Numbers screen we can also see the corresponding lot number if items is lot enabled and now lot genealogy can also  be seen and its serial numbers. Below columns are related to this functionality.

Description of newly added columns :

PARENT_ITEM_ID- Parent Item Identifier
PARENT_OBJECT_TYPE2- Parent Object Type2
PARENT_OBJECT_ID- Genealogy Object Identifier of the Parent entity
PARENT_OBJECT_NUMBER- Parent Object Number
PARENT_ITEM_ID
PARENT_OBJECT_ID
PARENT_OBJECT_ID2
PARENT_OBJECT_NUMBER
PARENT_OBJECT_NUMBER2
PARENT_OBJECT_TYPE
PARENT_OBJECT_TYPE2
MTL_SYSTEM_ITEMS_INTERFACE
MTL_SYSTEM_ITEMS_INTERFACE temporarily stores the definitions for
inventory items, engineering items and purchasing items before loading
this information into Oracle Inventory.
.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. Oracle
Inventory will default column values you do not enter, after
performing the proper validation. For example, you enter the
ORGANIZATION_CODE, and Oracle Inventory will fill in the corresponding
ORGANIZATION_ID for you. It is strongly recommended that users enter
the segment information for the item instead of the item number.
.
You can also specifiy a TEMPLATE_ID to copy item attributes from.
.
Also, if you enter REVISION, Oracle Inventory will insert a record
into MTL_ITEM_REVISIONS for your item.

As we know in R12 on the Item Master form lot of new fields are added like retest interval, Expiration Action,Process Manufacturing is the new tab and all its attributes so related to that this table is affected. All the new columns are added with respect to each new item added on the form in Interface table also.

Also for DFF where we were having only 15 attributes now it has extended to 30 so attribute16 to 30 are added.
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
CAS_NUMBER
CHANGE_ID
CHANGE_LINE_ID
CHARGE_PERIODICITY_CODE
CHILD_LOT_FLAG
CHILD_LOT_PREFIX
CHILD_LOT_STARTING_NUMBER
CHILD_LOT_VALIDATION_FLAG
CONFIRM_STATUS
COPY_LOT_ATTRIBUTE_FLAG
DEFAULT_GRADE
EXPIRATION_ACTION_CODE
EXPIRATION_ACTION_INTERVAL
GLOBAL_TRADE_ITEM_NUMBER
GRADE_CONTROL_FLAG
GTIN_DESCRIPTION
HAZARDOUS_MATERIAL_FLAG
HOLD_DAYS
INTERFACE_TABLE_UNIQUE_ID
ITEM_CATALOG_GROUP_NAME
LOT_DIVISIBLE_FLAG
MATURITY_DAYS
OUTSOURCED_ASSEMBLY
PARENT_CHILD_GENERATION_FLAG
PREPOSITION_POINT
PROCESS_COSTING_ENABLED_FLAG
PROCESS_EXECUTION_ENABLED_FLAG
PROCESS_QUALITY_ENABLED_FLAG
PROCESS_SUPPLY_LOCATOR_ID
PROCESS_SUPPLY_SUBINVENTORY
PROCESS_YIELD_LOCATOR_ID
PROCESS_YIELD_SUBINVENTORY
RECIPE_ENABLED_FLAG
REPAIR_LEADTIME
REPAIR_PROGRAM
REPAIR_YIELD
RETEST_INTERVAL
REVISION_IMPORT_POLICY
SOURCE_SYSTEM_ID
SOURCE_SYSTEM_REFERENCE
SOURCE_SYSTEM_REFERENCE_DESC
SUBCONTRACTING_COMPONENT
MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTIONS_INTERFACE allows calling applications to post
material transactions (movements, issues, receipts etc. to Oracle Inventory
transaction module.
Transaction Manager concurrent program polls this table at a
user-specified process interval, and submits the Transaction Workers
to process them. Processing consists of data derivation, validation,
and the transfer of records from MTL_TRANSACTIONS_INTERFACE,
MTL_TRANSACTION_LOTS_INTERFACE, and MTL_SERIAL_NUMBERS_INTERFACE into
their respective temporary tables, from where they are processed by the
transaction processor.
MTL_TRANSACTIONS_INTERFACE follows the Inventory standard for
interfacing flexfields. Any parameters which are represented by
flexfields may be entered in the interface table either as code
combination identifiers or as flexfield segment combinations. The
Transaction Worker will validate that any given identifiers are valid
and enabled. If no identifier is given, then the Transaction Worker
will validate and decode the flexfield segment values, and where
appropriate, create new flexfield combinations in the database.
The Transaction Manager picks up the rows to process based on the
LOCK_FLAG, TRANSACTION_MODE, PROCESS_FLAG.
Only records with TRANSACTION_MODE of '3', LOCK_FLAG of '2',
and PROCESS_FLAG of '1' will be picked up by the Transaction Manager
and assigned to a Transaction Worker. If a record fails to process
completely, then PROCESS_FLAG will be set to '3' and ERROR_CODE and
ERROR_EXPLANATION will be populated with the cause for the error.

Description of newly added columns :

RELIEVE_HIGH_LEVEL_RSV_FLAG- Indicates whether to check for high level reservations that needs to be relieved during transaction processing.
RELIEVE_RESERVATIONS_FLAG- Indicates whether to relieve the reservations during transaction processing
RELIEVE_HIGH_LEVEL_RSV_FLAG
RELIEVE_RESERVATIONS_FLAG
SOURCE_LOT_NUMBER
TRANSFER_PRICE


2.5.   Changes in APIs

SR No.
API Name
Changes Made
1
INV_ITEM_REVISION_PUB
In API for a record type two new
columns are added as template_name,template_id. Which are used in process item revision procedure also a new parameter as p_process_control is added in the procedures to create item revisions,update item revisions
2
INV_ITEM_API
As the columns in the item table has been changed the record types also changed in the API
3
INV_RCV_COMMON_APIS
A new column is added in the record for po startup values as inv_org_id
4
INV_RCV_INTEGRATION_APIS
Two new columns as sec_uom_code,sec_qty are added to record child_record_info .Three columns added to record mol_in_rec as sec_qty,wdd_id,reservation_id.New parameters are added to procedure insert_mtli which inserts records in MTL_TRANSACTION_LOTS_INTERFACE as
p_secondary_quantity
,p_origination_type,
p_expiration_action_code, p_expiration_action_date,p_hold_date
,p_parent_lot_number, p_reasond_id

2.6.   New forms

New form in R12 :
i)Material Status Definitions
SetupàTransactionsàMaterial Status
Here you can specify which transactions are you can restrict.

ii)Maintain Grades:->
SetupàLabel PrintàGrades

This is a grade master form where you can enter all the grades.

iii)Picking Rules Enhancement:->
Setup->Rules->Picking)


iv) Find Serials:->
On hand availability->Serial Numbers->

This screen enables you to find the serial numbers for particular item in an organization based upon your search criterion. You can navigate to Lot genealogy which is new feature.If item is already lot controlled enabled then lot button is enabled on this form.

v) Lot specific conversions:->
Setup->Unit of Measure->Lot specific conversions
Conversion can be created and modified for particular lot numbers. is the new screen.

2.7.   New Reports

Following New Reports are added in R12.
Write here the navigation to these reports and 2 line description.
Sr No.
Report Name
1
Consolidate Inventory Onhand Quantites
2
Genealogy Reports
3
Grade Change History Report
4
Inventory Packing Slip
5
Lot Inventory Report
6
Lot Master Report
7
Material Status Definition Report
8
Purchasing Packing Slip

Sr No.
Report Name

1
Grade Change History Report
View  RequestàSubmit New RequestàSingle Request

This report enables you to view all of the grade changes made during a given time
period for a particular item within an organization.

2
Inventory Packing Slip

View  RequestàSubmit New RequestàSingle Request
You can use the Inventory Packing Slip report to create a packing slip for return to vendor and inter-organization transactions. This report verifies the carrier is not the
owner of the shipped goods. This packing slip is issued to transport goods not related to a sale. You can also print a packing slip for the transfer of goods between warehouses that have a user-defined inventory transaction type.

3
Lot Inventory Report

View  RequestàSubmit New RequestàSingle Request
This reports provides you with an overview of item lots, quantities, and lot statuses in all or the selected subinventories and locators within the organization can be submitted from submit request window can be submitted through submit request window.


4
Lot Master Report

View  RequestàSubmit New RequestàSingle Request
This report provides you with an overview of the information you set up in the lot master. You
can run this report for a specific item, or all items in the organization.can be submitted through submit request window.


5
Material Status Definition Report

View  RequestàSubmit New RequestàSingle Request
This report provides you an overview of each material status and how it is used.
can be submitted through submit request window.


6
Transaction Purge Report

View  RequestàSubmit New RequestàSingle Request
this report is used  to purge transactions within the organization ,can be submitted through submit request window.

7
Create Deferred Logical Transactions

ReportsàTransactions
Create Deferred Logical Transactions concurrent request enables you to defer the creation of logical transactions for a pure shipment across multiple operating units.


2.8.   New Interfaces

1
INV_MAINTAIN_RESERVATION_PUB
API will handle changes to the resevation record based on the changes to the supply or demand record changes.
This Interface  will handle changes to the reservation record based on the action code and the supply or demand record changes.
2
INV_LOT_ATTR_PUB
This interface will perform all the validations and update insert related to LOTs like validating  retest date, maturity date, hold date ,grade code then inserting UOM, Validating child lot etc.

2.9.   New APIs

Following New APIs are added in R12.

1
Consolidate Inventory Onhand Quantites
INV_CONSOLIDATE_ONHAND
The quantity is consumed in the order received. If multiple users try to use onhand quantity at the same time, users might experience locks or queues waiting to use the onhand quantity record. A concurrent program was introduced to consolidate Onhand Quantity records for a particular item to reduce the enqueue waits.  The consolidation will also remove zero onhand quantity records. This will be done through a concurrent program called "Consolidate Inventory Onhand Quantities".
2
INV_LOT_API_PKG
This API is used to perform following actions
It populates the parent and child lot records and returns them to the Create_Inv_Lot procedure.It populates the  grade code, origination type, expiration date,
retest date, expiration action code, expiration action date,hold date and  maturity date based on the values from mtl_system_items for a given organization and inventory item id.It performs the validations on the lot and defaults the missing attributes as per the logic existing in the earlier create_inv_lot procedure.It returns the populate lot record.
This Function would be used to check whether the lot number passed exists in the database or not.
3
INV_COPY_ITEM_CP
This procedure submits the Item Import concurrent program. Before submitting the request, it verifies that there are enough workers available and wait for the completion of one if necessary.
4
MTL_CC_SCHEDULE_REQUESTS
This API is used to schedule item  in the  MTL_CC_SCHEDULE_REQUESTS table after  scheduling in the cycle count entries.

2.10.  Obsolete Objects

Following Concurrents are no longer use in R12

                        1) Transfer transactions to GL
Navigation:->View RequestàSubmit Request.

2.11 Others

Material Aging workflow.
              
Concurrent Request can be scheduled to take action on any date attribute of a lot or serial.
Workflow is initiated when any selected date attribute of a lot or serial is within X days of the current date. Default workflow sends notification, but can be customized to support any functionality

1 comment:

Anonymous said...

Excellent!

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect