Oracle Listagg function helps to concatenate multiple rows into a single string. This article explains this in details. Once a developer asked, “How to combine multiple rows into a single string delimited by comma, or pipe?” The requirement is to get email id from a table, concatenate those by “,” and use it as a parameter while […]
Combine multiple rows into a single string in Oracle Read More »
Oracle Application Express is Web Application Development Tool. It enables you to design, develop and deploy beautiful, responsive, database-driven applications using only your web browser. Oracle provides most of the development tool free to download for learning and evaluation purpose. This is not for production or commercial use. Oracle Apex is also available as a download
Download Oracle Application Express (APEX) [All Version Links] Read More »
Oracle Reports is an enterprise reporting tool. You can generate reports in any popular format for web and paper, burst, and distribute reports to any destination. Businesses get immediate access to information to all levels within and outside of the organization in an unrivaled scalable and secure environment. Oracle Reports is the one of execution
Oracle Reports (RDF) Concurrent Program in Oracle Apps Read More »
SQL* Plus is one of the executable methods available while defining a concurrent program in Oracle Apps. It allows running SQL* Plus script against the Oracle ERP database under Oracle Apps Environment following all security and access control. This method helps to create some ad-hoc script as a concurrent program. Ideally, convert this standalone script
SQL* Plus Concurrent Program in Oracle Apps Read More »
PL/SQL is procedural language extension for SQL. It has it’s own commands, datatype, operator, etc. You can use SQL statements within PL/SQL code. Here, PL/SQL code is executed by PL/SQL Engine while SQL by SQL Engine. You will never notice any lag as Oracle database manages this engine switch very efficiently This is fine for
How efficient is PL/SQL Bulk Processing? Does it really help……. Read More »
Business users sometimes need functionality to email the output of the concurrent program as soon as it completes. Let’s see how to email concurrent request output in Oracle Apps You can achieve this using another custom concurrent program based on Unix, PL/SQL so send an email of a concurrent program. Unix provides mailx and in
Email Concurrent Request Output in Oracle Apps Read More »
fnd_request.submit_request Oracle Apps PL/SQL API helps to submit the concurrent program from the backend. backend means from the Database. fnd_request.submit_request Below is the signature of fnd_request.submit_request API. This function submits a concurrent request for processing by concurrent Manager and returns, request id – if the request is submitted successfully 0 – if the request is not
How to Submit Concurrent Program from back-end using fnd_request in Oracle Apps Read More »
How to make Parent concurrent request to wait until all child concurrent programs complete in Oracle Apps? So what we are looking at here is a Parent program that submits multiple child requests at once and waits till all child programs complete either successfully. Oracle apps provide a built-in package FND_CONC_GLOBAL and FND_REQUEST to achieve
Parent Child concurrent request in Oracle Apps Read More »
ABS function in Oracle SQL returns the absolute value. Let’s assume a number -10 when you run the abs function of this number it returns 10 which is an absolute value. This function also works on the decimal. Syntax ABS(N) N – input parameter SELECT ABS(-10)FROM DUAL; Absolute ———- 10
ABS function in Oracle SQL Read More »
In the last article, we discussed how to define and schedule ESS Jobs in Oracle Fusion. Wondering which tables stores these ESS Job definition? Let’s try to find out this. As per this Oracle Support article, there are no tables that store ESS Job Definition. It is actually an XML document stored in MDS DB
ESS Job Definition tables in Oracle Fusion Read More »