Xref not built for bsfn's in demo 9.1

samantha_sana

Well Known Member
Hi all,
I have built xref file in demo but the bsfn details are not populated.
xref is built for all objects and for f9860.obnm="bsfnid" and the status on the pdf is "1"
I searched few threads but not helpful.
please help...

Thanks
demo 9.1
 

samantha_sana

Well Known Member
Hi all,
when xref is built its successful(pdf shows success) for all objects but only the bsfn details are not populated ...all other objects are searchable using xref....
any thoughts ?
 

rahul1279

Member
Building XREF Data for E1 Stand-Alone Clients

[FONT=&quot]Summary[/FONT]
[FONT=&quot]One of the frustrating items about running a stand-alone E1 client is that the cross reference build utility (R980011) doesn't seem to work out of the box. However, this is relatively easily remedied. [/FONT]
[FONT=&quot]Preparing the Data[/FONT]
[FONT=&quot]After installing your E1 stand-alone instance, you will notice a number of schemata/owners in the database, e.g., JDEData910, JDECTL910, JDEOL910. One of these will likely be SPEC_MASTER with a number of tables suffixed with "MASTER." When the XREF build process takes place, it looks at the JDEVL910 schema, but most of the tables in that schema are not populated. (See chart below.)[/FONT]
[FONT=&quot]
C:\Users\ADMIN\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg
[/FONT][FONT=&quot][/FONT]
[FONT=&quot]We can see that a number of tables that are the same between the two schemata/owners (with the exception of the "MASTER" suffix) have different counts. [/FONT]
[FONT=&quot]We need to copy the records from the SPEC_MASTER tables into the JDEVL910 tables.[/FONT]
[FONT=&quot]SQL Statements[/FONT]
[FONT=&quot]Note: Depending on your chosen RDBMS, you may need to adjust the schema/owner names slightly.[/FONT]
[FONT=&quot]INSERT INTO jdevl910.F98710
SELECT * FROM SPEC_MASTER.F98710MASTER;

INSERT INTO jdevl910.F98711
SELECT * FROM SPEC_MASTER.F98711MASTER;

INSERT INTO jdevl910.F98712
SELECT * FROM SPEC_MASTER.F98712MASTER;

INSERT INTO jdevl910.F98713
SELECT * FROM SPEC_MASTER.F98713MASTER;

INSERT INTO jdevl910.F98720
SELECT * FROM SPEC_MASTER.F98720MASTER;

INSERT INTO jdevl910.F98740
SELECT * FROM SPEC_MASTER.F98740MASTER;

INSERT INTO jdevl910.F98741
SELECT * FROM SPEC_MASTER.F98741MASTER;

INSERT INTO jdevl910.F98743
SELECT * FROM SPEC_MASTER.F98743MASTER;

INSERT INTO jdevl910.F98745
SELECT * FROM SPEC_MASTER.F98745MASTER;

INSERT INTO jdevl910.F98750
SELECT * FROM SPEC_MASTER.F98750MASTER;

INSERT INTO jdevl910.F98751
SELECT * FROM SPEC_MASTER.F98751MASTER;

INSERT INTO jdevl910.F98752
SELECT * FROM SPEC_MASTER.F98752MASTER;

INSERT INTO jdevl910.F98753
SELECT * FROM SPEC_MASTER.F98753MASTER;

INSERT INTO jdevl910.F98760
SELECT * FROM SPEC_MASTER.F98760MASTER;

INSERT INTO jdevl910.F98761
SELECT * FROM SPEC_MASTER.F98761MASTER;

INSERT INTO jdevl910.F98762
SELECT * FROM SPEC_MASTER.F98762MASTER;

INSERT INTO jdevl910.F98770
SELECT * FROM SPEC_MASTER.F98770MASTER;[/FONT]
[FONT=&quot]Running the XREF Build[/FONT]
[FONT=&quot]Now that the data has been copied into the appropriate tables, we can now run the XREF build (R980011). [/FONT]

  1. [FONT=&quot]Because all versions of R980011 have security against them, create a new version based on the type of build you wish to run, e.g., all objects, UBE only, APPL only, etc.[/FONT]
  2. [FONT=&quot]Run the UBE locally (this is a redundant instruction on stand-alone clients, but R980011 only runs locally on client-server based configurations.[/FONT]
  3. [FONT=&quot]Choose the appropriate spec source in the processing options. This is typically "DEMO" for stand-alone instances.[/FONT]
[FONT=&quot]Conclusion[/FONT]
[FONT=&quot]Once the XREF build is done, you will have a setup where you can review the interconnectivity between the various reports, applications, data items, etc.[/FONT]
[FONT=&quot]While the build utility may take some time to run, e.g., 10+ hours, you can monitor the status by reviewing the record counts from F980011 and F980021. One important note is that if you are rebuilding the XREF table you may see the record counts increase and decrease as the UBE will delete records before recreating them.[/FONT]
 
Top