Friday 20 May 2016

Oracle Fast Formula


As salamo alaikum wa rahmatullah


You can use Oracle FastFormula to:
  • Calculate your payrolls
  • Define the rules for PTO accrual plans
  • Define custom calculations for benefits administration
  • Define QuickPaint reports
  • Validate element inputs or user tables
  • Edit assignment sets
  • Calculate absence duration
  • Configure people management templates
  • Set up business rules and call them from other PL/SQL applications
  • Define your Oracle Business Intelligence Systems reports
  • Define collective agreements
  • Define custom global person number sequences
  • Define employment categories for EEO reports (US only)
  • Calculate ratings for individual competencies and objectives, and calculate a total score for an appraisal
----
MA ASALAAM
Passion 4 Oracle

Wednesday 18 May 2016

What is Profile Options?

AS SALAMO ALAIKUM WA RAHMATULLAH

A user profile is a set of changeable options that affect the way your application runs. The system administrator can set user profiles at different levels:

Site level     These settings apply to all users at an installation site.
Application level     These settings apply to all users of any responsibility associated with the application.
Responsibility level     These settings apply to all users currently signed on under the responsibility.
User level     These settings apply to an individual user, identified by their application username.
Important Profiles
1.1. HR: Business Group
1.2  HR: Security Option
1.3: HR: User Type (FOR accessing HRMS functions)
1.4  HR: Cross Business Group
2.1. GL: Set of Books(11i)
2.1  GL:%Ledger%  (R12)
2.3  GL: Data Access Set. This profile option to control the ledgers that can be used by Oracle General Ledger.
3.1. MO: Operating Unit
3.2. MO: Security Profile (R12)
3.3. MO: Default Operating Unit
4.1 Tax: Allow Override of Tax Code
4.2 Tax: Invoice Freight as Revenue
4.3 Tax: Inventory Item for Freight

5.1 Sequential Numbering
5.2 INV: Intercompany Currency Conversion
6.1 RCV: Processing Mode - Batch, Immediate, Online
6.2 QA: PO Inspection - Oracle Purchasing , Oracle Quality
7.1 Hide Diagnostics menu entry
8.1 OE: Item Flexfield
This profile option indicates the structure of the Item Flexfield (System Items) used by Order Entry. This structure should be the same across all applications in the same database.
This profile option is visible and updatable at the site level.
8.2 OE: Item Validation Organization
This profile option indicates the Oracle Manufacturing organization against which items are validated. You must define all items that can be included in your transactions in this organization.
Set the OE: Item Validation Organization profile at the site level for the inventory organization whose master item number you want to use. This profile option indicates the organization that Receivables uses to validate items.
This profile option is visible and updatable at the site level. 
Values set at a higher level cascade as defaults to the lower levels. Values set at a lower level override any default from a higher level. For profile options that need to differ at the operating unit level, including OE: Item Validation Organization, OE: Set of Books, and GL: Set of Books, you must set the values at the responsibility level. Oracle General Ledger windows use the GL Set of Books profile option to determine your current set of books. If you have different sets of books for your operating units, you should set the GL Set of Books profile option for each responsibility that includes Oracle General Ledger windows.
For profile options that need to differ at the set of books level, including Sequential Numbering, set the values at the responsibility level.
Profile options specify default values that affect system processes, system controls, and data entry. In a multiple organization
environment you may want to confine the effect to a specific operating unit. Therefore, you may want to change your profile options to be visible and updatable at the responsibility level.
1. MO: Operating Unit = {the users Operating Unit name}
     This points the responsibility to the appropriate Operating Unit. 
This the profile which holds the value of operating unit org_id when ever user login into system his org_id is  value is transfered to profile value base on this profile  we get data and put data from databaseUsed primarily in a multiorg environment. 
     Set the site level to the desired default operating  unit. 
     If there is more than 1 Operating Unit Defined, this profile option must be set at the responsibility level for each responsibility.


2. OE: Set of Books and GL: Set of Books
Each Responsibility is identified with a set of books using the profile option GL : Set of Books Name, a responsibility can only see the accounting information for that set of books in orcale GL.
3. HR: Business Group 
Business Group that is linked to the security profile for a responsibility. This option is used online to control access to records that are not related to organization, position, or payroll.
This option is seeded at Site level with the start-up Business Group. It is view only. Values are derived from the HR:Security Profile user profile option.

