EAM_PROCESS_WO_PUB.PROCESS_WO ASSET_NUMBER VAlidation - SCM - Asset Lifecycle Management (ALM)(Archived)

Hi,
I am creating a work order by the API EAM_PROCESS_WO_PUB.PROCESS_WO for this i need to what validation i should perform for the asset_number and asset_group_id.
Thanks
SureshP 

Please see if these docs help.
How to upload EAM Work Orders through EAM_PROCESS_WO_PUB.PROCESS_WO (Example) [ID 311315.1]
Sample Script to Create Work Order Through Work Order API [ID 377975.1]
How Can We Pass The Work Order Close Date To Public API Eam_process_wo_pub.Process_wo [ID 1363584.1]
How To Make API WIP_EAM_WORKREQUEST_PUB Update Work Requests [ID 472455.1]
Creating a work order through API EAM_PROCESS_WO_PUB.PROCESS_WO does not return any error message [ID 390316.1]
Thanks,
Hussein

Related

Receiving Open Interface 11i

Good Day!
I would just like to ask what is the navigation path of Receiving Open Interface in iREP. I can't find it in 'Procurement' module.
Thanks in advance! 
Hi jeff;
I would just like to ask what is the navigation path of Receiving Open Interface in iREP. I can't find it in 'Procurement' module.Please check here:
Welcome to the Oracle Integration Repository
http://irep11i10.oracle.com/OA_HTML/OA.jsp?page=%2Foracle%2Fapps%2Ffnd%2Frep%2Fwebui%2FInterfacesBrowsePG&_ti=525665121&oapc=3&oas=YgWTB2T_97mST4Y-FwmYgQ..
PS: 'Procurement' module is avaliable on http://irep11i10.oracle.com/ on left side menu under Process Manufacturing
Regard
Helios 
Thanks for the reply
I can see the 'Procurement' module but what I am looking for is the 'Receiving Open Interface' I looked at every sub-menu in Procurement -> Purchasing and I cant seem to find Receiving Open Interface.
I am in the process of implementing an interface for PO Receipts and I am looking for information to submit the 'Receiving Transaction Processor' via pl/sql procedure that is why I am looking it up on iREP
Thank you in advance :D 
Hi Jeff;
Please check below:
Receiving Open Interface: Description of Features and Sample Scripts [ID 559956.1]
OPEN INTERFACES: Receiving Open Interface (ROI) - Release 10.7, 11.0, 11.5.X
Sample Receiving Open Interface Script (ezROI) [ID 245334.1]
11.5.10 / R12 ROI How to Correct Receiving Transaction with Receiving Open Interface? [ID 335699.1]
Also check:
http://jyotioraapps.blogspot.com/2009/08/receiving-po-using-receiving-open.html
Hope it helps
Regard
Helios 
Thanks Helios for those helpful links.
Upon further 'google-ing' I found the submit procedure via PL/SQL which is (this might be helpful for someone else in the future)
Line: -----
fnd_request.submit_request('PO', --APPLICATIONI SHORT NAME;
'RVCTP', --PROGRAM SHORT NAME;
'',
'',
FALSE,
'BATCH',
v_group_id
);
*v_group_id = the group id fetched from RCV_INTERFACE_GROUPS_S sequence
Line: -----
But now, I'm stuck with an error in the interface lines. My transaction_type = RECEIVE and auto_transact_code = DELIVER and metalink says that I need to populate SUBINVENTORY and DELIVER_TO_LOCATION_ID, or DELIVER_TO_LOCATION_CODE.
Any idea on what I should put in DELIVER_TO_LOCATION_ID/CODE? I'm not that familiar with PO, any look-up table/master table where values for Deliver to Location which I can query?
Again, thanks for your time :D 
Hi Jeff;
Any idea on what I should put in DELIVER_TO_LOCATION_ID/CODE? I'm not that familiar with PO, any look-up table/master table where values for Deliver to Location which I can query?Please check etrm.oracle.com side for integration of table and clolumns
Hope it helps
Regard
Helios

EAM_PROCESS_WO_PUB for creating EAM work orders

