Need JobList data element info for Supplier Import Submission WebService

Need JobList data element info for Supplier Import Submission WebService           Problem Desc Under procurement cloud R11 , customer is using FBDI , "loadAndImportData" operation to upload CSV file of import Suppliers to ERP cloud . WSDL: https://edpe-test.fin.us2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL Operation : loadAndImportData <oer:parameter name="jobList" description="List of elements, each containing the details of the ESS job to be submitted to import and process the uploaded file. The details include the job definition name, job package name, and list of parameters."/> Not able to find required jobList payload details for "import Suppliers " The Attached document shows the information for Journal Import. Customer is looking for similar info for Supplier Import. Please advise.

Solution

Looks like customer expects the package name, job names and parameter list for supplier import. Here are the details, let is know if you need anything else:

Package Name: /oracle/apps/ess/prc/poz/supplierImport

Job Names:
ImportSuppliers
ImportSupplierAddresses
ImportSupplierContacts
ImportSupplierBusinessClassifications
ImportSupplierProductsandServicesCategory
ImportSupplierSites
ImportSupplierSiteAssignments

so in the service, this shall be used to import addresses: <ns2:JobName>/oracle/apps/ess/prc/poz/supplierImport,ImportSupplierAddresses</ns2:JobName>

For the parameter list, use - first option as New, All, Rejected and for second option use Y or N.
example: <ns2:ParameterList>NEW,Y</ns2:ParameterList>

Operation: loadAndImportData

The loadAndImportData operation uploads a file to the UCM server based on the document specified and submits an ESS job to load and import the uploaded files to an application table.

The following table lists the parameters for this operation:

Parameter Name	Description	Parameter (In/Out)	Mandatory	Type
Document	List of elements, each containing the details of the file to be uploaded. The details include the file content, file name, content type, file title, author, security group, and account. Document Attributes: •       Content: File content uploaded on to the UCM server. The value of the content tag is obtained by converting the file content into Base64 encoding. •       FileName: Name of the file on the UCM server. •       ContentType: Type of the content file format uploaded, such as.zip, .txt, or .csv. •       DocumentTitle: Title of the file on the UCM server. •       DocumentAuthor: Author of the document. •       DocumentSecurityGroup: A fixed value used to import or export documents on the UCM server. The security group for all the import processes is FAFusionImportExport. •       DocumentAccount: Account under which the file is uploaded..	IN	Yes	java.lang.String
Joblist	List of elements containing the details of the ESS job used to import and process the uploaded file. The details include the job definition name, job package name, and list of parameters.	IN	Yes	java.lang.String
Interface Details	The interface identifier of the specific product interface table to which data is loaded.	IN	No	java.lang.String
Notification Code	A two-digit number that determines how and when a notification is passed for the status of the import job. See the table below for the notification code values.	IN	No	java.lang.String
Callback URL	The callback URL of the specific web service implemented by a customer to receive the ESS job status upon job completion.	IN	No	java.lang.String
Response Code	The response code that returns the request identifier for the first import job in the joblist.	OUT		java.lang.Long

Note If the file upload to the UCM server has failed, then the rest of the ESS jobs are not executed and the response code will return as 0.

The notification code key information is outlined in the table below:

Digit Position	Digit Value	Meaning
First digit	1	E-mail notification
	2	Bell notification
Second digit	0	Send in any case (import failed or succeeded)
	1	Send on import success
	2	Send on import failure

The following sample payload illustrates the Journal Import process:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">      <soap:Body>           <ns1:loadAndImportData xmlns:ns1="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">                <ns1:document xmlns:ns2="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/">                     <ns2:Content>UEsDBBQAAAAIAHSsJUWkOHOwFAEAAHgDAAAXAAAAQXBJbnZvaWNlc0ludGVyZmFjZS5jc3bV0U9LwzAYBvC74HcIO3h61+XN/xzrqlLRItYJHivmUOzKbFJEP73p1sEQymDgwef0HB5I8gtKREop5Nc35LL3deu8J6u2DrC8S/P7EnAcKGtpwoBRFAtkC6ohOB9cG1y36WrvyGvVvpMLErreB1BMCo1gmNWaw6rM4AOgfEqLLH3MAKSao+TGSgVp8QL5eu3e6io4iNmfwHHsVA/9oE4EId6TMso0p3OEZGp3Qq6K7PxsK8HtEao4QC4Hsd1D6J5qU/UNCRHJdb5xX5HIcKRguBZsR1QdEnE1Z8oKI6aIRosTiFCgjD/A/ohI8CNEcSDVb6LZYPRcu4Y8JGRZ+U/XNEBuu2Q2SGkuo5SRUmylvv+91A9QSwMEFAAAAAgAM4YNRYXONvBWAAAAxQEAABsAAABBcEludm9pY2VMaW5lc0ludGVyZmFjZS5jc3YzNDU0NDAw0DHU8Qxx9dUxs7Q00DPSAYJCHWRgqKNjZGBoom9sqG9grkNT4OrnwstlCHKWsSXMWYbGpiBHAkEiilqjgXCWiTHMWaZmMGdVoag1prOzAFBLAQIUABQAAAAIAHSsJUWkOHOwFAEAAHgDAAAXAAAAAAAAAAEAIAAAAAAAAABBcEludm9pY2VzSW50ZXJmYWNlLmNzdlBLAQIUABQAAAAIADOGDUWFzjbwVgAAAMUBAAAbAAAAAAAAAAEAIAAAAEkBAABBcEludm9pY2VMaW5lc0ludGVyZmFjZS5jc3ZQSwUGAAAAAAIAAgCOAAAA2AEAAAAA</ns2:Content>                     <ns2:FileName>TestUploadFileName.zip</ns2:FileName>                     <ns2:ContentType>zip</ns2:ContentType>                     <ns2:DocumentTitle>LoadandImportCallbacktest</ns2:DocumentTitle>                     <ns2:DocumentAuthor>finuser1</ns2:DocumentAuthor>                     <ns2:DocumentSecurityGroup>FAFusionImportExport</ns2:DocumentSecurityGroup>                     <ns2:DocumentAccount>fin$/journal$/import$</ns2:DocumentAccount>                     <ns2:DocumentName></ns2:DocumentName>                     <ns2:DocumentId></ns2:DocumentId>             </ns1:document>                <ns1:jobList xmlns:ns2="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/">                     <ns2:JobName>/oracle/apps/ess/financials/generalLedger/programs/common,JournalImportLauncher</ns2:JobName>                     <ns2:ParameterList>1061,Expenses,1,ALL,N,N,N</ns2:ParameterList>                     <ns2:JobRequestId></ns2:JobRequestId>             </ns1:jobList>                <ns1:interfaceDetails>1</ns1:interfaceDetails>                <ns1:notificationCode>10</ns1:notificationCode>                <ns1:callbackURL>#NULL</ns1:callbackURL>         </ns1:loadAndImportData>     </soap:Body> </soap:Envelope>

Figure 3. Sample payload for the Journal Import process.