Data Integration

Get Involved. Join the Conversation.

Posts

  • Rama Pedamallu
    ADFS (Active Directory Federation Services) related...11.0
    Topic posted June 22, 2018 by Rama Pedamallu, tagged Cloud 
    Title:
    ADFS (Active Directory Federation Services) related issue
    Summary:
    ADFS (Active Directory Federation Services) related issue
    Content:

     we implemented ADFS on our Oracle ERP. we have hybrid screen now. Next 2 weeks, we are planning to disable Hybrid screen. In that situation, using URL, users can directly log into Oracle ERP without entering login credentials.

      Incase of any issues with Active Directory, users can't log into Oracle ERP. Is there any backdoor entry/ any other option to get hybrid page (without creating SR with Oracle to enable hybrid page)? 

  • 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:
  • David Tran
    Can OIC poll for file creating in FTP directory?5
    Topic posted February 15, 2019 by David TranRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, Tip 
    Title:
    Can OIC poll for file creating in FTP directory?
    Summary:
    Trying to poll a directory in an FTP for new files
    Content:

    Hello All!

    I need to trigger an integration for when a new file is uploaded into an FTP directory. Is this possible?

    Any help will be appreciated.

    Thanks!

  • 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:
  • 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
  • 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:
  • 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:
  • Tarun Dadhich
    HCM Extract - How to avoid sending blank file15.0
    Topic posted May 9, 2018 by Tarun DadhichGold Medal: 3,500+ Points, tagged Cloud 
    Title:
    HCM Extract - How to avoid sending blank file
    Content:

    Hi Everyone,

    We are developing a HCM extract to send email with attachments. The interface will be a changes only interface and will be scheduled daily. We don't want to send the email if there is no data extracted. Appreciate your help. 

    Delivery Type is Email and HTML/Excel will be the Template.

    Regards,

    Tarun

  • Raghavendra Manchigiah
    Load into Fusion applications1
    Topic posted July 15, 2019 by Raghavendra ManchigiahBlue Ribbon: 750+ Points, tagged Cloud, DIPC, ODI 
    Title:
    Load into Fusion applications
    Summary:
    Using ODI to load data in Fusion
    Content:

    With reference to a previous post - would like to clarify if ODI / DIPC can be used to create files in FBDI / HDL etc...compliant format , placed in a UCM location and trigger an ESS job

    https://blogs.oracle.com/dataintegration/oracle-data-integrator-odi-to-load-into-fusion-applications-oracle-erp-cloud

    Above post refers to such a use case - However all the research that we have done points to the fact that target web service execution is not supported in DIPC

    What is the solution then? use ODI - on Prem? Is ODI - CS still offered as a service or is the same product now called DIPC ? Please help clear the ambiguity.

    Thanks

    Raghvendra

  • 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