Oracle Order Management - Header and Line Statuses for Normal , Dropship and Back to back Orders

Statuses of

A.   Normal Order

B.    Drop shipment

C.    Back to back orders in Order management

NORMAL SALES ORDER STATUSES

STEP1:-ENTER THE DETAILS THEN SAVE
   
       HEADER STATUS      -->     ENTERED
       LINE STATUS        -->     ENTERED
STEP2:-BOOK THE ORDER

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     AWAITING SHIPPING

STEP3:-GOTO SHIPPABLE->TRANSACTIONS
                     ->LINES/LPN       ACTIONS:AUTO CREATE DELIVERY      -->     GO
                     ->DELIVERY        ACTIONS:LAUNCH PICK RELEASE       -->     GO      -->     OK
                     ->REQUESTS->FIND      -->     PICK SELECTION GENERATION
                                        PICK SLIP RTEPORT
                                        SHIPPING EXCEPTION REPORT

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     PICKED

STEP4:-GOTO SHIPPING->TRANSACTIONS
                     ->DELIVERY        ACTIONS:SHIP CONFORM      -->     GO--OK
                     ->REQUESTS->FIND      -->     BILL OF LOADING
                                                                     PACKING SHIP REPORT
                                                                             COMMERCIAL INVOICE
                                                                             VEHICLE LOAD SHETT DETAILS
                                                                             INTERFACE TRIP STAFF

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     SHIPPED

STEP5:-NOW RUN THE WORKFLOW BACKGROUND PROCESS
                       ITEMTYPE:-OM ORDER LINE

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     CLOSED
----------------------------------------------------------------
HEADER STATUS:-ENTERED        LINE STATUS:-ENTERED
HEADER STATUS:-BOOKED         LINE STATUS:-AWAITING SHIPPING
HEADER STATUS:-BOOKED         LINE STATUS:-PICKED
HEADER STATUS:-BOOKED         LINE STATUS:-SHIPPED
HEADER STATUS:-BOOKED         LINE STATUS:-CLOSED
----------------------------------------------------------------

DROP SHIPMENT STATUSES:

STEP1:-ENTER THE DETAILS THEN SAVE(IN SHIPPING TAB SOURCETYPE=EXTERNAL)
   
       HEADER STATUS      -->     ENTERED
       LINE STATUS        -->     ENTERED

STEP2:-BOOK THE ORDER

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     BOOKED

STEP3:-NOW RUN THE WORKFLOW BACKGROUND PROCESS(PARAM:ITEMTYPE NULL,YES,YES)

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     Awaiting Receipt
       (THE DETAILS MUST BE PRESENT IN REQUISITION INTEFACE TABLE)

STEP4:-NOW RUN THE REQUISITION IMPORT(PARAM:ITEMTYPE=ORDER ENTRY,ITEM,NO,YES)
       TO LOAD THE DATA INTO REQUISITION BASE TABLES

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     Awaiting Receipt
       (THE DETAILS MUST BE PRESENT IN REQUISITION BASE TABLE)

STEP5:-NOW COPY THE SALES ORDER NUMBER
       GOTO      -->     PURCHASING      -->     REQUISITION SUMMAY->RELATEC DOCUMENTS->SALES ORDER               NUMBER->FIND->COPY REQUISITION NUMBER

       GOTO      -->     PURCHASE ORDERS->AUTO CREATE->DELETE SEARCH CRITIRIAA->ENTER REQUISITION             NUMBER->AUTOMETIC->ENTER SUPPLIER NAME->CREATE->PURCHASE ORDER WILL BE               CREATED->COPY PO NUM&APPROVE THE PURCHASE ORDER

       GOTO      -->     RECIEVING->RECIEPTS->ENTER PONUM->FIND->SUB:STORES->SAVE

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     SHIPPED


STEP6      -->     NOW RUN THE WORKFLOW BACKGROUND PROCESS
           
       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     CLOSED
----------------------------------------------------------------
HEADER STATUS:-ENTERED        LINE STATUS:-ENTERED
HEADER STATUS:-BOOKED         LINE STATUS:-BOOKED
HEADER STATUS:-BOOKED         LINE STATUS:-AWAITING RECIEPT
HEADER STATUS:-BOOKED         LINE STATUS:-SHIPPED
HEADER STATUS:-BOOKED         LINE STATUS:-CLOSED
----------------------------------------------------------------

