Profile cover photo
Profile photo
Passion 4 Oracle
42 followers -
With out passion you dont have energy, with out energy you have nothing
With out passion you dont have energy, with out energy you have nothing

42 followers
About
Passion's posts

Post has attachment
Multi Organization in Oracle Apps R12
As salamo alaikum wa rahmatullah What is Multi-Org? It’s a feature used to store the data of multiple organization in a single instance by partitioning the data of human resource, financials, sales, purchases, assets and materials Examples of Multi Org are ...

Post has attachment
R12 - Explanation about the Segment Value
As salamo alaikum wa rahmatullah For All segment - Allow Budgeting and Allow Posting will default to NO fro parent accounts, or YES for posting accounts. These can be changed to meet your company's needs with one Emitted restriction:Parent accounts should n...

Post has attachment
R12 Accounting Flex Field
As salamo alaikum wa rahmatullah Segment Label : Identifies certain segments in your chart of accounts and assigns special functionality to those segments. The required segment labels are: Balancing Segment : Ensures that all journals balance for each balan...

Post has attachment
Primary Ledger Vs Secondary Ledger Vs Reporting Currency
As salamo alaikum wa rahmatullah Primary Ledger Vs Secondary Ledger Use secondary ledgers for supplementary purposes, such as consolidation, statutory reporting, or adjustments for one or more legal entities within the same accounting setup. For example, us...

Post has attachment
What is the cause of high transaction log file in SQL SERVER
As Salamo Alaikum wa Rahmatullah You probably either have a long running transaction running (Index maintenance? Big batch delete or update?) or you are in the "default" (more below on what is meant by default) recovery mode of  Full and have not taken a  l...

Post has attachment

Post has attachment
BE AWARE FOLLOWING THING WHILE WRITING SQL QUERY
AS SALAMO ALAIKUM WA RAHMATULLAH Queries Writing efficient
queries in SQL Server is more an exercise in writing elegant relational queries
than in knowing specific tricks and syntax tips. Generally, a well-written,
relationally correct query written against...

Post has attachment
FULLBACK DIFFERENTIAL BACKUP AND TRANSACTION LOG BACKUP WITH EXAMPLE
AS SALAMO ALAIKUM WA RAHMATULLAH USE  AdventureWorks2012 Go Begin Declare @Filename Varchar(200); Declare @FullPath Varchar(300); Declare @FinalPath Varchar(300); Set @FullPath='D:\ DB_Backup_Daily\DifferentialBackup\'; Set @Filename=' AdventureWorks2012_'+...

Post has attachment
DBCC COMMAND WITH EXAMPLE
AS SALAMO ALAIKUM WA RAHMATULLAH SQL Server – DBCC Commands DBCC (Database consistency checker) are used to check the consistency of the databases. The DBCC commands are most useful for performance and trouble shooting exercises. I have listed down and expl...

Post has attachment
WHAT IS DMF AND DMV IN SQL SERVER?
AS SALAMO ALAIKUM WA RAHMATULLAH Intro There were many new DMVs added in SQL Server 2012, and some that
have changed since SQL Server 2008 R2. This is a brief overview of the biggest
changes and what they mean to you. Introduction Dynamic management views (...
Wait while more posts are being loaded