opening xml file field properties not change in BI publisher Solution in rtf template

Step 1:

Open a Microsoft Word document

Step 2:

Go to ‘BI Publisher’ tab

Step 3:

Click on ‘Options’ and Open ‘Options’

                                   

Step 4:

Move to ‘Build’ tab

Step 5:

Choose option ‘Form field size’ for ‘Backward Compatible’

                        

Step 6:

Finally click ‘OK’

How to find password of a User in Oracle Apps R12?-Encrypting User Password

Here is a wonderful oracle seeded Procedure fnd_web_sec.get_guest_username_pwd which will help us to find out user password.

This will be handy for consultants in resolving the issues. Please use with this care and don't misuse this.

To achieve this you need to create a small package and run a query which I wrote below

--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';

Password Policies in Oracle E-Business Suite

One of my customers is challenging the possibility to enforce strong passwords in E-Business Suite (Release 12). Using the generic User Define Form you can define when a password expires, but that is more or less all you can do from that screen. In order to enforce an advanced Password Policy, you should go to the Profile Options:

Sign on Password Failure Limit

The Sign on Password Failure Limit profile option defines the maximum number of login attempts before the user’s account is disabled.

Sign on Password Hard to Guess

Set this Profile Option to Yes to ensure that they will be "hard to guess."

A password is considered hard-to-guess if it meets this requirements:

• The password contains at least one letter and at least one number.

• The password does not contain the username.

• The password does not contain repeating characters.

Sign on Password Length

Sign on Password Length defines the minimum length of the password. The default is 5 characters

Sign on Password No Reuse

This profile option specifies the number of days before any previously given password can be reused.

Sign on Password Case

Set this profile option to 'Sensitive' to make the password case sensitive (it defaults to 'Insensitive in 11i, apparently, it defaults to 'Sensitive' in R12.1.1).

In this example, Users will have to enter a case sensitive password, they are not allowed to enter more than 3 wrong passwords, the password must be hard to guess (see above), and the length is set to at least 8 characters and cannot be used again for at least a year after it has expired.

                                                  

In the Define User screen we can set the Password Expiration to either
• Days (see example),
• Accesses (the number of logins) or
• None.

Combining the profile options with the Password Expiration will give you a robust password policy for Oracle E-Business Suite.

Drawee Business Purpose in Oracle

Selected Terminology: Drawee Business Purpose
Term	Description
Bills Receivable	The Bills Receivable account for an address. AutoAccounting uses this value if you chose to derive the Bills Receivable account from the transaction drawee site.
Unpaid Bills Receivable	The Unpaid Bills Receivable account for this address. AutoAccounting uses this value if you chose to derive the Unpaid Bills Receivable account from the transaction drawee site. You can enter a value in this field only if the business purpose for this address is Drawee.
Remitted Bills Receivable	The Remitted Bills Receivable account for this address. AutoAccounting uses this value if you chose to derive the Remitted Bills Receivable account from the transaction drawee site. You can enter a value in this field only if the business purpose for this address is Drawee.
Factored Bills Receivable	The Factored Bills Receivable account for this address. AutoAccounting uses this value if you chose to derive the Factored Bills Receivable account from the transaction drawee site.