BACK TO BACK ORDER

STEP1:-ENTER THE DETAILS THEN SAVE(IN SHIPPING TAB SOURCETYPE=EXTERNAL)
   
       HEADER STATUS      -->     ENTERED
       LINE STATUS        -->     ENTERED

STEP2:-BOOK THE ORDER

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     SUPPLY ELIGIBLE

STEP3:- NOW      -->     ->RIGHT CLICK ON SUPPLY ELIGIBLE->PROGESS ORDER->OK

       HEADER STATUS:BOOKED
       LINES STATUS :External Req Requested
       (THE SALES ORDER DETAILS MUST BE PRESENT IN REQUISITION INTERFACE TABLE)

STEP4:-NOW RUN THE REQUISITION IMPORT(PARAM:ITEMTYPE=CTO(CONFIGURE TO ORDER),ITEM,NO,YES)
       TO LOAD THE DATA INTO REQUISITION BASE TABLES
 
       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     External Req Open
       (THE DETAILS MUST BE PRESENT IN REQUISITION BASE TABLE)

STEP5:-NOW COPY THE SALES ORDER NUMBER
       GOTO      -->     PURCHASING      -->     REQUISITION SUMMAY->RELATEC DOCUMENTS->SALES ORDER                      NUMBER->FIND->COPY REQUISITION NUMBER

       GOTO      -->     PURCHASE ORDERS->AUTO CREATE->DELETE SEARCH CRITIRIAA->ENTER REQUISITION             NUMBER->AUTOMETIC->ENTER SUPPLIER NAME->CREATE->PURCHASE ORDER WILL BE                      CREATED->COPY PO NUM&APPROVE THE PURCHASE ORDER

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     PO OPEN

STEP6:- GOTO      -->     RECIEVING->RECIEPTS->ENTER PONUM->FIND->SUB:STORES->SAVE

       HEADER STATUS      -->     BOOKED
       LINE STATUS        -->     AWAITING SHIPPING
STEP7:-PICKING
STEP8:-SHIPPING
STEP9:-CLOSED
----------------------------------------------------------------
HEADER STATUS:-ENTERED        LINE STATUS:-ENTERED
HEADER STATUS:-BOOKED         LINE STATUS:-SUPPLY ELIGIBLE
HEADER STATUS:-BOOKED         LINE STATUS:-External Req Requested
HEADER STATUS:-BOOKED         LINE STATUS:-External Req Open
HEADER STATUS:-BOOKED         LINE STATUS:-PO OPEN
HEADER STATUS:-BOOKED         LINE STATUS:-AWAITING SHIPPING
HEADER STATUS:-BOOKED         LINE STATUS:-PICKED
HEADER STATUS:-BOOKED         LINE STATUS:-SHIPPED
HEADER STATUS:-BOOKED         LINE STATUS:-CLOSED
----------------------------------------------------------------

Oracle - EAM - Basics First !

Maintenance, in all its essence, is an absolutely indispensable activity for all organizations today.

Downtimes or any damage due to malfunctioning of an equipment are most expensive and thus an immense squeeze in the profits. Almost each and every organization across industries have woken up to this fact and employ some or the other maintenance system

Furthermore to just having a system in place to take care of the maintenance activities, organizations today are moving towards most intelligent and sophisticated methods of maintenance viz. Predictive Maintenance and Reliability Centered Maintenance.

The goal of Predictive Maintenance is to perform maintenance exactly when the equipment needs it – neither earlier nor later than necessary. This essentially means tracking key indicators over time to predict when the equipment needs repair. Predictive maintenance programs measure equipment on a regular basis, track these measurements over time, and take preventive action whenever the measurements are about to go outside the operating limits. Repairing equipment as-needed requires fewer man-hours and parts than corrective maintenance.

