BOFC equalize system

[Olj]

Hi

I have some problem.

I need to equalize quality system(BOFC10) with productive like we do client(mandant SCC9) copy in ERP systems.

How can I do this with SAP BOFC10???

Can I to restore prd database and connect to quality? Or is there another solition?

[siwar_taleb · Accepted solution]

Hello,

You can find below the steps to duplicate the environment:

1-Create a backup of the database "PROD" (create a dump file);

2- Restore this backup by giving it a new name ("TEST" for example);

3- In order to avoid potential problems if you need in the future transferring data between the two databases having the same site name(see KBA1673334), you have to rename the site of the new

database "TEST" from '0000.PROD' to '0000.TEST' (for example) using an appropriate script.

4- Create a new datasource (via the Administration Console);

5- Configure the datasource pointing the database created.

Hope these would be helpful for you,

Regards,

Siwar

[Olj · Accepted solution]

Thank you Siwar,

I open KBA1673334 and there says:

Resolution

Change the site name of the TEST database.

See Also

1422884 - BOFC: How to change the site initialization of a database

Then I go to note 1422884 but that note doesn't released. What can I do?

Can you give me step-by-step how to change site name in TEST database?

[siwar_taleb · Accepted solution]

Hi,

please find bellow the steps:

1. Stop the datasource in the CtAdmin
2. Back up the ct_config, ct_identifier_pool and ct_recycled_identifier tables
   • SQL server:
     select * into ct_config_save from ct_config
     select * into
     ct_identifier_pool_save from ct_identifier_pool
     select * into
     ct_recycled_identifier_save from ct_recycled_identifier
   • Oracle:
     create table ct_config_save as select * from ct_config;
     create
     table ct_identifier_pool_save as select * from ct_identifier_pool;
     create
     table ct_recycled_identifier_save as select * from
     ct_recycled_identifier;
3. Run the script attached  (one for SQL Server and one for Oracle).
   Before
   running the script, it is necessary to enter the code of the site you want to
   initialize the database with, on line 9 of the script SQL version and line 8 of
   the oracle version :
   SET @strName = 'XXXXXXX' (SQL)
   strName varchar2(17)
   := 'XXXXXX' (ORACLE)
4. Restart the datasource in the CtAdmin. The restart may take some time as the
   ct_identifier_pool and ct_recycled_identifier tables will be rebuilt.

could you please indicate what's you database type tpo provide you with the script,

Siwar

[Olj · Accepted solution]

Thank you very much!

I need script for Oracle DB, but in future we will use SQL server too. Can you give me both scripts?

I very gratefull to you!

[siwar_taleb · Accepted solution]

Hello,

Please find attached in the link bellow the scripts:

https://share.sap.com/a:zy0um7/MyAttachments/afef136d-475d-4004-8773-a1537dae68bc/

Regards,

Siwar

[Olj · Accepted solution]

Thank you very much!!!

[Olj · Accepted solution]

Hi Siwar,

can you help me? With quality system all understand.

What about equalize dev system  from prod? Is that possible?

(our customer import entity directly to prod system during year, now we enter entities in dev, but now we afraid to transport, because the same entities have different id's)

[siwar_taleb]

Dear Daulet,

In this context, i would add that among the best practises on FC databases organization :

A developpement and a test database should be provided as well as a production database

Advantages:

• Secure the operating process
• Avoid test data and test objects in the prodcution database
• Enable a configuration enhancement schedule not linked to finatial reporting schedule

This database organization requires configuration transfer from the development database to the production databse:

Regards,

Siwar

[Olj]

Hello Siwar, thank you for all,

where can I read help about FC database oraganization and transport?

[siwar_taleb]

Hello Daulet,

Sorry, i have just seen now your question.

You can find some useful information about FC in the following SAP note:

Documentation :1552675- Available Documentation for SBOP Financial Consolidation

You can access to the following link and select “Financial Consolidation” as product: http://help.sap.com/boall_en/

This link contains all the documentation regarding Financial consolidation.

Regards,

Siwar