HR:Security Profile     Restricts access to the organizations, positions, and payrolls defined in the security profile. This option is seeded at Site level with the view-all security profile created for the Startup Business Group.  The business group you define appears in the list of values when you set up the HR: Security Profile profile option.
Security Groups
Security groups are a method of partitioning data. When you use the standard HRMS security model, you do not use security groups. The business group is the only data partition. Responsibilities are linked to business groups. Therefore, to access different business groups, users must change responsibilities.
If you want one responsibility to be enabled for more that one business group, you must use Cross Business Group responsibility security. In this model, security groups are defined to partition data within a business group. Multiple security groups can then be linked to one responsibility, even if they partition different business groups. To use security groups you must set the user profile option Enable Security Groups to Yes and run the Multiple Security Groups process.
HR: Cross Business Group
In the Oracle HRMS model, the business group is at the country level and a top organization encompasses all business groups in a company worldwide. People, projects, jobs, and organizations can be located in different business groups for different countries and all information can be shared throughout the enterprise.
Oracle Projects allows the visibility of all business groups to one another. For example, you can search staff resources on projects across business groups, and charge any project across the enterprise for a resource.
You control access to single or multiple business groups by setting the profile option HR: Cross Business Group:
• Set the profile option to Yes to allow cross business group access.
• Set the profile option to No to allow only single business group access.


--
MA ASALAAM
PASSION 4 ORACLE

Tuesday 17 May 2016

Just for Practice

As salamo alaikum wa rahmatullah

TITAN

USA_BG INDIA_BG UK_BG

USA_LED INDIA_LED UK_LED

SW_LE MT_LE FIN_LE

CAR_OU TRUCKS_OU BIKES_OU

INV_ORG



========================================
HRMS RESPONSIBILITY IS USED TO CREATE THE BUSINESS GROUP.

SEEDED HRMS RESPONSIBILITY IS HUMAN RESOURCES VISION ENTERPRISE
MENU - US SHRMS NAVIGATOR
DATA GROUP  - STANDARD APPLICATION - HUMAN RESOURCE
REQUEST GROUP - US SHRMS REPORTS AND PROCESSES
======================================



LEDGER
======
>CURRENCY
>CALENDAR (NORMAL CALENDAR JAN - DEC - FISCAL CALENDAR MAR-APR)
>CHART OF ACCOUNTS
>SUB LEDGER ACCOUNTING


CHART OF ACCOUNT (FORM ACCOUNT IN CHART - IT IS NOT ONLY THE BANK ACCOUNT WHILE IT IS ACCOUNT OF CHART)


STANDARD JOURNAL FORM
======================

COMPANY(TITAN)
-------------------------
COMPANY LEVEL TRANSACTION
----------------------------
SNO DESC CR_AMOUNT (COMING) DR_AMOUNT (GOING)
==== ===== ================== =================
01 COMPANY.CASH ------- 10,0000
02 COMPANY.RENT 10,000 -----
============= ============

10,0000 10,00000
DIVISIONS (CAR DIV/TRUCKS DIV/BIKE DIV)

DIVISION LEVERL TRANSACTION
---------------------------------
SNO DESC CR_AMOUNT (COMING) DR_AMOUNT (GOING)
==== ===== ================== =================
01 COMPANY.CASH ------- 10,0000
02 COMPANY.CARS.RENT 10,000 -----
============= ============
10,0000 10,00000

DEPARTMENTS (PO/AP/INV)
DEPARTMENT LEVERL TRANSACTION
--------------------------------
SNO DESC CR_AMOUNT (COMING) DR_AMOUNT (GOING)
==== ===== ================== =================
01 COMPANY.CASH ------- 10,0000
02 COMPANY.CARS.PO.RENT 10,000 -----
============= ============
10,0000 10,00000

LOCATIONS (HYDR/BUNG/DLH/CHN/PUNE)
LOCATION LEVERL TRANSACTION
-------------------------------------
SNO DESC CR_AMOUNT (COMING) DR_AMOUNT (GOING)
==== ===== ================== =================
01 COMPANY.CASH ------- 10,0000
02 COMPANY.CARS.PO.HYD.RENT 10,000 -----
============= ============
10,0000 10,00000
FOR THIS CHART OF ACCOUNT WE NEED 5 SEGMENT TO MAINTAIN OUR COMPANY CHART OF ACCOUNT BUT ORACLE CO OPERATION PEROVIDE 30 SEGMENT TO MAIN TAIN THE SECURTIY OF YOUR COMPANY.
IF YOUR TRANSACTION IS WORLD WIDE LEVERL IT IS MORE THAN ENOUGH TO HAVE 7 SEGMENT.

THERE ARE TWO TYPE OF FLEX FIELD AVAILABLE IN ORACLE APPLICATION
--------------------------------
1. KEY FLEX FIELD - 39 FLEX FIELD PROVIDES ORACLE
2. DESCRIPTIVE FLEX FIELD

=================================================================================
INVENTORY 
=========
CREATE INVENTORY RESPONSIBILITY (Seeded responsibility - Inventory, Vision Operations (USA))
===============================

