Sunday, February 14, 2021

How to set Signon Password Policy in Oracle Apps R12?

 

 

 

 

 

 

            In this post, we have given the list of profiles which controls the password policy in Oracle application R12. This is generally done during initial implementation or any changes on password policy from the customer end.

There are standard profiles which allow you to set the password policy. Further, if additional custom rules beyond standard configurable options is required, then the same can be met using the custom Java function. In this post, we have given the introduction to allprofiles  

Note: The entire setup is applicable only for local sign on .


 

 

 

 

 

 

Profile Name

Purpose

Sample Value

Signon Password Case

This profile controls whether the passwords should be case sensitive or not

Sensitive

Signon Password Length

This controls the minimum length of the password

8

Signon Password Hard To Guess

1) The password contains at least one letter and at least one number.
2) The password does not contain the username.
3) The password does not contain consecutively repeating characters.

Yes

Signon Password Failure Limit

This determines the maximum number of logins a user can attempt before the user's account is disabled

5

Signon Password No Reuse

This profile will set the minimum number of days that a user must wait after changing his or her password before being allowed to reuse a password

180

Signon Password Custom

This profile allows you to bring custom password rules based on the organization needs. This requires a custom java function.

oracle.apps.fnd. security.XXSH  CustPasswordRules

Oracle References:

  1.  Setting Password Case Sensitivity (Required for Business Intelligence Publisher)
  2.  Setting Password Length Requirement
  3.  Setting "Hard to Guess" Requirement
  4.  Enabling "Forgot Your Password?" Functionality
  5.  Setting a Limit on Log-In Attempts
  6. Setting a Time Limit on Password Reuse after Resetting Password

 

Hope this helps!!

Sunday, February 14, 2021 by Team search · 0

Tuesday, January 26, 2021

Query to fetch External Bank accounts, Bank and Bank Branch details in Oracle Apps R12 (IBY_EXTERNAL_BANK_ACCOUNTS_V, IBY_EXT_BANKS_V,IBY_EXT_BANK_BRANCHES_V)

 

 

 

 

 

 

 

In this post, we have given a query which gives the basic details related to External bank accounts, Bank branches and bank setup details. This inturn helps you to understand the joins between bank related tables/views.

Tables/Views Involved:

iby_external_bank_accounts_v

iby_ext_banks_v

iby_ext_bank_branches_v

fnd_territories_vl

Query:

 

     SELECT ieba.ext_bank_account_id,
            ieba.bank_account_name,
            ieba.bank_account_number,
            ieba.bank_account_num_electronic,
            ieba.currency_code,
            ieba.primary_acct_owner_name,
            ieba.start_date bank_account_start_date,
            ieba.end_Date  bank_account_end_date,   
            ieba.country_code,            
            ft.territory_short_name country,
            ieb.bank_name,
            ieb.address1 bank_address1,
            ieb.address2 bank_address2,
            ieb.city bank_city,
            ieb.state bank_state,
            ieb.postal_code bank_postal_code,
            ieb.country bank_country,
            ieba.bank_branch_name,
            ieba.branch_number,
            iebb.bank_branch_type,
            iebb.start_date branch_start_date,
            iebb.end_date branch_end_date,
            iebb.address_line1 branch_address_line1,
            iebb.address_line2 branch_address_line2,
            iebb.city bank_city,
            iebb.state bank_state,
            iebb.zip bankbranch_postal_code,
            iebb.country bank_branch_country,
            iebb.operation_flag
       FROM apps.iby_external_bank_accounts_v ieba
           ,apps.iby_ext_banks_v              ieb
           ,apps.iby_ext_bank_branches_v      iebb
           ,fnd_territories_vl ft
      WHERE ieba.bank_party_id = ieb.bank_party_id
        AND ieb.bank_party_id = iebb.bank_party_id
        AND ieba.branch_party_id = iebb.branch_party_id
        AND ft.territory_code = ieba.country_code; 

Tuesday, January 26, 2021 by Team search · 0

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.