Posts

Posts

  • Cesar Tepetla Corte
    Problem to send the payload of reading a file in Visual...7
    Topic posted July 17, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Action Flows, Custom Code, Database, JET, Process, REST, Services, Web in Application Development > Visual Builder public
    Title:
    Problem to send the payload of reading a file in Visual Builder to the RESTful web service of Apex
    Summary:
    Problem to send the payload of reading a file in Visual Builder to the RESTful web service of Apex
    Content:

    The requirement consists of a screen in Visual Builder that uses a file picker to upload a CSV file to a database.

    I have developed the screen and can read the files correctly.

    I have developed a package and a RESTful Web Service for the invocation and use of that package.

    I have tried the Rest service from Postman and it works without problem, then I have consumed it in Visual Builder and the test works well.

    Then I configure the service within an action in a button.

    The strange thing starts when I run the Visual Builder screen and everything indicates that all the execution was correct but when checking the database I insert an empty data, checking the browser console the request if it contains information and still insert it blank.

    I repeated that test but this time I created an OIC integration that receives the same payload and with ICO if it worked correctly

    What can be happening?

  • Karthik Ramachandran
    Connecting Oracle Integration to Oracle ATP - Issue with...Answered9
    Topic posted July 16, 2019 by Karthik RamachandranGreen Ribbon: 100+ Points, tagged Database, Integration, PaaS, REST in Integration > Integration public
    Title:
    Connecting Oracle Integration to Oracle ATP - Issue with Sequencing
    Summary:
    I am not able to understand from where the sequence is picked up.
    Content:

    In Oracle ATP DB : Created new sequence

    CREATE SEQUENCE ZEB_TEMP START WITH 1000000 INCREMENT BY 1

    so as per sequence when I call sequence number next val it give me next digit. 

    When we mentioned the same sequence in Oracle ATP connection step in integration, it is generating some different sequence number. Only one good thing is, it is not random. But not sure from where sequence is getting generated. It works fine from ATP database, only issue is when i call it from Oracle Integration Cloud. 

    Sequence number what it is generating is 1200214, 1200215, 1200216 etc

    Screenshot attached for the step in OIC where sequence is selected.

    Please let me know if you need more details.

    Image:
  • Amitabha Dutta
    Oracle DbaaS Test Connect Failure in ICS5
    Topic posted July 15, 2019 by Amitabha DuttaGreen Ribbon: 100+ Points, tagged Connection, Database, Integration, PaaS in Integration > Integration public
    Title:
    Oracle DbaaS Test Connect Failure in ICS
    Summary:
    ICS Test DbaaS Connection failing after updating the schema password
    Content:

    A number of integrations in ICS using a Oracle DbaaS Connection. The connection was created few months back, today the database schema password was changed and we had to update the ICS connection with new password. Now the Test Connection is failing with error "The connection test failed. Check your connection and use agent from agent group.". However, existing integrations using the connection are working fine.

    We had not created any agent for our connection and it was working fine. Can anyone highlight any possible reason for this issue?

     

    Version:
    19.3.1.0.0
  • Moon Ray Lo
    Best Practice for OIC to Cloud DB: DB Adapter or RESTful...
    Topic posted July 12, 2019 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Cloud, Connection, Database, Integration, Orchestration, PaaS, REST, Web Services in Integration > Integration public
    Title:
    Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?
    Summary:
    Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)
    Content:

    Hi,

     

    I'd like to hear your inputs as to which approach is better in terms of efficiency, performance and maintenance when connecting to Oracle DB Cloud items (ex: table) from Integration Cloud - DB Adapter Operations or RESTful Services (ORDS)?

     

     

    Thanks ahead,

    Moon

    Version:
    19.2.1.0.0 (190323.0400.26650)
  • logu Prasanth
    How to move IAR file from one OIC to Another OIC instance115.0
    Topic posted July 9, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Connection, Database, Integration, Mapping, Orchestration, Web Services, xml in Integration > Integration public
    Title:
    How to move IAR file from one OIC to Another OIC instance
    Summary:
    Move IAR file from one OIC to Another OIC instanc
    Content:

    I have Export the IAR file from One OIC Instance.

    1. Is it IAR having All the dependencies like lookups and libraries or we need to export dependency lookups and libraries

    2. If IAR having All the dependencies while importing to another OIC it will automatically import All the dependencies or we need to import separately ??

     Thanks in advance.

  • Kmuralidharan1992
    Image, Large files storage in VBCS?2
    Topic posted June 19, 2019 by Kmuralidharan1992 Bronze Medal: 1,250+ Points, tagged Business Objects, Custom Code, Database, REST in Application Development > Visual Builder public
    Title:
    Image, Large files storage in VBCS?
    Content:

    What are the datatypes available in VBCS. Is there any way to store image or large files in table in vbcs?

  • Arsalan Dilawar
    Load data from Microsoft Sql server to Oracle cloud Paas...
    Topic posted June 17, 2019 by Arsalan DilawarGreen Ribbon: 100+ Points, tagged Adapters, API, Connection, Database, Integration, PaaS, REST, Web Services in Integration > Integration public
    Title:
    Load data from Microsoft Sql server to Oracle cloud Paas using Web services
    Summary:
    Load data from Microsoft Sql server to Oracle cloud Paas using Web services
    Content:

    Hi,

    Can anyone please guide me, Is it possible to automate a process to directly upload the data from sql server table to Oracle Paas Apex table using  Rest web services.

     

     

  • Arsalan Dilawar
    Connect Oracle cloud Database service with Microsoft sql...
    Topic posted June 17, 2019 by Arsalan DilawarGreen Ribbon: 100+ Points, tagged Adapters, API, Cloud, Connection, Database, ERP Cloud, Integration, Mapping, PaaS, REST, SOAP, Web Services in Integration > Integration public
    Title:
    Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud tool
    Summary:
    Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud tool
    Content:

    Hi,

    Good day! Need help in connectivity 

    We have created a 1 custom table in oracle PaaS. We are daily uploading the Excel sheet based data in that table using Oracle apex loader utility. 

    We are picking that data from one customize Attendance system which is developed in Microsoft sql server.

    Now my requirement is automate this process. I want my attendance system data to go directly into oracle apex table and there should be no manually activity for that..  I tried to do searching on different forums but could not find any..

    Out main problem is we don't have Oracle Integration Cloud licence and because of that we are not able to create a connectivity between oracle cloud n sql server.. Is there any other way to create a connectivity and upload the data in Oracle cloud PaaS table 

  • Abhinav Prasoon
    Facing issue while reading EDI files
    Topic posted June 13, 2019 by Abhinav Prasoon, tagged Adapters, API, Cloud, Connection, Database, Integration, Mapping, PaaS, REST, SOACS, SOAP, Web Services, xml in Integration > Integration public
    Title:
    Facing issue while reading EDI files
    Summary:
    unable to read the file contents of edi files
    Content:

    Hi,

    I am trying read IGM/EGM EDI Files in OIC and tried multiple ways to read by creating NXSD by uploading sample files and later manually written some NXSD's for these files but still no luck. Please let me know if there any other way to read these kind of files in OIC and when can we expect B2B in OIC.

    Thanks in advance

    Regards,

    Abhinav

    Version:
    19.1.3.0.0 (190129.1200.23460)
    Image:
    Code Snippet:
    Document:
    Document:
    Document:
    CHN104.egm (12KB)
    Document:
    GUJ077.egm (15KB)
  • Disha Verma
    Table records is not visible to another admin user2
    Topic posted June 12, 2019 by Disha VermaGreen Ribbon: 100+ Points, tagged Database, REST, Services, UI, Web in Application Development > Visual Builder public
    Title:
    Table records is not visible to another admin user
    Summary:
    Table records is not visible to another admin user
    Content:

    Hi All,

    I am facing an issue, I am pulling the data from rest Service( rest Exposed Integration) in a table.

    And initially I am hiding the table, so when a user click on button then table will appear with data records.

    It is working with my login credentials, when another admin user tries to access the form ,click on button, only table structure appears not the data records.

    Is there anything I am missing?

    Thanks in Advance.

    Disha

    Version:
    19.1.3