Data Integration

Get Involved. Join the Conversation.

Posts

  • Hiten Shah
    AR invoice negative amount issue via REST API
    Topic posted December 5, 2019 by Hiten ShahRed Ribbon: 250+ Points, tagged Cloud 
    Title:
    AR invoice negative amount issue via REST API
    Content:

    Hello Everyone,

    While creating an AR invoice with negative amount in any of the lines, the AR invoice is not getting created via REST API but when we do it manually using Application, it allows to create.  It also works when using FBDI template, but fails with API.  Not sure if we are missing a parameter.

    I have attached the sample request payload for working as well as not working AR invoice CREATE payload.

     

     

    Image:
    Document:
  • Justin Kalin
    API Endpoint to provide a List of Users
    Topic posted November 20, 2019 by Justin KalinGreen Ribbon: 100+ Points, tagged Data Transformation 
    Title:
    API Endpoint to provide a List of Users
    Summary:
    Looking for an API Endpoint to provide a List of Users
    Content:

    I am assisting the development of a Rest API between Oracle Cloud and a third-party mobile app. As part of the integration, there is a need to get the full list of users (employees, vendors, etc.) from the cloud into the third-party mobile app, and to provide real-time updates on the full list of users, such as the creation and deletion of users, or updates to existing users.

    In order to accomplish this, the developer needs to know the API endpoint for that user data. I am wondering if anyone can point me in the direction of the correct API endpoint?

    The several lists of API endpoints can be found in the documentation below, which consists of references to all endpoints for Administrative Service and Analytics and Consumer Service and Gateway Controller and Management Service:

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrp/rest-endpoints.html

    It seems from these lists that there may not be an API endpoint provided for this purpose; but if there is one, I have the impression it would be derived from one of the following:

    Get content data for the given custom page

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrc/op-services-v1-portal-customization-pages-pageid-content-get.html

    Get custom page metadata

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrc/op-services-v1-portal-customization-pages-pageid-metadata-get.html

    Get service accounts a user can reference

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrm/op-apis-apiid-references-serviceaccounts-get.html

    Get Service Accounts

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrm/op-serviceaccounts-get.html

    Get Service Account details

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrm/op-serviceaccounts-said-get.html

    Update a Service Account

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrm/op-serviceaccounts-said-put.html

    Update Service Account Identity

    https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfrm/op-serviceaccounts-said-identity-put.html

  • Mohd Shahnawaz Mohd Merajuddin
    Creating Part of file while sFTP file transfer is in...
    Topic posted October 28, 2019 by Mohd Shahnawaz Mohd Merajuddin, tagged Cloud 
    Title:
    Creating Part of file while sFTP file transfer is in progress.
    Summary:
    Part files while file transfer is in process in paaS(MFT and DBCS)
    Content:

    Hi All, 

    Unlike we have a sFTP feature in HCM SaaS, where you can select an option to create a part file while sFTP file transfer is in progress, do we some a similar kind of feature in PaaS DBCS or Oracle managed file transfer.

     

    Thanks,

    Shahnawaz

    Image:
  • Navin Paremalla
    GGCC-20022: Error getting JPS credential store instance
    Topic posted October 23, 2019 by Navin Paremalla, tagged Cloud, DIPC, ODI, On-Premise 
    Title:
    GGCC-20022: Error getting JPS credential store instance
    Summary:
    Error while trying to install DIPC Agent on my linux server
    Content:

    I got all the required details from my DIPC instance and was running the ./dicloudConfigureAgent.sh. While running and after the "Enter agent IDCS Client scope" line I am facing the error GGCC-20022: Error getting JPS credential store instance.

    Code Snippet:
  • Subrahmanyam Vempati
    ODI-Read files from SFTP Server25.0
    Topic posted October 17, 2019 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged Cloud, ODI, Tip 
    Title:
    ODI-Read files from SFTP Server
    Summary:
    ODI-Read files from SFTP Server
    Content:

    Hi ,

    We want to read the files from SFTP server and process in ODI. Is there any way we can read the file content directly , Instead of loading it in local folder and process.

    Thanks,

    Vempati

    Version:
    ODI 12c
  • Mohan
    How to access RCU in ODI Marketplace?2
    Topic posted October 17, 2019 by Mohan, tagged ODI 
    Title:
    How to access RCU in ODI Marketplace?
    Summary:
    ODI in the marketplace comes with pre-built MySql and WLS. How do we create work repositories in a oracle DBCS.
  • Subrahmanyam Vempati
    How to Provision DIPCS?2
    Topic posted October 7, 2019 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged DIPC, ODI, Provisioning 
    Title:
    How to Provision DIPCS?
    Summary:
    Provision DIPCS Instance
    Content:

    Hi Team,

    Could anyone please help to share the steps to provision DIPCS Instance.With the changes in the new OCI UI, It is getting difficult to follow oracle documentation.

    Thanks,

    Vempati

  • Nathaniel Vadde
    How to Integrate two instances on Oracle Cloud2
    Topic posted September 5, 2019 by Nathaniel Vadde, tagged Tip 
    Title:
    How to Integrate two instances on Oracle Cloud
    Summary:
    How to Integrate two instances on Oracle Cloud
    Content:

    We have two instances on Oracle Cloud, on one instance we have linux and Oracle database installed on it, and on the other instance we installed Windows Server. We are not able to communicating between linux instance and windows server instance in Oracle Cloud. We are successfully communicating between On-Premise Oracle database using RMI with other application installed on Windows Server. But the same thing is not happening on Oracle Cloud.

    Both Linux Instance and Windows Server instance are in the same region and same Virtual Cloud Network (VCN). The public IP and Private IP's of these two instances are different.
    We have defined ingress rules with source IP and destination port. 

  • Frank Cruz
    Error while trying to create a connection to an oracle data...1
    Topic posted August 30, 2019 by Frank CruzRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, GG, ODI, Provisioning 
    Title:
    Error while trying to create a connection to an oracle data integrator cloud service agent
    Summary:
    When trying to save a database connection associated with a data preparation agent, the following error occurs: Unable to update Oracle DB Client in GG instance with SID information.
    Content:

    After creating an instance of oracle integration cloud service 

    When trying to save a database connection associated with a data preparation agent, the following error occurs:

     In the agent log it shows the following:

    ERROR Unable to process message. The plugin ( ggmon ) which can handle this message was not configured or null on the agent. The received message is : oracle.dicloud.agent.mediator.dto.AgentMessageDTO@3c53288e : {
      "payloadType" : "oracle.dicloud.platform.common.agent.goldengate.mgmt.GGSIDConnectionPayload",
      "payload" : "{\"type\":\"goldengate\",\"name\":\"DBCLOUD\",\"host\":\"132.145.108.235\",\"port\":\"1521\",\"sid\":\"ORCL\"}",
      "msgId" : "76685cfd-d0ab-4699-8b75-4b86984309bd",
      "lastUpdateTime" : 1567179466907,
      "agentId" : "34f75c36-9643-4500-9bc7-d0f6e1167107",
      "agentInstanceId" : null,
      "msgType" : "goldengate".

    Is it necessary to have an instance of OGG to perform this configuration?

    My version is trial.

     

     

    Version:
    Oracle Data Integration Cloud Service
    Image:
  • Mark Hamilton
    DIPC Starting Agent - Trust Store Password Issue2
    Topic posted August 19, 2019 by Mark HamiltonGreen Ribbon: 100+ Points, tagged Cloud, DIPC, GG, ODI 
    Title:
    DIPC Starting Agent - Trust Store Password Issue
    Summary:
    Error about Trust Store Password Missing
    Content:

    Hi

    When i run the start agent file command in Linux I am getting this message:

    GGCC-20046: Trust store password does not exist, use createTrustStoreUnlockPassword.

    I wonder if this is possibly a missing property or if i need to install something relating to certiificates. 

    Please can you help? Happy to raise support tickets if that is best,

    Thanks,

    Mark

    Version:
    DIPC agent download on Linux