In a similar fashion, Reliability Centered Maintenance focuses on prioritizing maintenance efforts based on equipment’s importance to operations, its downtime cost in revenue and customer loss, its cost of repair, and its impact on safety. It offers extensive analytical data to ensure that the critical equipments are identified and maintained on a priority. Reliability maintenance depends on the same measurements used in predictive maintenance, but saves additional maintenance cost by spending less effort on lesser important equipments

The EAM (Enterprise Asset Management) module in the Oracle E-Business Suite family offers these refined maintenance techniques of Predictive Maintenance as well as Reliability Centered Maintenance
But as they say, just implementing something does not ensure a job been done. It is equally important for people working with these methods to understand them thoroughly and learn how to identify potential problem areas. If an intelligent solution is implemented and work practices change accordingly, phenomenal results become apparent pretty soon.

Oracle EAM - Linear Asset Management - Overview

Most challenges in Linear Asset Management

Maintenance of linear assets (A kind of networks) is completely different from maintaining non linear assets like a fleet, machine. They through lot more challenges in modelling and executing the maintenance work compared to non linear assets. The ability to model and execute the maintenance these assets is what can tap the huge market potential in this segment.

Maintenance Assets can be broadly divided into two categories namely
a. Liner and
b. Non linear.

If we underrated non linear assets, it is easy to understand linear assets.

Non linear assets are like Plant, equipment, Machine, fleet etc., they are confined to a size and specific location etc., Maintenance of them is relatively easy.

Linear assets are not specific to single location. Linear assets can be like roads, runways, gas pipe lines, electrical transmissions, rail tracks, telecom lines etc., where they are not specific one single location. They more or less represent a network.

Many linear asset networks cross over with other networks and can also be a place holder of many non linear assets. For e:g one railway track can connect to other railway track and also holds many non linear assets like traffic control systems, stations, power generating equipment and more importantly other parallel linear asset like power cables etc., Maintaining these assets requires much more capability than maintaining non linear assets

There are many challenges that will surface in maintaining these assets. All these challenges need to be addresses adequately by any ERP to realize the benefits. Again the challenges will be different for different industries and this blog lists these challenges a generic manner.


1. Modelling of the linear assets:
As the linear assets are not confined to a single location but widely spread across some geographies, modelling of these assets is the first most challenge for any ERP. This modelling can be either engineering or visual in nature. For e.g. a metro rail network is spread across a city. Typical asset hierarchy may not work here.

2. Assigning the non linear assets to the linear assets:
Every linear asset can be a place holder for many non linear assets. For e.g. a national highway contains traffic signals, light posts at definite locations also requires maintenance.

3. Parallel networks:
There are some networks that work in parallel. A metro rail network requires a parallel power lines. Failure of any of them can result in stoppage of the services. Modelling of such networks is a challenge.

4. Intersecting networks:
Networks that cross over. Typically can operate independently but the shutting down of one network can result in shutting down of other network. A metro rail network and a road network can operate independently but the shutting down of one network can result in shutting down of other network due to cross over at some places. This requires additional tag out processes.

5. Planned downime of the network:
The linear assets or networks does not offer too much of a time for planned down time. They need to be scheduled typically on a weekend or public holidays by virtue of their connection to the public life. At times they need to be scheduled in summer only. This leaves additional challenge for the ERP systems.

6. Increased load on other networks:
At times when one network is down, the traffic is to be diverted to the other network. This mean, some networks can’t be planned for maintenance in parallel. Higher load on other networks means more usage that could result in breakdown as well.

7. Skilled personnel in performing the maintenance:
Maintaining the linear assets needs a crew (group of technicians) from different departments to work at the same time. e.g. technicians from civil and electrical departments.

8. Special equipment in performing the maintenance:
Maintaining these assets needs at times needs special crew. For e.g. a crane or excavator and their operators would be special equipment in executing the maintenance of these assets. Also arranging the required consumables to complete the maintenance work location requires initial assessment and planning.

9. Work orders planning and execution:
Work order planning and execution requires much more co-ordinated process than non linear assets. For e.g. arranging the crew from different departments, approvals from other departments even though the other department is not involved in the maintenance work. At times the maintenance of all networks is to be combined due to geographical constraints and same crew members. This also requires additional tag out processes.

