Thanks for the information I really appreciate that. Would that be in the BUILD HOME that IFS Support can provide us?I’m sorry, I just don’t know IFS or the process that IFS uses to distribute this type of information, I mostly work with the data and transferring the data between different systems. This is our first update and the first time the BI module has stopped loading data.It’s been a struggle trying to get things working again.
Thanks @subashfestus that makes sense. Do you know where we can get the updated SSIS packages from IFS for UPD22?Do we reach out to IFS support for this or is available for download somewhere?We haven’t had to update our BI pipelines before.
Just to update this, it did solve the error with the view but we are still seeing errors when we tries to run the SQL job to update the database:The Source.Outputs[ADO NET Source Output].Columns[ACTIVITY_CLASS_SEQ] does not have a matching source column in the schema. Description: "Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA".I’m sure we need to do something else to get this running again but I’m not sure what is needed.
Hi, Thanks for the information, we are using the following versions:IFS Aurena framework version: 10.22.30.0 IFS Aurena client version: 10.22.142.0 IFS OData provider version: 10.21.2.0The run on the previous day worked and then it stopped working yesterday. This is probably because we are getting updated to UPD22. I had no idea about those access views but following those steps fixed the issues with the FACT_ACTIVITY_CALCULATION_BI view. Thanks for the help!
Ah too bad, thanks for the the information Tomas. We will look into using the report actions to attach the documents as this seems like the preferred approach regardless of IFS version.
Hi Thomas, Thanks for the replay that makes sense. Do you know if this has been updated in IFS Cloud? It seems like something you would want to have (e.g. a way to link the report to the entity that generated it) but perhaps there are things in the background that I don’t fully understand that make that a difficult proposition.I will dig into the report actions. It’s actually the solution that we came to on our own, attaching the document to the customer order, so that we are not “guessing” if it’s the correct document.
Good morning everyone, does anyone know when the “Execute Online SQL” action will be removed from IFS Cloud?We are in Apps10, is there any plan to remove this functionality from that version of IFS?What is the recommendation for customer events in Apps10 instead of “Execute Online SQL” to ensure that they are easy to port to Cloud in the future?
For what it’s worth you can get the ResultKey from the CustomerInvoiceAnalysis APY as shown in this thread: Might be a better way to do it instead of using the notes, however the ability to get the ResultKey doesn’t seem to be available in all entities.
Ok Thanks @Tomas Ruderfelt , is there a clean way then to match a shipment that has generated a BOL to the BOL that was generated in the Report Archive?Is this functionality in Cloud? It seems like something that would be desirable, but maybe I’m not understanding the way IFS is expecting this to work? Maybe there is a better way to handle this. If we want to be able to surface documents using external API’s what is the best way to find the documents that have been previously generated? Should we be using something other than the Report Archive? Thanks,Mark Mruss
@Tomas Ruderfelt Quick question for you, do you happen to know where I could find the same information for a Bill of Lading? I took a look at the ShipmentSet and OverviewShipmentSet but I couldn’t find a ResultKey. Thanks,Mark Mruss
Ah thanks! I was only looking in the CustomerOrderInvoiceHandling projection I didn’t even think to look elsewhere. I think that this will do exactly what we are looking for. Thanks again!
Hi Thomas, Thanks for the information that is exactly what I’m looking for. However I don't see that projection in our API Explorer. We are using Apps10 not the cloud version. I’m not sure how the API has changed between versions. When I look at CustomerOrderInvoiceHandling I don’t see any information about the ResultKey. Is the Resultkey available in Apps10 somewhere? Thanks, Mark
Ok thanks for the information. That’s all that I could find that would link the entries within the Customer Invoice, I was just a bit concerned that the notes field wouldn’t always match. Thanks for the reply!
Hi Charith,Sorry if I wasn’t clear, what I am trying to do is find our customer invoices within the ReportArchive via API and perform the same lookup that “Reprint Original From Archive” does. I have the invoice information, but I don’t know how to correlate that with the entries in the ReportArchive ArchiveDocumentSet. I can do it by filtering on the Notes property of the items within the ArchiveDocumentSet: As that seems to contain the Order Number and Invoice Number:ArchiveDocumentSetBut filtering based on the Notes feels implicit as opposed to explicit. Is there any way to explicitly link an entry in the ReportArchive ArchiveDocumentSet with the object that created it? In my example the Customer Invoice. I don’t see any other information within the ArchiveDocumentSet that links this with the Customer Invoice.
Hi, We are wanting to do something similar, how are you identifying your invoice within the ReportArchive API? It looks like we can use the notes property, but I was hoping that there would be a more explicit way to link an Invoice number / ID with an item within the ReportArchvie.
It seems like we need to always re-compile the Invalid Objects every time we deploy to IFS. Using: Solution Manager > System Information and Utilities > Oracle Objects > Compile Invalid Objects seemed to solve the problem. If anyone knows of any documentation related to this that would really be appreciated.
Is it a situation where you need to recompile invalid objects after every code deployment? E.g. navigate to Solution Manager > System Information and Utilities > Oracle Objects > Compile Invalid Objects? We are new to developing our own code for IFS, is this part of the standard process? If anyone knows of any documentation regarding this, it would be really appreciated if you could share. Thanks, Mark
Hi WIlliam,Thanks for the reply we are using IFS Apps 10 Update 16.I think what I need to do is call /ShipmentBillOfLadingRep.svc/VirtualOrderReports and set the ReportId, CompanyId, ShipmentID, etc in order to get an Object Key. Then with the object key call ShipmentBillOfLadingRep.svc/VirtualOrderReports(Objkey='{KEY}')/IfsApp.ShipmentBillOfLadingRep.VirtualOrderReport.OrderReport to generate the actual report. But whenever I do I get the following response and I’m not sure what I’m missing: { "error": { "code": "ODP_DESERIALIZATION_ERROR", "message": "Error while de-serializing contents." }}
Thanks for the help @Charith Epitawatta that seems like exactly what is happening here. I doubt it will be an issue in production and it’s probably just happening in development because people are actively working. Thanks!
Hi @Charith Epitawatta Thanks for the information. Does this mean that someone was updating the custom fields while the script was running? I can check within the organization to see if that’s the case. If that does happen what do we need to do in order to get the custom fields to be re-initialized? I don’t change anything and just runt he SQL again and it works. Thanks, Mark Mruss
Thanks! That helps and I’ve been able to start following the tree through the PURCHASE_ORDER_LINE_TAB. Do you happen to know which tables I would need to use based on the ICD and ICT demand codes? Edit: After looking more I think it’s in CUSTOMER_ORDER_LINE_TAB. I’m continuing to go down this rabbit hole!
If I recall correctly, if you work backwards from the last member of the hierarchy you describe, the fields DEMAND_CODE and ORDER_REF1 should help you find the previous member in the hierarchy. For example, a demand code of “Int Purch Trans” on a customer order points to an internal purchase order - it’s number stored in ORDER_REF1. Thanks for the information do you know which tables I should be inspecting? I’ve been able to find DEMAND_CODE in CUSTOMER_ORDER_LINE_TAB along with DEMAND_ORDER_REF1 - 4, but it doesn’t seem to contain all the information that I thought I would be able to see and I can’t see the hierarchy that I can see on the Supply Order Analysis screen. This seems like a great step forward for me, any further hints you would provide would be appreciated.
Hi,Just giving this a bump to see if anyone knows the answer. To describe what I am looking for in other words, I’m trying to find out how orders, whose order numbers change as the order moves through the supply order analysis (from site to site), are related. supply_order_analysis_api.generate_tree() will generate the hierarchy in the SUPPLY_ORDER_ANALYSIS_TAB table but that doesn’t work for us, as we would like to perform our own analysis. Thanks, Mark Mruss
Thanks @Rifki Razick I’ll keep that in mind, it would be great if we could get whether or not the endpoint is virtual added to the documentation. If all the end points had virtual in their name it would work as well, but for something like DocumentTextHandling.svc/NoteTexts the only clue I can see is the ObjKey. Thanks again for the help getting me through this.Mark
Thanks @Rifki Razick and @Tomas Ruderfelt that worked.Does this mean that any API call that uses an ObjKey is designed only to be used in the IFA UI and should not be used by an external client? Are there any other clues in the API Documentation about which API’s are Virtual Based? Thanks,Mark Mruss
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