Application - Inventory
Data Group - Name - Standard Application - Inventory
Menu - INV_NAVIGATE
Request Group -  All Inclusive GUI - Application Inventory


-----------------------------------------------------------



--
MA ASALAAM
Passion 4 Oracle

General Ledger Table with Navigation Steps

As salamo alaikum wa rahmatullah


-- RESPONSIBILITY TABLE

SELECT * FND_RESPONSIBILITY

-- LOCATIONS TABLE
NAV>WORKSTRUCTURE>LOCATION

SELECT * FROM HR_LOCATIONS_ALL WHERE LOCATION_CODE LIKE 'TITAN%'


-- BUSINESS GROUP
NAV>WORKSTUCTURE>ORGANIZATION>DESCRIPTION

SELECT * FROM HR_ALL_ORGANIZATION_UNITS WHERE  NAME LIKE '%_BG%'

--LEDGER
--========
-- CURRENCY
NAV>SETUP>CURRENCIES>DEFINE

SELECT * FROM FND_CURRENCIES_TL WHERE NAME LIKE 'India%'

-- CALENDAR TYPE
NAV>SETUP>FINANCIAL>CALENDARS>TYPES

SELECT * FROM GL_PERIOD_TYPES WHERE USER_PERIOD_TYPE LIKE 'TITAN%'

-- CALENDAR MONTHS (PERIOD)
-------------------
NAV>SETUP>FINANCIAL>CALENDARS>ACCOUNTING

SELECT * FROM GL_PERIOD_SETS WHERE PERIOD_SET_NAME LIKE 'TITAN%'

SELECT * FROM GL_PERIODS WHERE PERIOD_SET_NAME LIKE 'TITAN%'


-- CHART OF ACCOUNT
--- FLEX FIELD - TWO TYPES OF FLEX FIELD KEY FLEX FIELD AND DESCRIPTIVE FLEX FILED
NAV>SETUP>FINANCIAL>FLEXFIELDS>KEY>SEGMENTS

SELECT * FROM FND_ID_FLEX_STRUCTURES_VL 

SELECT * FROM FND_ID_FLEXS

-- SEGMENTS STRUCTURE STORED
------------------------------
SELECT * FROM FND_ID_FLEX_STRUCTURES_TL WHERE ID_FLEX_STRUCTURE_NAME LIKE 'TITAN%'

SELECT * FROM FND_ID_FLEX_SEGMENTS WHERE ID_FLEX_NUM='53542'

--VALUE SET  TABLEN

SELECT * FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_NAME LIKE 'TITAN%'

--VALUE SET VALUE
-----------------
NAV>SETUP>FINANCIAL>FLEXFIELDS>KEY>VALUES

Select * from FND_FLEX_VALUES

-- ACCOUNTING SETUP MANAGER LEDGER
--LEDGER
==
NVA>SETUP>FINANCIALS>FINANCIAL ACCOUNTING SETUP MANAGER>ACCOUNTING SETUPS

LEGAL ENTITY INFO
----

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'TITAN%'

SELECT * FROM GL_LEDGERS WHERE NAME LIKE 'TITAN%'

OPERATING UNIT 
----------------

SELECT * FROM HR_ALL_ORGANIZATION_UNITS
WHERE NAME LIKE 'TITAN%'

ONLY OPERATING UNIT
--------------------

SELECT * FROM HR_OPERATING_UNITS 
WHERE NAME LIKE'TITAN%'

INVENTORY ORGANIZATION
=====================
NAV>SETUP>ORGANIZATIONS>ORGANIZATION

SELECT * FROM HR_ALL_ORGANIZATION_UNITS
WHERE NAME LIKE 'TITAN%' 

ONY INVENTORY ORGANIZATION
========================
SELECT * FROM 

SELECT * FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_NAME LIKE 'TITAN%' 


--
MA ASALAAM
Passion 4 Oracle

Monday 16 May 2016

FIND THE TABLE WHICH HAS ROW LOCK (UPDATE/INSERT)

AS SALAMO ALAIKUM WA RAHMATULLAH

The follwoing Query publish Table name which has Row Lock due to not commit the transaction.

select
  object_name(resource_associated_entity_id) as 'TableName' ,*
from
  sys.dm_tran_locks
where resource_type = 'OBJECT'
  and resource_database_id = DB_ID()

MA ASALAAM
--
Passion 4 Oracle

Tuesday 3 May 2016

How many types replication in SQL Server

As Salamo Alaikum Wa Rahmatullah

There are three types of Replication in SQL Server 2012/2014.

1.Snapshot Replication
2. Transaction Replication
3. Merge Replication

--
Ma Asalaam
Passion 4 Oracle