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>