Recover Suspect SQL Server 2005 Database

If database is in suspect mode , follow below steps only and get relief with in 10 minitus.

EXEC sp_resetstatus 'DB_Name';

ALTER DATABASE DB_Name SET EMERGENCY

DBCC checkdb('DB_Name')

ALTER DATABASE DB_Name SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('DB_Name', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE DB_Name SET MULTI_USER



if database properties are locked due to permissions  with following screen

use DB_Name exec sp_changedbowner 'User_name'

ORA-20001: An active sequence assignment is required when JV not posted in Gl

Try to disable the accounting sequence required check box,

GL > Accounting Set Up Manager > Sequencing (Update)

Uncheck the option for "Require Assignment.

Then post and let us know if still any issue. thanks

NO Legal Entity (List of Value in) the Bank Account Owner Field in Cash Management for Open Bank

• Logon to Sysadmin and assign a Responsibility User management

• Switch Responsibility User management

Open Role and Role Inheritance tab And  Create Role

Enter Required ( * ) information the Press Save and  Apply

agaim open Role and Role Inheritance tab and search in Type ,Category,Name and Application name (Cash Management) and Press Go

Press Update

Press Security Wizards Button

Press Run Wizard of CE UMX Security Wizard in First line

Press Add Legal Entity Button

Search your Legal Entity You defined Already In GL then Select

Then select Check Box of Use, Bank Account Grants maintance and Bank Account Transfer and then Apply

Then  Select User Tab

Select User Name Which Required Authority To Create Bank Account Holder and Role Defined Above

Press update

Press Assign Roles Button

Search Your Role and Select Check Box and Press Select  Button

Press Apply Button

If SuccessFul Created You Will geta Success Message

logon To Your user and Open Cash Management Responsibility and Open Bank Account Form

Press Create button

Press Continue Button 

select bank Account Owner and Search your Legal Entity Defined In GL

 Legal Entity  defined in GL Will  Now  in List  Press Select Button and Continue

Remembers Me in Urs Prayers.

Regard

Mahr Haider Iqbal
Functional & Technical Consultant
Pakistan
+92-333-5492472
+92-313-5492472
mahrhaideriqbal@hotmail.com

Territory List Of Value In Accounting Setup Manager (General Ledger) is Empty

Territory List Of Value In Accounting Setup Manager (General Ledger) is Empty

Add a Responsibility  Legal Entity Administrator to Your User and Switch to That Responsibility
and Open Define Lookup

Enter a line in this type as requirement
Search  XLE_REG_CODE  in Type and Enter a line in Detail

Search Again  In Type XLE_REG_CODE_EST and Enter A line in Detail

 Save a Record and Go Back At Main Menu Of Legal Entity Administrator

and Open Jurisdictions

Select a Value Fedral Tax From List As Below ad press Go

 Enter Value as Below

That The Complete Procedure .Go to Back To Accounting Setup Manager in GL and Create Legal Entity,Now TerritoryWill Show Yours Country Pakistan

Remembers Me in Urs Prayers.

Regard

Mahr Haider Iqbal

Functional & Technical Consultant

Pakistan

+92-333-5492472