thiago
Forum Replies Created
-
Maybe there is something creative to be done on the Forms Designer side in combination with part master configuration.
-
Scott, if you would like to do a quick screen share and look at it together, let me know. thiago@datastudioaviation.com
-
Select OPM.opm_auto_key, opm.pnm_auto_key, opm.pnm_modify, opm.wrv_auto_key,
opm.sysur_auto_key, opm.operation_id, opm.description, opm.ber_threshold,
opm.flat_rate, opm.parts_flat_price, opm.labor_flat_price,
opm.misc_flat_price, opm.flat_rate_labor, opm.default_repair,
opm.turn_around_time, opm.in_capabilities, opm.oem_repair,
opm.version_num, opm.consolidate, opm.template_type, opm.pdl_auto_key,
opm.yield_perc, opm.max_lot_size, opm.end_item, opm.blueprint,
opm.part_cost, opm.labor_cost, opm.fo_cost, opm.vo_cost, opm.osv_cost,
opm.costing_method, opm.fixed_unit_cost, opm.mdl_auto_key,
opm.work_package, opm.sequence,
MDL.mdl_auto_key mdl_auto_key_1, MDL.amt_auto_key, MDL.model_number, MDL.description description_1,
MDL.model_type,
MDL.notes,
MDL.life_with, MDL.model_sub_type,
MDL.full_model, CAST(QC_UTL_PKG.check_mark(OPM.WORK_PACKAGE) AS VARCHAR2(2)) WP_FLAG
from OPERATION_MASTER OPM, MODEL MDL
where OPM.MDL_AUTO_KEY = MDL.MDL_AUTO_KEY
and OPM.TEMPLATE_TYPE = ‘P’
-
Henrik, I just noticed you mentioned that you combine a Command and a table. I have seen issues when you try to link in Crystal a Command sql stmt to a “Crystal” table. try to change everything into one command or tables only, specially if the report has a paraemeter being passed. It’s intermitent, depending on the SQL and/or data it is not a problem, but i had fixed quite a few of escalated issues while at Component Control related to that. Something to try if I understood you correctly.
-
Henrik, do you have the issue when you run the report in Crystal Reports outside of Quantum? Maybe downoad the free trial 2016 version on his machine and give it a try. It would be good to know that.
-
Jef, some forms have programming to show different types of header with logo side by side or just the logo. You may need to delete what is there on design mode to make your life easier. To add the logo you can use the image object from the toolbar. Place it, right click and chose picture. Reach out if you need more help at thiago@datastudioaviation.com
-
You don’t necssarily need to create the query again. When you select that event, it tells you at the bottom which procedure runs it along with the information on parameters. Find that procedure in the database and copy the sql from the procedure and use it in your custom one.
-
Josh,
In addition to Nadim’s recommendation, one thing i have done for a customers is to create scripts that analyze WO main components historical costing/pricing/margins/etc… for that PN based on WO Work Type and other charachteristics and update the Parts Master with that information in udf and sdf fields. We create a report specific to Part Analysis using that data. The final product looks really cool.
-
Lee, I would first build a query considering the quote part.
Once i have that I would create a custom column subquery for the cust_pn or alternate…probablly use the listagg function for the list.
Once you have everything you need I would filter the query on the match of the Crystal parameter with items in custom field.
Basically you are trying to compare a parameter to a list of fields per row. Look into functions that will help you have all that info in one row.
That’s one approach, hope it helps.
-
Wow, that’s a bad one. It needs to be escalated by Tech Support.
-
I also use the wob_ref as Nadim is explaining.
-
Start simple and build up from it testing each step of the way:
1) Change your sql in same template to something simple like
select * from uom_codes
Emgr gets confused when parsing compicated queries even in a view. Make sure no errors in error tab.
2)Make sure you have an attachment name like extract.csv. in parameters.
3) Copy a simple template as base first to test…..like the Project Audit one which just says csv attached
-
Many companies use that code…it seems correct. If you are using new page per task, that’s one of the things this code helps with. I would assume there is something with your data. Does it do that to all WOs?
-
First I would check all the section bands in design mode to see if there is a new_page property checked.
Next, go to calc tab and look at the code under Group(0) or Group(1) which is responsible for the paging per task.
-
Mike, By “STD Emgr Event” I mean the standard event called “Quantum Systems Errors Event”
-
Mike, I don’t think SQL errors in Crystal Reports will get logged in that table even in the newest version. That table is used by Quantum programmers and they need to be inserted as an exception by a pkg in Quantum. The Command window in Crystal does not have that functionality.
If you add this SQL to the Custom SQL Template Event as an Excel Extract, Emgr will log the error in Emgr Log.
Another way would be for you to create a procedure that returns a collection object that you can select from the command in Crystal. In the procedure you can insert any exception into sys_error_log and then use the STD Emgr Event to notify you of the error.
In that table, you can classify the type of error and tell the Event only to notify that type of error.
-
There is a std event in Emgr that monitors that table. You can use that.
-
Lee, see attached. This is the Stock Browse code.
I got it from the Oracle packages and cleaned it up for you.
Let me know if it works well.
-
Henrik, the first error seems to be related to the viewer while Exception Errors are usually Delphi related which could be the interface between viewer and Quantum.
Have you tried downloading a STD report from the DB that has issues and reloading it again with another name? How about loading a report with just a label and no db data?
You should definitely contact CC for this, they might need to bring your database in and try to reproduce the error in their development environment to figure out the issue.
-
Kristen, I have helped customers create Custom Event Manager Events that can analyze specific characteristics of a WO(BOM reservation, Header Status, Labor, notes, etc…) and modify specific task statuses accordingly on a schedule.
-
Yes, grabing the STD code from the event and using it with the Custom Sql event is how I usually go about it.
-
Craig, you can use the Custom SQL Statetemt Template Event.
Add a sql statement to your template and the event will attach a spreadsheet to the email.
-
Tony, I could create a script that merges parts depending on specific characteristics on those records.
I have built that before for customers going through similar issues and cleaning up duplicates. Let me know in case you decide to go that route.
-
Yes, that’s correct. Stock_reservations while it’s reserved and wo_stm_complete for historical. Probably simpler to use the view.
-
If you decide on another route, the stock reservations table has a woo_auto_key for the wo header and an stm_auto_key for the stockline reserved.
-
There is a bug with the new version of OCDIA in 12.1 where you get an error when trying to click the “Add Table” and “Import Table” button to add a new External Table.
This means you cannot create a custom OCDIA.
They are able to replicate the error at CC and are investigating the issue at the moment. Hopefully we will have a patch soon.
-
Just a heads up, if you end up needing warehouse transfers, the best practice would be to build a procedure that uses the same functions as the Warehouse Transfer Feature in Quantum.
This will make sure all aspects of warehouse functionality and links in the different modules are managed properly during the transition.
A simple update of auto keys is dangerous business… Let me know in case you need help and I would be happy to assist. thiago@datastudioaviation.com
-
Nate, great intro!
As far as visibility goes on those BOMs, you could create a custom event manager event that will look at the Image Code of the documentation attached to the BOM reservation and notify the WO Manager of BOMs that do not comply with needed Image code/Condition Code combination.
Let me know in case you need help with any variation of that. thiago@datastudioaviation.com
-
If you would like to use the crystal schema the info is:
service:maxqprod, user:crystal, pass: report
It’s a read only schema. Aside from having access to qctl data you can create views that will not be deleted by an upgrade. It’s also the new schema for Analytics module.
There is one more option where you can load csv files into an OCDIA external table that can be used for comparison with data in Quantum on your reporting, PBI and sql analysis. That can be extremely useful.
OCDIA is on the server Quantum folder.
service: maxqprod,user:dia,pass:quantum
-
Andrew, Jason answered your question. They do not sell the module anymore.
There were a few instances where they allowed the use of it for maintenance of older scripts knowing that I would be the one doing the work. There were other cases where my customer just received a NO. They want to make sure that whoever is touching those modules knows them really well.
I believe they would currently make changes for you if you pay them to do it. Screen Scripter is definitely a safer approach and better documentation of the work done which is important.
Screen Designer is where there are risks and they had problems in the past after a specific upgrade. At the time I had to modify scripts from several companies for them that were affected by the upgrade. It was a simpler fix with the script, but with screen designer(F7) it is really difficult to reconfigure the F5 code which is how screen designer configuration gets saved.
They are trying to be safe so no more issues. I believe it’s worth a try asking them to add Screen Scripter to a specific screen for you if you really neeed it. I would stay away from Screen Designer.
If you have an urgent issue with your script, there may be a way to fix it by updating the screen scripter code in the database. I always recommend to call them. I have a good relationship with CC and plan to keep it that way. 🙂
-
Randy,
SDF fields don’t have a user friendly interface to configure like UDFs. Thre is a module you use to be able to purchase called Screen Designer to customize screens and those fields were used to add a new field to the screen. You can still use the field to store data and maybe pull data into a Form in Forms Designer or Crystal Reports.
Please let me know if you need help with that and we can do a quick screen share. thiago@datastudioaviation.com
-
Konstantin and Dominic have decades of Oracle and Quantum. There is a lot to learn in those packages, it’s like free money. I never missed an opportunity to use that.
-
Scott,
I like to approach it this way:
1) Figure out which reports your accountants use to validate their data.
2) Go to Rpt_ packages and find the procedure or views that feed those reports in sql developer.
3) Use that SQL from the procedure to modify and create your own version.
This approach will teach you a lot about the report links and give you an understanding on differences between your queries and the reports they use when they come back to you with questions( dates being used to filter that give a different total..etc…).
You will need to prove that you are correct and this helps you do it by comparing to the STD report.
-
I have worked with customers that have a separate sql server to move data out of Oracle, transform the data in sql server and read Power BI from there. You avoid the license issue , slow speeds and maybe make the data a bit more user friendly in the process. Not as real time but you can get pretty close.
-
Great! I know they started developing it years ago while I was still working there, so probably just released it now. Many customers were asking for it.
-
Vicky,
They have added a double electronic signoff maybe 5 years ago. You are able to do a Mechanic Sign off and then Inspectors.
The options may only show once you enable it in the WO Control setup.
-
Lisa,
I have attached some general guidelines on setup and use of OCDIA that were given to me years ago.
Let me know If you would like a more detailed training on how to build OCDIA scripts and I can hep you with that.
We can spend a day creating scripts that you need and training on how to code in PL/SQL. It is what I used on our project cleaning up all the duplicate parts.
Kind Regards,
Thiago
-
I would be happy to help if you need any customization on Accounting Reports. They are complicated to deal with and a little customization can go a long way.
I have built custom Income Statements, P&L and Aging Reports to look at certain accounts conditionally which could be helpful in this situation. thiago@datastudioaviation.com
-
Tony, it seems like the company_agents table may be throwing you off. I don’t see a link for it.
-
Jeremy, in case you need additional funcitonality other than the transfer explained by Jason above I could help you by building an Oracle Script to get it done.
It could transfer parts conditionally and help clean history if needed.
You can reach me at thiago@datastudioaviation.com
Rgds, Thiago
-
You could build a custom Event in Event Manager to automate that process, shoot me an E-mail if you would like help with that. talvares@datastudiodev.com
-
Wow friend…that’s bad…shoot me an e-mail and let’s do a screen share and look at it together tomorrow.
-
Hi Craig, my name is Thiago Alvares, I worked as a Developer for CC and built some of the STD Events in Emgr. I work as consultant now and the majority of my customers today use Emgr and get incredible value from it. Aside from automating Crystal Reports, you can build custom Excel Extracts sent via E-mail and custom notifications.
You can also create a lot of value for your business from building custom procedures for automation with Emgr. For example, I have built a collection of Events that can track when is time for different types of re-certification and automatically creates contacts in Contact Mgmt and notifies your customers for specific components.
You can store these events separately, but you will need a user that knows PL/SQL Language to maintain them and create them. There is a learning curve even if you know PL/SQL because of the complexity in Quantum and Emgr. I provide a lot of training for my customer on that and would be happy to help you with training or creating them for you.
The cost of creating new Events depends on the Event. I can give you an estimate if you send me your requirements. I used to quote them for CC so I have a lot of experience on estimates for those. You can reach me at talvares@datastudiodev.com and I will be happy to answer questions and give you free advice around Emgr. That also goes for anyone else reading this. 🙂 Cheers Thiago
-
I have done it using the stock adjust table but it is a lot of work and it gets tricky when you start needing to track the cost through split stock lines.
-
I have connected with visual studio. Which technology are you using for your app? You could build a web service for it too. I have done that.
-
Tino, you would have to change the order by statement in the sql query for that pipeline in the oracle package. That would change the sorting in any form that uses that pipeline, not just your custom form. I have done that before and it works.
Another option is to create the form from scratch using memo fields with sql statements where you would be able to control the sorting on your sql statement but that is a lot of work.
If you need help I can give you some guidance on a screen share free of charge. talvares@datastudiodev.com
-
1. Print any STD form that works on that print setting screen you are trying to print from.
2. Open this STD form in Forms Designer, go to Data Tab and look at the name of the data pipeline on top.
3.Open your form and see if the data pipeline on data tab has the same name. It’s probably different. Every form/data pipeline is designed to be printed from one specific place(print setting) only.
If you desire to create something custom, you have to begin with a std form that works on that print setting screen and save as with a different name. Hope this helps.
-
Brandon,
Give this a shot and let me know if it works.
Paste it on the OnGetText Event in Calc Tab for a label.
var
q : TOracleDataset;
begin
q := TOracleDataset.Create(nil);
q.SetSession;
q.Sql.text :=’Select si_number from wo_operation woo, wo_bom wob where woo.woo_auto_key = wob.woo_auto_key and wob.wob_AUTO_KEY = ‘+ RO_DETAIL[‘WOB_AUTO_KEY’];
q.Open;
Text := q.FieldByName[‘si_number’].AsString;
q.Free;
end;
-
Hi Tino, yes it is possible to modify any of the templates.
You can save them to file, make modifications and upload them again.
Just because you are modifying an XML, doesn’t mean you will get that data. You need to modify the pl/sql procedure to provide data for the xml.
-
You can build a script that uses the same company merge function to do it for a list based on conditions you define.