Hello everyone,
We have for our customer an lobby element constructed to display “Incoming dispatch advice lines”.
It works but we noticed that unlike other lobby elements, our “site” filter does not work properly.
When we put “%” to show all sites linked to our user, we see all lines from all sites. It’s not a SQL problem because if we go directly to the menu “Incoming dispatch advice lines” and we search without any filter, we see all lines from all sites. If we go to “Customer Order” and search without filter, we only see the customer orders from the sites linked to the user.
Here is the lobby date source designer :
I tried to add this to filter only the site linked to the user :
and contract IN
(
SELECT contract FROM USER_ALLOWED_SITE
where userid = (select fnd_session_api.get_fnd_user() from dual )
)
With an administator account, it seems to work :
But as soon as I test it with an account with limited sites connected, I have this error message :
Messages d'erreur du serveur :
3021b040-5fb8-4541-a053-1a169fedaf8a
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-00942: Table ou vue inexistante
Table or view does not exist. (ORA-00942: Table ou vue inexistante)
à Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
à Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
à Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
à Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
--- Fin de la trace de la pile d'exception interne ---
à Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
à Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
à Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
à Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
à Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
à Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)
Any idea why it does not work ?
Our customer’s version is V10.
Thank you in advance :)