PeopleSoft XML File Layout

  1. Create the record to insert data into (for example MY_FILETEST)

     

     

  2. Create file layout by dragging the test record on to the file layout

     

  3. Create XML file to use

 

<?xml version=”1.0″?>

<MY_FILETEST>

    <MYNUMBER>100</MYNUMBER>

    <MY_FACT_BEL>200</MY_FACT_BEL>

</MY_FILETEST>

<MY_FILETEST>

    <MYNUMBER>200</MYNUMBER>

    <MY_FACT_BEL>200</MY_FACT_BEL>

</MY_FILETEST>

<MY_FILETEST>

    <MYNUMBER>300</MYNUMBER>

    <MY_FACT_BEL>200</MY_FACT_BEL>

</MY_FILETEST>

 

 

  1. Save the file in the following folder if running the import from application server if running from the process scheduler save it in the prcs\files folder

    D:\Apps\PT849\appserv\EPM9DMO\files


 

 

  1. Use the following code to import the data into the record

 

Local File &FILE;

Local Record &REC;

Local Rowset &FRS;

 

&FILE = GetFile(“MyFileXML.xml”, “R”);

&REC = CreateRecord(Record.MY_FILETEST);

&SQL = CreateSQL(“%Insert(:1)”);

 

If Not &FILE.IsOpen Then

Error (“TEST: failed file open”);

Else

If Not &FILE.SetFileLayout(FileLayout.MY_FILETEST_XML) Then

Error (“TEST: failed SetFilelayout”);

Else

&FRS = &FILE.ReadRowset();

While &FRS <> Null

&FRS.GetRow(1).MY_FILETEST.CopyFieldsTo(&REC);

&SQL.execute(&REC);

&FRS = &FILE.ReadRowset();

End-While;

End-If;

&FILE.Close();

End-If;

 

  1. Call the code from the page

 

  1. Test if data is inserted


OBIEE Changing Administrator Password

  1. Shutdown OAS and OBIEE services.

Change the password in the BI server repository offline.


 3.Run crypto tools for both Publisher and BI Scheduler.
cryptotools credstore -add -infile D:\OracleBIData\web\config\credentialstore.xml
BIPublisher Alias : bipublisheradmin
     BIScheduler Alias : admin

 

4.Change password in Scheduler Config in job manager

 

5.Start OAS server and OBIEE services and update the JDBC connections for BI Server Answers


 

6.Update security configuration for the BI server security model with the new password.

 

 7.Restart all the servers again. If second restart is not done then BIPublisher reports based on answers will not work.