Topics started by proharikg
Hi, Scenario:I need to create a lobby data source where 2 views are involved.View1- DOC_ISSUE_REFERENCEView2- PROJECT_BASE from view1 has project title,view 2 has project id and manager name these two view has no relation between them, but I use regexp_substr to sort out view2.project_id from view1.titleand using that project id I fetch the manager. Since lobby data source can only use one view, I have implemented this using IAL.Query:select a.*, b.manager from DOC_ISSUE_REFERENCE a, PROJECT_BASE b where b.project_id = REGEXP_SUBSTR (a.title,'(\S*)') Problem: I need the result per manager in lobby condition, using lobby datasource. But it is showing an error while clicking lobby element and no data is getting populated, Is there anyway to do this.Or do I have to create a custom column for manager to solve this issue? Please Advise...Thanks in advance Error
Hi,I tried to create a custom field, in PLSQL developer value is getting correctly. But when I deploy the same in custom field, value is coming incorrectly. What could be the possible reason, Please help.Code- in back endSELECT c.order_no,c.BUY_QTY_DUE SalesQty,c.QTY_ASSIGNED ReservedQty, CASE WHEN c.QTY_ASSIGNED/*Reserved Qty*/ >= c.BUY_QTY_DUE/*Sales Qty*/ THEN 'Fully Reserved'WHEN c.QTY_ASSIGNED IN (NULL,0) THEN 'Released'WHEN c.QTY_ASSIGNED < c.BUY_QTY_DUE THEN 'partially Reserved' END Status FROM CUSTOMER_ORDER_LINE c,CUSTOMER_ORDER dWHERE c.order_no= '&order_no' AND c.order_no=d.order_noCorrect result for status in plsql developerCode- in custom field- (Read only field)SELECT CASE WHEN c.QTY_ASSIGNED >= c.BUY_QTY_DUETHEN 'Fully Reserved'WHEN c.QTY_ASSIGNED IN (NULL,0) THEN 'Released'WHEN c.QTY_ASSIGNED < c.BUY_QTY_DUE THEN 'partially Reserved' END Status FROM CUSTOMER_ORDER_LINE c,CUSTOMER_ORDER dWHERE c.order_no= :order_noAND c.order_no=d.order_noResulthere t
Hi Community, I face below error while searching in a window in test environment, please help how to resolve this.Things I have done: Cross checked every permission set with prod of user where this error is not present. checked Every check box of API( API in system info) is checked in in new permission set windowdetails of error message:Thanks in advance.
Hi Community,I need to make this field read only for every users in the environment.I tried to make it read only by RMB on the page >Properties > Read only but it reflected for only the current account. When I logged in to other user accounts, I can still edit the field. Please help how to get this done..thanks in advance.Regards/Hari
IFS 9 supports which version of SSRS Report ? Kindly help to resolve this error ? Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method PrintReport/ReportFormatRequest ---> Ifs.Fnd.FndServerFaultException: PluginExecute Failed. PluginException:SSRS:Error Executing plugin ifs.application.printagentservice.impl.extendedformatter.PluginException: PluginException:SSRS:rs.render com.sun.xml.ws.fault.ServerSOAPFaultException: Client received SOAP Fault from server: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or en
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.