How to get Current Row in OAF

We can Get current Row Using findRowByRef method of ApplicationModule.


Here Example Code.


Code of my AM
UploadFileAMImpl am = (UploadFileAMImpl)pageContext.getApplicationModule(webBean);

Code of RowImp
FileSetupVORowImpl setupRow = (FileSetupVORowImpl) am.findRowByRef(pageContext.getParameter(OAWebBeanConstants.EVENT_SOURCE_ROW_REFERENCE)) ; 



findRowByRef is standard method that will return Current Rowimplement
.
Note: Your Action Type must be FireAction. findRowByRef  will return null for firePartialAction.

How to get next value of Sequence dynamically in Oracle

we can execute sequence and get its value using Execute Immediate.
here is the Example Code;

CREATE SEQUENCE mySEQ START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 1000000 NOCYCLE NOCACHE ORDER

declare

  SequenceValue number;

begin

    EXECUTE IMMEDIATE 'select mySEQ.nextval  from dual' INTO SequenceValue;

    ---Now you can Use SequenceValue anywhere

end;

/

drop sequence mySEQ 

/

Rownum in SQL

The Oracle/PLSQL ROWNUM function returns a number that represents the order that a row is selected by Oracle from a table or joined tables.

Example

select * from all_objects where rownum < 2

BIP 11g: Template Builder replaces with

XML-22008: (Error) Namespace prefix ‘ref’ used but not declared

By Default MSWord user form field help text as <?ref:xdo00003?> and when we configrute this rtf file in Oracle EBS. so it generate error or Dont show proper format. So need to change  this text <?ref:xdo00003?> to it's data tag.

Solution:

choose tab "Build" and select radio button "Backward compatible" then re-create fields.

after this setting ms word will add <?ColumnTag?> instead of <?ref:xdo000x?>.

Compute and Set Interactive Grid Column Value Oracle Apex

Set / Get Interactive Grid Column Value Master Detail Form Oracle Apex 1) Assign Static Id to Column (that will be update by command) and use it's id in following commands. in my example P4_ITEM_VALUE is Static Id of Item Value Column.


2) Write Dynamic action and call this JavaScript apex.item( "P4_ITEM_VALUE").setValue(apex.item('P4_RATE').getValue()*apex.item('P4_QUANTITY').getValue());

Set / Get Interactive Grid Column Value Master Detail Form Oracle Apex

1) Assign Static Id to Column (that will be update by command) and use it's id  in following commands.

in my example P4_ITEM_VALUE is Static Id of Item Value Column. 

2) Write Dynamic action and call this JavaScript

var salary = apex.item( "P4_ITEM_VALUE"); 

salary.setValue(100);

or 

apex.item( "P4_ITEM_VALUE").setValue(10);

Oracle DDL with EXECUTE IMMEDIATE -- Drop Multiple Object at once

If You want to Drop Multiple Object at once use this script. Please using

This script check cursor query and take update of your database

/* Formatted on 3/31/2020 1:40:01 am (QP5 v5.139.911.3011) */

DECLARE

   CURSOR OBJECTLIST

   IS

      SELECT    'Drop '

             || OBJECT_TYPE

             || '  '

             || OWNER

             || '.'

             || OBJECT_NAME

             || ''

                DROPCOMMAND

        FROM ALL_OBJECTS

       WHERE OWNER = 'APPS' AND OBJECT_NAME LIKE 'EBA%';

BEGIN

   FOR LDX IN OBJECTLIST

   LOOP

      DBMS_OUTPUT.PUT_LINE (TO_CHAR (LDX.DROPCOMMAND));

      BEGIN

         EXECUTE IMMEDIATE LDX.DROPCOMMAND;

         DBMS_OUTPUT.PUT_LINE ('Object has been dropped.');

      EXCEPTION

         WHEN OTHERS

         THEN

            DBMS_OUTPUT.

            PUT_LINE (

                  SQLERRM

               || ' While performing this Command,'

               || TO_CHAR (LDX.DROPCOMMAND));

      END;

   END LOOP;

END;

select 'Drop '||OBJECT_TYPE||'  '||OWNER||'.'||OBJECT_NAME||';'

from all_objects

where owner='APPS'

AND OBJECT_NAME LIKE 'EBA%'