OIC/ICS Agent Limitation and Workaround

As there is a limitation of 5 agents in ICS, how do we overcome, if we want to use the 6th one? Below is the workaround/approach to be followed : It is possible that we can Connect One Agent with multiple on-prem applications if they are in the same network. You do not need a […] →Read more

How to install Sample DataSet in APEX

Click on Install in the below list in the respective row →Read more

How to delete application in Oracle APEX

Navigate to : App Builder Edit the application in the Tasks list –Right Side –> click on : Delete the Application Click : Permanently Delete Now →Read more

REST Status Codes

HTTP Status Code Description 200 OK The request was completed successfully A 200 status is returned for a successful GET or POST method. 201 Created The request was fulfilled and resulted in a new resource being created. The response includes a Location header which contains the canonical URI for the newly created resource.A 201 status is returned from a synchronous resource […] →Read more

How to Display No Data Found in BIP

Display : No Data Found Message in BIP To handle no data found conditions: At the end of the RTF template, add a section break. On the last page (the new section page), add the command <?if@section:not(ELEMENT_NAME)?>No Data Found<?end if?>where ELEMENT_NAME is the same data element that you are using in the for-each@section loop.Now if no […] →Read more

Oracle Cloud – SaaS, PaaS and IaaS Free Learning Courses

There are numerous free explorer learning courses from Oracle University. Check out the website : https://education.oracle.com/learning-explorer#startLearning →Read more

Oracle Cloud ERP – Query to find the current logged in users

→Read more

QRCode and PD417 in BIP- Oracle Cloud ERP

Use the following code details to display the data in QRCOD or PD417 Format QR Code PDF417 Example : <?qrcode:QR_DATA; 100?> Example : <?pdf417:QR_DATA; 10?> Syntax : <?qrcode: <DATA>; <SIZE>[; <CHARSET>]?> Syntax : <?pdf417: <DATA>[; <XSCALE>[; <COLUMNS>[; <ROWS>[; <CHARSET>]]]]?> Oracle Doc : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/2d-barcode-functions.html#GUID-E0D697B1-0B13-46A3-8578-1FE933F1A86D Live Session : →Read more

Tech KeyWords

CI/CD : Continuous Integration/ Continuous Deployment →Read more

AR Invoice REST API – Error Applying List binding LOV_ShipToCustomerName with given set of values leads to multiple matching rows

While Creating AR Invoice – below is one of the error which you may face : Applying List binding LOV_ShipToCustomerName with given set of values leads to multiple matching rows for a row of type:InvoiceHeader, key oracle.jbo.Key[    300000223632391] Reason : REST API – AR Invoice Create Payload : There are multiple records with same party name : Solution : Dont Pass the : “ShipToCustomerName”: “Business World” Extra Information leads to extra errors, so always try to […] →Read more