10. Maintenance analytics:
Apart from planning and executing the work, the ERP should generate the required analytics like down time trend, cost of maintaining the network, allocation of the costs to different networks etc., requires additional features

Any ERP that can beat these challenges is sure to tap the huge market and we will see how Oracle EAM is offering various solutions to address these challenges

Oracle EAM and GIS Integration Setup and Overview

 

Geographic Information System (GIS) is an information system for storing, analyzing, managing and presenting digital data such as geographic features present on the Earth’s surface using spatial references.

 

Some of the GIS solutions available in the market are ESRI, Google Maps, Oracle Spatial, etc.

 

A Geocode (Geospatial Entity Object code) is a representation format of a geospatial coordinate measurement used to provide a standard representation of an exact geospatial point location on the earth. For example, the format (41°54’12″N, 87°37’35″W) indicates latitude, longitude of a unique location on earth.

Latitude gives the location of a place on earth north or south of the equator. Lines of Latitude are the horizontal lines shown running east-to-west on maps. Latitude is given as an angular measurement ranging from 0° at Equator to +90° at North Pole and -90° at South Pole.
An example of a latitude in DMS (Degrees Minutes Seconds) format is 41°54’12″N

Longitude is the east-west geographic coordinate measurement. Longitude is given as an angular measurement ranging from 0° at the prime meridian to +180° eastward and −180° westward.
An example of a longitude in DMS (Degrees Minutes Seconds) format is 87°37’35″W

Release 12.1.1 enables GIS Integration using web based source map viewer of Google maps and provision is given to allow assets/ instances to be geocoded so that they can be spatially located on the map viewer. All item instances, i.e. EAM Assets and OAT instances are eligible to be geocoded and viewed in the Asset map viewer

Release 12.1.1 provides ability so that item instances can have a provision to capture their geocodes i.e. Latitude and Longitude. This can be done either manually through a mass data entry page or automatically through an API. 
In Enterprise Assets Maintenance, users can search for any EAM assets using simple/ advanced search, enter geocodes for the assets using the ‘Mass Geocode Entry’ form, then locate the resulting asset on the map viewer by invoking the ‘Map All’ button. Alternatively, users can navigate to the Asset details page and locate the particular asset on the map viewer.

When a user selects any asset icon on the map viewer, details such as Asset Number, Description, Asset Group, Owning Department, Asset Location and Geocodes are displayed in a pop up. Also, hyperlinks are displayed for performing the following actions:

1. View asset details page
2. Create work request
3. Create work order
4. View open work requests
5. View open work orders
6. View Graphical Asset hierarchy.

 

 

When user selects any of the above actions, the page control is transferred to the appropriate tab in EAM responsibility with the context of the asset number selected. All other details corresponding to the selected asset number are defaulted when the page is rendered

SETUP STEPS

To enable the GIS Integration using Google Map feature, follow these instructions:
1. Set the following profile options:

• (R) System Administrator
• (N) Profile > Systems
  • ‘CSI: Mapviewer Name’ = Google

Profile value can be set at any level.

• ‘CSI: Google Registration key’

This profile hold the complete registration key (license key) for the Google Maps and can be set at any level

• ‘CSI: Google Map Client ID’

This profile hold the client ID for the licensed copy of

Google Maps and can be set at any level,

Contact Google to obtain Map Registration Key and Map Client ID

 

In R12.1.1, ‘Google’ and ‘Custom’ are the seeded values for ‘CSI: Mapviewer Name’ profile option. However, more look up values might be added in future releases based on other supported map viewers. If no value is set for this profile, then it is assumed that GIS integration is not intended. If it is set to ‘Google’, then GIS Integration with Google map is activated. If it is set to ‘Custom’, then GIS Integration with custom map viewer is activated. Custom source maps usually show details to a greater extent compared to the default images provided. Custom source maps can be either made by a tool if geocodes are available or a satellite imagery can be taken. Each source map viewer supports few specific formats of the custom source maps like Oracle Spatial supports 1 or 2 ESRI formats. Custom source maps in case of Utility industry can be entire stretch of utilities with associated information

2. Associate the function ‘Map All’ to the responsibility meant for accessing Maintenance user’s menu.

