Oracle Application Blog

Field Locks In Oracle Apex

      Step:1: On-change of items, insert into locks table. Dynamic Action : On-Change    Selector : JQuery Selector              [name=f05] Execute Javascript Code,    /* Getting the Program Name Details*/ var c=($(this.triggeringElement ).attr(‘name’).substr(0,3)); var d=this.triggeringElement.id; //alert(d);  var str = d.substring(4,8); if(c==”f05″) { // Assigning PDVD Type var p_pdvd_type=”Master”; //alert(p_pdvd_type); //getting column header value idheader =”#f05_0001_LABEL” ; var p_field_name = $(idheader).closest(“label”).html();    //alert(p_field_name); //getting Master PDVD ID var p_pdvd_id=$(‘#P77_MASTER_PDVD_ID’).val(); //alert(p_pdvd_id); //getting Item ID var p_item_id=$(this.triggeringElement ).attr(‘id’); //alert(p_item_id); //getting Item value var p_item_val=$x(p_item_id).value;…

Read More

Third Party Process – Colombia

This page explains the steps involved in generating the Colombia Third party report balances. This process ensures the passage of the third party details to GL. This is mandatory in…

Read More

Electronic File Transfer in AR – Brazil – Technical Information

Companies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files…

Read More

Brazil Electronic File Transfer in Receivables

Companies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files…

Read More

Excel Merge and Download using Custom Template in APEX

For Merging cells in Excel and for other CSS in download property, i.e  to create  down loadable XLS formatted sheets from any version of APEX use the following steps: 1. Create a new blank page in the application using Customized template. In that customized template remove all the contents in the page, like navigation menus, APEX page Toolbar, and others , since by putting this in a Before Header process on a page, the entire page will be downloaded as a native Excel Spreadsheet. 2. Create PLSQL Region with no template. — Should use recursion for a full tree, but we only need executives.  DECLARE    l_dirtotal   NUMBER (12, 2); BEGIN    HTP.p       (‘<table border=1 white-space=nowrap><tr style=”background-color:silver;”>     <th colspan=5>Employee</th><th>Title</th><th>Salary</th>     <th>Direct Report Total</th></tr>’       );    FOR c_exec IN (SELECT *                     FROM employee                    WHERE direct_report_id IS NULL)    LOOP       SELECT SUM (salary)         INTO l_dirtotal         FROM employee        WHERE direct_report_id = c_exec.ID;       HTP.p          (   ‘<tr height=80><th align=right><img src=”‘           || c_exec.image           || ‘”></th><th colspan=4 style=”white-space:nowrap;font-size:36px;color:green;background-color:#CCFFCC;”>’           || c_exec.NAME           || ‘</th><th>’           || c_exec.title           || ‘</th>     <th style=”font-size:36px;”>’…

Read More

Get Filtered Columns and Values in APEX Interactive Report

In order to get the filtered columns and their corresponding values in APEX Interactive Report, we can use this code.  So if the user selects multiple filters in IR and we need to retrieve the values of filter columns and their corresponding values, conditions, operators used for the conditions,etc we can retrieve using the below code: SELECT ircond.condition_name, ircond.condition_type, ircol.report_label,        ircond.condition_column_name, ircond.condition_operator,        ircond.condition_expr_type, ircond.condition_expression,        ircond.condition_expression2, ircond.condition_sql,        ircond.condition_display, ircond.condition_enabled   FROM apex_application_page_ir ir JOIN apex_application_page_ir_rpt irr        ON ir.interactive_report_id = irr.interactive_report_id        JOIN apex_application_page_ir_cond ircond        ON irr.report_id = ircond.report_id        JOIN apex_application_page_ir_col ircol        ON ir.interactive_report_id = ircol.interactive_report_id      AND ircond.condition_column_name = ircol.column_alias  WHERE ir.application_id = TO_NUMBER (:app_id)    AND ir.page_id = TO_NUMBER (:app_page_id)    AND ir.region_name = ‘Interactive Report’    AND ircond.condition_type = ‘Filter’    AND irr.session_id = :app_session    AND irr.base_report_id =           (SELECT apex_ir.get_last_viewed_report_id (TO_NUMBER (:app_page_id),                                                      ir.region_id                                                     )              FROM DUAL) Use a condition to identify the specific interactive report using either the region name or a static region ID.  Note: Can filter using Actions Menu and also using Header column filter.  Example: The below filtered columns and corresponding values can be retrieved using the above code.

Read More

Open Script – DataBank – CSV or Text File

Open Script – DataBank   It is used to Provide input data  to Open Script at run time from a Text File. Click on the below link to read the document…

Read More

Open Script – DataBank – Database Table

Topics 1.DataBank – DataBase Table Use 2.How to Run Iterations Objective:- How to Use DataBase Table as Data Bank Please click on this link to read the document By Venkata GANNE

Read More

Discrete Job Migration Along With PO

Discrete Job Migration Along With PO Script  CREATE OR REPLACE PACKAGE BODY APPS.XXEUR_CREATE_DISCRETE_JOB AS PROCEDURE main(errbuf            OUT  VARCHAR2               ,retcode           OUT  NUMBER               ,p_validate_flag   IN   VARCHAR2               ,p_load_flag       IN   VARCHAR2…

Read More

Open Script – Dynamic Login URL

Dynamically Reading Login URL  From Input Dialog Box please click on below link to read the document                          …

Read More