Oracle Web ADI Defaulting Flagged Row Issue

Web ADI Defaulting Flagged Row Issue

Requirement: Sometimes the client wants to default selection of flagged rows option, instead of select all rows.

Navigation: Application Developer Responsibility > Application > Function

Query Custom Function which you define for web ADI

Goto Form Tab

Parameter: bne:page=BneCreateDoc&bne:integrator= XXAPINV6_XINTG&bne:rows=FLAGGED

Add defaulting parameter like shown above.

Oracle Web ADI Invalid Integrator Key Issue

Web ADI Invalid Integrator Key Issue

Following Error Comes When User try to open Web ADI from Different EBS User Login.

Solution:

Navigation : Desktop Integrator Manager > Select Integrator > Goto Integrator Tab

Step 1: Select Check Box: Display in Create document Page

Step 2: Add Function under Security Rules

1)      BNE_ADI_CREATE_DOCUMENT (Many Time Required to add ‘BNE_CREATE_DOCUMENT’)

2)      XXAPINVFN1 (Function which is used for assign Web ADI to Specific responsibility)

Oracle Retrieve Application Password for specific User Query

Solution 1:

SELECT usr.user_name,

       get_pwd.decrypt

          ((SELECT (SELECT get_pwd.decrypt

                              (fnd_web_sec.get_guest_username_pwd,

                               usertable.encrypted_foundation_password

                              )

                      FROM DUAL) AS apps_password

              FROM fnd_user usertable

             WHERE usertable.user_name =

                      (SELECT SUBSTR

                                  (fnd_web_sec.get_guest_username_pwd,

                                   1,

                                     INSTR


(fnd_web_sec.get_guest_username_pwd,

                                           '/'

                                          )

                                   - 1

                                  )

                         FROM DUAL)),

           usr.encrypted_user_password

          ) PASSWORD

  FROM fnd_user usr

WHERE usr.user_name = 'FIN_ADMIN2';





Solution 2:

Package Specification:
CREATE OR REPLACE PACKAGE get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2;

END get_pwd;

Package Body:

CREATE OR REPLACE PACKAGE BODY get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2
   AS
      LANGUAGE JAVA
      NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';

END get_pwd;

Query to execute:


SELECT usr.user_name,
       get_pwd.decrypt
          ((SELECT (SELECT get_pwd.decrypt
                              (fnd_web_sec.get_guest_username_pwd,
                               usertable.encrypted_foundation_password
                              )
                      FROM DUAL) AS apps_password
              FROM fnd_user usertable
             WHERE usertable.user_name =
                      (SELECT SUBSTR
                                  (fnd_web_sec.get_guest_username_pwd,
                                   1,
                                     INSTR
                                          (fnd_web_sec.get_guest_username_pwd,
                                           '/'
                                          )
                                   - 1
                                  )
                         FROM DUAL)),
           usr.encrypted_user_password
          ) PASSWORD
  FROM fnd_user usr
 WHERE usr.user_name = '&USER_NAME';