Posts

Showing posts from August, 2021

API for Reports & UCM

 SOAP UI https://fusovmsmc84-fa-ext.us.oracle.com/xmlpserver/services/v2/ReportService?wsdl runReport Remove all other attributes apart from paramname & values, format, <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">    <soapenv:Header/>    <soapenv:Body>       <v2:runReport>          <v2:reportRequest>                <v2:attributeFormat>pdf</v2:attributeFormat>             <v2:parameterNameValues>                <v2:listOfParamNameValues>                   <!--Zero or more repetitions:-->                   <v2:item>                      <v2:name>?</v2:name>                      <v2:values>                         <!--Zero or more repetitions:-->                         <v2:item>?</v2:item>                      </v2:values>                   </v2:item>                </

Security

 Securing ESS Jobs When a custom ESS job is created a Function Privilege with same name will be created implicitly Create a Custom JOB role and add the new custom ess privilege that is created Add the custom job role to USER Submit Retrieve Latest LDAP Changes job  BIP Security Analytics -> Browse Catalog BIP Template -> More -> Permissions -> add -> Add user Following user will have following permissions. To modify More -> Permissions and change BI Administrator BI Author BI Consumer System Administrator(User)   ---- select /*3-25921486741*/ Distinct bu_id, bu.BU_NAME, u.username, role.ROLE_NAME, role.START_DATE_ACTIVE, role.END_DATE_ACTIVE, role.ACTIVE_FLAG from fusion.hz_parties h, fusion.per_users u, fusion.per_all_people_f f, fusion.FUN_ALL_BUSINESS_UNITS_V bu, fusion.FUN_USER_ROLE_DATA_ASGNMNTS role where 1=1 and h.user_guid = u.user_guid and u.person_id = f.person_id and sysdate between f.effective_start_date and f.effective_end