Posts

Posts

  • Sherwood Daniels
    Display reference or combo box in table15.0
    Topic posted March 6, 2018 by Sherwood Daniels, tagged Business Objects, Custom Code, Database, REST in Application Development > Visual Builder public
    Title:
    Display reference or combo box in table
    Summary:
    Display reference or combo box in table
    Content:

    I am developing a VBCS app where the data comes from a DBaaS instance. I access this data via REST API. Not sure if this is relevant but thought I'd mention it.

     

    I have tables that reference foreign keys. The foreign key is a sequence number generated by the database. Obviously the users would rather see business values than these sequence numbers. I have created References that provide user-friendly values for the foreign keys. On detail pages I can use a list box to display the user-friendly values.

     

    Is there a similar strategy that I can use for tables? I don't see a way to define which control is used to display a data field in a table. Dragging-and-dropping any of the controls from the palette is being rejected for tables.

     

    Attached is a pic of representative page. The Group and Mapping columns are pointed to the references. In Development mode they show up as blanks.

     

    Thanks in advance for your help.

  • Yanal Sakaji
    Error While inserting Data into DBaas through ICS...15.0
    Topic posted February 15, 2018 by Yanal SakajiRed Ribbon: 250+ Points, tagged Database, Integration in Integration > Integration public
    Title:
    Error While inserting Data into DBaas through ICS "Inserted value too large for column:"
    Summary:
    Error While inserting Data into DBaas through ICS "Inserted value too large for column:"
    Content:

    Hi All,

     

    I am encountering the following error while trying to insert data into DBaas through ICS using Invoke stored procedure option.

     

    please note that i have changed the data type into Varchar2(1000) and i did not make a difference

     

    <fault xmlns="http://www.bea.com/wli/sb/context"><errorCode>OSB-380001</errorCode><reason>oracle.tip.adapter.sa.api.JCABindingException: Set object error. Error binding the value of parameter OAC_P_DAY_IN.

    An error occurred when binding the value of parameter OAC_P_DAY_IN in the APPSDB.TEST_OAC_DAY_OBJ_PKG.OAC_DAY_INSERT_DATA API. Cause: java.sql.SQLException: Inserted value too large for column: "2018-01-23 17:46:50.165000" Check to ensure that the parameter is a valid IN or IN/OUT parameter of the API.

    This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-17072" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. Inserted value too large for column: "2018-01-23 17:46:50.165000"Fault Details : &lt;err:serviceInvocationError xmlns:err="http://xmlns.oracle.com/cloud/generic/service/fault"&gt; &lt;err:type&gt;Set object error&lt;/err:type&gt; &lt;err:title&gt;Error binding the value of parameter OAC_P_DAY_IN.&lt;/err:title&gt; &lt;err:detail&gt;An error occurred when binding the value of parameter OAC_P_DAY_IN in the APPSDB.TEST_OAC_DAY_OBJ_PKG.OAC_DAY_INSERT_DATA API. Cause: java.sql.SQLException: Inserted value too large for column: "2018-01-23 17:46:50.165000"&lt;/err:detail&gt; &lt;err:errorCode&gt;serviceInvocationError&lt;/err:errorCode&gt; &lt;err:remedialAction&gt;Check to ensure that the parameter is a valid IN or IN/OUT parameter of the API.&lt;/err:remedialAction&gt; &lt;/err:serviceInvocationError&gt; </reason><location><node>RouteNode1</node><path>request-pipeline</path></location></fault>

     

    what would be the cause  please ?

     

    Thank you in advance for your help

  • paryul mehta
    Custom BOP issue while getting data from Database as a...25.0
    Topic posted February 13, 2018 by paryul mehtaBlue Ribbon: 750+ Points, tagged Business Objects, Custom Code, Database in Application Development > Visual Builder public
    Title:
    Custom BOP issue while getting data from Database as a Schema Service
    Summary:
    Custom BOP issue while getting data from Database as a Schema Service
    Content:

    Hello we  have the following tools to work with.

    1: Database as a Schema service

    2: Visual Builder Cloud service

    We're trying to do the following.

    Deploy a restful webservice created by the wizard available in APEX , deploy it , consume that as a business object in Oracle Visual Builder Cloud service.

    So we can build an app around this object. In an older post it was explained to me that for these restful webservices created in apex (ORDS) we need to create a Business Object Providers to consume

    such services. I've attached the code that we edited based on the link provided before as a reference point https://blogs.oracle.com/shay/getting-data-from-rest-services-into-oracle-application-builder-cloud-service

    We can see that the webservice is called but no data is showing up in the Visual builder cloud service. We can get the data when we call the webservice in our browser and in apps such as SOAPUI etc.

    I've attached some screenshots and also the sample code files. Can you help?

    Have a sample table test_state

    pastedImage_0.png

    we've deployed this table as a rest service from the Database as a schema service Apex console.

     

    pastedImage_1.png

     

    pastedImage_2.png

     

    pastedImage_10.png

     

    pastedImage_3.png

     

     

    pastedImage_4.png

     

    pastedImage_5.png

     

    We tried accessing the data using the steps shown below but it doesn't bring up anything.

     

    pastedImage_6.png

     

    pastedImage_7.png

     

    pastedImage_8.png

     

    pastedImage_9.png

  • Sanjeevchauhan Orcl
    Connectivity with database associated with JCS-SC45.0
    Topic posted January 20, 2018 by Sanjeevchauhan OrclBlue Ribbon: 750+ Points, tagged Database, PaaS, Tip in Application Development > Java public
    Title:
    Connectivity with database associated with JCS-SC
    Summary:
    Connectivity with database associated with JCS-SC
    Content:

    I know JCS-SX comes with a Database schema.

     

    Is there a possibility to connect with this database using local sqldeveloper. I would require host/port/service/username/password.

    My earlier assumption was that JCS-SX comes with preconfigured database as schema. But now in JCS-SX guide it looks like we need to provision DBCS before JCS-SX. Which means I would get db details and then I should be able to use SQL developer to connect with it. Right

     

    When we provision DBCS, we get complete database. We can create multiple schema in it. Which schema will get configured with JCS-SX.

    Is it like JCS-SX will create a new schema when we provision JCS-SX and it will use that to create a jndi connection.

     

    Thanks

    Sanjeev.

  • José Alves
    Can a JCS-SX application connect to multiple databases...15.0
    Topic posted January 12, 2018 by José Alves, tagged Cloud, Database, PaaS in Application Development > Java public
    Title:
    Can a JCS-SX application connect to multiple databases (and perform select/insert/ etc)?
    Summary:
    Can a JCS-SX application connect to multiple databases (and perform select/insert/ etc)?
    Content:

    Hello all

    It seems that JCS-SX is bound to one database schema in a multi-tenant database.

    Question is, can a JCS-SX application connect to another schema in another database in the oracle cloud or is it restricted to use only that specific database schema?

    The reason for this question is that we need to use JCS-SX and a database with several schemas and no pl/sql restrictions in terms of low level networking and file system access.

    Thanks

    Alex

  • Vaibhav Patil
    Getting Error PLS-00201: identifier 'DBMS_PICKLER'...25.0
    Topic posted January 11, 2018 by Vaibhav Patil, tagged ADF, Cloud, Database, PaaS in Application Development > Java public
    Title:
    Getting Error PLS-00201: identifier 'DBMS_PICKLER' must be declared when ADF application is deployed on JCS SaaS
    Summary:
    Getting Error PLS-00201: identifier 'DBMS_PICKLER' must be declared when ADF application is deployed on JCS SaaS
    Content:

    Hello,

     

    We have deployed one custom ADF application on JCS SaaS instance. Which call procedure having in and parameter. Some of the parameters uses custom data types.

    When we run in JCS SaaS getting below error:

     

    java.sql.SQLException: ORA-06550: line 1, column 13:

    PLS-00201: identifier 'DBMS_PICKLER' must be declared

    ORA-06550: line 1, column 7:

    PL/SQL: Statement ignored

     

    It happens when registering the IN and OUT parameter

     

    ArrayDescriptor inputArrayCollection =ArrayDescriptor.createDescriptor("DRIVER_RULE_VALUES", conn);

     

    ArrayDescriptor inputArrayCollection1 =ArrayDescriptor.createDescriptor("DRIVER_RULE_VALUES", conn);

     

    ArrayDescriptor outputArrayCollection =ArrayDescriptor.createDescriptor("RULE_VALUES", conn);

     

    Thanks,

    Vaibhav