Home/ Gomaa Elmokhtar/Followers Answers
  1. Asked: April 30, 2017In:

    What is FNDLOAD command to move Value Sets from one instance to another ?

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    Hello Matheo, You can use this command to download and upload value sets : FNDLOAD to Download Valueset: $FND_TOP/bin/FNDLOAD username/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name" FNDLOAD to Upload Valueset: $FND_TOP/Read more

    Hello Matheo,

    You can use this command to download and upload value sets :

    FNDLOAD to Download Valueset:

    $FND_TOP/bin/FNDLOAD username/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name"

    FNDLOAD to Upload Valueset:

    $FND_TOP/bin/FNDLOAD username/password 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
    See less
  2. Asked: April 8, 2017In:

    Repeat same previous record or item in oracle forms ?

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    You can use DUPLICATE_RECORD built-in

    You can use DUPLICATE_RECORD built-in

    See less
  3. Asked: April 8, 2017In:

    How to show a message in a report at runtime?

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    hi Albert, You can display a message in Oracle report builder by using the standard built-in srw.message. The basic syntax for using this package is: srw.message(error_no,'YOUR MESSAGE'); the error no will appear along with the message text. and here is the sample to do this in a particular functionRead more

    hi Albert,

    You can display a message in Oracle report builder by using the standard built-in srw.message.

    The basic syntax for using this package is:

    srw.message(error_no,'YOUR MESSAGE');

    the error no will appear along with the message text. and here is the sample to do this in a particular function

    FUNCTION chck_sal RETURN BOOLEAN IS
BEGIN
  IF :sal < 0 THEN SRW.MESSAGE(
    100,
    'There is employee that take negative salary.'
  );
RAISE SRW.PROGRAM_ABORT;
ELSE :bonus := :sal * .01;
END IF;
RETURN(TRUE);
END;
    See less
  4. Asked: March 20, 2017In:

    Convert number of seconds to Hours:Minutes:Seconds format

    ashishpandey
    ashishpandey Explorer

    Hi, SELECT TO_CHAR(SYSDATE,'SSSSS') FROM DUAL; -- will return like 54071SELECT TO_CHAR(TO_DATE(54071,'SSSSS'),'HH24:MI:SS') FROM DUAL;-- will RETURN like 15:01:11 It will help

    Hi,

     

    SELECT TO_CHAR(SYSDATE,’SSSSS’) FROM DUAL; — will return like 54071

    SELECT TO_CHAR(TO_DATE(54071,’SSSSS’),’HH24:MI:SS’) FROM DUAL;– will RETURN like 15:01:11

     

    It will help

    See less
  5. Asked: March 26, 2017In:

    How to add “Auto Refresh” feature in EBS submit request form like version 12.2.6?

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    Hello Beter,here you will find how to implement this functionality inside 12.1.3 + versions:Click Here : Implement Auto Refresh functionality in EBS 12.1.3+

    Hello Beter,

    here you will find how to implement this functionality inside 12.1.3 + versions:

    Click Here : Implement Auto Refresh functionality in EBS 12.1.3+

    See less
  6. Asked: June 19, 2016In:

    What is the difference between schema and user ?

    ashishpandey
    ashishpandey Explorer

    User is a credential to log-into to the database.Schema is group of objects of databse to be used for same purpose.One schema cam have multiple users to log into

    User is a credential to log-into to the database.

    Schema is group of objects of databse to be used for same purpose.

    One schema cam have multiple users to log into

    See less
  7. Asked: June 14, 2016In:

    get number of days between two dates column in oracle sql?

    ashishpandey
    ashishpandey Explorer
    This answer was edited.

    Hi, Like this we can use: SELECT pol_fm_dt, pol_to_dt, ROUND(pol_to_dt - pol_fm_dt) FROM pgit_policy;  

    Hi, Like this we can use:

    SELECT pol_fm_dt, pol_to_dt, ROUND(pol_to_dt - pol_fm_dt) FROM pgit_policy;

     

    See less
  8. Asked: March 4, 2017In:

    How to execute multiple procedures simultaneously ?

    ashishpandey
    ashishpandey Explorer

    Hi,   Its better you can create different jobs for each procedure and setting their time same to start execution.

    Hi,

     

    Its better you can create different jobs for each procedure and setting their time same to start execution.

    See less
  9. Asked: March 6, 2017In:

    How to use COMMIT or ROLLBACK inside database trigger ?

    ashishpandey
    ashishpandey Explorer

    Hi, You can creater a procedure to insert into your test_table_log table with parameter of the columns of thie table.   Then on your test_table table trigger call this procedure by passing the values. Commit will be in your calling procedure. So it will work.

    Hi,

    You can creater a procedure to insert into your test_table_log table with parameter of the columns of thie table.

     

    Then on your test_table table trigger call this procedure by passing the values.

    Commit will be in your calling procedure. So it will work.

    See less
  10. Asked: June 20, 2016In:

    Return more than one row from stored procedure in pl/sql

    ashishpandey
    ashishpandey Explorer

    CREATE OR REPLACE PROCEDURE pr_return_multiple_out(p_row_number VARCHAR2) IS CURSOR c0 IS SELECT pol_no, pol_assr_name FROM pgit_policy WHERE ROWNUM <= p_row_number; BEGIN FOR i IN c0 LOOP dbms_output.put_line(i.pol_no||' : '||i.pol_assr_name); END LOOP; EXCEPTION WHEN OTHERS THEN dbms_output.putRead more

    CREATE OR REPLACE PROCEDURE pr_return_multiple_out(p_row_number VARCHAR2) IS
    CURSOR c0 IS
    SELECT pol_no, pol_assr_name FROM pgit_policy WHERE ROWNUM <= p_row_number;
    BEGIN
    FOR i IN c0 LOOP
    dbms_output.put_line(i.pol_no||’ : ‘||i.pol_assr_name);
    END LOOP;
    EXCEPTION
    WHEN OTHERS THEN
    dbms_output.put_line(SQLERRM);
    END pr_return_multiple_out;
    /

    —————-Calling by passing number of output we want

    BEGIN
    pr_return_multiple_out(4);
    END;
    /

    See less