For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hi Rob,
Go to Processes -> Process , under 'Allow the application to use test instances during development?' check the option to 'Allow Test Instances' with Runtime option and retry.
Regards,
Preetesh
If you disable VB Proxy (in Auth section) does it work? Could you append please also Request/Response headers (can be found in CHrome Network Monitor) on failed request. Thx
-David
Solved offline. The solution attached FYI.
-David
• custom event has to have payload defined:
"events": { "DisplayResultsEvent": { "payloadType": { "qrCode": "string" } } }
• custom JS code needs to fire custom event using payload defined above, that is:
this.eventHelper.fireCustomEvent("DisplayResultsEvent", { "qrCode" : "david12434" });
• custom event listener needs to either pass whole payload object into chain or just one handpick property, eg.:
"DisplayResultsEvent": { "chains": [ { "chainId": "qrCodeScannedListener", "parameters": { "qrCode": "{{ $event.qrCode }}" } } ] }
• chain needs to have correct param defined as input+required:
"qrCodeScannedListener": { "variables": { "qrCode": { "type": "string", "required": true, "input": "fromCaller" } },
Hi Sunil,
Here is my VBCS POST request log from the browser's developer console:
jsnlog.js:1 vbdt/services-core/api/executor/RequestBuilder: POST https://XXXXXXXXXX:XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/
VM482:5030 Before fetch handler plugin
persistenceManager.js:219 POST https://XXXXXXXXXX.integration.ocp.oraclecloud.com/ic/builder/design/XXXXXXXXXX/1.0.1/services/auth/proxy/CallRunTest/uri/https/XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/ 400 (Bad Request)
(anonymous) @ persistenceManager.js:219
PersistenceManager.browserFetch @ persistenceManager.js:217
eval @ VM482:3497
Promise.then (async)
fetch @ VM482:3491
eval @ VM482:3682
Promise.then (async)
eval @ VM482:3680
Promise.then (async)
eval @ VM482:3673
Promise.then (async)
handleRequest @ VM482:3632
handleRequest @ VM482:4256
eval @ VM482:4829
_dispatchEvent @ persistenceManager.js:278
(anonymous) @ persistenceManager.js:476
Promise.then (async)
(anonymous) @ persistenceManager.js:472
fetch @ CertificateEvents.js:2
execute @ CertificateEvents.js:2
invoke @ Catalog.js:2
async function (async)
invoke @ Catalog.js:2
execute @ Catalog.js:2
async function (async)
execute @ Catalog.js:2
sendRequest @ Catalog.js:2
TestTabModel.sendRequest @ SourceTab.html!text:2
domListener @ ojet.min.js:138
I attached SS from Postman as well.
Hi Sunil,
Here is my VBCS POST request log from the browser's developer console:
jsnlog.js:1 vbdt/services-core/api/executor/RequestBuilder: POST https://XXXXXXXXXX:XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/
VM482:5030 Before fetch handler plugin
persistenceManager.js:219 POST https://XXXXXXXXXX.integration.ocp.oraclecloud.com/ic/builder/design/XXXXXXXXXX/1.0.1/services/auth/proxy/CallRunTest/uri/https/XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/ 400 (Bad Request)
(anonymous) @ persistenceManager.js:219
PersistenceManager.browserFetch @ persistenceManager.js:217
eval @ VM482:3497
Promise.then (async)
fetch @ VM482:3491
eval @ VM482:3682
Promise.then (async)
eval @ VM482:3680
Promise.then (async)
eval @ VM482:3673
Promise.then (async)
handleRequest @ VM482:3632
handleRequest @ VM482:4256
eval @ VM482:4829
_dispatchEvent @ persistenceManager.js:278
(anonymous) @ persistenceManager.js:476
Promise.then (async)
(anonymous) @ persistenceManager.js:472
fetch @ CertificateEvents.js:2
execute @ CertificateEvents.js:2
invoke @ Catalog.js:2
async function (async)
invoke @ Catalog.js:2
execute @ Catalog.js:2
async function (async)
execute @ Catalog.js:2
sendRequest @ Catalog.js:2
TestTabModel.sendRequest @ SourceTab.html!text:2
domListener @ ojet.min.js:138
I attached SS from Postman as well.
Can you check browser log and compare VBCS request with postman and see if you find any difference.
Also in connection/Authentication setting can invoke using proxy and see if that makes any difference.
Regards,
Sunil
Hi Kashyap,
You can find detailed info for List of Values here:
The search expression is used on the referenced business object (i.e. the business object that provides the display values, not the business object of current table).
If I understand your question correctly, you are trying to filter the List of Values based on another field in the table.
Say you have column D with label "ID" and column E with label "Banana". Column E has List of Values but you want to filter the list using a value in column D. You want to know how to do that.
Is that correct?
Regards,
Yuandi
Hi John,
Its working fine now. Some extra class was overriding in Edge & IE on removing it got fixed. Thankyou.
You can use a variety of REST services with the Excel add-in.
Be sure to grab the latest version here: https://www.oracle.com/downloads/cloud/visual-builder-addin-downloads.html
...and review the guide here: https://docs.oracle.com/en/cloud/paas/app-builder-cloud/visual-builder-excel/toc.htm
In particular, check out chapter 11 on REST service support.
> Can I also hookup REST enabled pl/sql procedure in the VBCS excel?
Probably not. But, what does the API look like? Do you have a sample to share?
Yes John, Tried taking images from application-path & flow-path both. But both are not working.
Image Url i have given in same way as below:-
:src="{{ $flow.path + 'resources/images/icon_Gray_Plus-Expand.png'}}"
:src="{{ $application.path + 'resources/images/button_Search.png' }}"
But main problem is the images folder itself is not coming up in source structure in browser console for Edge as shown in the picture.
if you're putting them in the resources folder then the path should be $application.path + "/resources/images". Did you create a new resources folder under the flow?
Thanks for your input Shay!!
Can I also hookup REST enabled pl/sql procedure in the VBCS excel?
I don’t believe we are directly exposing our server logs right now.
What info would you be interested to gain from those logs?
You can REST enable your table with ORDS and then hookup the VB Excel plugin to it.
(or if you prefer working in Java you’ll be able to take a similar approach using ADF business objects as the REST enabling layer)