In the Administration > User, you can record setup data that define your organization structure and its users. Information in this link is more “data” related, whereas the information stored on the System drop-down link functions more like switches that control system behavior.
Navigating to Administration System
The User drop-down link records the following data:
The Organization screen records the operational hierarchy of your business in terms of people. It groups the human resources of your business in three categories: organization, division, and department. The system uses this data to control access of users to applications (The Companies screen allows you to setup the location of these applications .)
Note
You can have only one active organization, so use the Organization field to define your organization at its highest level.
Divisions are groups within your organization that will have access to the same applications . Larger organizations often define their divisions by region. Smaller organizations may define division as branch offices or even departments, and might only have one division defined.
Departments are smaller units within a division. They expand on who is in the corresponding Division field. The system uses this sub screen, for example, when setting up the Services screen on the Utility form. At least one department must be defined for each division.
As an example of an organization setup, Oracle Corp. might be defined as:
Organization: O-0001 Oracle Corp. ORA
Division: OD-001 Central Region C01
Department: ODD-01 Origination ORG
Department: ODD-02 Funding FUN
Department: ODD-03 Servicing SER
Division: OD-002 Eastern Region E01
Department: ODD-11 Servicing SER
Department: ODD-12 Collection COL
Note
The Short Name field on the Organization screen allows you to create the ID that Oracle Financial Services Lending and Leasing will use when referring to the organization, division, and department throughout the system.
To setup the Organization screen
A brief description of the fields is given below:
Field: |
Do this: |
Organization |
Specify the organization ID (the ID is the unique identifier used internally by Oracle Financial Services Lending and Leasing to represent your organization). Note: Do not edit this field. |
Organization Name |
Specify the organization name. |
Short Name |
Specify the short name for the organization. Note: This ID represents this organization throughout the system. |
Enabled |
Check this box to enable the organization. Note: Only one enabled organization is currently allowed by Oracle Financial Services Lending and Leasing. |
Country |
Select the country where the organization is located from the drop-down list. |
City |
Specify the city where the organization is located. |
State |
Select the state where the organization is located from the drop-down list. |
Address Line 1 |
Specify the address line 1 for the organization. |
Address Line 2 |
Specify the address line 2 for the organization. |
Zip |
Select the zip code of the location where the organization is located from the drop-down list. |
Extn |
Specify the extension of the selected zip code. |
Phone 1 |
Specify the primary phone number for the organization. |
Extn 1 |
Specify the phone extension for the primary phone number. |
Phone 2 |
Specify the alternate phone number for the organization . |
Extn 2 |
Specify the phone extension for the alternate phone number, if specified. |
Fax 1 |
Specify the primary fax number for the organization. |
Fax 2 |
Specify the alternate fax number for the organization. |
A brief description of the fields is given below:
Field: |
Do this: |
Division |
Specify the division ID. The ID is the unique identifier used internally by the system to represent the division within the organization. Note: Once specified, do not edit this field. |
Division Name |
Specify the division name. |
Short Name |
Specify the short name for the division. Note: This ID represents this division throughout the system (required). |
Enabled |
Check this box to enable the division. |
Country |
Select the country where the division is located from the drop-down list. |
City |
Specify the city where the division is located. |
State |
Select the state where the division is located from the drop-down list. |
Address Line 1 |
Specify the address line 1 for the division. |
Address Line 2 (unlabeled) |
Specify the address line 2 for the division. |
Zip |
Select the zip code of the location where the division is located from the drop-down list. |
Extn |
Specify the extension of the selected zip code. |
Phone 1 |
Specify the primary phone number for the division. |
Extn 1 |
Specify the extension for the primary phone number. |
Phone 2 |
Specify the alternate phone number for the division. |
Extn 2 |
Specify the extension for the alternate phone number . |
Fax 1 |
Specify the primary fax number for the division. |
Fax 2 |
Specify the alternate fax number for the division. |
A brief description of the fields is given below:
Field: |
Do this: |
Department |
Specify the department ID. Note: The ID is the unique identifier used internally by the system to represent the department within the division. |
Department Name |
Specify the department name. |
Short Name |
Specify the short name for the department. Note: This is the ID that appears throughout the system to represent this department. |
Enabled |
Check this box to enable the department. |
Country |
Select the country where the department is located from the drop-down list. |
City |
Specify the city where the department is located. |
State |
Select the state where the department is located from the drop-down list. |
Address Line 1 |
Specify the address line 1 for the department. |
Address Line 2 |
Specify the address line 2 for the department. |
Zip |
Select the zip code where the department is located from the drop-down list. |
Extn |
Specify the zip extension where the department is located. |
Phone 1 |
Specify the primary phone number for the department. |
Extn 1 |
Specify the phone extension for the primary phone number. |
Phone 2 |
Specify the alternate phone number for the department. |
Extn 2 |
Specify the phone extension for the alternate phone number. |
Fax 1 |
Specify the primary fax number for the department. |
Fax 2 |
Specify the alternate fax number for the department. |
A brief description of the fields is given below:
Field: |
Do this: |
Format Type |
Select the type of format from the drop-down list. |
Format Sub Type |
Select the sub type of the format from the drop-down list. The format sub type will be displayed based on the format type selected. |
Format |
Specify or select the format based on the format type and format sub type selected. For Date and Time Zone format, select the required option from the drop-down list. |
Format Mask |
Specify the format mask. |
Format Filler |
Specify the format filler. |
Special Data |
Specify the special data, if any. |
Enabled |
Check this box to enable the display format. |
The Companies screen records the hierarchical structure of your portfolio companies and their branches. Just as Oracle Financial Services Lending and Leasing uses the Organization screen to determine the location of people, it uses the information on the Companies screen to determine the location of applications . In completing the Companies screen, there can be more than one company, and each company can have more than one branch.
Accounting is performed at the company level. Accountsand applications can be sorted down to the branch level. For this reason, branches are set up to reflect different business practices. You would set up different branches if, for example:
As an example of the companies setup, Oracle Corp. might have the following companies and branches defined as:
Company: C-0001 TrustOne Financial Corp TOFC
Branch: CB-01 TOFC - Headquarters HQ
Branch: CB-02 Kennedy Plaza KP
Company: C-0002 Credtyme Credit Corp CCC
Branch: CB-11 CCC - Headquarters HQ
Branch: CB-12 CCC - Missoula MT
Note
Key concept: Note the difference between the Company screen and the Organization screen:
As you can see in the following Access screen section, the information on the Organization and Companies screens define the operational hierarchy of your companies in terms of which Oracle Financial Services Lending and Leasing users will have access to which applications
To setup the Companies
A brief description of the fields is given below:
Field: |
Do this: |
Company |
Specify the portfolio company ID. (This ID is the unique identifier used internally by the system to represent the company). |
Name |
Specify the name of the portfolio company (required). |
Short Name |
Specify the short name for the portfolio company (ID displayed to represent the company). |
Currency |
Select the currency of the portfolio company from the drop-down list. The system displays the default value as ‘US DOLLAR’. |
Enabled |
Check this box to enable the portfolio company. |
Country |
Select the country where the portfolio company is located from the drop-down list. The system displays the default value as ‘UNITED STATES’. |
Address Line 1 |
Specify the address line 1 for the portfolio company. |
Address Line 2 |
Specify the address line 2 for the portfolio company. |
Zip |
Select the zip code of the location where the portfolio company is located from the drop-down list. |
Extn |
Specify the extension of the zip code where the portfolio company is located. |
City |
Specify the city where the portfolio company is located. |
State |
Select the state where the portfolio company is located from the drop-down list. |
Company Time Zone |
Select the time zone in which the company operates using the drop-down list. This time zone is considered if system is setup to process GL at Company level. For more information, refer to ‘Appendix - Configuration at Company Level’ chapter. |
Remittance Address section |
|
Country |
Select the remittance address country from the drop-down list. The system displays the default value as ‘UNITED STATES’. |
Remittance Address 1 |
Specify the remittance address line 1, if it is different from the company address. This address is included as the remittance address on statements. |
Remittance Address 2 |
Specify the remittance address line 2. |
Zip |
Select the zip code of the remittance address line 1 from the drop-down list. |
Extn |
Specify the extension of the remittance address zip code. |
City |
Specify the remittance address city. |
State |
Select the remittance address state from the drop-down list. |
Phone 1 |
Specify the primary phone number for the portfolio company. |
Extn 1 |
Specify the phone extension for the primary phone number. |
Phone 2 |
Specify the alternate phone number for the portfolio company. |
Extn 2 |
Specify the phone extension for the alternate phone number. |
Fax 1 |
Specify the primary fax number for the portfolio company. |
Fax 2 |
Specify the alternate fax number for the portfolio company. |
Tax ID # |
Specify the tax identification number for the portfolio company. |
TCC |
Specify the transmitter control code for the portfolio company (1098 Electronic Filing). |
Contact |
Specify the contact information about the portfolio company. |
Coupon Order Code |
If you are using coupons, Specify the coupon order code to be used by a third party printing the coupons for billing statements. |
HMDA |
Select the HMDA agency (Home Mortgage Disclosure Act reporting agency for the company). |
A brief description of the fields is given below:
Field: |
Do this: |
Branch |
Specify the portfolio branch ID. (This ID is the unique identifier used internally by the system to represent the branch within your company). |
Name |
Specify the name of the portfolio branch (required). |
Short Name |
Specify the short name for the portfolio branch (ID displayed to represent the branch) (required). |
Enabled |
Check this box to enable the portfolio branch. |
Sub Unit |
Select the Sub Unit from the drop-down list. Sub Unit refers the entity which is the source of funds for the credit application/Account. System associates the selected sub unit with the particular company/branch combination and displays by default when the same is selected during an application/Account creation. |
Country |
Select the country from the drop-down list. The system displays the default value as ‘UNITED STATES’. |
City |
Specify the city where the portfolio branch is located. |
State |
Select the state from the drop-down list. |
Address Line 1 |
Specify the address line 1 for the portfolio branch. |
Address Line 2 |
Specify the address line 2 for the portfolio branch. |
Zip |
Select the zip code of the location where the portfolio branch is located. |
Zip Extn |
Specify the extension of the zip code, where the portfolio branch is located. |
Phone 1 |
Specify the primary phone number for the portfolio branch. |
Extn 1 |
Specify the phone extension for the primary phone number. |
Phone 2 |
Specify the alternate phone number for the portfolio branch. |
Extn 2 |
Specify the phone extension for the alternate phone number. |
Fax 1 |
Specify the primary fax number for the portfolio branch. |
Fax 2 |
Specify the alternate fax number for the portfolio branch. |
Using the organizations, divisions, companies, and branches created on the Organization and Companies screens, you can control the access privileges of applications. On the Access screen, you define which organization/division (users) can gain access to which company/branch (applications and) locations.
Normally, for each division within an organization, you would define a record with Company value of ALL and a Branch value of ALL, then select the Allowed box. You then define other records for the same Organization and Division for other Company and Branch combinations with the Allowed box cleared to restrict access.
To setup the Access
The Data screen allows you to restrict access to different data.
To setup the Data
A brief description of the fields is given below:
Field: |
Do this: |
Organization |
Select the organization for which you are defining access privileges from the drop-down list. |
Division |
Select the division within the organization for which you are defining Access privileges from the drop-down list. |
Company |
Select the portfolio company to which you are defining access privileges for the organization and division specified from the drop-down list. |
Branch |
Select the portfolio branch of the company to which you are defining access privileges for the organization and division specified from the drop-down list. |
Allowed |
Check this box to provide access to the data pertaining to the company and branch, for the organization and division specified. |
In the screen, you can control the access to the following:
For example, Add and Edit buttons can be disabled once an application is funded.
If you want to restrict updating the Applicant details, then edit button has to be disabled for the stage.
The screen allows you to restrict access to different screens and fields using the following tabs:
To set the Screen Security
Note
You can not add a new record
A brief description of the fields is given below:
Field: |
Do this: |
Access Code |
The system displays the selected access code. |
Description |
Modify the description of the access code. |
Type |
The system displays the type of security access definition. |
System Defined |
If ‘Yes’ is selected, the security access definition entry is system defined. If ‘No’ is selected, the security access definition entry is manually defined. |
Enabled |
Check this box to enable the security access definition entry is enabled. |
A brief description of the fields is given below:
Field: |
Do this: |
Access Type |
Select the access type of the user who will have access to this screen from the drop-down list. |
Active Value |
Select the active value of the user who will have access to this screen from the drop-down list. |
Allowed |
Select ‘Yes’ to allow access to this screen or ‘No’ to deny access to this screen. |
System Defined |
Select ‘Yes’, if the screen user access definition entry is system defined. Select ‘No’, if the screen user access definition entry is manually defined. |
The Field Access Definition tab facilitates for field customization in the User Interface (UI) screen. In this tab, you can do the following:
Note the following:
Before defining field access, refer to the table below which indicates the possible combinations of a particular field being displayed and allowed to edit in UI.
View Type |
Access |
Result |
VIEW |
NO |
NON VIEWABLE |
VIEW |
YES |
VIEWABLE AND EDITABLE |
LOCK |
NO |
READONLY |
LOCK |
YES |
VIEWABLE AND EDITABLE |
To add/enable new User Defined Fields
Field: |
Do this: |
Language |
Select the language of the user(s) who will have access to this field from the drop-down list. |
Division |
Select the division or group within the organization to which the user belongs from the drop-down list. |
Object Name |
Select the Object Name from the drop-down list. You can use the search option to query based on specific name. The list is populated based on the combination of Language and Division selected above. |
Field Name |
Select the field to be updated from the drop-down list. The list is displayed based on the object selected. |
Access Type |
Select the access type as one of the following from the drop-down list. View - to display and make the field editable. Lock - to only display the field. Note: Option defined here takes precedence with the display (Y/N) option selected in Setup > Administration > System > Label Configuration tab. |
System Defined |
Select ‘Yes’, if the field access definition is system defined. Select ‘No’, if the field access definition is manually defined. |
Enabled |
Check this box to enable the field access definition. |
After updating the required changes in screen, you need to logout and re-login for changes to be effective. This is basically to refresh session cache and update Field Access information from database server. Though, there is ‘Update’ option, clicking on the same only refreshes the cache and reloads the record.
To enable/disable Base fields
Field: |
Do this: |
Access Code |
View the access code defined for the field. |
Description |
View the access code description. You can modify the details if required. |
Type |
By default, system displays the name of the group inside which the field is displayed in UI. To move the field to a different group, select the required type from the drop-down list. |
System Defined |
Select ‘Yes’, if the screen field access definition is system defined. Select ‘No’, if the screen field access definition is manually defined. |
Enabled |
Check this box to enable the field access definition. |
The ‘Security User Access Definition Details’ sub tab is available only for base - non mandatory fields and user defined fields. In the ‘Security User Access Definition Details’ sub tab you can defined field access and set restrictions to specific user responsibility.
A brief description of the fields is given below:
Field: |
Do this: |
Access Type |
Select RESPONSIBILTY as the access type from the drop-down list since access to field is based on responsibility by default. This field is disabled during edit. |
Active Value |
Select the user role who needs to have access to this field from the drop-down list. |
Allowed |
Select ‘Yes’ to allow access to this field or ‘No’ to deny access to this field. |
System Defined |
Select ‘Yes’, if the field user access definition is system defined. Select ‘No’, if the field user access definition is manually defined. |
In the Reports screen you can control access to generate certain reports.
To set up Reports
A brief description of the fields is given below:
Field |
View this: |
Code |
Displays the code of the report. |
Module |
Displays the code of the report from the drop-down list. |
Description |
Displays the description of the report. |
Enabled |
Displays whether the report definition is enabled or not. |
A brief description of the fields is given below:
Field: |
Do this: |
Access Type |
Select the access grid function type from the drop-down list. |
Access Value |
Select the access function grid value from the drop-down list. |
Allowed |
Select ‘Yes’ to allow access or ‘No’ to restrict access to the entry based on the access type and value. |
System Defined Yes/No |
Select ‘Yes’, if the report user access definition entry is system defined. Select ‘No’, If the report user access definition entry is manually defined. |
The Correspondence screen allows you to restrict access to different correspondence commands on the Letters menu, thus restricting your ability to generate certain correspondence.
If you do not have the responsibility to create a type of correspondence, the corresponding command on the Letters menu is unavailable (dimmed).
To setup the Correspondence
A brief description of the fields is given below:
Field: |
Do this: |
Code |
The system displays the correspondence code name you want to work with. |
Description |
The system displays the description for the correspondence code (display only). |
Enabled |
Check this box to enable the selected correspondence code entry. |
A brief description of the fields is given below:
Field: |
Do this: |
Access Type |
Select the access grid function type from the drop-down list. |
Access Value |
Select the access function grid value from the drop-down list. |
Allowed |
Select ‘Yes’ to allow access or ‘No’ to restrict access to the entry based on the access type and value. |
System Defined Yes/No |
Select ‘Yes’, if the correspondence user access definition entry is system defined. Select ‘No’, If the correspondence user access definition entry is manually defined. |
The Webservice screen in Access setup allows you to configure access to the available RESTful webservices in the system. The associated seed data for all the RESTful webservices are loaded during product installation and process of installing the same is detailed in the Installation guide.
As an administrator/superuser, you can Enable/Disable Web Service access to users based on their responsibility and ensure that only authorized user have access to specific type of data in the system. Following list indicates some of the available RESTful webservices in the system and the complete list is made available in swagger JSON file shared in OTN library:
To setup the Webservice access
Field: |
Do this: |
Access Code |
The system displays the webservice access code. |
Description |
The system displays the description of the associated webservice access code and can be edited for required changes. |
Type |
The system displays the type of security access definition. |
System Defined |
If selected as ‘Yes’, the security access definition entry is system defined. If selected as ‘No’, the security access definition entry is manually defined. |
Enabled |
Check this box to enable the selected webservice access code. |
A brief description of the fields are given below:
Field: |
Do this: |
Access Type |
Select ‘Responsibility’ (default) as the access type from the drop-down list. For this access type to be available in the drop-down list, ensure that the Lookup Type ‘ACCESS_GRID_TYPE_CD’ is maintained in the system. |
Access Value |
This field is ‘Read-only’ for ‘System Defined’ Security Access Definitions which are loaded as part of seed data during installation. For non-system defined Security Access Definitions, select the access value which is the user responsibility who needs to have access to this webservice from the drop-down list. For user responsibilities to be populated in the drop-down list, ensure that the Lookup Type ‘RESPONSIBILITY_CD’ is maintained in the system. |
Allowed |
Select ‘Yes’ to allow user access to this webservice or ‘No’ to deny access. By default, No’ is selected. |
System Defined |
Select ‘Yes’, if the webservice user access definition entry is system defined. Select ‘No’, if the webservice user access definition entry is manually defined. |
If you have selected the Security Super Group as ‘SERVICING and COLLECTIONS’, there is an additional sub section ‘Security Access Definition Details’ enabled. This sub tab facilitates you to further restrict and control access to specific type of data within the accessible RESTful web services. The restriction can be defined based on specific ‘Account Condition’ or ‘Account Status’.
For example, out of all the account types maintained in the system you can restrict data access to only delinquent account(s) to a particular user responsibility by selecting Access Type as ‘Account Condition’ and Access Value as ‘Delinquent’,
For any user to access web service data, you need to define atleast one positive (allowed) definition defined in 'Security Access Definition Details' section. Else, webserivce data is not displayed for that particular user even if that user responsibility has permissions to access web service.
OFSLL supports multiple user conditions on an Account and system requires to have atleast one account condition defined as ‘Allowed’ in setup to display the data. In case, even if any one of the account condition is defined as ‘Not Allowed’ in setup, then system does not allow to access the data.
During the following scenarios, data is either displayed/not displayed in Webservice screen:
Scenario |
Data displayed |
No condition is available on the account and also no condition defined in setup |
Data is displayed since there is no restriction. |
Condition is available on the account but not defined in setup |
Data is not displayed since restriction is applied |
Multiple conditions are available on the account and one condition is defined in setup as ‘Allowed’ |
Data is displayed |
Multiple conditions are available on the account and one condition is defined in setup as ‘Not Allowed’ |
Data is not displayed |
Whenever user with specific responsibility tries to access the restricted data, following type of error messages are displayed:
Note
When multiple user access definitions are defined in the system, while processing the data access request to a web service OFSLL first validates for any access restrictions on the user responsibility. If not, then validates the same against 'ALL' responsibility before displaying the data in Webservice screen.
For example, if data access restriction is defined for ALL and SUPERUSER responsibilities. when logged in with SUPERUSER responsibility, the data restriction of SUPERUSER is applied. In case, if the user logs in with any other responsibility other than SUPERUSER, then restriction defined for ‘ALL’ is applied.
To define Security Access Definition Details
A brief description of the fields are given below:
Field |
Do this: |
Access Type |
Select the access function type (as either ACCOUNT CONDITION or ACCOUNT STATUS) that is being used to control the user access from the drop-down list. |
Access Value |
Select the access value from the drop-down list. The list is sorted based on the Access Type selected. Also, based on a lookup associated with the Access Type multiple entries for each access type can be created as long as each has a different access value. |
Allowed? Yes/No |
Select ‘Yes’ if the access is allowed and ‘No’ if the access is not allowed. This indicates whether the selected combination of Access Type and Access Value is allowed to access the data. |
System Defined Yes/No |
Select ‘Yes’, if you wish to maintain access type as system defined and ‘No’, if you do not want to maintain it as system defined. However, system defined entries cannot be modified. |
The Users screen allows you to create and set up an user. In the User Definition section, you can assign a user an identification name and password to log on to the system. You can also assign the organization, division, and department where each user is located. Additional fields allow you to record information for contacting the user. You can also define the time frame within which a user has access to the system to ensure compliance to the company’s schedule. This is a very useful feature to prevent logins during scheduled maintenance.
The Responsibility field records the job function of the user and defines the level of access that user has within the system; in particular:
Note
The system’s SUPERUSER responsibility grants access to the entire system. Give careful consideration to the number and type of users who receive this responsibility.
To set up the Users screen
A brief description of the fields is given below:
Field: |
Do this: |
User |
Specify the user ID. Note: This field is a unique indicator and cannot be updated, edited, or deleted once saved. |
Organization |
Select the organization to which the user belongs, from the drop-down list. |
Division |
Select the division to which the user belongs, from the drop-down list. |
Department |
Select the department to which the user belongs, from the drop-down list. |
Start Dt |
Specify the start date for the user. You can also select from the adjoining calender icon. |
End Dt |
Specify the end date for the user. You can also select from the adjoining calender icon. |
System Defined |
Select ‘Yes’, if the entry is system defined. System defined entries cannot be modified. Select ‘No’, if the entry is not system defined and it can be modified. |
Enabled |
Check this box to enable the user. |
First Name |
Specify the first name of the user. |
MI |
Specify the middle initial of the user. |
Last Name |
Specify the last name of the user. |
Responsibility |
Select the responsibility for the user from the drop-down list. Note: The users mapped to the role ‘Responsibility’ can only view the screens. |
Review Request Supervisor |
Select the supervisor responsibility who can also review and respond to review requests from the drop-down list. The list displays the corresponding Review Request Supervisors who are either one or more levels higher from the above selected user ‘Responsibility’ as maintained in ‘RESPONSIBILITY_CD’ lookup code. |
Phone 1 |
Specify the user’s primary phone number. |
Extn 1 |
Specify the phone extension for the primary phone number. |
Phone 2 |
Specify the user’s alternate phone number. |
Extn 2 |
Specify the phone extension for the alternate phone number. |
Fax 1 |
Specify the user’s primary fax number. |
Fax 2 |
Specify the user’s alternate fax number. |
Replacement User |
Select the user ID of the replacement user from the drop-down list. |
Dt |
Specify the date from when the replacement is effective. You can also select from the adjoining calender icon. Note: These two fields allow you to create a replacement user for the current user. This is particularly useful when a new employee assumes the duties of a former. By completing the Replacement User and Replacement Dt field, the system recognizes the replacement user as the current user on the effective date. For more information, refer the section, ‘Replacement Users’. |
Type |
Select the user type from the drop-down list. |
Reference # |
Specify the reference number for the user from the drop-down list. |
Specify user’s email address. |
|
Default language |
Select the default language from the drop-down list. |
Time Zone |
Select the required Time Zone from the drop-down list, The specified time zone would be applicable at company level. |
Time Zone Level |
Select the time zone level (Organization, Company or User) that would apply by default, when specific time zone is not specified at Company and User level. |
By completing the Replacement User and Dt fields on the Users screen, you can replace an existing user with a new user. The system assigns all responsibilities of the original user to the new user as of the date of the replacement.
The Replacement User and Dt fields allow you to designate a replacement for the current user in the User ID field. When you complete the Replacement User and Dt fields, save your entry, and then enable the record, the system replaces the original user. The system changes the End Dt field to the date when the original user was replaced (the same date in the Dt field).
The system assigns the queues of the original user to only those replacement users who have the same user responsibilities (or Super User responsibility) as set in the system.
The system updates the following when replacing users:
Note
The system will not update the replacement user ID for accounts that are closed.
Oracle Identity Manager is for user administration. Oracle Financial Services Lending and Leasing has been developed in such a way that it can be implemented with or without Oracle Identity Manager. In case OID has been employed, the user definition is done in OID and then synchronized to the Oracle Financial Services Lending and Leasing Users table using a utility JAR called OID Synchronization JAR. In OID, users are defined across various groups belonging to a realm which is nothing but the directory structure in OID. A user can be configured to belong to multiple groups in a realm. Every time the user tries to login to Oracle Financial Services Lending and Leasing or OBIEE, the system validates the login ID and the password with OID and provides access to those applications.
In the system, an important part of the origination process is pulling a credit report from a credit bureau and scoring that information against a user-defined risk model. These credit reports can be pulled both automatically and manually.
After you enter an application, the system compares its contents against pre-screen criteria. If the application passes a pre-screen edits check, the system advances the status of the application and automatically pulls a credit report.
You can manually request a credit report for an applicant or any other party included on the application, such as co-signers and spouses by selecting the bureau from which you want to pull the report. If more than one report type is defined for the selected bureau, then you can indicate the type of report you want to pull.
The following are few additional Credit Bureau Setup details:
Member codes and passwords when switching credit bureau access methods (moving from dial-up to Net Connect). The member codes and passwords are not dependent on the connection method used to access the bureau.
Frame relay access is from the database server to the Experian host though a TCP/IP socket connection. The connection is outbound only and it is to a specific port (699 or 700) on the Experian host.
The credit bureau service will be accessing Experian Net Connect service through HTTP to the ECALS URL supplied by Experian as well as by the HTTPS to the URL returned as a response to the ECALS URL inquiry (the credit request URL). This access is from the database server access.
The setup for Credit Bureau spans across the following links:
Navigating to Credit Bureau
The Reports Formats screen captures and tracks the attributes related to the multiple types of reports offered by the credit bureau agencies. When a company enlists the service of a credit bureau, the credit bureau provides a membership code and password. This information needs to be entered on the Reports Formats screen before you can request a credit report. You must define at least one report for each credit bureau from which you want to pull reports.
The information on the Report Formats screen is location-specific. If the business requires different membership codes for each location, be it a company or branch, then individual records must be set up.
The Score Type, Additional Product, and Inquiry Limit fields on the Credit Report Setup section are optional. They may not apply to all credit bureau types and even if they do apply, you may want to leave them blank and rely on a default value set up at the credit bureau.
Note
For more information, refer to the the application Installation Guides.
To setup Report Formats
A brief description of the fields is given below:
Field: |
Do this: |
Bureau Name |
Specify the name of the credit bureau company. |
Short Name |
Specify the abbreviated or short name for the bureau. |
Source |
Select the credit bureau source from the drop-down list. |
Country |
Select the country of the credit bureau address from the drop-down list. |
City |
Specify the city for the credit bureau address. |
State |
Select the state of the credit bureau address from the drop-down list. |
Address Line 1 |
Specify the address line 1 for the credit bureau. |
Address Line 2 |
Specify the address line 2 for the credit bureau. |
Zip |
Select the zip code for the credit bureau address from the drop-down list. |
Extn |
Specify the extension of the zip code for the credit bureau address. |
Phone 1 |
Specify the primary phone number for the credit bureau. |
Extn 1 |
Specify the extension for the primary phone number. |
Phone 2 |
Specify the secondary phone number for the credit bureau. |
Extn 2 |
Specify the extension for the secondary phone number. |
Fax 1 |
Specify the primary fax number for the credit bureau. |
Fax 2 |
Specify the alternative fax number for the credit bureau. |
A brief description of the fields is given below:
Field |
Do this: |
Company |
Select the portfolio company that will be using the above credit bureau from the drop-down list. |
Branch |
Select the portfolio branch from the company that will be using the above credit bureau from the drop-down list. |
Description |
Specify the credit report format description. |
Member Code |
Specify the credit bureau member code (assigned by bureau). |
Password |
Specify the credit bureau password. |
Customer Code |
Specify the customer code. |
Auth Password Change Dt |
Display the last authorization password change date. The Experian Net Connect product requires that the Auth Password (or SSP Password in Experian jargon) be changed every 90 days (or sooner). Equifax may have similar requirements, but they were not known at the time of this writing. Use the date displayed in this field to identify when the password needs to be changed. Note: The password needs to be changed both in the system and at the credit bureau. Changing the password does not initiate or perform a change at the bureau. Changing the password at the bureau must be done outside the system. Contact the credit bureau for the procedure for changing the password (display only). |
Auth User ID |
Displays the authorization user ID (display only). |
Auth Password |
Displays the authorization password (display only). Note: This field is not displayed to the user and is also encrypted before being stored in the database (display only). |
Change Authorization User Id/Password section |
|
New Auth User Id |
Specify the authorization user ID. |
New Auth User Password |
Specify the authorization user password. |
TransUnion Details section (Note: This is only applicable for TransUnion.) |
|
Market |
Specify the TransUnion market id. |
Sub Market |
Specify the TransUnion Sub Market id. |
Industry |
Specify the TransUnion Industry code. |
Experian Details section (Note: This is only applicable for Experian.) |
|
Preamble |
Specify the Experian preamble code. |
Host Code |
Specify the Experian host ID. |
UIC |
Specify the Experian UIC. |
Equifax Details section (Note: This is only applicable for Equifax.) |
|
Service Name |
Specify the equifax service name. The service name will be provided to you by Equifax when your company's Internet System to System account is created. Possible values for pulling credit reports are acrotest (for access to the test system) and acro (for access to the production system). |
To support geography specific Credit Bureau integration, external interface is also supported in OFSLL. In such case, a webhook request for Credit Bureau Onboarding report is initiated from OFSLL. The same is processed in external bureau service depending on the endpoint configuration (type of bureau to be used as defined in Setup > Administration > System > Webhook screen).
Based on the response received the ‘Credit Bureau Put’ web service is triggered to update the details. Also on processing CREDIT_REQUEST_DETAILS the ‘Status’ of the request received in CRL_CRB_REP_STATUS_CD is updated in ‘Bureau’ tab of Origination and Servicing screens in the following combination:
CRL_CRB_REP_STATUS_CD |
Bureau Details > Status |
|
Primary |
Secondary |
|
Completed |
Completed |
Completed |
Completed |
Failed |
Failed |
Failed |
Completed |
Failed |
Failed |
Failed |
Failed |
Submitted |
Completed |
Submitted |
Completed |
Submitted |
Submitted |
A brief description of the fields is given below:
Field |
Do this: |
Report |
Specify the report name to be accessed from the credit bureau. |
Report Type |
Select the report type of the credit bureau report from the drop-down list. |
Report Class |
Select the report class as either Consumer or Business from the drop-down list. |
Multi Request Allowed |
Check this box to allow report request from multiple bureaus. |
Score Type |
Select the credit score type from the drop-down list. |
Addl Product |
Select the product code from the drop-down list. |
Inquiry Limit |
Select the inquiry limit for the credit report from the drop-down list. |
Default |
Check this box set this as default report format. |
External Report |
Check this box if the Credit Bureau Onboarding report request format is to be processed from external system. If selected, the encoding and decoding of request details and pooling of data into report is handled externally. By default, this check box is not selected and Credit Bureau Onboarding report request is processed within the system. |
A brief description of the fields is given below:
Field |
Do this: |
Report |
Specify the report name to be accessed from the credit bureau. |
Report Type |
Select the report type of the credit bureau report from the drop-down list. |
Score Type |
Select the credit score type from the drop-down list. |
Addl Product |
Select the product code from the drop-down list. |
Inquiry Limit |
Select the inquiry limit for the credit report from the drop-down list. |
Enabled |
Check this box to enable the report as default. |
The Connections screen records and supports various connections to the credit bureau to receive reports from the agencies. The system supports connections to the bureaus through one or more modems attached to the database server, network accessed modem server, or direct network connection (usually frame relay).
For modem-based connections, multiple credit bureaus can be accessed over the same modem. If there are multiple requests in the queue, the order in which the bureaus are listed determines the order in which the requests are processed.
For example,
If the credit bureau service checks the submitted credit requests and finds three Experian, one Equifax, and two TransUnion credit requests and the connections setup is Bureau1=TUC, Bureau2=EFX, and Bureau3=EXP, the two TransUnion requests will be processed first, the Equifax request next, and then the three Experian requests.
Note
For this above example, adding two more modems and assigning a specific bureau to each one would help to avoid the delay caused by queuing all requests through a single modem.
IMPORTANT: Direct network connections must be set up for only one bureau.
Like the Credit Bureau section on the Report Formats screen, the data fields used on the Connections screen are generic and not all fields are used for all access methods. The following table summarizes the data needed for each access method:
For frame relay access, specify the IP address provided by the bureau followed by a space and then the port number (for example, 192.168.36.2.700).
At the time of this writing, the Experian product ECALS URL is:
http://www.experian.com/lookupServlet1?lookupService
Name=AccessPoint&lookupServiceVersion=1.0&serviceName=Net
Connect&serviceVersion=2.0&responseType=text/plain
Note
The URL given above is one continuous string. This can be verified by entering the URL with a browser. The displayed value will be an HTTPS URL.
Enter the entire ECALS URL provided by Experian into the Device field. Notice that this URL does not start with https. The ECALS URL is a URL used by the credit bureau service to request the HTTPS URL. The HTTPS URL is not displayed on any setup screen and is only known to the credit bureau interface at runtime.
At the time of this writing, the Equifax Internet System to System URL is:
https://transport5.ec.equifax.com/servlet/stspost
CSC Tri-Merge
At the time of this writing, the CSC URL is:
https://www.emortgage.Equifax.com/cgi-bin/emspop.exe
To setup the Connections
A brief description of the fields is given below:
Field: |
Do this: |
Name |
Specify connection name. |
Bureau 1 |
Select first credit bureau from the drop-down list. |
Bureau 2 |
Select 2nd credit bureau from the drop-down list. |
Bureau 3 |
Select 3rd credit bureau from the drop-down list. Note: The Bureau1, Bureau2, and Bureau3 fields in the Credit Bureau Connections section specify which bureau types can be accessed over the connection. |
Device |
Specify the connection device name. The Device field lists the physical device name for a modem, or the IP address for a network accessed connection. |
Device Speed |
Select the connection device speed. The Device Speed field is only applicable to server-attached modems. It is used to specify the communications speed between the server and the modem. |
Enabled |
Check this box to enable the connection. |
The system uses the zip code of the applicant’s current home address to determine which credit bureau to use when automatically pulling a report. The Zip Matrix screen allows you to record the credit bureau from which a report is pulled based on a range of zip codes, as well as the company, branch and country of the account.
When searching for a zip code match, the system:
If the system cannot pull a report from the first bureau, it pulls one from the second. If the zip code you entered does not fall in the matrix setup, then the system uses a default zip matrix (0000000000 to 0000000000) to select the required bureau.
To set up the Zip Matrix
A brief description of the fields is given below:
Field: |
Do this: |
Company |
Select the portfolio company from the drop-down list. |
Branch |
Select the portfolio branch from the drop-down list. The branch will be displayed based on the company selected. |
Country |
Select the country from the drop-down list. |
From Zip |
Specify the starting zip code (From). |
To Zip |
Specify the ending zip code (To). |
Bureau 1 |
Select the preferred bureau #1 (first bureau pulled), from the drop-down list. You must enter at least one credit bureau in the Bureau 1 field for each zip code range. The bureau entered in the Bureau 1 field for each range is the primary bureau. For any given range, do not list the same credit bureau in more than one field. |
Bureau 2 |
Select the preferred bureau #2 (second bureau pulled) from the drop-down list. |
Bureau 3 |
Select the preferred bureau 3 (third bureau pulled) from the drop-down list. |
The Parameters screen records parameters specifically dealing with credit bureau information. These parameters are divided into three groups:
Parameters can be defined at the company or branch level. The following credit bureau parameters are configured during the installation:
PARSING PARAMETERS FOR CREDIT BUREAU SERVICE
CONFIGURATION PARAMETERS FOR CREDIT BUREAU SERVICE
The following credit bureau parameters are configured during implementation:
REQUEST PARAMETERS FOR CREDIT BUREAU Service
Request Parameters for Credit bureau Service
To setup the Parameters
A brief description of the fields is given below:
Field: |
Do this: |
Company |
Select the portfolio company from the drop-down list. |
Branch |
Select the portfolio branch from the drop-down list. The branch will be displayed based on the company selected. |
Parameter Group |
Select the credit bureau parameter group from the drop-down list. |
Parameter |
Select the credit bureau parameter from the drop-down list |
Parameter Value |
Specify the credit bureau parameter value. |
Enabled |
Check this box to enable the credit bureau parameter. |
The Score Reasons screen allows you to define or modify the scoring reason codes and descriptions for the predefined scoring models used by the credit bureau agencies.
Note
This information is not associated with the user-defined scores determined by the internal Oracle Financial Services Lending and Leasing model during product setup.
To setup the Score Reasons
A brief description of the fields is given below:
Field: |
Do this: |
Score Model |
Displays the credit bureau score model (display only). |
Enabled |
Displays if the credit bureau score model is enabled or not. |
A brief description of the fields is given below:
Field |
Do this: |
Reason Code |
Specify the reason code. |
Description |
Specify the description. |
The system reports to the credit bureau agencies in the Metro 2 format with the payment and account status information of each account holder. The Credit Bureau Reporting screen contains the program identifier to be reported to the bureaus.
To setup the Reporting
A brief description of the fields is given below:
Field |
Do this: |
Company |
Select the portfolio company from the drop-down list. |
Bureau |
Select the bureau from the drop-down list. |
Program Identifier |
Specify the program identifier. The customer receives this from the bureau and uses it to identify itself to that bureau. You will need to update this information. |
Enabled |
Check this box to enable the program. |
The system allows you to report the following special Metro II segments to the credit bureau output file:
The system users will need to use call Action/Results and Reason fields on the Call Activities sub screen of the Customer Service form (Lending > Customer Service > Customer Service (2) master tab > Account Details tab > Call Activities sub tab) to place specific account conditions where these Metro II segments are to be reported. The specific segment reported for a given condition will be based on the account condition and call activity reason codes.
Note
It is the responsibility of the Administrator or individual user to setup Special Metro II Code reporting functionality.
When users open one of the following conditions:
Code |
Description |
CIIC |
Consumer Information Indicator Code (METRO2 - FCRA) |
CCCD |
Compliance Condition Code (METRO2) |
SPCC |
Special Comment Code (METrO2) |
The system recognizes the condition, processes the selected Metro II reporting call activity reason code, and generates the Metro II reporting segment in the Metro II reporting output file.
Note
To setup Metro II Code reporting
Action Code |
Description |
CIIC |
Consumer Information Indicator Code (METRO2 - FCRA) |
CCCD |
Compliance Condition Code (METRO2) |
SPCC |
Special Comment Code (METRO2) |
When setup is completed, you can open and close Special Metro II code conditions.
Note
Opening and closing Special Metro II Code reporting is a manual process.
The CBU_FILE_FREQUENCY (METRO 2 FILE FREQUENCY) Company system parameter determines, if output file is generated and created daily or output file is written with daily data and output monthly.
The Experian Net Connect, Equifax Internet System to System, and CSC interfaces within the the system credit bureau service use functionality provided by the Oracle Wallet feature. Use the Oracle Wallet Manager on the database server to create and export a wallet for use by the credit bureau service.
Note
All of the above mentioned interfaces use the same Oracle wallet. If a wallet already exists and is in use by one of the credit bureau interfaces, there is no need to create another wallet. Due to differing certificate requirements, there may be a need to import additional trusted certificates into the wallet, but there will not be a need to create a new one. The credit bureau parameter ORA_WALLET_PATH contains the location of the Oracle Wallet used by the credit bureau service.
To create and export a wallet suitable for use by the credit bureau
Refer to the Oracle documentation for more detailed instructions on how to use the Oracle Wallet Manager to create and manage a wallet:
https://ss1.experian.com |
Experian |
https://transport5.ec.equifax.com |
Equifax |
https://www.emortgage.Equifax.com |
CSC |
This list may change. Use the URL provided to you by the credit bureau when they set up your service. To get the proper Experian HTTPS URL, enter the ECALS URL that was provided by Experian into a web browser. The response returned to the browser is the HTTPS URL that will be used to communicate with Experian.
SQL> select utl_http.request('https://ss1.experian.com', NULL, 'file:/etc/ORACLE/WALLETS/oracle', 'password') from dual;
Replace the URL in the above command with each HTTPS URL given to you for use by the credit bureaus. Also replace the wallet path with the path to your wallet and your wallet password. The output from the command is not important, what is important is that it runs without displaying an Oracle error. If there is an Oracle error, then something is wrong with the contents of the wallet, the path to the wallet, and/or the wallet password.
The Experian Net Connect interface within the credit bureau service requires the use of the Oracle Java Virtual Machine (JVM) that is resident in the Oracle database. Furthermore, specific permissions must be granted to the Java classes used by the credit bureau service. These permissions have been added to the set_java_perms.sql script that is part of the distribution. This script (as well as many other useful SQL scripts) is available from the Oracle Financial Services Software technical support Oracle Financial Services Lending and Leasing patches web site.
The set_java_perms.sql script needs to run as the SYS user (or a user with SYS privileges). The script will prompt for SYS user id and password. Be prepared to provide it when prompted. Also, the script will select the value of the ORA_WALLET_PATH parameter from the credit bureau parameters table. Make sure that it has been updated with the proper wallet path before running the set_java_perms.sql script (although the script can be safely run again if necessary).
The basic operation of the credit bureau service has not changed. Once setup, there is no operational difference between accessing the credit bureaus via dial-up, frame relay, or the Internet.
The HTTPS servers used by Experian, Equifax, and CSC for their Internet based credit report services (as well as all HTTPS servers) contain a site certificate signed by a trusted Certificate Authority (CA). The CA is an entity that guarantees the identity of the HTTPS server. If the client trusts the CA, and the CA says that the HTTPS server is who they say they are, then the client inherently trusts the HTTPS server. Normally, a client tool such as Microsoft Internet Explorer has a large store of trusted CA certificates which makes secure communication between a client and a trusted HTTPS server relatively seamless and uneventful. Unfortunately, the store of CA certificates in the default Oracle wallet is rather small and it is likely that it will not contain the certificate of the CA that is certifying one or more of the credit bureau web sites. This means that the CA certificate must be imported into the wallet. To do this, the certificates must first be exported from a browser and then imported into the Oracle wallet using the Oracle Wallet Manager.
Using Microsoft Internet Explorer to Export a Certificate
If the web site asks for a user id and password, cancel the dialog box and remain on the top-level HTTPS screen.
The screen shot below shows a certificate that is already in the wallet’s list of trusted certificates (see the last entry for the www.verisign.com/CPS certificate).
Oracle Financial Services Lending and Leasing allows you to remove duplicate (“de-dupe”) liabilities data from the credit bureau information.
The de-duping logic is based on a number of parameters that the system compares among tradelines (only) to determine if they are duplicates. The following fields are used to determine if two tradelines are duplicates:
Field: |
Description: |
Account # |
The account number of the consumer with the lender for the particular account. |
Open Date |
The date the account was opened. |
Member Code |
The subscriber code of the lender with the respective credit bureau. Note: Since member codes for the same lender differ across bureaus, this field is used only for tradelines reported by the same bureau. Since reports obtained from CSC can have tradelines from different bureaus, this field is only for reports pulled from the credit bureaus. |
All available bureau reports pulled later than DEDUP_CRB_EXPIRATION_DAYS days old will be used.
The following system parameters will be set up to provide switches to allow the functionality to be turned on and off:
Whenever two (or more) items are identified as duplicates, Oracle Financial Services Lending and Leasing uses the following hierarchy to pick one of the items as the “correct” one:
Oracle Financial Services Lending and Leasing uses the system parameter DBR_JOINT_INC_DEBT_WITH_SPOUSE to decide whether to combine debt ratios of the spouse with the primary applicant. The DBR_JOINT_INC_DEBT_WITH_COAPP parameter decides whether to do the same on a non-spousal joint application.
When this indicator is checked, all liabilities in the Liability section on the Summary sub screen of the Applicant (2) master tab with the Include box selected will be used in the debt ratio calculation.
The following system parameter will be set up to provide switches to allow the functionality to be turned on and off:
The de-duping logic will be integrated into the system decision-making process in the following manner:
Initial credit pulls on new applications
Subsequent credit pulls (manual)
The de-duping logic will be limited based upon the discussion above. If the system cannot identify two tradelines as duplicates based upon the logic mentioned above, the individual tradelines will be retained. In such circumstances, both tradelines will be used in the debt ratio calculation and it will be the user’s responsibility to disregard one of them by clearing the Include check box.
The Correspondence screen enables you to setup the system’s correspondence.
The system provides two types of correspondence: predefined and ad hoc. The following chart provides a quick summary of both:
This chapter explains how to setup ad hoc correspondence with the Correspondence form.
The Correspondence screens provide a cost-effective and easy to use method to build custom documents that draw information from the system’s database without additional programming. You can choose what to include in a letter, create a template, and then use this template to produce a letter.
The core of the Correspondence module is the document element -- the information stored in the database merged into the correspondence. The system has document elements defined for commonly used data elements in correspondence, such as account numbers, account balances, customer addresses, telephone numbers, and due dates.
Correspondence consists of a document file with text of your choice and the document elements from the system’s database.
You can create a correspondence set that consists of one or more documents. If a correspondence set consists of more than one document, such as the account details letter and a payment overdue letter, it prints both documents every time the system generates correspondence for a customer.
The Correspondence module creates the following standard ad hoc correspondence:
Note
In this document and in the system, the term bankers system is synonymous with Adobe Acrobat.
The Correspondence screen contains the following sub screens:
Navigating to Correspondence
The System Functions screen enables you to view the predefined functions for the appropriate Lease product in the system. These are attributes from the database.
Functions define how the system retrieves data to include in correspondence. The data is retrieved as elements which are either specific database columns or calculated values. Elements are recorded on the Elements screen.
To view the predefined system functions
A brief description of the fields is given below:
Field: |
View this: |
Function Name |
Displays the function name. |
Description |
Displays the function description. |
Function Type |
Displays the function type. |
Source Program |
Displays the source program. |
A brief description of the fields is given below::
Field: |
View this: |
Position |
Displays the parameter position. |
Parameter |
Displays the function parameter. |
Description |
Displays the function parameter description. |
The Elements screen displays the predefined document elements retrieved from the database when the correspondence is generated.
In the Element Definitions section, you can update or edit only the Description field.
To view the Elements
A brief description of the fields is given below:
Field: |
Do this: |
Level0 Type |
Displays the element Level0 type. |
Element Name |
Displays the element name. |
Element Type |
Displays the element type. |
Description |
Specify the element description. |
Data Type |
Displays the element data type. |
Source Function |
Displays the element function. |
Enabled |
Displays if the element is enabled or not. |
Default Value |
Displays the default value. |
The E-forms Elements screen defines elements included when the system generates online correspondence with a browser. The E-forms screen is set up only for PDF elements using the XFDF format. These definitions translate the external element required by the vendor to a systems correspondence element.
For example,
Type |
Details |
Vendor Element |
AllBorrowers.FullNameStreetCityStateZip (Contains names of all borrowers with address of primary customer) |
The system’s Elements |
PRIM_APL_NAME SPOUSE_APL_NAME PRIM_APA_ADDRESS1 PRIM_APA_ADDRESS2 PRIM_APA_ADDRESS3 |
Translation: |
PRIM_APL_NAME || ', ' || SPOUSE_APL_NAME || ', ' || PRIM_APA_ADDRESS1 || '; ' ||PRIM_APA_ADDRESS2 || '; ' || PRIM_APA_ADDRESS3 |
To setup the E-forms Elements
A brief description of the fields is given below:
Field: |
Do this: |
Level0 Type |
Select the element Level0 type from the drop-down list. |
Source Code |
Select the element e-form source code from the drop-down list. |
Element Name |
Specify the element name (the name used in the external form). |
Description |
Specify the element description. |
Data Type Code |
Select the element data type code from the drop-down list. |
Translation |
Select the translation for the e-form element (SQL statement fragment defining the element data), from the drop-down list. |
Enabled |
Check this box to enable the e-form element. |
The Documents screen enables you to set up the various documents and the data fields that the system compiles together when creating a correspondence. The system provides two different document formats: Word or XFDF: XML-based form.
Note
Oracle Financial Services Software assumes that the user is familiar with Word and the Merge Document command. If the user is creating e-form documents with XFDF, then Oracle Financial Services Software assumes that person is familiar with Adobe forms.
To setup documents to be compiled in correspondence
A brief description of the fields is given below:
Field: |
Do this: |
Code |
Specify the document code to define the name for the new document. |
Description |
Specify the document description for the new document. This entry appears in the Correspondence section on the Request screen, when you generate an ad hoc correspondence. |
File Name |
Specify the document file name for the resulting file (Word or XFDF document). Ensure that the name specified here is same as the BIP Template name since system refers to this file name for generating the correspondence. |
Level0 Type |
Select the level0 type from the drop-down list. |
E-form Source |
Select the element e-form source from the drop-down list. |
Product |
Select the document product from the drop-down list. |
Source |
Select the document source type from the drop-down list. |
Enabled |
Check this box to enable the document definition. |
A brief description of the fields is given below:
Field: |
Do this: |
Seq |
Specify the sequence number to order the document elements. |
Type |
Select element type from the following from the drop-down list. This list provides the following options: System-defined – If you select, the value is supplied by the system and cannot be changed in the Correspondence Request screen. Constant. User Defined Element – If you select, you can choose the value and change it in the Correspondence Request screen. User Defined Constant – If you choose, you can choose the value, but you cannot change it in the Correspondence Request screen. Translated Element – If a document contains an e-form element and you do not select this option, then the value will not be translated. |
Element Name |
Select the element name from the drop-down list. |
Description |
Specify element description. Notes: 1. Check that the element name does not have blank spaces or special characters, such as the forward slash “/” or backward slash “\”. 2. If the element is system-defined, then the system will automatically complete this field. |
Data Type |
Select the element data type from the drop-down list. |
Format Mask |
Select the element format mask from the drop-down list. |
Default Value |
Specify the element default value. |
Enabled |
Check this box to include the element in the document. |
A brief description of the fields is given below:
Field: |
Do this: |
File Name |
Specify the file name to define the name for the new template. |
Product |
Select the product for which the template is valid, from the drop-down list. |
Customer State |
Select the customer state for which the product is valid, from the drop-down list. |
Producer State |
Select the Producer state for which the product is valid, from the drop-down list. |
App/Acc St |
Select the Applicant/Account state for which the product is valid, from the drop-down list. |
New Template |
Check this box to load the template as a new template. |
Loaded |
Check this box to indicate that the template is loaded. |
Enabled |
Check this box to enable the template. |
Note
You can define multiple templates for each document and the template file name (BIP template) is picked based on following criteria – Product and Producer / Account / Customer State.
The Document Elements sub screen records the system’s application or account information that appears in the ad hoc correspondence
To generate a data file for a document
The system displays a new screen with the following options:
The Correspondence screen enables you to define who will receive the documents you created on the Document Definition screen by creating correspondence sets. Each document must belong to a set, and a set can have more than one document.
To set up a correspondence set
A brief description of the fields is given below:
Field: |
Do this: |
Code |
Specify the correspondence code. |
Description |
Specify the correspondence description (required). |
Print Schedule |
Select the correspondence output schedule type from the drop-down list. |
Level |
Select the correspondence level type from the drop-down list. |
Group |
Select correspondence group from the drop-down list. |
Company |
Select the correspondence company from the drop-down list. |
Branch |
Select the correspondence branch from the drop-down list. |
Product |
Select the correspondence product from the drop-down list. |
Enabled |
Check this box to enable the correspondence. |
A brief description of the fields is given below:
Field: |
Do this: |
Document |
Select the correspondence document from the drop-down list. |
Recipients |
Select the recipients for the document from the drop-down list. |
Enabled |
Check this box to enable the recipient selected. |
A brief description of the fields is given below:
Field: |
Do this: |
Function |
Select the correspondence functions from the drop-down list. |
Execute When? |
Select when to execute the correspondence function from the drop-down list. |
Note
Oracle Financial Services Software assumes that BIP Desktop Tool is installed and the user is familiar with the BIP Report Tool.
Note
The .xml and .rtf file should be saved with the same name as entered in the ‘Code’ column of Document Definition section.
When processing an application, various users might work on the application to complete different tasks. A data entry person might complete the Application Entry screen before an underwriter works on the application using the Applications screen. Later, another user might use the Applications screen to fund the application.
The application processing workflow facilitates the movement of the application from one person to another with queues. Queues create a work section of accounts waiting for a particular and common task to be performed, such as application entry or verification. The system’s powerful queuing module automates this otherwise manual process.
In the Queues setup screen, you can setup and manage workflow and work assignments on a daily basis to ensure that all applications are in the queues of the appropriate users at all times.
Any time an application’s status is changed, the system checks whether the application is in the right queue.
The system will sort queues based on an application’s status and sub status.
The Origination screen on the Queue Setup form allows you to set up queues that direct applications to users during the loan origination cycle. Origination queues are based on an application’s status and sub status. Whenever an application changes its status/sub status, the system moves the application to a queue based on the information on this screen.
You can define the loan origination queues and the corresponding selection criteria based on:
With loan origination queues set up, the applications in your work queue automatically appear on the Results screen when you open the Underwriting or Funding screen. The queue to which you are assigned appears in the Queue Name field. You would then begin processing the applications in the order of which they are listed, double-clicking the application at the top of the list to load it.
On the Setup > Setup > Queues screen, you can determine the direction of the applications to users who process then. Whenever there is a change in the status or sub status of the application, the system places the application in a appropriate queue based on the information available in this screen.
Applications are further filtered based on the following criteria:
To setup Origination Queues
You can either define new Queue Definition details or specify a new name in the New Queue field and click Create Copy to create a copy of selected queue definition with details.
A brief description of the fields is given below:
Field: |
Do this: |
Queue Name |
Specify queue name. |
Queue Description |
Specify queue description. Note: The system uses this entry when referring to the queue on other forms. |
Override Responsibility |
Select an override responsibility code from the drop-down list. The system uses this data to determine the User who holds the override responsibility for the specified queue, if an application triggers an “override” edit. |
Priority |
Specify the priority number. The system sorts applications by the higher number. For example, an application with a priority # 5 is considered to have a higher priority than the one with a priority # 3. |
Company |
Select the company from the drop-down list. |
Branch |
Select the branch drop-down list. |
Enabled |
Check this box to enable the queue. |
Here, you can further filter the applications in a particular queue. This criteria is generally used by organizations to categories and allocate large number of applications to different queues.
Note
If you want to execute search on like operators, then use '%'.
To setup Selection Criteria
A brief description of the fields is given below:
Field: |
Do this: |
Status |
Select application status from drop-down list. |
Sub Status |
Select application sub status drop-down list. |
Enabled |
Select the check box to enable the application status. |
Note
All is the default value for each field.
A brief description of the fields is given below:
Field: |
Do this: |
Product Type |
Select the product type as loan from the drop-down list. |
Funding Type |
Select funding type from the drop-down list. |
Product |
Select product from the drop-down list. |
State |
Select state from the drop-down list. |
Channel |
Select channel from the drop-down list |
Underwriter |
Select underwriter from the drop-down list. |
Producer Type |
Select producer type from the drop-down list. |
Producer Group |
Select producer Group from the drop-down list |
Producer |
Select producer from the drop-down list. |
Region |
Select region of the producer from the drop-down list. |
Territory |
Select territory of the producer from the drop-down list. |
Sales Agent |
Select sales agent for the producer from the drop-down list. |
Funder |
Select funder for the producer from the drop-down list. |
Perform any of the Basic Actions mentioned in Navigation chapter.
In the Sort sub tab of Queue Definition, the new applications which are in origination queue are displayed here based on sort criteria defined. In case of any overrides, applications would be sorted automatically without the need of a setup definition. However, there is no impact if sort is not defined for a queue.
To setup Sort Criteria
A brief description of the fields is given below:
Field: |
Do this: |
Seq |
Specify the sequence number representing the sorting priority. |
Sort Field |
Select the sort criteria from the list of parameters available in the drop-down list. |
Order |
Select either 'ascending' or 'descending' as the sort order. |
A brief description of the fields is given below:
Field: |
Do this: |
Responsibility |
Select the responsibility from the drop-down list. |
Enabled |
Check this box to enable the responsibility. |
A brief description of the fields is given below:
Field: |
Do this: |
User |
Select user from the drop-down list. |
Enabled |
Check this box to enable. |
Data node Assignments provides user with the flexibility to view the tabs in origination. User will have option to enable disable Tabs. All the enabled tabs will be displayed when application is in that particular queue. Disabled tabs for the tabs will not be shown when applications is in respective queue.
For example: Application entry Queue
If summary tab to be disabled, the search for the ULN Summary tab and Disable. IN application Entry summary will not be shown
A brief description of the fields is given below:
Field: |
Do this: |
Node |
Select the node from the drop-down list. |
Enabled |
Check this box to enable the record. |
The Group Assignment sub tab allows you to add user groups to Origination Queue.
Note
Modification of user details (adding or disabling users) within a user group which is added to Group Assignment will implicitly be updated in Responsibilities and Users tab also.
To add User Group to Group Assignment
A brief description of the fields is given below:
Field: |
Do this: |
Group Name |
Select the user group name from the drop-down list. The list displays the pre-defined user groups available in the system. |
Enabled |
Check this box to enable the user group. |
The User Groups tab in Queues is a centralized repository which allows you to define user groups, add and remove users from user groups.
The User Groups tab consists of User Group Definition section listing the defined User Groups and User section below listing the associated users of the selected User Group.
To define a User Group
A brief description of the fields is given below:
Field: |
Do this: |
Name |
Specify user group name. |
Description |
Specify an appropriate user group description. The same is used while referring this User Group on other screens. |
Responsibility |
Select the responsibility of the user group from the drop-down list. You can later add only those ‘Users’ who have the selected responsibility into the user group. |
Enabled |
Check this box to enable the user group. |
To add Users to User Group
A brief description of the fields is given below:
Field: |
Do this: |
Name |
Select the user from the drop-down list, The list displays the available users based on the responsibility defined for the user group. |
Enabled |
Check this box to enable the user. |
The Printers screen allows you to set up an unlimited number of network printers and fax devices to be used with the system server. The system uses the information on this screen while selecting a printer, when the printing process involves a batch job or uses a job scheduler. Examples include printing reports and correspondence.
The printers and fax devices can be set up at each organization, division, or department to promote efficient printing of documents, and reports. The system uses this information during product setup and on the Letters screen in the Batch Printer field.
The following printer names are predefined and have specific functions within the system:
Name |
Description |
UNDEFINED |
Indicates that the document to be printed is to be previewed in your browser instead of actually printing the document. |
archive |
Instead of sending an item to the printer, the system generates a PDF document and saves it in the archive directory on your server. |
For origination correspondences that can be faxed, the system e-mails the document as a PDF attachment to the consumer for direct or to the producer in the case of in-direct . |
|
fax |
For origination correspondences that can be faxed, the system generates a PDF document and will send to the fax server defined in System Parameters. |
Additionally, you may set up composite entries in the Printer Name field to perform two or more functions at the same time. This can be done by defining a printer name with the following format:
Printer name = <Printer_Name1> + <Printer_Name2>
For example, if a printer named jet4050 was previously defined, as were the special printer names listed above, then the following additional printers could be defined:
Name |
Description |
jet4050+archive |
Prints the document with the jet4050 printer and archives the document. |
fax+archive |
Faxes and archives the document. |
email+archive+jet4050 |
E-mails, archives, and prints the document with the jet4050 printer. |
To set up the Printers
A brief description of the fields is given below:
Field: |
Do this: |
Printer Name |
Specify the printer name. The name of the printer as defined by the server. For a UNIX server, the name might be jet4050, while to access the same printer from a Windows server the name would be: \\servername\jet4050. |
Description |
Specify the description for the printer. |
Organization |
Select the organization to which the printer belongs, from the drop-down list. |
Division |
Select the division to which the printer belongs, from the drop-down list. The division will be displayed based on the organization selected. |
Department |
Select the department to which the printer belongs, from the drop-down list. The department will be displayed based on the division selected. IMPORTANT: When you select a printer to use, the system searches for a best match using the following attributes: 1 Organization 2 Division 3 Department Hence, Oracle recommends creating a version of each edit, where ALL is the value in these fields. It is also recommended that, you define a default printer for an Organization, Division and Department. |
Default |
Check this box to set the printer as a default printer. |
Enabled |
Check this box to enable the printer and that the printer is active. Note: Never disable the UNDEFINED printer. |
The Banks screen defines the banks, a company/branch uses for processing Automatic Clearing House (ACH) and lock box payments.
Note
This is “behind the scenes” information that the system uses for payments and does not appear on any other forms.
To set up the Banks
A brief description of the fields is given below:
Field: |
Do this: |
Code |
Specify the bank code (ID used internally by Oracle Financial Services Lending and Leasing to represent the bank). |
Name |
Specify the name for the bank. |
Short Name |
Specify the short name for the bank (ID displayed to represent the bank. This may be included in any output files). |
Enabled |
Check this box to enable and indicate this as an active bank |
Account # |
Specify the account number used for banking transactions with the bank. Note: If the organizational parameter UIX_HIDE_RESTRICTED_DATA is set to Y, this appears as a masked number; for example, XXXXX1234. |
Routing # |
Specify the routing number of the bank. |
BIC |
Select the Business Identifier Code from the drop-down list. The list displays the BIC codes defined in the system. |
IBAN |
Specify the IBAN (International Bank Account Number). IBAN is used for identifying bank accounts across national borders with a minimal of risk of propagating transcription errors. Ensure that value entered satisfies the check-digit validation based on modulo 97. On save, system automatically validates the IBAN number length based on country code, characters, white spaces, and checksum. Validation is also done during posting non-monetary transaction (ACH Maintenance). You can maintain the IBAN length and other details required as per the country code in the user defined table (Setup > Administration > System > User Defined Tables). Note: IBAN for 'NL' country code (IBAN_FORMAT_NL) is defined by default with length of IBAN as 18. |
Country |
Select the country where the bank is located, from the drop-down list. |
City |
Specify the city where the bank is located. |
State |
Select the state where the bank is located, from the drop-down list. |
Address Line 1 |
Specify the address line 1 for the bank. |
Address Line 2 |
Specify the address line 2 for the bank. |
Zip |
Specify the zip code where the bank is located, from the drop-down list. |
Extn |
Specify the extension of the zip code where the bank is located. |
Creditor Id |
Specify the creditor identification details. |
Phone 1 |
Specify the primary phone number of the bank. |
Extn 1 |
Specify the phone extension for the primary phone number. |
Phone 2 |
Specify the alternate phone number for the bank. |
Extn 2 |
Specify the phone extension for the alternate phone number. |
Fax 1 |
Specify the primary fax number for the bank. |
Fax 2 |
Specify the alternate fax number for the bank. |
ACH Format |
Select the ACH format accepted by this bank from the drop-down list. The list displays the following options: - NACHA Format - SEPA Format |
A brief description of the fields is given below:
Field: |
Do this: |
Company |
Select the portfolio company from the drop-down list. |
Branch |
Select the portfolio branch from the drop-down list. |
ACH Identifier |
Specify the lock box ID provided by the bank. This field is used in the ACH files to identify the bank. |
Enabled |
Check this box to enable the ACH and indicate this as an active ACH identifier. |
A brief description of the fields is given below:
Field: |
Do this: |
Lock Box Identifier |
Specify the lock box ID provided by bank. This field is used in the lock box files to identify the bank. |
Company |
Select the portfolio company from the drop-down list. |
Branch |
Select the portfolio branch from the drop-down list. |
Enabled |
Check this box to enable the lock box. |
The Standard Payees screen defines the third parties that are frequent payees for checks issued within your organization. These payees are then available on the Consumer Lending screen’s Advance Entry screen. When you select the Payee # in the Advance Allocation section, the system completes the remaining fields in this screen with information from the Standard Payees screen.
Note
The Payee # field on the Advance Payment forms is a non-validated field. This allows you to select an entry or enter one of your own.
To set up the Standard Payees
A brief description of the fields is given below:
Field: |
Do this: |
Payee # |
Specify the payee number (Identifier for the payee). |
Name |
Specify the payee name. |
Pmt Mode |
Select the payment method for the payee from the drop-down list. |
Enabled |
Check this box to enabled the payee. |
Country |
Select the country where the payee is located from the drop-down list. |
City |
Specify the city where the payee is located. |
State |
Select the state where the payee is located from the drop-down list. |
Address Line 1 |
Specify the address line 1 for the payee (optional). |
Address Line 2 |
Specify the address line 2 for the payee (optional). |
Zip |
Select the zip code where the payee is located from the drop-down list. |
Extn |
Specify the extension of the zip code where the payee is located. |
Phone 1 |
Specify the primary phone number for the payee. |
Phone 2 |
Specify the alternate phone number for the payee. |
Bank Name |
Specify the payee ACH bank name used by the standard payee. |
Routing # |
Specify the payee ACH bank routing number of bank used by the standard payee. |
Account Type |
Select the payee type of ACH bank account maintained by the Standard Payee from the drop-down list. |
ACH Account # |
Specify the payee ACH bank account number. |
Company |
Select the company from the drop-down list. The list is populated with Company definitions based on the Country selected. |
Branch |
Select the branch drop-down list. The list is populated with Company branch based on the Country selected. |
BIC |
Select the Business Identifier Code from the drop-down list. The list displays the BIC codes defined in the system. |
IBAN |
Specify the IBAN (International Bank Account Number). IBAN is used for identifying bank accounts across national borders with a minimal of risk of propagating transcription errors. Ensure that value entered satisfies the check-digit validation based on modulo 97. On save, system automatically validates the IBAN number length based on country code, characters, white spaces, and checksum. Validation is also done during posting non-monetary transaction (ACH Maintenance). You can maintain the IBAN length and other details required as per the country code in the user defined table (Setup > Administration > System > User Defined Tables). Note: IBAN for 'NL' country code (IBAN_FORMAT_NL) is defined by default with length of IBAN as 18. |
Start Dt |
Specify the payment mode start date, the date the current payment method was implemented (defaults on Pmt Mode change). you can also select from the adjoining calendar icon. |
Comment |
Specify a comment for this advance allocations. This is the default comment to include with payments to this Payee. |
The Check Details screen allows you to set up check details.
To setup the Check Details
A brief description of the fields is given below:
Field: |
Do this: |
Company |
Select the company from the drop-down list. |
Branch |
Select the branch from the drop-down list. |
Payee Type |
Select the payee type from the drop-down list. |
Check # |
Specify the check number (required). |
Printer Name |
Specify the printer name (required). |
Enabled |
Check this box to enable the check details entry. |
The Currencies link allows you to set up currency details.
Navigating to currencies
The Currency Definition screen allows you to set up currency details.
To set up the currency definition information
A brief description of the fields is given below:
Field: |
Do this: |
Currency |
Select the currency you want to define, from the drop-down list. |
Currency Name |
The system displays the currency name based on the currency selected. |
Country |
Select the country for which the currency is defined, from the drop-down list. |
Enabled |
Check this box to enable the currency entry. |
The Currency Pair Definition link allows you to set up currency pair details.
To set up the currency pair definition information:
A brief description of the fields is given below:
Field: |
View this: |
Currency Code |
Select the currency code from the drop-down list. |
Currency Pair Code |
Select the currency pair code from the drop-down list. |
Through Currency |
Check this box to set the selected currency as a through currency. |
Through Currency Code |
Select the through currency code from the drop-down list. |
Enabled |
Check this box to enable the currency pair entry. |
The Zip Codes screen allows you to set up zip code details.
To set up the zip codes information
A brief description of the fields is given below:
Field: |
View this: |
Country |
Select the country from the drop-down list. |
State |
Select the state from the drop-down list. |
Zip Code |
Specify the zip code (required). |
City |
Specify the city. |
County |
Specify the county. |
The Payment Hierarchy screen facilitates to define hierarchy definition along with payment appropriation, excess payment handling, account selection criteria and sort order. These details are required by the system to allocate payments to the matching accounts of a customer, when customer based payments are being processed in ‘Payment Entry’ screen.
Below is an illustration on how payment hierarchy is used to post customer based payments.
Any Payment transaction generated in the system either from UI / Web Service Call or through a Payment Batch (Generic Payment Upload) can be directly posted to an Account or at Customer level.
In such case, the Payment Hierarchy determines the sequence of payment as to which account is to be appropriated first and which is to be appropriate next. This is based on 'order by clause' and ‘appropriation sequence’ defined.
Also the Balance Type determines the distribution type as one of the following:
Once the account is narrowed down and payment amount is decided, then based on spread the payment is appropriated. This gives additional flexibility for defining payment modes at the master account level.
If Payment Hierarchy is not defined while funding an application or needs correction, the same can be done by posting ‘MASTER ACCOUNT PAYMENT HIERARCHY MAINTENANCE’ non-monetary transaction in Servicing > Maintenance > Transaction Batch Information section. At Customer level, Payment hierarchy can be updated by posting CUSTOMER MAINTENANCE transaction.
While creating Hierarchy definition in the Payment Hierarchy screen, you can use any of the following payment appropriation methods available in Hierarchy Type field. On selecting the specific Hierarchy definition at Application or Account level, the defined method is used to allocate payments to corresponding accounts.
However in all the methods, the payment criteria is also used for identifying the due accounts and careful consideration is required while defining the same.
Method |
Description |
EQUAL AMOUNT |
To allocate payment equally to all the accounts picked. This is traditional method of payment allocation in which the total payment amount received is divided and adjusted equally to all customer linked accounts. |
DUE AMOUNT RATIO |
To allocate payment based on the ratio of amount due on all accounts. In this method, the due accounts are identified based on the defined selection criteria and the payment appropriation is done on the ratio of amount due on each account using the below formula. ![]() Following is an illustration on payment allocation: ![]() |
OUTSTANDING BALANCE RATIO |
To allocate payment based on the ratio of total outstanding due on all accounts. Similar to above, even in this method the due accounts are identified based on the defined selection criteria and the payment appropriation is done on the ratio of outstanding amount due on each account using the below formula. ![]() This method can be selected if the received payment amount is equal to total outstanding due on all linked accounts indicated in Customer Service > Transaction History > Balances screen. |
ACCOUNT COLUMN BASED |
To allocate payment based on hierarchy order. In this method, the due accounts are identified based on the defined selection criteria and the payment appropriation is done as per the sequence of due accounts defined either in ascending/descending order. |
During payment appropriation, system allocates the payment amount only up to the total of resulted accounts and remaining amount (if any) are processed based on the excess payment method value.
While onboarding accounts through web services, system considers the value of system parameter PMT_HIERARCHY_CODE to default the payment allocation in Customer/Business Details screen after account activation.
Also while onboarding if the Payment Hierarchy is not passed as part of the request (Applicant/Application), then system parameter value is considered.
During or after payment appropriation, there can be a residual amount pending for allocation. For example, $0.01 remains when $100 is equally paid to 3 accounts. In such case the residual amount is transferred to last account in the hierarchy sequence. However, note that system performs this residual payment allocation only once.
In other case where there in an excess payment received which is more than account dues, the same can be processed for payment allocation using any of the following ‘Excess Handling Method’ while defining the Hierarchy Definition.
Method |
Description |
SUSPENSE |
To post the excess amount as suspense on Customer or Master account. |
HIERARCHY BASED |
To allocate the excess payment based on any of the Hierarchy Definitions maintained in the system. |
Based on the selection, system re-allocates the excess amount to corresponding accounts.
To set up payment hierarchy
A brief description of the fields is given below:
Field: |
View this: |
Name |
Specify an unique name for the hierarchy definition. |
Description |
Specify the description for the hierarchy definition. |
Hierarchy Type |
Select one of the following type of payment allocation method from the drop-down list. The list is populated based on the PMT_HIERARCHY_TYPE_CD lookup. - EQUAL AMOUNT - DUE AMOUNT RATIO - OUTSTANDING BALANCE RATIO - ACCOUNT COLUMN BASED For more information on the above methods, refer to ‘Payment Appropriation Methods’ section. You can define multiple Hierarchy definitions with same Hierarchy type. |
Excess Handling Method |
Select one of the following type of excess payment allocation method to be used with payment hierarchy definition from the drop-down list. The list is populated based on PMT_HIERARCHY_EXCESS_METHOD_CD lookup. - SUSPENSE - HIERARCHY BASED For more information on the above methods, refer to ‘Excess Payment Appropriation’ section. |
Excess Hierarchy Name |
This field is enabled and is mandatory if the Excess Handling Method is selected as ‘Hierarchy Based’. Select the Hierarchy Definition from the drop-down list. This list is populated with all the pre-defined and enabled hierarchy definitions maintained in the system. For more information on the above methods, refer to ‘Excess Payment Appropriation’ section. |
Enabled |
By default this check box is enabled for new hierarchy definition. |
Account Selection Criteria
This sub tab facilitates to define the account selection criteria that is used to identify due account for payment allocation. Atleast one valid account selection criteria is required for all the Hierarchy Types.
Field: |
Do this: |
Seq |
Specify sequence numbers. |
( |
Specify left bracket. |
Parameter |
Select the parameter from the drop-down list. The list is populated based on the values maintained in CUSTOMER PAYMENT HIERARCHY ORDER PARAMETERS user defined table. |
Comparison Operator |
Select comparison operator from the drop-down list. |
Criteria Value |
Specify criteria value. |
) |
Specify right bracket. |
Logical Expression |
Select logical operator from the drop-down list. |
Enabled |
Check this box to enable the selection criteria. |
Hierarchy Order
This sub tab facilitates you to define hierarchy order that is used to sort the due account for payment allocation. This sub tab is enabled only for ‘ACCOUNT COLUMN BASED’ Hierarchy type.
Field: |
Do this: |
Seq |
Specify sequence number. |
Sort Field |
Select sort field from the drop-down list. The list is populated based on values maintained in CUSTOMER PAYMENT HIERARCHY ORDER PARAMETERS user defined table. |
Order |
Select sort order as either Ascending or Descending from the drop-down list. |