Another happy customer

Publish date:

Another happy customer where we extended Oracle eBS R12 by fully integrating Oracle Apex just by following the instructions on my own blog:  Integration of Oracle Apex and E-Business Suite R12 Using the page wizard ‘form on table with report’ a powerful interactive report and related update form are created to maintain records in a custom […]

Another happy customer where we extended Oracle eBS R12 by fully integrating Oracle Apex just by following the instructions on my own blog:  Integration of Oracle Apex and E-Business Suite R12

Using the page wizard ‘form on table with report’ a powerful interactive report and related update form are created to maintain records in a custom table. However for each record you want to update, you first have to open an update form via a click on the pencil at the beginning of the line. You’d rather want to update the records straight on the interactive report page. Therefore using the page wizard also a tabular form has been created. This form has far less options for filtering, sorting, downloading, … than an interactive report page. Too bad!

Added to this tabular form is a button that the status field of all selected records sets to ‘FINAL’. The processing is not so straightforward. There is no field in the screenbuffer that corresponds with the check box at the beginning of the line. So it is not possible to write an UPDATE statement with a condition like check box checked. Now a piece of code has been developed that goes through some internal apex collection to update the correct rows. The process added to the page processing:

DECLARE
l_checked_row NUMBER;
l_pkey NUMBER;
BEGIN
FOR i IN 1..apex_application.g_f01.count
LOOP
l_checked_row := apex_application.g_f01(i);
l_pkey := apex_application.g_f02(l_checked_row);

UPDATE xxapx_contractline
SET STATUS = ‘FINAL’
WHERE contractline_id = l_pkey;
END LOOP;
END;

 

For more information, please contact Marc Weeren

 

Related Posts

MSP

Moving logistical planning to the Oracle Cloud

Johan Louwers
Date icon November 11, 2019

There’s a need to manage workloads effectively while streamlining the business model.

MSP

Moving workloads to the Oracle Cloud

Jane Arnold Hommet
Date icon October 24, 2019

We helped one of Spain’s largest mobile network providers transition to the Oracle Cloud

blockchain

Blockchain distinguishing the fads from the credible

Jonathan Eaton
Date icon June 26, 2019

A case to show when blockchain is an appropriate solution