• (R) System Administrator
• (N) Application > Menu
  • Query for “EAM_MAINTENANCE_UNIT_SEARCH” menu.
  • Add the function ‘Map All’

Associating the ‘Map All’ function to the responsibility will enable ‘Map All’ button and ‘Map’ button to EAM/ OAT responsibilities.
3. Enter geocodes for assets/instances manually using the ‘Mass Geocode Entry’ form:

• (R) Maintenance Super User responsibility
• (N) Assets > Mass Geocode Entry
  • Query for an Asset Number
  • Enter geaocodes for the Asset
  • Save

Note: Geocode information capture can be allowed of all item instances, both customer and enterprise owned. except for Non-serial Rebuildables, Asset Routes and Systems

Geocode API: Geocodes can be entered for assets/instances using CSI_GIS_INSTANCE_LOC_PUB. IMPORT_INSTANCE_GEO_LOCATION Import API. This will enable mass entries for goecodes and save time. This Import API has been included in csipgilb.pls & csipgils.pls and meant to populate the CSI_II_GEOLOC_INTERFACE interface table

 

 

4. View the EAM Assets on Google Map:

•   (R) Maintenance Super User
•   (N) Assets > Capital
  • Query for an Asset Number
  • Click ‘Map All’ button to locate the asset in the Google Map Viewer

Note: Function ‘Map All’ need to be associated to the responsibility meant for accessing Maintenance user’s menu. By default, this function is not associated to any Maintenance responsibility

Oracle EAM Implementation Issues

Oracle eAM is a very powerful module and is giving a very stiff competition to its biggest competitor Maximo (MRO by IBM). Specially with its new features in r12, and seamless integration with Oracle Fixed Asset's Capitalization function. Nevertheless, a still developing module that it is, expect some issues while implementing the same. Though many of these issues have been resolved in Oracle Release 12, still some remains. Here is my effort to catalogue the same: Note: These issues are related to new eAM implementations only (and not subsequent issues that might crop up after Go-Live)

