Solved

How to login to IFS Report Designer

  • 14 December 2023
  • 10 replies
  • 232 views

Userlevel 7
Badge +22
  • Superhero (Customer)
  • 943 replies

Hi all,

I am able to login with IFSAPP user to the Report Designer.

I have full permissions but can’t login there.

Do I need any special permissions?

 

icon

Best answer by Charith Epitawatta 14 December 2023, 18:59

View original

10 replies

Userlevel 5
Badge +14

Hi @Link,

 

Can you check whether the user has FND_ENDUSER permission? I can connect with just with FND_ENDUSER permission set. But, I can’t fetch any layout as expected.

 

Userlevel 7
Badge +22

Hi @hhy38 

thank you for answering.

I will test my login with this permission set.

Userlevel 4
Badge +8

Hi @Link ,

 

Your IFSAPP password probably ‘LOCKED’ due to entering wrong password multiple times. It happened to me few times with report designer.

 

So I think you wont be able to login in IEE with IFSAPP if you logged out. 

 

But if you already logged in SQL database with IFSAPP,  you can alter your account like below;

 

alter user <your_username> account unlock

 

Hope it helps

Özgün Bal

Userlevel 7
Badge +22

Hi @Link,

 

Can you check whether the user has FND_ENDUSER permission? I can connect with just with FND_ENDUSER permission set. But, I can’t fetch any layout as expected.

 

No, it doesn’t work. It’s unbelievable.

Userlevel 7
Badge +22

Hi @Link ,

 

Your IFSAPP password probably ‘LOCKED’ due to entering wrong password multiple times. It happened to me few times with report designer.

 

So I think you wont be able to login in IEE with IFSAPP if you logged out. 

 

But if you already logged in SQL database with IFSAPP,  you can alter your account like below;

 

alter user <your_username> account unlock

 

Hope it helps

Özgün Bal

 

Hi @Ozgun BAL 

with IFSAPP I am able to login but not with my own account.

With my own account I can login to PL/SQL, IFS IEE, Aurena, Wadaco etc. but not to Report Designer.

Although I have full permission set. Very strange.

Userlevel 7
Badge +31

Hi @Link,

Are you trying to login with a user ID that is authenticated with an external identity provider such as Azure? If that is the case, then please use a database authentication enabled user since the Report Designer connects to the application server via the admin gateway, which does not allow external IDP authentication.

Hope this helps!

Userlevel 7
Badge +22

Hi @Charith Epitawatta 

yes, we import the user with AD Sync and use SSO as well.

Does this mean that I can't log in to Report Designer with this user?

Thank you a lot.

Userlevel 7
Badge +31

Hi @Link,

Yes, in IFSAPP10, please use a database authentication enabled user to connect to IFS Report Designer. 

 

Userlevel 7
Badge +22

Hi @Charith Epitawatta 

thank you a lot for supporting. Then we need to create a database authentication enabled user for the Report Designer.

Have a nice day. 😊

Userlevel 7
Badge +22

I have created a test user and it works indeed.

Reply