How to Implement Row Level Edit for Table in VBCS In this post, we will implement row level edit for table in VBCS. Let us create new Web app as shown: Click on Create. We will use same service connection based on ORDS data source. Create new types. Navigate to Types —>From Endpoint. Click Next. […]
Implementing Pagination Control for Table using ADP in Oracle VBCS
Implementing Pagination Control for Table using ADP in Oracle VBCS In earlier posts, we have seen how to implement pagination in VBCS page using ADP variable for ORDS data source. In this post, we will see how to implement pagination control for table using ADP variable. Let us create new Web Apps for this requirement. […]
How to implement Pagination in VBCS with ORDS and ADP
In earlier posts, we have seen how to implement pagination in VBCS using SDP variable and ORDS as data source. In this post, we will see how to implement pagination in VBCS with ORDS and ADP variables. Let us create new VBCS application: Click on Create. Create new Service Connection for ADP variable. Navigate to […]
Error: ORDS was unable to make a connection to the database.
If you are getting below error while launching ORDS, follow steps mentioned to resolve the error: “ORDS was unable to make a connection to the database. The database user specified by db.username configuration setting is expired. The connection pool named: |default|lo| had the following error(s): ORA-28001: the password has expired” Solution: This error occurs when […]
How to implement Pagination in VBCS with ORDS and SDP
How to implement Pagination in VBCS with ORDS and SDP. In this post, we will see how to implement pagination in VBCS with ORDS and SDP. Pagination is a technique used in APIs (and UIs) to return large result sets in smaller, manageable chunks instead of all rows at once. Imagine a table with 1 […]
How to Create AR Invoice Using RecInvoiceService SOAP Webservice
Creating AR Invoice Using RecInvoiceService SOAP Webservice We can use below SOAP WSDL to insert data into AR Invoice Interface table. WSDL: This WSDL is having below Methods: Under InvoiceServiceSoapHttp, We have different methods which we can use for inserting data into RA_INTERFACE_LINES_ALL table or Creating AR invoice directly in Receivable. Method Name Usage createSimpleInvoice […]
Configuring AP Invoice Payment Batch Business Event in OIC
Configuring AP Invoice Payment Batch Business Event in OIC For Oracle Payments Cloud business events, Payments sends an event occurrence signal when the event has happened. This table describes the business event supported by Payments. To enable Business event for Accounts payable, we need to follow below steps: To enable Business Event for payment, we […]
How to Perform DML operations on Business Object in VBCS
How to Perform DML operations on Business Object in VBCS In last section, we have seen introduction to Business objects and seen how to create business objects and display data from business object on VBCS page. In this section, we will see how to perform DML (INSERT/UPDATE/DELETE) operations on business objects by creating page. Let […]
How to call Oracle Integration Cloud (OIC) REST APIs using OAUTH 2.0 authentication
How to call Oracle Integration Cloud (OIC) REST APIs using OAUTH 2.0 authentication. In this blog post, we will explore how to configure and use Oracle Integration Cloud (OIC) REST APIs using OAUTH2.0 authentication. OAuth 2.0 is an open standard authorization framework that allows users to grant third-party applications limited access to their resources (like […]
How to Create Simple Process Approval Flow in Oracle Process Automation
How to Create Simple Process Approval Flow in Oracle Process Automation (OPA) In this post, we will see how to create simple process approval flow in Oracle process automation. Oracle Process Automation (OPA) is a cloud-based solution from Oracle designed to help organizations to automate business processes with minimal coding. It is part of the […]