Ovr Installation 1

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 28

weblogic123

Step 7: Configure user and Group


 Log on to WebLogic Administration Console,
 http://BATAOVR01:9702 ---admin console
 http://bataovr01:9702/em ---EM console

 Select “Security Realms -> Myrealm -> Users and Groups”


Select Groups and click New
o Create the following Groups:
 BIAuthors
 BIAdministrators
 BIConsumers
 Create EnterpriseOne User, Select Users tab and click New

User :JDECNC/jdecnc123

 Assign BI group to the user, Select the newly created EOne User, and select Groups tab
 Select BIAuthors group and move it over to Chosen column.
http://server:port/xmlpserver
http://bataovr01:9704/xmlpserver/

Boilerplates are template files that are used to create JD Edwards EnterpriseOne report layouts.
These templates are not mandatory to run One View Reports, but you are welcome to use them to
achieve a look and feel that is consistent with the delivered One View Reports.

You can also download them from update center:

1. Open the update center: https://updatecenter.oracle.com/apps/WebSearch/updatecenter.jsp?


2. In the search parameters, enter search type as "Enterprise One User Defined Objects"
3. Then download "OneView_Boilerplates JDE Boilerplates for OneView Reporting" from the same
search results.

Step 9: Upload EnterpriseOne Report Boilerplates


 Download and unzip the boilerplates zip file
 Log on to BI Publisher Server, http://server:port/xmlpserver
 Select Catalog > Shared Folders > Components > Boilerplates > Edit
Softcoding
P953000
P954000

<webservice>
<endpoint>http://bataovr01:9704</endpoint> ----BI Publisher Endpoint
<username>weblogic</username> ----User name used to import the templates
<password>weblogic123</password>
<properties>
<property><name>root catalog</name><value>JD Edwards</value></property> --default value
<property><name>bip version</name><value>12.2.5.9.0</value></property> ---BIP Version
<property><name>bip url</name><value>http://bataovr01:9704</value></property> --BIPURL
</properties>
</webservice>

JDE user Mapping :


P0092---search user --->
Known Issue:
E1: UDO: "Object Retrieval Failure" Error or "Export Failed" Error while attempting to
Approve Share Delivered UDOs (Doc ID 2091975.1)

SELECT * FROM DBA_TABLES where table_name like '%F98700R%';

SELECT * FROM PD920.F98700R where XMPATHCD='PY920';

SELECT * FROM PY920.F98700R where XMPATHCD='PY920';


SELECT * FROM PY920.F98700R where XMPATHCD='PY920';

create table PD920.F98700R_bkp as select * from PD920.F98700R;

SELECT * FROM PD920.F98700R where XMPATHCD='PY920';

update PD920.F98700R set XMPATHCD='PD920' where XMPATHCD='PY920';

We have uploaded the boiler templates with weblogic user that’s why we have user weblogic
instead of JDECNC user.
Always upload the templates using JDECNC(user create in BI publisher)

You might also like