Oracle12: 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