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.










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

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>