Hell Everybody,
My IPM server :11.1.1.3 version(linux)
EBS server:R12 version
i m following the below process.
Uploading document(for KFI) through the document capture,then it goes to the IPM server.
Then in EBS server click the zoom button ,IPM task viewer page is opened.
Login as user1:
Push the data into EBS looking IPM task viewer data.
Save it in EBS.Click Invoice Approval ,provide permission to get data to a particular user.
Login as User2:no task found.
Error in BPEL instance is as below:
*<part name="summary">*
*<summary>Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'Get_InvoiceTransaction' failed due to: Interaction processing error. Error while processing the execution of the BPEL_RETRIEVEINVOICE.AXF_VALIDATION_IMPORT_PKG$RET API interaction. An error occurred while processing the interaction for invoking the BPEL_RETRIEVEINVOICE.AXF_VALIDATION_IMPORT_PKG$RET API. Cause: java.sql.SQLException: invalid name pattern: AXF.AXF_VALIDATION_IMPORT_PKG_R_I ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary>*
*</part>*
*<part name="detail">*
*<detail>invalid name pattern: AXF.AXF_VALIDATION_IMPORT_PKG_R_I</detail>*
So can anyone tell what packages are used to integrate IPM and EBS.
Following are the sql file names for integrating IPM with EBS:
PATH\CREATE_TEMP_TABLE.sql;
PATH\AXF_VALIDATION_IMPORT_PKG.sql;s
PATH\AXF_VALIDATION_IMPORT_PKG_BODY.sql;
PATH\AXF_PREIMPORT_CUSTOM_PKG.sql;
PATH\AXF_PREIMPORT_CUSTOM_PKG_BODY.sql;
PATH\BPEL_11G_IMPORTINVOICE.sql;
PATH\BPEL_PLACEIPMVALIDATIONHOLDSON.sql;
PATH\BPEL_PREIMPORTCLEANUP.sql;
PATH\BPEL_UPDATEHOLDLIST.sql;
PATH\BPEL_VALIDATEINVOICE.sql;
PATH\BPEL_RETRIEVEINVOICE.sql;
PATH\BPEL_GETORGID.sql;
PATH\EBS_CREATE_HOLD_LOOKUP.sql;
Please response me ASAP.
With Regards
Jyoti