SELECT company_id, LEVEL, pos_code, sup_pos_code FROM company_position WHERE company_id = '10' START WITH sup_pos_code = '*' CONNECT BY PRIOR pos_code = sup_pos_code AND PRIOR company_id = company_id; SELECT company_id, RPAD('+', LEVEL, '+') || pos_code FROM company_position START WITH sup_pos_code = '*' CONNECT BY PRIOR pos_code = sup_pos_code AND PRIOR company_id = company_id;
by switching to FNDMIG At this level of effort, I’d write a PL/SQL wrapper to call External_File_Utility_API.Execute_Batch_Process2 and trap the exception inside of it. I was hoping to avoid that and do this in pure configuration.
same code for product structure Sure, but it’s better to start a new question so future users of the forum can find it.
@0guz , here you go.
Hello @durette can it possible to write same code for product structure? https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/sql-for-visualizing-product-structure-2864
There are examples here if I remember correctly. (This page is restricted to authorized users.) https://community.ifs.com/technology-97/is-there-a-way-to-call-a-custom-api-378
Here’s an example of Oracle PL/SQL in action. This creates a custom package, adds it to the dictionary cache, grants it to a permission set, refreshes the security cache, creates a database task, and sets up a database task schedule.
Oracle Database can process JSON natively. You may need a full license of the Oracle Database software, since creating your own tables is usually not something you can do with an ASFU license. Attached is some SQL showing how this might work. The column constraint is not merely a constraint but also a flag that changes the logical behavior of the subsequent SELECT query. This is why this won’t work on a native CLOB you might find in the existing application.
This is nearly a duplicate of this question: https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/yes-no-dialog-box-408 The subtle difference is that you’d like a custom menu, and the original question was about an event. I don’t believe there’s a solution yet.
Thank you. This does now work.
He has a wildcard certificate. But he is not sure how to combine the code signing certificate with it. Thank you. You’ll need to convert your certificate to the PFX format.In Apps 9, you would first reconfigure your extended server, i.e. by calling %IFS_HOME%\installer.cmd, and feed it your PFX file when it asks. You would then need to update your client manifest file by calling F1MAGE. (If you’re running Sales and Marketing, you’ll also need to update that other application manifest by calling DeployUI.)In Apps 10, F1MAGE is now called by the extended server installer at the end of the process to sign the Enterprise Explorer application, so you can update both the HTTPS cert and the client signing cert in one shot with install.cmd.
According to Oracle, it's not safe to delete these. (MOS 1185713.1)However, you can clean up the files not needed for patch rollback. (MOS 550522.1)opatch util cleanup
With the Chromium-based Microsoft Edge browser, version 78 or later, we now have a flag to natively enable ClickOnce:edge://flags/#edge-click-once
If you’re using IFS Enterprise Explorer, you can revoke the EXAMPLE_CLP.NEW__ database method. (I haven’t tested this in Aurena.)
I’d be interested in this answer, too.Rephrasing the question, you’d like Active Directory to serve as the authorization server, correct? It would then hand out an authorization grant to the application and an access token with each login.
What are they seeing?
During our upgrade from Apps 8 to Apps 9, we discovered the following file was missing. This caused errors when users attempted to load help pages.%IFS_HOME%\ifsdoc\documentation\en\OnlineDocSettings\settingsFlow.xml
To debug, log on to the server hosting IIS for Crystal. Open the web browser:http://host/directory/Ifs_ReportService.asmx?op=GetSavedPDFReportFrom here, while coming from the local host, it provides a form where you can make a manual Crystal request.FileName: your RPT filenameParamaterValues: your result key if it's an operational reportLangCode: en (or your language)
We use sticky notes quite a bit.They’re stored in RTF format on the database. Converting rich text and images to HTML or plaintext is a nontrivial task.
If the database images are black, then that’s all Crystal is going to see. This needs to go back to your third-party vendor to see why the images are bad. (I suspect this may be a problem with image transparency.)
Would IFSSYS, FND_RUNTIME, or some other grantee be more appropriate? UTL_HTTP could be used to send data to malicious web sites, so PUBLIC feels too broad.http://www.dba-oracle.com/t_revoke_execute_from_public.htm
IFS CRM Consultant needs to provide a script with instructions to add it as an add-in to Outlook What kind of script is this?
This GPL-licensed PowerShell solution could adapted to any .NET language.Export each of the two PDFs as a raster image Compute the color differences between the two images Export the difference as a new raster imagehttps://github.com/durette/Powershell-Compare-PDF
This might also help:https://docs.ifs.com/techdocs/Foundation1/050_development/040_core_server/027_base_server_dev/030_mechanisms/
The LU name doesn’t need the trailing “Api”. The _API suffix on the package name is a convention that gets added later.Examples:LU CustomerOrder ↔ Package CUSTOMER_ORDER_APILU CustomerInfo ↔ Package CUSTOMER_INFO_API Did you log out of Enterprise Explorer and log back in?Can you see the package in the dictionary cache? Go to System Information and Utilities → Logical Units → Logical Unit and see if you can see it there. Alternatively, you can query the cache directly:SELECT * FROM dictionary_sys_package WHERE lu_name = 'CbMsLevel1Api';Did you refresh the security cache? (This shouldn’t matter, but it’s worth a shot.)
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.
