Purchasing recognizes items, while eAM recognizes resources. As a result, the contractor service item must be linked to a resource for the purchase order to be tied to the Work Order. This is associated via the Resources window. Additionally, the
resource must be associated with a department. The department must specify the location where the services are to be delivered. This must be a valid location for the organization.
For each contractor service resource, you can determine whether the rate charged to the Work Order will be a standard rate or the actual amount, based on the purchase order price. This is set up within the Resources window, and may vary for each resource.
To set up outside services as items
Create an item for each outside service, such as landscaping services.
1. Navigate to the Master Item window.
2. Enter the item Name for the contractor service. For example, Landscape Service.
3. Select Copy From within the Tools menu.
4. Select @Outside Processing Item from the Template list of values.
5. Choose Apply.
6. Choose Done.
7. Within the Purchasing tabbed region, ensure that the Outside Processing Item check box is selected.
8. Select the Resource Unit Type.
Resource: Costs are based on the resource standard rate.
9. Select a Default Buyer from the list of values.
10. Enter a List Price for this contractor service.
11. Select Each for the Unit of Issue. This is the unit of measure you use to issue the item from inventory.
12. Within the Receiving tabbed region, select Direct from the Receipt Routing list of values.
13. Save your work.
14. Select the Organization Assignment tabbed region on the left side of the window, then assign this item to the eAM organization.
15. Save your work.
Entering Requisitions for Direct Items
Requisitions for direct items can be created within iProcurement or Purchasing. If you have Oracle iProcurement installed, you can access supplier catalog items directly from an eAM Work Order. If you create a requisition within iProcurement,
the Work Order and operation inform ation is created as you proceed to checkout. You can access a link to direct items using the Maintenance Workbench or within the Work Order window. The Work Order must be at a status of Released.
To enter requisitions for direct items using Oracle iProcurement:
1. Navigate to the Work Orders window.
2. Select a valid, released Work Order number from the Work Order list of values.
3. Choose Find.
4. Choose Materials to view or update the material requirements for this purchase order. Once purchase
orders or requisitions related to direct items have been created for this Work Order, they will be referenced in the Direct Items region of this window.
5. Choose Direct Item to purchase items directly from supplier and non-supplier catalogs, using Oracle iProcurement. The related requisition or purchase order number will appear in the Direct Items region.
6. Save your work.
To enter requisitions for direct items via Oracle Purchasing
If you do not have iProcurement installed, you can access direct item procurement functionality using Purchasing. This functionality is only available if you have Enterprise Asset Management installed.
You can enter a requisition within both the forms application and Maintenance User. When entering a requisition within the forms application, this is done directly from the Requisitions window, and not from the eAM Work Order, as in
Maintenance User.
1. Navigate to the Requisitions window.
2. Optionally, enter a requisition Description.
3. Select the Items tabbed region.
4. Select Goods from the item Type list of values.
5. Optionally, selec t an Item to purchase from the list of values. Items that are defined in Inventory, with the Stockable check box cleared, are available for selection. See: Inventory Attribute Group, Oracle Inventory User’s Guide
6. Select the purchasing Category o the item you want to purchase.
7. Enter the Description of the item. This description should be meaningful, as it is used to procure the item. If this item is not inventoried, this is the only way an internal person will understand what item you are attempting to procure.
8. Select a UOM from the list of values. The unit of measure qualifies the quantity you enter on the purchase order line. When you choose a line type, its default un o of measure populates this field. If you had chosen an item, its default unit
of measure would have overridden the line type default.You can change the UOM until the item is received, bill, or encumbered.
9. Enter a Quantity to purchase.
10. Select a Need-By date.
11. Select Shop Floor from the Destination Type list of values for all direct item and non-stock item, eAM related requisitions. You can select a destination type of Shop Floor for all purchasable items that are not selected as Stockable in the
item master. When you select a destination type of Shop Floor, eAM recognizes this as a equirement to deliver the direct item to the maintenance Work Order.
12. The Destination Organization list of values will only display those organizations where the item is non-stockable, if the Destination Type is Shop Floor.
13. Choose Outside Services. You can access this window from the Requisition, Purchase Order, and Release windows. This is enabled if the Destination Type previously specified is Shop Floor.
14. Select a Work Order from the Job list of values. Only Released maintenance Work Orders are available for selection. Once a Work Order is selected, any eAM project and task information associated with the Work Order is copied to
the corresponding Project and Task fields, within the Project tabbed region in the requisitions or purchase order Distributions window.
15. Select an Operation Sequence from the list of values. The purchased material will be associated with this operation on the current Work Order. Purchasing displays the operation Code and the Department.
16. Choose Done.
17. Save your work.
18. The requisition needs to be approved (See: Creating Process Definitions in Oracle Workflow Builder, Oracle Workflow isition is approved, it will appear on the eAM Work Order, and can be viewed in Purchasing.
Enabling Direct Item Procurement
To enable direct item (both supplier catalog and non-catalog items) procurement for eAM Work Orders directly from an eAM Work Order, Oracle iProcurement must be installed. You must set the PO: Enable Direct Delivery To Shop Floor profile
option to Yes. When this value is set to Yes, you can create an eAM-related requisition or purchase order. You can enter eAM specific information, such as Work Order and operation reference numbers, as well as identify a requisition line
as having a Shop Floor destination.
To enable direct item procurement
1. Navigate to the Personal Profile Values window.
2. Select PO: Enable Direct Delivery To Shop Floor from the Profile Name list of values.
3. Select Yes from the Default Value list of values.
4. Save your work.
Direct Item Procurement for eAM Work Orders
One of the most important features included in Enterprise Asset Management (eAM) is Work Management.
It enables you to service requests when a Maintained Number is problematic. After the Work Request is approved, a Work Request can be linked to a Work Order. A Work Order includes a listing of all maintenance activities that must be performed on a Maintained Number. Material requirements for a Work Order may include stocked, non-stocked, and direct items. Stocked items are those that are either used frequently, or the criticality of short lead time to obtain replacement parts mandates that they be stocked in inventory. Non-stock items are included in the internal catalog, but the decision is made to not maintain an inventory balance. These items are not transactable, but you can procure them. Direct items are those that are either
used on an infrequent basis, or lead time to obtain replacement parts is not critical.
These items do not need to be stocked in inventory, although they can be stocked in inventory with the Stockable check box (item attribute) left un-selected. These items are not included on the maintenance bill of material. If you have Oracle iProcurement installed, all item types may be included in your internal catalog.
A planner can procure direct items from the Maintenance Workbench to perform direct item delivery from the supplier. Purchase requisitions and purchase orders of such items capture the Work Order for which they are required. The Work Order must be at a status of Released. If the Work Order is project related, then the project and task information is captured in the purchase requisition.
The following diagram illustrates the integration between Enterprise Asset Management and Procurement. First, a maintenance Work Order is created at a Released status. There is a need for a direct item. A requisition is created either
manually, or via iProcurement, linked to the Work Order, and then approved. A purchase order is created from the requisition, and then approved. A purchase order can also be created manually, without first creating a requisition. In both
cases, the purchase order needs to be approved. The items are received using a standard receipt routing, and delivered to the maintenance Work Order. The cost on the Work Order is recorded at the actual purchase order price.
Meter and Meter Templates
Preventive Maintenance Setup
eAM can generate Work Orders automatically based on meter readings, runtime and/or calendar days. An example of meter-based preventive maintenance is your car’s oil changes. Most car manufacturers recommend that you change your engine oil every 3,000 miles or six months, whichever comes first.
To set up the above scenario, you would first define your car’s odometer as a meter. Next, you would associate that meter to an asset (your car), using the Asset Meter Association window. After you have associated the meter to the asset, you can associate the Maintenance Activity (oil change) that should occur, based on the meters you have defined. This is done via Preventive Maintenance Scheduling
Defining Meter Templates
There are two ways to create meters. You can create them within the Meter Definition window, or create them using a Meter Template window. If you create Meters using the Meter Definition window , you will need to associate that meter definition with individual Maintained Numbers manually. If you utilize the Meter Template definition functionality, you can associate that Meter Template with Maintained Groups. After the association is created, when a Maintained Number (Asset Numbers or Rebuildable Serial Numbers) is created within that Maintained Group (Asset Group or Rebuildable Item), the system will automatically create a new instance of the meter, associated with the specific Maintained Number. This enables you to streamline your meter setup.
However, the meters are not created retroactively; it applies only to Maintained Numbers created after the Meter Template was created.
To define Meter Templates:
Navigate to the Meter Template window.
1. Enter a unique meter template Name amd Description of the Meter Template.
2. Select a unit of measure (UOM) from the list of values. After the meter is created, this field cannot be updated.
3. Select whether the meter readings will be Ascending, Descending, or Fluctuating. If you choose blank from the drop down list, the meter reading can fluctuate. A fluctuating meter reading is one that can go up and down, for example, a temperature gauge. As production units pass through meters, meter readings increment. Another example of an ascending meter is a car odometer. Some liquid dispensers start full and record decreasing readings as material is used.
Note: If the meter is fluctuating, then it cannot be used in Preventive Maintenance scheduling.
4. If you select the Used in Scheduling check box, the meter will be used in Preventive Maintenance Scheduling. If there are any scheduling rules associated with this meter, this check box cannot be cleared. If this is a fluctuating meter, this check box is disabled. If the Used in Scheduling check box is selected, the Usage Rate (per day) and Use Past Reading fields become mandatory.
5. Enter a usage Rate (per day). This field works in conjunction with the Use Past Readings field to support historical readings prior to eAM implementation. It supplies the system benchmark data that can be used to set the occurrence of
scheduled PMs. Rate per day is referred to in the absence of a sufficient value in the Use Past Reading field.
This field is mandatory only if you have selected the Used in Scheduling check box.
6. Enter a value for the number of past readings. This value designates how many readings prior the scheduler should go to for calculating the usage rate. If there is an insufficient number of readings (for example four, instead of the required
five), the system will continue the calculation based on the usage Rate per day entered.
This field is mandatory only if you have selected the Used in Scheduling check box.
7. Optionally, enter an Initial Reading. This is automatically used for the meter, or each new instance of the meter that is created and associated to a Maintained Number via the Meter Template.
8. Select the meter effectivity dates. If left blank, the meter is effective all of the time, after it is created. If you select a future date, the meter is disabled until that date. You can disable a meter effective on a specific date by selecting a To date.
9. Save your work.
Defining Meters
Alternatively, you can create Meters using the Meter Definition window. You will need to manually associate the meter definition with individual Maintained Numbers. If you utilize the Meter Template definition functionality, you can associate that Meter Template with Maintained Groups .
To define a meter within the Meter Definition window:
Navigate to the Meters window.
1. Enter a unique meter Name and Description for this meter.
2. Select a unit of measure (UOM), associated with this meter, from the list of values. After the meter is created, this field cannot be updated.
3. Select whether the meter readings will be Ascending, Descending, or Fluctuating. If you choose blank from the drop down list, the meter reading can fluctuate. A fluctuating meter reading is one that can go up and down, for example, a temperature gauge. As production units pass through meters, meter readings increment. Another example of an ascending meter is a car odometer. Some liquid dispensers start full and record decreasing readings as material is used.
Note: Fluctuating meters cannot be used in Preventive Maintenance scheduling.
After the meter is created, you cannot update this field.
4. If you select the Used in Scheduling check box, the meter will be used in Preventive Maintenance Scheduling. If there are any scheduling rules associated with this meter, this check box cannot be cleared. If this is a fluctuating meter, this check box is disabled. If the Used in Scheduling check
box is selected, the Usage Rate (per day) and Use Past Reading fields become mandatory.
5. Enter a usage Rate (per day). This field works in conjunction with the Use Past Readings field to support historical readings prior to eAM implementation. It supplies the system benchmark data that can be used to set the occurrence of scheduled PMs. Rate per day is referred to in the absence of a sufficient value in the Use Past Reading field.
This field is mandatory only if you have selected the Used in Scheduling check box.
6. Enter a value for the number of past readings. This value designates how many readings prior the scheduler should go to for calculating the usage rate. If there is an insufficient number of readings (for example four, instead of the required five), the system will continue the calculation based on the usage Rate per day entered.
This field is mandatory only if you have selected the Used in Scheduling check
box.
7. Optionally, enter an Initial Reading. This is automatically used for the meter, or each new instance of the meter that is created and associated to a Maintained Number via the Meter Template.
8. Select the If left blank, the meter is effective all of the time, after it is created. If you select a future date, the meter is disabled until that date. You can disable a meter effective on a specific date by selecting a To date.
9. Save your work.
Work Order Billing
While maintaining an asset or servicing a customer request, you can bill a third party customer for the work that they performed. The cost of the work performed is based on the material and resource requirements (Bill of Material) of the Work Order, or the cost of the Activity associated with the Work Order.
Setting Up Parameters
You can optionally enable the ability to change the billable material on a Work Order at the time a bill is created.
To enable the change of billable material functionality:
1. Navigate to the Enterprise Asset Management Parameters window.
2. Optionally, select the Invoice Billable Items Only check box. If selected, you can change the billable material at the time the bill is created.
If selected, this check box indicates that you want to invoice only billable items. Billable items are those that have a populated value within the Billing Type field, within the Service Tab, of the Master Item window. Billing Type is relevant
only if you have this check box selected. Also, selecting this check box means that you can choose a different item to be billed.
3. Save your work.
Service Attribute Setup
You need to set the Billing Type for each item that you want billable. The Billing Type field, within the Master Item window, requires a value if you have selected the Invoice Billable Items Only check box, within the Enterprise Asset Management
Parameters window.
To set up the Billing Type attribute:
1. Navigate to the Master Item window.
2. Select the Service tabbed region.
3. Optionally, select Expense, Labor, or Material from the Billing Type list of values. This field requires a value only if you have selected the Invoice Billable Items Only check box, within the Enterprise Asset Management Parameters window.
4. Save your work.
eAM Cost Management
Costs are generated as maintenance work is executed and completed. These costs roll up through the Parent/Child hierarchies defined within Enterprise Asset Management, and can roll up to any level within an asset hierarchy. Labor, Materials, and Equipment charges can be further classified into several maintenance cost categories.
All work is captured and retained by Enterprise Asset Management. You can reference work that has been completed to review operations, resources, and costs. This information can help you understand the scope of work and the process by
which it is completed.
eAM Costing Methods and Mappings
eAM supports four perpetual costing methods: standard, average, fifo, and lifo. As a foundation, eAM uses the following five basic cost elements provided by Cost Management:
- Material
- Material Overhead
- Resource
- Resource Overhead
- Outside Processing
Asset management requires different cost classifications. eAM provides these cost classifications, while maintaining the integrity of the basic costing rules. The five cost elements above are translated into several cost classifications that are familiar to maintenance managers.
eAM classifies work performed on maintenance Work Orders into cost categories. By default, eAM has defined three cost categories: Contract, Operations, and Maintenance. You can define additional cost categories, if needed. Each cost category is further classified into three cost elements: Equipment, Labor, and Material.
- Material – Costs from material transactions.
- Labor – Costs from labor resource transactions.
- Equipment – Costs from equipment resource transactions.
Material charges are classified as Material cost elements. Resource charge of type person is classified as a Labor cost element. Resource charge of type machine is classified as Equipment cost element. All other resource types are classified by the default cost element in the eAM Parameters.
For each department, a maintenance cost classification is identified to reflect the above breakdown. The cost category for the Material cost element is the cost category of the department assigned to the routing of the operation. For the Labor
cost element, it is the cost category of the resource’s owning department. For the Equipment cost element, it is the cost category of the Maintained Number’s owning department.
eAM Mappings
The three cost elements (Material, Labor, and Equipment) are mapped to the five basic cost elements (Material, Material Overhead, Resource, Resource Overhead, and Outside Processing) provided by Cost Management.
The above diagram illustrates that the eAM Material cost classifications are mapped to Material, Material Overhead, and Outside Processing. Labor and Equipment cost classifications are mapped to Resource, Resource Overhead, and Outside Processing.
Express Work Orders in Oracle eAM (Enterprise Asset Management)
Express Work Orders in Oracle eAM (Enterprise Asset Management)
- Generally we Plan, Forecast, Schedule and Execute the Maintenance works. In that process, we first create work orders, release, approve, issue materials, complete and close them.
- But what about unplanned work orders where there is no time to have proper approvals and follow the maintenance procedures. For Example, during non working hours and holidays any maintenance works need to be approved, there will not be any officials in the office.
- Take an example of Burning of a Transformer in a busy location during a Public Holiday. Due to importance of area, location of the Transformer (may be VIP Area), replacement of transformer cannot be delayed to next working day to have proper approval and issue of new transformer. In such a case the On Duty maintenance engineer first take out a serviceable and/or new transformer from the stock and other necessary materials and replace the burnt out transformer.
- The next working day, he will the report to Maintenance Manager / supervisor about the unplanned / emergency maintenance activities carried out on Public Holiday. However for the system it is necessary to complete the paper action (computerization of Maintenance works).
- But in this as the maintenance work is already completed, no formal approval are required (No AME Rules to be applied). Materials are already taken from stores and consumed, no separate issue required.
- To meet situations like these, Oracle eAM has been provided with Express Work Orders functionality, where Express Work provides users with a quick way to report work that has been completed without any planning – often referred to as ‘after-the-fact’ reporting
The important features of Express Work Orders
- Work Order can be created with one of the following statuses
- Released
- Complete
- Complete No Charge
- All the related Work Order Completion details can be completed:-
- Meter Readings
- Collection Plans
- Completion Information
- Optionally you can complete the Operations / complete the work order
- You can charge the resources.
- You can mention the materials consumed. No issues are required.
- You can even indicate the Rebuildables replaced along with their serial numbers.
- Failure information can be entered as per the option (mandatory or optional)
- Meter Reading and Quality Data can be entered.
- Any mandatory data like Meter Reading, Failure Codes, Quality data is not entered then the Express Work Order is saved in the Released Mode, not with the Complete Status.
- Non Stocked Items cannot be selected / selected (need to be checked / tested).
- OSP Resources can be attached with an Express work order Operation Resource Requirements and on saving the Express Work Order, Requisition Import and Create Release concurrent Programs will run.
- It has been observed that the Requisition Import and Create Release are run for every creation of Express Work Order with OSP Resource irrespective their status (Released or Complete). But no Purchase Requisition is not created. A detailed more testing are required. I am getting some errors like No Preparer ID, DELIVER_TO_REQUEST ETC.
- I hope it will work if proper employee and Buyer setups are done. I need to test the same with the proper User ID who is associated with an Employee ID and Buyer Setup. After that I only I can give clear picture on this.
- One can also manually create Purchase Requisition, Purchase Order and attach the same with the Express Work Order. This perfectly works.
- Non Stock Direct Items are not visible in the LOV of Materials of Express Work Order
- Description Based Items are also not available in the Express Work Orders.
- However one can add Non Stock Direct Item and Description Based Item through Request Item feature .On Saving Requisition Import and Create Releases are PERFECTLY happening (working).
- Costing: Both the Estimated and Actual Costs are calculated for Express Work Orders
- AME Rules are not applicable and No Approvals are required.
- There is no any technical difference or any database level attribute, with which one can differentiate between normal work orders and work orders created through Express Work Order Feature.
Express Work Order Problems-Oracle Support Documents
- When Expanding Quality Plans in Express Work Order Page, Error Is Thrown (Doc ID 1604939.1)
- Express Work Error: oracle.apps.fnd.framework. OAException: oracle.jbo. SQLStmtException: JBO-27122: SQL error during statement preparation. (Doc ID 1302353.1)
- Changing the Failure Code on A Work Order Results In: ‘oracle.apps.eam.workorder.webui.WOFailureEntryRNCO.processFormReques…’ (Doc ID 1956960.1)
- When Attempting to link Work Request To Express Work Order, Error “Class CastException: oracle.apps.eam.workorder.server.ExpressWorkOrderAMImpl …..” Occurs (Doc ID 1918614.1)
- Express Work Order Page Cannot Be Open Due to java.lang.ClassCastException error (Doc ID 1590342.1)
- Issue When Creating Express Work Order While Work Order Approval Workflow is Enabled (Doc ID 1608628.1)
- Missing Work Order Completion Information In Debrief / Express WO Page (Doc ID 1490153.1)
- Operation Completion DFF Not Displayed In Express Work Order Page (Doc ID 1558200.1)
- Descriptive Flexfield Does Not Display In Express Work Order OAF Page (Doc ID 1340094.1)
- Entering Quality Results in Express Work Order Is Not Triggering the Display a Message Action from the Plan (Doc ID 1404285.1)
- Failure Reporting On Express Work Order Sets To “No” Automatically In Complete Status (Doc ID 1595440.1)
- Problem About Dates For Express Work Order (Doc ID 1583228.1)
- Work Order Completion Descriptive Flexfield on Express Work Orders page (Doc ID 1598745.1)
- Reconciliation Code Not Populated For The Express Work Order (Doc ID 1932747.1)
- Eam Express Work Orders – Start Date Time And End Date Time The screen jumps and does not recalculate the other values. (Doc ID 1372667.1)
Accounting Requirements for eAM and related Inventory Organization
Accounting Requirements for eAM and related Inventory Organization
WIP Accounting Class
Maintenance accounting classes are used to group costs for work orders used in Oracle Enterprise Asset Management (eAM). For example, if you are creating work orders for plant maintenance activities, you can define your accounting classes to separately value and report the costs related to asset. Maintenance accounting classes are automatically defaulted when you create eAM work orders.
When you define an accounting class, you must assign valuation and variance accounts to it. When you issue materials to a work order that uses this accounting class, the appropriate valuation accounts are charged. When the work order is closed, final costs and variances are calculated and posted to the variance and valuation accounts. When the accounting period is closed, these journal entries are automatically posted to the general ledger.
The WIP Accounting Class is the Class which is associated with eac Asset Number and then with Work Order. Accounting distributions for all the Work Order Transactions pertaining to that asset are posted as per the WIP Accounting Structure.
Generally the WIP Accounting Classes are Organization Specific i.e. for one Maintenance Organization there will be on WIP Accounting Class.
However based on accounting and finance reporting requirements, any number of WIP Accounting classes can be created and attached to the Asset Numbers and Work Orders.
Here in RGO, the Maintenance expenditure is posted to Asset Owner Department / Organization and sometimes to the Maintenance Organization. It depends. This issue needs special attention.
Valuation and Variance Accounts
WIP accounting class valuation accounts are charged when you issue components, move assemblies, complete assemblies, and charge resources.
Variance accounts associated with Standard Discrete and Non-standard Asset accounting classes are charged when jobs are closed. Variance accounts associated with Expense Non-standard Discrete, and optionally Repetitive accounting classes, are charged when accounting periods are closed.
As noted in the following table, different valuation and variance accounts are required under standard versus average costing:-
| Sl No | Account | Valuation | Variance |
| 1. | Material | Standard and Average | Standard and Average |
| 2. | Material Overhead | Standard and Average | Standard and Average |
| 3. | Resource | Standard and Average | Standard and Average |
| 4. | Outside Processing | Standard and Average | Standard and Average |
| 5. | Overhead | Standard and Average | Standard and Average |
| 6. | Standard Cost | Standard Only | Variance Not Applicable |
| 7. | Bridging | Average Only | Variance Not Applicable |
| 8. | Expense | Average Only | Variance Not Applicable |
The screen shot of the WIP Accounting is appended below
Resource Accounts
- Resource Absorption Account
- Variance Account
Sub Ledger Accounting and EAM
Without SLA, all material on a work order will debit the same material expense account.
SLA will enable the customer to define an expense account for each type of category (spares and supplies), so the work order can debit one expense account for spares, and a different expense account for supplies.
Valuation Accounts
Material Account – Normally an asset account this account tracks material costs. Under standard costing, it is debited at standard when you issue material to a job or schedule and credited at standard when you complete assemblies from a job or schedule, close a job, or close an accounting period. Under average costing, this account is debited at the average cost in effect at the time of the issue transaction and is credited when you complete assemblies from a job.
Material Overhead – Normally an asset account this account tracks material overhead (burden) costs. Under standard costing, it is charged/debited at standard when you issue material with material overhead to a job or schedule and relieved at standard when you complete assemblies from a job or schedule, close a job, or close an accounting period. Under average costing, this account is debited at the average cost in effect at the time of the issue transaction.
Resource – An asset account that account tracks resource costs. Under standard costing, it is charged/debited at standard when resources are charged to a job or schedule and relieved/credited at standard when you complete assemblies from a job or schedule, close a job, or close an accounting period. Under average costing, this account is debited and credited at the resource rate in effect at the time the resource is charged.
Outside Processing – An asset account that tracks outside processing costs. Under standard costing it is debited at the standard or purchase order cost when you receive items for a job or schedule in Oracle Purchasing. It is credited at standard when you complete assemblies from a job or schedule, close a job, or close an accounting period. Under average costing when you move job or repetitive schedule assemblies through an outside processing operation, it is debited at the resource’s predefined rate or at the purchase order cost.
Overhead – Normally an asset account this account tracks resource or department overhead cost. Under standard costing it is debited at standard when resources are charged to a job or schedule. It is relieved at standard when you complete assemblies from a job or schedule, close a job, or close an accounting period.
Variance Accounts
Material This account tracks variances that occur when the previous level material costs charged to the job or schedule do not equal the previous level material costs that are relieved. This calculation gives you a net material usage and configuration variance.
Resource This account tracks variances that occur when the this level resource costs charged to the job or schedule do not equal the this level resource costs that are relieved. If you charge actual labor without creating resource rate variances (resource standard rate is set to No), the resource variance includes any rate, efficiency, and method variances. If you recognize rate variances or charge resources at standard, the resource variance includes resource efficiency, and any method variances.
Outside Processing Tracks the variances that are occur when the this level outside processing costs charged to the job or schedule do not equal the this level outside processing costs that are relieved. If you do not calculate purchase price variance (resource standard rate is set to No), the outside processing variance includes any rate, efficiency, and method variances. If you recognize purchase price variance, this account includes efficiency and any method variances.
Overhead Tracks the variances that are occur when the this level overhead costs charged to the job or schedule do not equal the this level overhead costs relieved from the job or schedule. These variances include both efficiency and method variances.
Standard Cost Applies only to standard discrete and non-standard asset. This account is charged for the sum of all the elemental standard cost adjustments when you perform a standard cost update that impacts an active job. Cost updates are not performed for repetitive schedules or expense non-standard jobs.
Estimated Scrap Applies only to lot based jobs in Oracle Shop Floor Management enabled inventory organizations when Estimated Scrap Accounting is enabled. If this feature is enabled, both Estimated Scrap accounts are required. The scrap account field is required when defining a department on the Departments window. Additionally when you define this account, you can also track operation yield and estimated scrap absorption when creating transactions for lot based jobs.
Sub Inventory – Accounts
Accounts Required for Subinventory
- Material Account
- Outside Processing
- Material Overhead
- Overhead
- Resources
- Expense
- Encumbrance
OSP (Outside Service Processing) Transactions – Accounts
- AP Accruals
- Receiving Accrual
Direct Items – Accounts
- AP Accrual
- Receiving Inspection
Invoice Variance Transferring – Accounts
- Invoice Variance Adjustment Account
Configuration History
- Maintenance Offset Account
Work Order Closing and Capitalization – Accounts
- Asset Clearing Account / Offset Account / Variance Account
- Asset Cost Account
Inventory Organization – Valuation Accounts
| 1 | Material | An asset account that tracks material cost. For average costing, this account holds your inventory and intransit values. Once you perform transactions, you cannot change this account. |
| 2 | Material Overhead | An asset account that tracks material overhead cost. |
| 3 | Resource | An asset account that tracks resource cost. |
| 4 | Overhead | An asset account that tracks resource and outside processing overheads. |
| 5 | Outside processing | An asset account that tracks outside processing cost. |
| 6 | Expense | The expense account used when tracking a non-asset item. |
Inventory Organization – Other Accounts
| 1 | Sales | The profit and loss (income statement) account that tracks the default revenue account. |
| 2 | Cost of Goods Sold | The profit and loss (income statement) account that tracks the default cost of goods sold account. |
| 3 | Purchase Price Variance | The variance account used to record differences between purchase order price and standard cost. This account is not used with the average cost method. |
| 4 | Inventory A/P Accrual | The liability account that represents all inventory purchase order receipts not matched in Accounts Payable, such as the uninvoiced receipts account. |
| 5 | Invoice Price Variance | The variance account used to record differences between purchase order price and invoice price. This account is used by Accounts Payable to record invoice price variance. |
| 6 | Encumbrance | An expense account used to recognize the reservation of funds when a purchase order is approved. |
| 7 | Project Clearance Account | When performing miscellaneous issues to capital projects, the project clearance account is used to post the distributions. |
| 8 | Average Cost Variance | Under average costing with negative quantity balances, this account represents the inventory valuation error caused by issuing your inventory before your receipts. |
Inter Organization Transfer Account
- Transfer Credit
- Purchase Price Variance
- Receivable
- Payable
- Intransit Inventory
Category Accounts
- Material: A default general ledger account to accumulate material costs for this category/subinventory combination. This is usually an asset account.
- Outside Processing: A default general ledger account to accumulate outside processing costs for this category/subinventory combination. This is usually an asset account.
- Material Overhead: A default general ledger account to accumulate material overhead or burden costs for this category/subinventory combination. This is usually an asset account.
- Overhead: A default general ledger account to accumulate resource or department overhead costs for this for this category/subinventory combination. This is usually an asset account.
- Resource: A default general ledger account to accumulate resource costs for this category/subinventory combination. This is usually an asset account.
- Encumbrance: A default general ledger account to hold the value of encumbrances against subinventory items belonging to this category set.
Purchasing – Receiving Options – Accounts
- Receiving Inventory Account
- Retroactive Price Adjustment Account
- Clearing Account
Purchasing – Purchasing Options
- Expense AP Accrual Account
Asset Groups – Oracle eAM
Asset Groups – Oracle eAM
- What is Asset Group?
Asset groups represent groups of assets that are virtually identical. Generally, an asset group is defined for each Manufacturer and Model Number combination (Make, Model, and Year).
- What is the Maximum length of the Asset Group Code and Description?
Asset Group Code: Generally the length of the Asset Group is the length of the Item Segment defined in the -Inventory System Items KFF. (Per segment Maximum 40).
Asset Group Description: 240 Characters
- Some Important Pre-required setups and Profile Options for Asset Groups:-
- Asset Group Template and their attribute Controls with default values
- INV: Default Primary Unit of Measure
- INV: Updateable item name à Yes / No
- Default Category Sets (Category Sets)
- Enable Service Fulfillment Manager (SFM) Event Manager Queue Service
- Defining and Freezing the Oracle Install Base Parameters
- What is the Name of the Template used by EAM Asset Groups?
- @Asset Group
- Asset Group – Naming Conventions and its Components?
- Function à Washing Machine
- Make à LG
- Model à S11-P02
- Model Year à 2014
- eAM Asset Group Template and their default values:
- User Item Type à Asset Group
- Item Status à Active
- Primary Unit of Measure à Each
- Inventory Item à Enabled
- Transactable à Disabled
- Serial Number Generation à Predefined / At Receipt
- Effectively Control à Model / Unit Number
- EAM Item Type à Asset Group
- BOM Allowed à Yes
- Track in Installed Base à Yes
- What is the relationship between Asset Group and Inventory Item?
Basically every Asset Group is an Inventory Item. Its item type is Asset Group.
- In how many ways an Asset Group can be created?
- Asset Groups Form in Oracle eAM
- Inventory Master Items (Apply Asset Group Template)
- Importing Inventory Items
- What is the name of the Table / View Name of the Asset Groups?
- View Name – MTL_SYSTEM_ITEMS_VL
- In which COLUMN_NAME the Asset Group / Item Code is stored?
- SEGMENT1 or
- CONCATENATED_SEGMENTS of MTL_SYSTEM_ITEMS_B_KFV
- What is the actual name of the Database Table in which the Asset Group Details are stored?
- MTL_SYSTEM_ITEMS_B_KFV
- What is the Name of the Interface Table that is used for Mass upload of Asset Groups?
- New Asset Groups à MTL_SYSTEM_ITEMS_INTERFACE
- Revision Details à MTL_ITEM_REVISIONS_INTERFACE
- Item Categories à MTL_ITEM_CATEGORIES_INTERFACE
- In case of Centralized Maintenance architecture, where all the Assets of INV Organizations are maintained by EAM Organization, how the Asset Groups are created and organizational assignment is done?
- Asset Groups created should be first assigned to INV organization followed by EAM Organization.
- Also the INV organization should be given EAM Responsibility (for Organizational Access).
- Can we change the Asset Group Starting Prefix, once the Assets are created in the eAM Asset Numbers Form?
- One cannot change the Asset Group Starting Prefix (subject to Uniqueness) and Starting serial Number from the EAM Asset Group Form Functionality.
- Whereas the same can be changed from the Inventory Master Items.
- Can we change the Asset Group Starting Number, once the Assets are created in the eAM Asset Numbers Form?
- Yes, one change the Starting Prefix (subject to Uniqueness) and Starting Serial Number even after creation of Asset Numbers from EAM.
- But one can change the same from Inventory Master Items form but not from EAM Asset Groups Form.
- Can we change the Asset Group Code and Description?
- One can change the Asset Group Description, but not the Asset Group Code. The profile options that needs to be setup is INV: Updateable item name.
- What are the functions available from Asset Group Form?
- View Item Details (Tools à Item Details)
- View Failure Analysis and Maintain Failure Codes and sets (Tools à Maintain Failure Set)
- Various Functions available for an Asset Group from Master Items Form:-
- Categories (Tools à Categories)
- Items Costs
- Cross References
- Item Subinventories
- Item Relationships
- Revisions
- Catalog
- Export the Asset Groups to Excel (File à Export)
- Can we change the Asset Group associated with an Asset Number?
- No we cannot Change the Asset Group Associated with an Asset Number. However one can change the Asset Group Description subject to profile setting up (INV: Updateable item name)
- What are the automation features available in eAM that can be automated / associated or attached at the Asset Group Level?
- Activity Association Template
- Meter Templates
- Failure Codes and Sets
- Asset Attribute Groups
- Collection Plans
- PM Schedule Template
- Bills of Materials
- Budget Forecasting
- Activity Suppression Templates
- What are the Serial Generation Options available for an eAM Asset Group?
- At Receipt
- Pre-defined
- No Control
- How to Export all the Asset Groups to Excel?
- Change the Organization
- Open the Master Item Window
- Open the Search Window
- Search for Asset Item Type à Asset Groups
- Search Results are Displayed
- File à Export (to export the search results to Excel Sheet).
- SQL Query used to extract the Asset Groups from Database?
SELECT inventory_item_id, accounting_rule_id, invoicing_rule_id,
segment1 asset_group, segment2, segment3, segment4, segment5
FROM mtl_system_items
WHERE eam_item_type = 1
- What are the Setups that need to be completed for automatic generation of EAM Asset Number in while creating Asset Number?
- At the Asset Group Level setup the following:-
- Serial Generation à Predefined OR At Receipt
- Starting Prefix
- At the Asset Group Level setup the following:-
- Starting Serial Number
- In the EAM Parameters set the following:-
- CHECK à Asset Serial Number Auto Generation
- What are the uses of (a) Starting Prefix Number and (b) Starting Number in the Asset Group Definition Form?
- When EAM Asset Numbers are generated automatically, the system will use tie Starting Prefix and Starting Number to automatically generate the Asset Number when defining in the EAM Asset Numbers Form.
- In order to Move an Asset, what the Main Attribute that should be CHECKED or made ACTIVE for the Asset Group?
Transactable à Yes (CHECKED)
- For all the Asset Groups, which will be considered as Fixed Assets, for which Purchase Requisitions and POs will be created, How the Costing Parameters are setup?
- Costing should be disabled when they are receiving into Asset Sub Inventory.
- If costing is enabled, then they should be received into an Expense Sub inventory.
- What are pre-requisite to create an Asset Group with No Serial Controls?
Asset Groups cannot be created with No Serial Control option.
- How to create and use an Asset Group without a Serial Control? What is the Best Scenario?
Ans: No. An Asset Groups Cannot be created with Serial Generation – No Control. Whereas Rebuildables can be created with Serial Generation – No Control Option.
When trying to create An Asset Group with No Serial Control, then the following errors are encountered:-
- If an item is under “Model/Unit Number Effectively” control then Serial Number Generation Must be “At Receipt” or “Predefined”.
- Asset Group must be Serial Controlled Item with “Predefined” or “At Receipt”.
- What is the profile option with which the Asset Group Attribute can be updated?
- INV: Updateable item name
- Is it necessary to compulsorily use the System Generated Auto Numbers for EAM Asset Numbers?
- No, It is not necessary to use the system generated / suggested EAM Asset Number.
- The same cane be changed manually to any desired number or a number suggested by the users (subject to Uniqueness of EAM Asset Number and EAM Asset Serial Number).
- What is the API for Creation of Items?
- Item Creation and Updation
- EGO_ITEM_PUB.PROCESS_ITEM(S)
- This API provide functionality to create and update an item(s).
- What is the API for Item Category Code Creation?
- Category Code Creation Public API
- INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY
- This API provide functionality to create a category
- What is the API for Item Category Assignment?
- Item Category Assignment Public API
- EGO_ITEM_PUB.PROCESS_ITEM_CAT_ASSIGNMENT
- This API provide functionality for the user to assign/remove a catalog to/from an item and will verify whether user has edit item privilege on item
- What is the API for Item Catalog Descriptive Element?
- Item Catalog Descriptive Element Public API
- EGO_ITEM_PUB.PROCESS_ITEM_DESCR_ELEMENTS
- This API provide functionality for the user to give the values of item catalog category descriptive elements and will verify whether user has edit item privilege on item.
- What is the API for Item Revision Creation and Updation?
- Item Revision Creation and Updation Public API.
- EGO_ITEM_PUB.PROCESS_ITEM_REVISION
- This API provide functionality to create and update Item Revision
- What is the API for Implement Item Pending Changes?
- Implement Item Pending Changes Public API.
- EGO_ITEM_PUB.IMPLEMENT_ITEM_PENDING_CHANGES
- This API provide functionality to implement pending changes (phase and/or status) for an item/item revision.
- What is the API for Item Lifecycle?
- Item Lifecycle Public API
- EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS
- This API provide functionality for changing the status of an item or promote/demote the lifecycle of an item/item revision
- What is the API for The Item Grant?
- Item Grant public API
- EGO_ITEM_PUB.PROCESS_ITEM_ROLE
- This API provide functionality to create/updation/deletion one role grant on one item
- What is the API for Item User-Defined Attributes Data?
- Item User-Defined Attributes Data Public API
- EGO_ITEM_PUB.Process_User_Attrs_For_Item
- This API provide functionality to create/updation/deletion on one or more rows of user-defined attributes data for an item.
- What is the API for Item Assignment to an Organization?
- Item Assignment to an Organization Public API
- EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG
- This API provide functionality to assign one item to an organization
- EGO_ITEM_PUB.PROCESS_ITEM_ORG_ASSIGNMENTS
- This API provide functionality to assign one/more items to an organization(s)
- What are Logical Asset Groups?
- Sometimes for the purpose of maintaining proper Asset Hierarchy, we need to map the assets with the locations, areas or departments which are not physical assets, for which a Non Maintainable, Non Transactable Assets with costing disabled can be created.
- To achieve this purpose, it is better to create a separate Item Template with required attributes and default values.
- Asset Groups – Some Important Oracle Support Documents
- Asset Group Must Be Unit Effective When Defining Asset Groups (Doc ID 297959.1)
- Error = ‘Insert procedure failed with the following error message 22’ When Creating Asset Group in EAMITMDF (Doc ID 1352238.1)
- Asset Groups Created On The Master Item Screen Shows ‘X’ As The Asset Group In EAM Self Service Pages (Doc ID 859832.1)
- EAMITMDF – Error ‘Expense Account Is Required’ Is Received When Creating EAM Asset Group (Doc ID 1113173.1)
- Asset Group Can Be Seen In The Material Select List For Work Order (Doc ID 1218093.1)
- Primary Unit Of Measure Is Invalid Error When Defining Asset Group (Doc ID 813563.1)
- How To Transfer A Whole Asset Group Between Org’S With Rebuildables & Components (Doc ID 601389.1)
- When trying to create an Asset Group Using the Item Master Form Get Message ‘Tracking Install Base Flag must be set for Asset Group or Rebuildable Serial controlled item’ (Doc ID 560461.1)
- Assign One Asset Group to Multiple Failure Sets (Doc ID 1567721.1)
- How To Change Asset Group For Existing Asset Numbers (Doc ID 1573422.1)
- Asset Group Must Be Unit Effective When Defining Asset Groups (Doc ID 297959.1)
- Is an Asset Number Possible to be Moved to Another Asset Group (Doc ID
- 1542361.1)
- How To Update Asset Group In Asset Number Form After It Is Saved And Used (Doc ID 1588183.1)
- How to Assign an Asset Category To an Asset Group (Doc ID 884811.1)
- EAMFANDF:Asset Group Not Defaulting From Asset Number In Asset Route Form (Doc ID 1350169.1)
- When trying to create an Asset Group Using the Item Master Form Get Message ‘Tracking Install Base Flag must be set for Asset Group or Rebuildable Serial controlled item’ (Doc ID 560461.1)
- Can I Mass Assign Asset Groups？ (Doc ID 1942653.1)
No comments:
Post a Comment