Monday 22 February 2021

Oracle Fusion BIP Report - Interactive Layout - Bar Graph need to show numeric values

Requirement:  How to enable numeric value on interactive layout Bar Graph Property in BIP Report.


Solution:

You can set Data Visible property Under the heading Chart Plot Area. Please find below a screenshot where I have highlighted the property to enable numeric value on the interactive layout.










Posted by at No comments:
Labels:

Wednesday 3 February 2021

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

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

https://servername/fscmService/FscmCustomReferenceService?WSDL


1) CreateEntity

Create Entity


2) Find Entity

Find Entity


3) Get Entity

Get Entity


4) Update Entity

Update Entity

Posted by at 2 comments:
Labels:

Oracle Fusion ERP and SCM Cloud Application - Custom Object - Update 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:updateEntity>

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

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

            <ns1:RecordName>Test31</ns1:RecordName>

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

         </ns2:object>

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

      </ns2:updateEntity>

   </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/updateEntityResponse</wsa:Action>

      <wsa:MessageID>urn:uuid:6b16de27-7b2b-48b8-b5d6-9ea55f10b9dd</wsa:MessageID>

   </env:Header>

   <env:Body>

      <ns0:updateEntityResponse 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>Test31</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:15:10.0Z</ns1:LastUpdateDate>

            <ns1:ObjectVersionNumber>2</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:updateEntityResponse>

   </env:Body>

</env:Envelope>

Posted by at No comments:
Labels:

Oracle Fusion ERP and SCM Cloud Application - Custom Object - GetEntity - 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/">

   <soapenv:Header/>

   <soapenv:Body>

      <typ:getEntity>

         <!--Zero or more repetitions:-->

         <typ:keyValue>300000011991343</typ:keyValue>

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

      </typ:getEntity>

   </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/getEntityResponse</wsa:Action>

      <wsa:MessageID>urn:uuid:5c344cd8-e108-4956-9cd3-7bac45ab8454</wsa:MessageID>

   </env:Header>

   <env:Body>

      <ns0:getEntityResponse 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:getEntityResponse>

   </env:Body>

</env:Envelope>

Posted by at No comments:
Labels:

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>


Posted by at No comments:
Labels:

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>

Posted by at 3 comments:
Labels:
Subscribe to: Posts (Atom)