No. Issues/FAQs Solutions/Answers Metalink Note id 1 What is the integration between eAM and FA? On the eAM Asset Number, there is an "Other" tab where the FA Asset Number can be entered. This gives you a link between the eAM and FA Asset. As this implies, you will have to create an FA Asset Number and an eAM Asset Number. If you are using r12, there is lots more for you. Release 12 allows you to capitalize selected Work Orders for the assets which pass entries into the FA import transactions. For each Work Orders, yuo can select which elements (material/labor/OPS) you want to capitalize and by how much percentage 2 Impact of Closing Accounting Period When Incomplete Work Orders Exist Incomplete Work Orders count refer to Maintenance Work Orders that are scheduled to complete by period end but are not closed yet. While closing a period, the system displays a warning to the user indicating that some maintenance work orders have not been completed as yet. The user now has an option to respect the warning and go back and complete the work orders. If they do not respect the warning and go ahead and close the period (even though some work orders have not been completed), then the user can only complete the work order in an open period, which will be different from the scheduled completion date of the work order. Thus the maintenance history of the work orders will not be correct. 401311.1 3 What Role do Variance Accounts Play in eAM ? Variance accounts play no role in eAM. The proper set up is to load the appropriate maintenance expense account into both the valuation and variance account fields for the WIP Accounting Class. This will result in maintenance work order expenses booking to the expense account when incurred. So, when setting up WIP Accounting Classes, use the same maintenance expense account code in both the valuation and variance columns. This will cause maintenance expenses to book to the proper GL account and period. 372108.1 4 Cant Create New Asset Group: Asset Group Must Be Non- Transactable APP-INV-05623 Navigation - Inventory > Setup > Item > Atrribute Controls Status Attributes: Group Name = Inventory Attribute Name = Transactable Controlled At = Master Level Status Setting = Defaults Value (changed from previous value = Sets Value) However, this solution works only on an instance when PJM is installed. Please note that PJM does not need to be setup in it's entirety in order to use eAM application. All you need to do is to save PJM parameters for the eAM enabled organization. When you install eAM, the discrete mfg family is automatically installed. PJM is part of discrete family. So you should be able to just open the form and save it without entering any data. 374952.1 5 How to Change the Parent Asset of an Existing Asset Number As per functionality through forms, parent asset fields should be non-updateable. However, Configuration History Page (in Self Service) can be used to remove Parent Asset. We support the removal of the Parent Asset from Self Service. Forms are used to just establish the relationship (i.e. Add a Parent to an Asset) for the first time. Subsequently any changes in the hierarchy have to be done via the Configuration History Page in Self Service. 396972.1 6 What is the Purpose of the Maintenance Offset Account? The Maintenance Offset account is used for the accounting distribution entries of Rebuild Serial Number in the following transactions in R11i10: * When you instantiate a new Rebuild Serial Number, eAM generates a Miscellaneous Receipt transaction behind the scenes: - Dr. Subinventory Valuation accounts Cr. Maintenance Offset account * When you specify a parent asset for a Rebuild Serial Number that is in store, a Miscellaneous Issue transaction is created by eAM to move it out of inventory: - Dr. Maintenance Offset account Cr. Subinventory Valuation accounts * When you end-date a hierarchy, you have the option to return Rebuild Serial Number to inventory. No entries will be created if you do not select the option. - Dr. Subinventory Valuation accounts Cr. Maintenance Offset account 370142.1 7 11i INV INVIDITM - Effectivity Control field is missing in Item Master Screen under BOM tab Navigation : Project manufacturing super user Projects -> setup -> PJM organization parameters. 1. Enable Project costing flag in costing tab in organization parameters form 2. Define Organization as project manufacturing organization 8 Is it possible to display the asset description for all assets in Enterprise Asset Management (EAM) Self Service ? Yes, the profile option "EAM: Asset hierarchy description length" governs how asset description is displayed. Here is how the profile option behaves: A. If the option is not specified no asset description will be appended. B. If a number is specified for the profile value, the first characters up to that number will be appended in the following format: (1.....n of asset description) C. If a non-number or non whole number is specified for the profile value, no description will be displayed next to the asset number in the hierarchy. To enable the profile option: A. Navigate to Enterprise Asset Management B. Setup C. Profile -> 'EAM: Asset hierarchy description length' D. Specify a whole numeric value 253790.1 9 JSP Error Occurs While Accessing Work Orders In Self Service Cause 1. DISPLAY variable is not configured properly 2. Or, authorization of the Xserver on Linux is not set Fix Refer to the following Metalink Notes to verify X Server configuration: 139863.1 : Configuring and Troubleshooting Oracle HTTP Server with Oracle Applications 181244.1 : Configuring VNC Or XVFB As The X Server For Applications 11i 297965.1 10 How to generate updatewo.log and createwo.log file for a particular work order ? In order to provide additional information on the Work Order creation/ updation, EAM generates two additional files very usefull in debugging the Work Order issues. In order to generate the log files: updatewo.log or createwo.log it is necessary to have the following settings: 1. Under System Administrator > Profiles > System EAM: Debug Profile Option needs to be set to Yes at site level. 2. A writable directory in v$parameter. Perform the test case: create Work Order or Update Work Order in EAMWOMDF form. Every time when WO API is involved, the following files are generated: createwo.log , updatewo.log. These log files will be generated in the the first writable directory specified in v$parameter : Run the following query to determine the path: SELECT value FROM v$parameter WHERE name='utl_file_dir'; Please note: createwo.log is overwritten every time when a new work order is created. updatewo.log is overwritten every time when a new work order is updated. 395519.1 11 Is there a way to prefix Preventive Maintenance (PM) work orders, e.g., system profile like 'PM: Generate Work Order Prefix ' ? This is by design. We have prefix that can be set for manual Work Orders in the eAM Parameters window. However, we do not have any prefix that can be specified for the PM created work orders. Using a Prefix for PM created work orders is an enhancement request (Refer ER 5638441). 430484.1 12 Preventive Maintenance Work Orders Are Not Getting Generated Cause : The GL Accounting period was not defined for the period for which the user was trying to generate the work orders. Issue only comes with the work orders getting generated in the time period where the GL Accounting Periods are not defined. BUG 4879426 - PREVENTIVE MAINTENANCE WORK ORDERS NOT GETTING GENERATED Solution: Define the GL Accounting Periods. Generate Work Orders program requires the GL Accounting periods to be defined for the Work Orders to get generated during those periods. 344906.1 13 What is the functionality of the profile option "EAM: Maintenance Work Request Options" . This profile option was introduced in 11.5.9 and the profile option is set at the responsibility level Based upon the profile, EAM: Maintenance Work Request, users will be able to - Update All Work Requests - Update User Created Work Requests Only - View All but Update Users Created Work Requests (Also the Default Setting for the new Responsibilty) The above mentioned three are converted as the following 3 values for the profile : - View All and Update user logged - View and Update user logged only - View and Update All As this set in the responsibilty level it controls the way that the user can view and update work requests that are created by users. 292585.1 14 EAM Work Order Number is increasing at a very fast rate This can be prevented by 'pinning' the sequence in shared memory. Please do the following : 1. From sqlplus run the command exec dbms_shared_pool.keep('WIP_JOB_NUMBER_S', 'Q'); to pin the sequence. 2. Verify that there is no undue jumps in WO numbers. 3. After verification ,add it to some sql script which would run it at db startup, so that the pinning is not lost after a db bounce. References 287531.1 15 Things to do Prior to Logging an EAM (Enterprise Asset Management) Service Request or Bug This will be wxactly same as the Metalink note number 297007.1 16 EAMWOMDF - Asset Management Asset Attachments Do Not Copy To Work Order Solution to the problem : 1) Go to Application Developer responsibility. 2) Go to Attachments > Attachment Functions 3) Search in Attachment Function form for name = "EAMWOMDF" and user name = "EAM Work Order Definition". 4)Once you pull up the record for name = "EAMWOMDF", click on "Categories" button. A new window will pop up with the 3 default attachment categories for the work order (Maintenance Work Order Attachments,Miscellaneous,Operation Attachments) 5) Add another attachment category called "Asset Attachments (1)" to the list of categories. Save the Form. 6)Go back to your Work Order form and you will be able to view all the attachments that you have copied. 206140.1 17 How To Find EAM Maintenance User Workbench User Maintenance Workbench is a responsibility. To find it, navigate to System Administrator > Security > User > Define. Query the appropriate user name and add the responsibility = User Maintenance Workbench. 373409.1 18 Purchasing Category Contains No Values in Work Order Form - FRM-40212 To implement the solution, please execute the following steps: 1. Please download and review the readme and pre-requisites for Patch 4202684. 2. Please apply Patch 4202684 in a test environment. 3. Please confirm the following file versions: EAMMRMDF.fmb 115.77.11510.8 eamwork.odf 115.39.11510.8 4. Please retest the issue. 5. If the issue is resolved, please migrate the solution as appropriate to other environments. 364964.1 19 Unable To Select Non Stock Items In A Work Order: ORA-01403: No Data Found To implement the solution, please execute the following steps: 1. Apply patch 4202684 which is available via Metalink 2. Verify that version of EAMMRMDF.fmb is updated to 115.77.11510.8, as: - Go to EAM -> Work Order Details ->Material Requirements - Query a work order - From Tools menu, go to Help -> About Oracle Application - Scroll down to the Current Form section and verify the version 3. Test the scenario and verify the fix 304188.1 20 Requisition Import Is not Consistently Invoked. When creating new Direct Items, description only Items after the APPLY button is pressed, the Requisition Import Process is invoked immediately. But, when a Non-Stock Item is created and the APPLY button is pressed, the Requisition Import Process is not invoked immediately. The Work Order "Status" must be Changed/ Updated, which then Invokes the Requisition Import Process. To implement the solution, please execute the following steps: 1. Please download and review the readme and pre-requisites for Patch 4522821. 2. Please apply Patch 4522821 in a test environment. 3. Please confirm the following file versions: EAMVWOPB.pls and version 115.65.11510.17. 4. Please retest the issue. 5. If the issue is resolved, please migrate the solution as appropriate to other environments. 357836.1 21 In the Easy Work Order form, the work order operation does not have the file attachment. Apply patch 3262984 EAMVEXAB.pls 115.7.1159.5 EAMVEXAS.pls 115.2.1159.2 286346.1 22 eAM: ORA-06502: Numeric Or Value Error: Character String Buffer Too Small To implement the solution, please execute the following steps: 1. Please download and review the readme and pre-requisites for Patch 4655371. 2. Please apply Patch 4655371 in a test environment. 3. Please confirm the following file versions: EAMWOTHB.pls 115.35.11510.5 You can use the commands like the following: strings -a $EAM_TOP/EAMWOTHB.pls |grep '$Header' 4. Please retest the issue. 5. If the issue is resolved, please migrate the solution as appropriate to other environments 341722.1 23 An error occurred when add direct material on WO ORA-6502 PL/SQL ORA-6512 EAM_WORKORDER_UTIL_PKG To implement the solution, please execute the following steps: 1. Please download and review the readme and pre-requisites for Patch.4886427. 2. Please apply Patch 4886427 in a test environment. 3. Please confirm the following file versions: EAMVDIPB.pls-115.6.11510.2 . You can use the following commands to do it : select text from user_source where name like '%EAM_DIRECT_ITEMS_PKG_PVT%' and line=2; 4. Please retest the issue. 5. If the issue is resolved, please migrate the solution as appropriate to other environments. 361572.1 24 On 12.0.1 in Production: When attempting to complete work orders in eAM Self Service, the following error occurs: ERROR oracle.apps.fnd.framework.OAException: oracle.apps.edr.framework.EresException: ORA-20002: 3825: Error '-20001 - ORA-20001: APP-FND-01934: ORA-20001: Approval engine for the transaction type oracle.apps.eam.wo.comp.ss has failed with following error: ORA-01403: no data found. Change the approval setup and retry. in Package EDR_PSIG_RULE Procedure PSIG_RULE' encountered during execution of Rule function 'EDR_PSIG_RULE.PSIG_RULE' for event 'oracle.apps.eam.wo.comp.ss' with key '4001'.ORA-06512: at "APPS.WF_EVENT", line 2904ORA-06512: at "APPS.FND_WF_EVENT", line 126ORA-06512: at "APPS.EDR_ERES_EVENT_PVT", line 1074ORA-06512: at "APPS.EDR_UTILITIES", line 582ORA-06512: at line 2 To implement the solution, please execute the following steps:: 1. Go into the responsibility: System Administrator. 2. Navigate to Profiles > System. 3. Query up profile option for enabling ERES 'EDR: E-records and E-signatures' 4. Set value to No. 5. Retest the issue. 6. Migrate the solution as appropriate to other environments. 455024.1 25 ERROR ORA06512 APPS.AME_AP12 ORA06512 APPS.EAM_WORKORDER_UTIL_PKG Performed the following setups set the profile EDR: E-records and E-signatures = yes Responsibility :Approvals Managemnt Business Analyst 1)Search for Transaction Type: EAM Work Order Completion - SSWA->Approver Group ->Create a new Approver Group with the following settings Name:EAM-WO-COMP Type:Static Order No.:1 Voting Method:First Responder Wins and add an approver type: FND User 2)Go to Action Types->Use existing Action Type->Select approval-group chain of authority 3)Rules ->EAM Work Order Completion Approval Rule-> Click on Update icon->Add Action->Add the Action Type: Require approval from EAM-WOCOMP . Also, reset the EAM Parameter (EAM > Setups > Parameters)Enable Workflow for Work Orders = Yes performed the same setups for Transaction Type EAM Work Order Release Approval in AME. Responsibility :Approvals Managemnt Business Analyst 1)Search for Transaction Type: EAM Work Order Release Approval->Approver Group ->Create a new Approver Group with the following settings Name:EAM-WO-REL Type:Static Order No.:1 Voting Method:First Responder Wins and add an approver type: FND User 2)Go to Action Types->Use existing Action Type->Select approval-group chain of authority 3)Rules ->Work Order Release Approval Rule -> Click on Update icon ->Add Action->Add the Action Type: Require approval from EAM-WO-REL

Below link takes you to a qualitative analysis of Oracle EAM implementation practical issues !

http://www.oraclechamps.com/oracle-functional-documents/248-general-implementation-issues-in-oracle-eam.html