Thursday 13 June 2019

Post Mass Additions Book Parameter List Of Values (LOV) Is Empty

Issue : Post Mass Additions Book Parameter List Of Values (LOV) Is Empty
Solutions:
Case-1 : There are no record in fa_mass_additions interface in POST queue.
Case-2 : provide data access set for the user to Asset boot for the roles Asset Administrator, Asset Accounting Manager.

Wednesday 12 June 2019

Sample Soap Payload for Uploading attachment to the requisitions

Sample Soap Payload for Uploading attachment to the requisitions 
<!-- Request Payload -->
<soapenv:Envelope xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:uploadAttachment>
         <typ:entityName>POR_REQUISITION_HEADERS</typ:entityName>
<!---POR_REQUISITION_HEADERS – for requisition header attachments
POR_REQUISITION_LINES – for requisition line attachments---->
         <typ:categoryName>MISC</typ:categoryName>
         <typ:allowDuplicate>yes</typ:allowDuplicate>
         <!--Zero or more repetitions:-->
         <typ:attachmentRows>
            <!--Optional:-->
            <erp:UserKeyA>Requsition number</erp:UserKeyA>
            <!--Optional:-->
            <erp:UserKeyB>Business Unit</erp:UserKeyB>
            <!--Optional:-->
            <erp:UserKeyC>#NULL</erp:UserKeyC><!--Line number-->
            <!--provide line number if adding attachments to lines else provide null-->
            <!--Optional:-->
            <erp:UserKeyD>#NULL</erp:UserKeyD>
            <!--Optional:-->
            <erp:UserKeyE>#NULL</erp:UserKeyE>
            <!--Optional:-->
            <erp:AttachmentType>TEXT</erp:AttachmentType>
            <!--Optional:-->
            <erp:Title>SampleFILE.txt</erp:Title>
            <!--Optional:-->
            <erp:Content>Testing Attachment for PO using Requsition number</erp:Content>
         </typ:attachmentRows>
      </typ:uploadAttachment>
   </soapenv:Body>
</soapenv:Envelope>

Response 

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
   <env:Header>
      <wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpObjectAttachmentService/uploadAttachmentResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:b09e60ec-9867-43dc-9984-80529b6b39e0</wsa:MessageID>
   </env:Header>
   <env:Body>
      <ns0:uploadAttachmentResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
         <result xmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">"Attachment1":"SUCCEEDED"</result>
      </ns0:uploadAttachmentResponse>
   </env:Body>
</env:Envelope>

Thursday 30 May 2019

Importing Supplier Attachments in oracle Cloud


You can import attachments for supplier profiles, supplier sites and supplier business classifications for existing suppliers. Different types and categories of attachments can be imported.
You can import attachments for:
  • Supplier profile
  • Supplier sites
  • Supplier business classifications
For File type attachments, you must add the file to a .zip file and upload the .zip to the Procurement Suppliers UCM account: /prc/supplier/import.
Multiple files can be added to the same .zip file and can be organized within folders as needed.
The template is designed to accept the path along with the file name. 
 

Place the file ‘PricingSheet-Supplier1.pdf’ used for attachment in company_data.zip and upload to UCM folder /prc/supplier/import in file import and export.

Generate csv from the SupplierAttachmentImportTemplate FBDL .
Upload the file to UCM folder /prc/supplier/import
Run Load Interface File for Import  as Shown below.
 

Once the above process completes Successfully Run “Import Supplier Attachments” with batch Id As Input which was given in FBDL template as Show below.
 

Will get the Status of import as shown below.
 
Supplier screen