Wednesday, 3 February 2021

Oracle Fusion ERP and SCM Cloud Application - Custom Object - Find Entity - SOAP Envelop - Request and Response Sample payload

 --ERP and SCM Cloud Application - Custom Object WSDL Link--

https://servername/fscmService/FscmCustomReferenceService?WSDL 


--SOAP Request--

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">

   <soapenv:Header/>

   <soapenv:Body>

      <typ:findEntity>

         <typ:findCriteria>

            <typ1:fetchStart>0</typ1:fetchStart>

            <typ1:fetchSize>500</typ1:fetchSize>

         </typ:findCriteria>

         <typ:findControl>

            <typ1:retrieveAllTranslations>false</typ1:retrieveAllTranslations>

         </typ:findControl>

         <typ:objectName>Party_c</typ:objectName>

      </typ:findEntity>

   </soapenv:Body>

</soapenv:Envelope>


--SOAP Response--

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/">

   <env:Header>

      <wsa:Action>http://xmlns.oracle.com/apps/custom/extnService//FscmCustomReferenceService/findEntityResponse</wsa:Action>

      <wsa:MessageID>urn:uuid:afe8e8c1-64a6-4da0-8d2f-e908e9b7ddc4</wsa:MessageID>

   </env:Header>

   <env:Body>

      <ns0:findEntityResponse xmlns:ns0="http://xmlns.oracle.com/apps/custom/extnService/types/">

         <ns2:result xsi:type="ns1:Party_c" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

            <ns1:Id>300000011991343</ns1:Id>

            <ns1:RecordName>Denial Den</ns1:RecordName>

            <ns1:CreatedBy>test.scm</ns1:CreatedBy>

            <ns1:CreationDate>2021-01-14T07:24:06.326Z</ns1:CreationDate>

            <ns1:LastUpdatedBy>test.scm</ns1:LastUpdatedBy>

            <ns1:LastUpdateDate>2021-01-14T07:24:59.836Z</ns1:LastUpdateDate>

            <ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>

            <ns1:RecordNumber>11</ns1:RecordNumber>

            <ns1:LastUpdateLogin xsi:nil="true"/>

            <ns1:UserLastUpdateDate xsi:nil="true"/>

            <ns1:CurrencyCode>USD</ns1:CurrencyCode>

            <ns1:CurcyConvRateType>Corporate</ns1:CurcyConvRateType>

            <ns1:CorpCurrencyCode>USD</ns1:CorpCurrencyCode>

            <ns1:PartyNumber_c>1003</ns1:PartyNumber_c>

            <ns1:SelectedRow xsi:nil="true"/>

            <ns1:PartyName_c>Denial Den</ns1:PartyName_c>

         </ns2:result>

      </ns0:findEntityResponse>

   </env:Body>

</env:Envelope>


Oracle Fusion ERP and SCM Cloud Application - Custom Object - Create Entity - SOAP Envelop - Request and Response Sample payload

--ERP and SCM Cloud Application - Custom Object WSDL Link--

https://servername/fscmService/FscmCustomReferenceService?WSDL 


--SOAP Request--

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom">

   <env:Body>

      <ns2:createEntity>

         <ns2:object xsi:type="ns1:Party_c" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

            <ns1:RecordName>Test3</ns1:RecordName>

            <ns1:PartyNumber_c>1001</ns1:PartyNumber_c>

            <ns1:PartyName_c>Test3</ns1:PartyName_c>

         </ns2:object>

         <ns2:objectName>Party_c</ns2:objectName>

      </ns2:createEntity>

   </env:Body>

</env:Envelope>


--SOAP Response--

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/">

   <env:Header>

      <wsa:Action>http://xmlns.oracle.com/apps/custom/extnService//FscmCustomReferenceService/createEntityResponse</wsa:Action>

      <wsa:MessageID>urn:uuid:b4d84f48-ffc0-4554-ae34-227e57ed79eb</wsa:MessageID>

   </env:Header>

   <env:Body>

      <ns0:createEntityResponse xmlns:ns0="http://xmlns.oracle.com/apps/custom/extnService/types/">

         <ns2:result xsi:type="ns1:Party_c" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

            <ns1:Id>300000012482600</ns1:Id>

            <ns1:RecordName>Test3</ns1:RecordName>

            <ns1:CreatedBy>test.scm</ns1:CreatedBy>

            <ns1:CreationDate>2021-02-03T12:02:00.0Z</ns1:CreationDate>

            <ns1:LastUpdatedBy>test.scm</ns1:LastUpdatedBy>

            <ns1:LastUpdateDate>2021-02-03T12:02:00.519Z</ns1:LastUpdateDate>

            <ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>

            <ns1:RecordNumber>4010</ns1:RecordNumber>

            <ns1:LastUpdateLogin xsi:nil="true"/>

            <ns1:UserLastUpdateDate xsi:nil="true"/>

            <ns1:CurrencyCode>USD</ns1:CurrencyCode>

            <ns1:CurcyConvRateType>Corporate</ns1:CurcyConvRateType>

            <ns1:CorpCurrencyCode>USD</ns1:CorpCurrencyCode>

            <ns1:PartyNumber_c>1001</ns1:PartyNumber_c>

            <ns1:SelectedRow xsi:nil="true"/>

            <ns1:PartyName_c>Test3</ns1:PartyName_c>

         </ns2:result>

      </ns0:createEntityResponse>

   </env:Body>

</env:Envelope>

Sunday, 31 January 2021

Oracle Fusion: Application Composer



1) How to Create Custom Object and Page using Oracle Fusion Application Composer

Oracle Fusion Application Composer: How to create a custom object and page


Video Link: (Specially Prepared for the lazy people😜)

Oracle Fusion: Application Composer


2) How to Design Oracle OTBI Report Using Custom Object which is defined by Application Composer.

Oracle Fusion Application Composer: How to Design Oracle OTBI Report Using Custom Object.


3) How to Upload Bulk Data in custom objects.

Oracle Fusion Application Composer: How to upload Bulk data in Custom Object


4) Oracle Fusion Application Composer: How to find base tables for Custom Objects.

Oracle Fusion Application Composer: How to find base tables for Custom Objects


5) Oracle Fusion CRM - Custom Object - SOAP Envelop - Request and Response Sample payload



6) Oracle Fusion ERP and SCM Cloud Application - Custom Object - SOAP Envelop - Request and Response Sample payload