VBCS - Create Custom Javascript function in Visual Builder

Use Case: Here, we will create a Javascript function which will accept a name string as input and return concatenated greetings.

Javascript code:

PageModule.prototype.greetingsFunction = function(name) {

var result = "Hello " + name + ". Have a nice day !!";

};

High level Steps:

• Create a javascript function code.
• Take an input text (name) and a text area(greetings) and create 2 variables varName  and varGreetings and map them to the name and greetings element.
• From name element >> create an event and call the javascript using call function and feed input with varNane and take the result and map back to grestings variable.

Steps with Screenshots:

Create a new web application

Take a input test (Name), divider, a text area(greetings)

Create 2 variables. varName and varGreetings.

Map the data variables with the Name and Greetings elements.

Select Name element >> events >> New event >> On Value

Drag and drop JS call function

Add the JS function code.

Map the varName to Function input name.

Take a assign and map the function result to varGreetings .

Go Live and test.

Provide name and tab any where on the page.

OIC - Prerequisites for creating Oracld ERP Cloud Connection

Following steps required to perform:

1. Subscribe / access to Oracle Fusion Cloud Preferably with integration User / Service Account.

2. Obtain Oracle Fusion Cloud URL along with credentials

https://<oracle fusion erp cloud pod>

3. Assign following roles to Integration user / Service Account in Oracle Fusion ERP cloud in security console.

• Integration Specialist : it is a job role which inherits Oracle ERP Cloud roles but does nkt include any data access.
• AttachmentsUser: provides access to the Attachments Security which enables user to download log or output file using ERP Integration service.
• SOAOperator: SOA Operator role 
• FND_MANAGE_CATALOG_SERVICE_PRIV : To Manage Web service Catalog.

4. Module/Functionality/object specific (GL, AP, AR etc) job roles along with data access for the concerned security context. E.g, General Accounting Manager with data access to US Primary Ledger for Data access set security context.

5. To Subscribe to Fusion Business Events and FBDI Callback: Register CSF key(Identity domain and OIC Service name) under Manage Security of SOA Composer in Fusion SaaS.

https://<Oracle Fusion ERP Cloud Instance>/soa/composer

6. To access REST catalog through Oracld ERP Cloud Adapter 

Step1: 

Go to Setup and Maintenance >> Manage Profile Options

Create a profile option by giving following information:

Profile option code: ORACLE.BC.REST.IGNORECATALOGERRORS

Application: Application Toolkit

Module: Application Toolkit

Description: any comment

Start date: current date

Enable at User level.

Click on save and close.

Step2:

Go to Setup and Maintenance >> Manage Administrator Profile Values

Created Profile Option values (profile level=User | Value =true)

Click on save and close.

OIC - Rest Path Or Template parameters vs Query Paramters | How to create Path or template Parameters and Query Parameters

Differences:

• The first difference between query and path parameters is their position in the URL. While the query parameters appear on the right side of the ‘?’ in the URL, path parameters come before the question mark sign.
• Secondly, the query parameters are used to sort/filter resources. On the other hand, path parameters are used to identify a specific resource or resources.
• You can’t omit values in path parameters since they are part of the URL. On the other hand, query parameters are added at the end of the URL, and thus can allow omission of some values as long as the serializing standards are followed.
• Query parameters have unique attributes which help to define resources in a better way. Path parameters, on the other hand, have dynamic resources, which act upon more granular objects of the resource.

How to create Template Parameters in OIC:

How to create Query parameters in OIC:

How the path and Query Parameters URLs look:

For Path or Template parameters:

https:/oic_instance/ic/api/integration/v1/flows/rest/Hello_World_Rest_Service/2.0/sayHello/Sanddy

For Query Parameters:

https:/oic_instance/ic/api/integration/v1/flows/rest/Hello_World_Rest_Service/2.0/sayHello?name=Sanddy

OIC - Understand of FBDI properties file | How to create a .properties file | How to get properties values from ERP

Why we need Properties file?

In Oracle Cloud ERP, In order to import data in bulk using FBDI based integration, importBulkData operation of ERPIntegration Service is used . The entire load process includes following steps:

1. Upload files to UCM
2. Submit Load Interface file for import
3. Submit respective import jobs

Now to submit import job along with parameters, a properties/manifest file is created and embedded within the FBDI zip(Dynamic way) or can be uploaded in UCM and reused(Static way).

Structure of .properties file:

<Import Job Package Name>,<Import Job Name>,<ZIP file prefix>,<Param1>,...<ParamN>

Notes:

1. Properites file must have .properties extension.
2. All the fields in the .properties file should be comma separated
3. Suppose you have zip file like ImportJournal_05122022.zip, then the zip file prefix will be as "ImportJournal".

How to get Job Package name and import job name from ERP:

Go to Setup and Maintenance

Search with Manage Enterprise and select

Search with the import job name in the display name section >> select the job, here showing Import Payables Invoices >> Edit

See the Path(Job Package Name) and Name (Job Name).

Now the .properties file look as below:

/oracle/apps/ess/financials/payables/invoices/transactions/,APXIIMPT,<ZIP file prefix>,<Param1>,...<ParamN>

How to get all the Parameters of the properties file:

Go to Scheduled Processes

Click on Schedule new Process

 

Search with Import job name . Herr job name we use Import Payables Invoives.

Select Import Payables Invoices.

Click ok.

Submit

Refresh >> Select Impory Payables Invoices >> Expand Parameters >> take the values under all Parameter values.

Now the final .properties file looks like as below:

oracle/apps/ess/financials/payables/invoices/transactions/,APXIIMPT,ImportInvoice,#NULL,300000026XXX,"N",#NULL,#NULL,#NULL,1000,"INVOICE GATEWAY","TEST","N","N",30000000241XXX,#NULL,1

Where ImportInvoice is the Zip file prefix.