Hi all
Is there anybody that use EAM_PROCESS_WO_PUB api for creating eam work order in release 12.1.1
I have written a procedure for creating eam work order.
I use EAM_PROCESS_WO_PUB api.
Procedure ends with "S" (success) status but the work order isn't created.
Is there a sample about how this API is used. I found a sample in Metalink. But it's useless.
Thanks
Engin 
Do you see a record in the wip_discrete_jobs tables?
Have you trying looking up the work order on the Maintenance workbench screen AND the WIP work order screen?
Does it show up on one but not the other?
Sandeep Gandhi 
I wirte an sql for wip_discrete_jobs table.
And there isn't any record.
I try to use wip_job_schedule_interface now.
I don't know if I will be successful or not but I will try.
Thanks
Engin 
Hi Engin :)
Please check below note which could be helpful for your issue:
Sample Script to Create Work Order Through Work Order API [ID 377975.1]
CANNOT CREATE WORK ORDER DUE TO INVALID PACKAGE EAM_PROCESS_WO_PVT [ID 1051335.1]
Also see:
How to Calculate Work Order Duration Using EAM_PROCESS_WO_PUB API [ID 388523.1]
CANNOT CREATE WORK ORDER DUE TO INVALID PACKAGE EAM_PROCESS_WO_PVT [ID 1051335.1]
Regard
Helios

ar invoice_api_pub.create_invoice can not create CM

Hi to all.
When using ar invoice_api_pub.create_invoice can not create CM having error massage
Transaction type is invalid with current transaction date
Is someone familier with that api/ errors ?
is there any docs to workaround this error?
Thank you in advance
Soni 
What is the application release?
Please see if (How To Create Invoice Using API AR_INVOICE_API_PUB.Create_Invoice - Sample [ID 265604.1]) helps.
Thanks,
Hussein 
Thank you for your response
i have used
(Transactions APIs Setup & Usage Guide [ID 734232.1])
(How To Create Invoice Using API AR_INVOICE_API_PUB.Create_Invoice - Sample [ID 265604.1])
to develop a plsql procedure
As per ID 734232.1 it is said that
On Account credit memos can be created using ar_invoice_api_pub using the Transaction Type ID for the credit memo as follows:
l_trx_header_tbl(1).cust_trx_type_id := 2; -- Credit Memo
and negative amount as follows:
l_trx_lines_tbl(1).unit_selling_price := -100;
when i try to make a test the following error is displayed in ar_trx_errors_gt tables "*Transaction type is invalid with current transaction date*"
I have also checked the if the start date on transaction type is before the transaction date.
I am stacked at this point
Regards,
Soni 
Kindly repost. 
If the doc referenced above did not help, please log a SR.
Thanks,
Hussein 
Thank you hsawwan .
I will go after your recommendation.
Kind regards,
Soni

API or Interface table for receiving an RMA return line

is there an API or interface table for receiving an RMA return line? any example/notes available that can i refer to ? 
Hello,
Look at: http://www.oracleappshub.com/oracle-purchasing/oracle-api-availability-purchasing/ sentence What you can't done by this API's
You have sample: How to Receive and Deliver Against RMA Using ROI [ID 339835.1]
Regards,
Luko

Error while Multiple PO line Update  Using Update API

Hello All,
I want to update multiple Lines of PO. for that I am using PO_CHANGE_API1_S.UPDATE_PO API.
But some how whenever I am updating multiple PO lines am getting following error
This document is locked by another user. Please try again later.
I tried with DBMS_LOCK.SLEEP(1), but sometimes its working and sometimes its not.
Could anybody tell me how can I avoid this, Is there any other way to achieve this. Please help
Thanks in advance
Ravi Raj. 
I'm not sure about the code you are using but you may review the following docs for sample codes about using this API.
How API Po_change_api1_s.Update_po works in 11.5.10? [ID 335083.1]
How to use PO_CHANGE_API1_S.update_po to Change Three Lines [ID 1077455.1]
Vision Demo - How To Use the PO Change API To Update Existing Purchase Orders [ID 1078842.1]
Thanks,
Hussein

Categories

Resources