Resolved! Enhacned Query for convert Customquery to EQ
Hi,please can you provide EQ query for below sql update queryupdate arstasks a set a.STATUS = 3,a.provisioningcomments ='No Action Required' where a.taskkey in (1231,1241,1243,1244)
Forum Posts
Application Connector Invalid access token provided
We have configured the REST connector for the Coconut application and configured a security system, an endpoint, and an application data import job to import accounts from the application.We used the following JSON:connection Json:{ "authenticatio...
Resolved! Job Log Details insdie violation data results
Hi Team,I want details of RunAllAnalyticsJob job log inside violation data , what was it got picked accounts and users , if any possibility to get those data.Analytics report histroy we can see but i want which users got picked these job:Reference ch...
Analytics email to managers about their subordinates
Hello,We are getting error when we try to send emails to managers about their subordinates through analyticsbelow query iam usingSELECTmgr.username AS username,mgr.firstname as 'ManagerFirstName',mgr.email AS ManagerEmail,usr.username AS UserUsername...
This job for was suspended as there is already an import running for the same security system
All,Good afternoon. We start getting these failed tasks errors from an Accounts Import Job from a SQL Server.Currently we are doing a full account import, and sometimes we see this error. The only information we are getting is the follow:Any ideas w...
Resolved! enhance query help
The query is:UPDATE entitlement_values evSET ev.customproperty1 = 3381WHERE ev.entitlement_value LIKE '%33XX%' and ev.endpoint = 3;Can someone please convert this into an enhance query.I got stuck at the WHERE logic for "and ev.endpoint = 3"
Resolved! Trigger Chain Job doesn't work
Hello communityI made trigger chain job which should trigger three jobs in sequence one by one.The first job is a type of FileTransferJob, second job is a type of File based Entitlement Import (SchemaEntitlementJob) and third job is a type of File ba...
Entitlements not showing under Entitlements Hierarchy after schema upload
Hello Everyone, I am trying to upload accounts and their entitlements using file based schema approach, the job is running successfully and the entitlement type is created in the Entitlements Hierarchy of the accounts as well but when I am clicking o...
Resolved! Creating a Job Trigger via API
Hello World,So I was trying to create a newly fresh Job trigger in "Job Control Panel" and running it through Saviynt API,But the API is not creating a Job "properly", by properly I meant,Through API it is creating a Job but it is not able to fetch "...
How to send csv file instead of zip using SFTP Connector
We have configured SFTP connector to transfer file from analytics generated to customer SFTP location.We see SFTP connector sending zip formated file to SFTP location from Saviynt analytics location after job execution successfully.But customer is ex...
Display Old Value Of a CP in Email Template
Hi,We have a requirement, that whenever the Plant (cp20) of a user is updated, the manager of the user should be notified.Hence, via user update rules we can Notify as an email, the new value of cp20 in the email template. Is there a way by which we ...
Workday : Import issue with conversion
we are trying to pull the user from Workday which was recently converted from Contractor to employee. during the conversion, contractor record was terminated and employee record is generated. When we run a single user import putting a filter to impor...
EOFException while resuming the jobs from paused state
Hi,I am getting the below exception while trying to resume the jobs from paused state. Because of this issue it is not able to run the jobs as per schedule.Even after clicking the resume button all the jobs are marked as paused in the databaseIf anyo...
ADSI FULL Access Recon job is taking 20 hours and still giving error message
We are running ADSI FULL Access Recon job every weekend. The job is taking 20 hours or more everytime. The issue is that job either fails or does not give an end time, suggesting that the job did not complete successfully.Is there any way to reduce t...
Enhanced Query: entitlement_owners table
I'm trying to insert a single row into the table entitlement_owners using the Enhanced Query.Configuration: Query used:select '7318' ENTITLEMENT_OWNERS__USERKEY, '135229' ENTITLEMENT_OWNERS__ENTITLEMENT_VALUEKEY, '1' ENTITLEMENT_OWNERS__RANK from ent...
Resolved! Dashboard data refresh and Dashboard refresh job
Hello all,So we have a few Dashboards scheduled in our project which are report based and runs once a day, that's when the data is being refreshed. All the Dashboards are ES tile based. Now we have a requirement to update the data more frequently so ...
Resolved! To monitor Saviynt Connection
Hi All,I have a query reg Connection failure & notification - how to trigger email notification when connection got failed in Saviynt.Test connection only updated Status of the connection so we will be notified for connection failure.
Resolved! Download the xml file from User Import DB job
Hi Team,Hi Team, we have a User Import DB job, Recently, we are having some issues, ,so I want to see the code of the xml file.Could you please help me to know, how I can download the below XML file.
Resolved! Query Current Job Name
Hi All!We would like to start a user import from 2 different jobs: one for full import, one for incremental.The REST API connecting our HR system allows ur to query all users, or all users that have been modified since a certain date.To be able to do...
Custom query into Enhanced Query
I'm trying to change the format of a deprecated custom query, which is quiet important for us, into the format of an enhanced query. Can someone please help at the following query?Both Update statements were in one query, is it possible to have them ...
Apps Onboarding- Performance analysis
Hi TeamWe have the requirement from client to onboard 2000+ apps. We want to understand how should we add the applications in prod so that there is no impact on performance.Currently client is having 300 applications in production. Can you please sha...
SAP incremental jobs are failing
We have SAP incremental job with following import tables - USR04,AGR_USERS,AGR_TIME,AGR_AGRS,AGR_TEXTSThe job keeps on failing with this error 'Failed to import one or more object types. Checkthe Job Log Details page for more information.'Attached wi...
AnalyticsV2 Job with Analytics application
Hi,i’ve created an analytics report with default action “Disable Account”.When I run the AnalyticsV2 Job with this defAult action option Checked, it generates the “Disable Account” Tasks -> Normal behaviorWhen I select a security system in Analytics ...
Resolved! Email Generation Rule not triggering on new user import
I am setting up an Email Generation Rule and and I have it setup as yes to generate on our import job. However I noticed for brand new users emails are not being generated. I verified that the rule I created works but doesn't seem like its getting tr...
Oracle Fusion Security Context
I've found previous posts on this topic, but I've not seen an answer.For some Job Roles in Oracle Fusion, we also require a Security Context to control data access. So, for example, you might have the "Buyer" role but only for a specific Business Uni...
Two call in ImportAccountEntJSON Rest connector
Hi Team, I have two different call for import account from Target. in the 1st call we are importing id, email and in the next call will get all information. How we can achieve this ? ImportAccountEntJSON : { "accountParams": { "connection": "ac...
Resolved! Actionable Analytic Error: Failure : Cannot invoke method split() on null object
We are trying to execute this actionable analytic and receiving the error below when executing the analytics job. The accounts are identified in the analytic report but updateaccount tasks are not created. How can we resolve this issue?SELECT a.acco...
Execution trail - failed rule extract
Hi Team, I have attached a screenshot from execution trail, where we can see there are 31,000+ failed rules. So can we have an extract of this report for further analysis via analytics as there is no option in UI to get this extract. [This messa...
What is Incremental PC in "Job Type" , inside Saviynt?
Hi all,I really need to have some info on Incremental PC in Saviynt tool. What is it about? (Below I have attached one screenshot of it from Saviynt tool, it's under "Job Type" section ).If anyone knows anything about it, kindly reply Definitio...
How to create an 'Application Data Import' type trigger using Saviynt APIs?
Hi,I am trying to execute the job type Application Data import and using the following payload.{ "jobgroup": "data", "triggername": "Unisource_User_Accounts_Full_Import", "jobname": "SapImportJob", "system": "ActiveDirectory - Corp – unis...
Resolved! Need help for an Enhanced Query
Hello,I'm trying to update a customproperty field for an entitlement with a newly created Enhanced Query, but I'm getting the following error messsage. The query is:Select '0' AS customproperty1from entitlement_values evWHERE ev.ENTITLEMENT_VALUE LIK...
Resolved! SFTP file download issue
Hi,We are getting the below error when trying to download the file from SFTP location. even if the file is present in the mentioned location, we are getting an error that file is not available in the location. Any suggestions?FILES_TO_GET:[{"eic_dest...
Enhanced query converting boolean value to string
Hi All,We are trying to update the 'EXCLUSIVE_ACCESS' column of the table 'APPLICATIONTYPE' using enhanced query. We are facing the issue:'Data truncation error: Data too long for column 'EXCLUSIVE_ACCESS'.Below are my observations and understanding:...
Launch Certification from Rule Job failing
Hi Team,We are triggering certification on change in few attributes as part of the Mover/Transfer process.Below is the Screenshot of User Update Rule:Mover Rule is triggering for a user but when I run the Launch Certification from Rule Job, the JOB i...
Azure AD Entitlment Filter is not working
Hi Team, We have to import only 2 AAD groups from Azure AD based on groups displayname we tried below syntax but its importing all groups and account. Please let us know the proper syntax for this use case.{ "group_filter":"displayName eq 'E3 Licens...
AD User Import Incremental not working
Hi All,I am trying to perform Incremental User Import from AD (Update Only), but the job is not picking any user.I have configured the search filter and Object filter, same filter is working fine while performing Incremental Account Import but same i...
Daylight Saving Time and job schedules - Helpful Hint
Here's something I wish my implementation partner had known that I've just figured out with the latest time change. For obvious reasons, UTC is the default time zone for scheduled jobs and analytics. If you live in a place that observes Daylight Savi...
How to set the Service Account Owner attribute after importing the accounts from AD
Previously we use a CustomQueryJob to update teh account owner for all the Service Owner.We are reconciling the owner's details in CP11.Now, after migrating to 23.10 we don't have the option to create a new Custom Query Job. The old Custom Query Job...
Extract all the jobs with all the details like scheduled time
Hi All,I need one urgent help, i am trying to extract all the jobs available in system with below information-1. Job Name2.Schedule time3.Status of job4.Endpoint name associated with the job5.Jobtype6.connection and file name attached to that job?Is ...
Enhanced Query for JOB to Update Account CP based on dataset value
Hello Experts,I need help in developing enhanced query for below senario,We have dataset with Department, country and Role. we want to update the XYZ app Accounts CP10 attribute based on camparing users Department and Country with Dataset Department,...
Data Mismatch in Users Import via Schema Job history
Hi Team,We are importing users via File based Users Import (SchemaUserJob). We have noticed one mismatch in the data shown in our Job History panel regarding the Users Inactivated data.Users Inactivated always shows 0 even though We see 10 plus users...
CUSTOMPROPERTY converting to null from Sav4Sav REST Connection
Hi,We are currently implementing user termination flow (eg.:- Disable user identity on termination date, Move organization value to archive after n days from termination date). To implement these use cases, we use a Saviynt-For-Saviynt (Sav4Sav) REST...
Resolved! Multiple job for "user import via a connection"
Our environment requires multiple jobs "user import via a connection."For example, we have several to bring in users, and a Saviynt for Saviynt connection to rewrite username.However, while one of these jobs is running, the other user import job cann...
SFTP Connection is display in FileTransferJOB
In our Environment we have configured the SFTP server and SFTP server is accessible. We have configured the SFTP Connection and given all mandatory attributes such as IP address, Port, Username, Password, File to Get and File to PUT and we have saved...
Advanced query in Job control
I am trying to pick and provision to target depending on the account name.Can you please give me an advice to make this work? select at.taskkey in (select a.taskkeyfrom Arstasks a, Accounts aawhere a.accountkey=aa.accountkey and aa.name like '%-1'an...
File transfer job (SFTP) error : 504 Gateway Time-out
I have issue with this job which retrieve files from the SFTP side. When I start this job it mostly gives me this error 504 Gateway Time-out but downloaded all the files in the file directory. Sometimes it can happen that it doesn't download all the ...
Concatenate Entitlement Types via different apis (REST)
Hi,We have a requirement in Oracle HCM. We have two entitlement types one with the name Responsibility Type and another with Scope of Responsibility.The Responsibility Type holds values like ER_User, HR Admin User,Comp_Head whereas Scope of Responsib...
Trigger Chain job skips one job
Hi,We have a trigger chain job that has 6 different jobs (imports and analytic jobs). Our problem is that the trigger chain always skips the fifth job. But when we run the fifth job manually/individually it works just as expected. We also can't reall...
Saviynt API - Job Trigger with Advanced Query (SQL)
How to use the Job Trigger API with Advanced query? The Saviynt API doesn't talk about it but is there a way we can run particular tasks like how we do from the UI?To put it simply, how to do the below from the API
Resolved! Duo import jobs issue
Hi - i have configured Duo connector to import accounts / access data from Duo server. I am able to pull required data from Duo but if we look at the Job History details for both Account and Access import jobs , it says "null import" under FILE NAME ...
