0 Archived
Forum Replies Created
-
Did you set a warning message for that company? We did that for folks we got RMAs from and they owed us money and we never applied it to any payments do (I think).
-
Not sure with Mobile Tech, but we use the desktop Generic BC and they just clock out for their non-paid breaks and back on to whatever job they come back to.
Not sure if this is an option.
-
I see 12.7.9 on Component Control’s website, anyone have a preferred version that is most stable?
-
If you don’t need OCR, there is an interesting open source editor, it opens quickly, you can use digital signatures, it does not support forms.
With Adobe recently updating their terms of service where they require access to your files to train their AI, I think things will start to heat up.
okular.kde.org
Okular - The Universal Document Viewer
Multi-platform, fast and packed with features, Okular allows you to read PDF documents, comics and EPub books, browse images, visualize Markdown documents, and much more.
-
Have you looked at the view STOCK_AUDIT, you maybe able to utilize this to gather the data you want. Maybe in your where use TRAN_DESC LIKE ‘Sale Income%’ to just get sales figures?
-
This reply was modified 1 year, 10 months ago by
0 Archived.
-
This reply was modified 1 year, 10 months ago by
-
Anyone use the remote USB so the scanner talks directly with the host so you don’t have to upload any files?
-
Did someone turn on something in IIS? On my dashboard I have it set to allow anonymous as the portal handles logging in via quantum user.
https://learn.microsoft.com/en-us/iis/configuration/system.webserver/security/authentication/
learn.microsoft.com
Security Authentication <authentication>
Overview Authentication is the mechanism you use to verify the identity of visitors to your Web site or Web application. Typically, you do this by assigning...
-
Have you verified DNS is working correctly?
-
This is pretty cool. To get it to run on Oracle 11g I had to tweak it a bit. I had to increase the field size of the base lookup to allow for two 50 character fields + the 3 spacers. I added links to SYS_USERS so I could see by person.
Pretty neat.
with recursion_view( cls_parent, cls_auto_key, description) as (
select cls_parent, cls_auto_key, cast(description as VARCHAR2(250)) description
from call_list
WHERE cls_auto_key = 1
union all
select current_level.cls_parent, current_level.cls_auto_key, trim( previous_level.description ) || ' > ' || trim(current_level.description) as description
FROM recursion_view previous_level
INNER JOIN call_list current_level ON current_level.cls_parent = previous_level.cls_auto_key
)
select recursion_view.cls_parent, recursion_view.cls_auto_key, description
from recursion_view
inner join call_users on call_users.cls_auto_key = recursion_view.cls_auto_key
inner join sys_users on sys_users.sysur_auto_key = call_users.sysur_auto_key
where user_name = 'BOB'
order by recursion_view.cls_parent, recursion_view.cls_auto_key;
-
We have started to see the Ctrol # / Ctrl ID barcode at the top is unreadable when we place them on cans. The curve throws off our readers.
Looking at the STD Barcode PN Label in the Report Designer, how would I be able to shrink it making the curve more readable?
-
We figured out if we roate our labels getting applied to curved items to be vertical we can scan them without issue.
Please disregard.
-
-
When I looked at this I didn’t see a better solution than Adobe. Granted it’s impossible to purchase an older version.
simplyPDF loaded fast and did what we need and didn’t cost too much.
How can you turn off Internet features so you can support ITAR/CMMC requirements I guess is the real question.
-
"UPDATE WO_OPERATION WOO SET RELEASED = 'F' WHERE WOS_AUTO_KEY IN (5, 37, 63) AND WOO.RELEASED = 'T' AND WOO.CLOSE_DATE IS NULL
-
For us, we had released WO’s to the purchase management system, then flipped the WO status back to one that should not be, I wrote a simple SQL to update that released flag back to F.
Not sure, but you could create an Event Manager job with a Custom SQL statement that could run every hour or what not and unrelease work orders .
-
Looking at the system, this flags the PI record as “BLOCK ACTIVITY” and that’s all. So if you print out your PI count, it wouldn’t show future activity is all.
Could be wrong on this, but PI_BLOCK_ACTIVITY is not in any of the WO or other packages in the Oracle Database
-
I was trying to do this too. Using a combination of Shipping Status and Event Manager. The change in Shipping Status is what creates the WO Billing and posts WO Billing and create Invoice / Post Invoice (Event Manager), That way we can review them and adjust before they get posted at end of day for event manager. For customers wanting immediate invoices they can be processed when needed (before end of day).
Maybe someone has more information on getting this working.
I do see this discussion that covers the create invoice piece but I think you have to do some other steps before you can invoice it?
https://quegroup.org/forums/discussion/airway-bill-on-the-invoice/#post-25171 -
If you just want to move the views you made to another schema, you could use the CRYSTAL schema (User CRYSTAL, Password REPORT), I logged in to that schema, created VIEW_WO_OPEN_TASK taken directly from QCTL and it created it just fine, the data populated from the QCTL tables as well.
CREATE OR REPLACE FORCE VIEW “CRYSTAL”.”VIEW_WO_OPEN_TASK” (“WOT_AUTO_KEY”, “SI_NUMBER”, “SEQUENCE”, “STATUS_TYPE”, “STATUS_DESC”, “ENTRY_DATE”, “WO_TYPE”, “WO_DESC”, “WOO_AUTO_KEY”, “WO_TASK_INFO”) AS
select wot.wot_auto_key, woo.si_number, wot.sequence, nvl(wos.status_type,’Pending’) status_type, nvl(wos.description,’Pending’) status_desc,
woo.entry_date, woo.wo_type, woo.description wo_desc, woo.woo_auto_key,
decode( upper(woo.wo_type), ‘MFG’, ‘MO: ‘, ‘WORK PACKAGE’, ‘WP: ‘, ‘WO: ‘) || woo.si_number || ‘, Task: ‘ || to_char(wot.sequence) wo_task_info
from wo_operation woo, wo_task wot, wo_status wos
where woo.woo_auto_key = wot.woo_auto_key
and Upper(woo.wo_type) in (‘MFG’, ‘WORK PACKAGE’, ‘INTERNAL’, ‘EXTERNAL’, ‘NON-STOCK’)
and wos.wos_auto_key (+)= wot.wos_auto_key
and nvl(wos.status_type,’Pending’) in (‘Open’,’Pending’,’Delay’)
and woo.woo_auto_key = qc_wo_pkg2.get_wo_get_tree_top(woo.woo_auto_key).woo_top; -
IMPDP canc reate an SQLFILE instead of actually doing the work on the SCHEMA. You could find your entries in the SQL file, copy and then have them executed to your schema by CC?
-
Do you still have the DMP file from when it was on-prim? Super simple to restore if so.
-
It really depends on what Oracle patches / version you are on. Mine does not support the required TSL versions to achieve HTTPS to a webserver.
I am on Oracle Database 11g Release 11.2.0.3.0 – 64bit Production
Would be nice to have this working.
Per the community: https://community.oracle.com/mosc/discussion/3923204/tls-1-1-and-tls-1-2-availability-in-oracle-rdbms-11gr2
It needs 11.2.0.4.0 or newer.
-
SSL protocols have changed over the years, I don’t believe 11g supports and current SSL protocol. All the exampels I see are for SSL v1 which has been retired for a few years now.
There is mention of a patch for 11g that enables TLS 1.2 but most servers only support 1.3 due to security concerns:
- SSL 1 – Never released due to high insecurity.
- SSL 2 – Released in 1995. Deprecated in 2011.
- SSL 3 – Released in 1996. Deprecated in 2015.
- TLS 1.0 – Released in 1999 as an upgrade to SSL 3.0. Planned deprecation in 2020.
- TLS 1.1 – Released in 2006.
- TLS 1.2 – Released in 2008.
- TLS 1.3 – Released in 2018.
docs.oracle.com
Installation Guide Oracle Health Sciences Central Coding 3.1
Installation Guide Oracle Health Sciences Central Coding 3.1
-
Are the shifts people are working pretty stable? Or is there a lot of flux what shifts are worked?
-
Thanks everyone for the feedback. I think Mike is on the right track in having an event manager job auto create the links.
It really isn’t about package tracking.
-
Still reseraching this vs. hack. In the Shipping Header form there is a WHS From and WHS To. If you pick the from, the status codes should be filtered to just that warehouse.
No need for a change request to CCI if this pans out.
-
Here is what it looks like if the user doesn’t have access to the status code they are changing to:
-
Here is the SQL, anyone have any recommendations on how best to update a trigger?
In the declare section of the trigger
V_COUNT NUMBER := 0;
V_SYSUR NUMBER := QC_SC_PKG.GET_SYSUR ;
right after the audit log loop =, guess it could be before
IF (:NEW.SMS_AUTO_KEY IS NOT NULL) AND (:NEW.SMS_AUTO_KEY <> :OLD.SMS_AUTO_KEY) THEN
SELECT COUNT(*) INTO V_COUNT FROM SM_EMPL_STATUS SES WHERE SES.SYSUR_AUTO_KEY = V_SYSUR AND SES.SMS_AUTO_KEY = :NEW.SMS_AUTO_KEY;
IF (V_COUNT = 0) THEN
:NEW.SMS_AUTO_KEY := :OLD.SMS_AUTO_KEY;
RAISE_APPLICATION_ERROR(-20797,'Invalid status code.');
END IF;
END IF;
-
The update trigger tweak is pretty easy to just leave the status at the old value if the user doesn’t have access to the status they selected.
Not sure how much that would help you.
-
If you’re thinking a user shouldn’t be able to do a global status change, I think that would be easy enough to incorporate in a trigger. I think CCI thought that if you were coming from that screen instead of ship management, they didn’t want to restrict it in that fashion.
The trigger would check the new status is in the SM_EMPL_STATUS table for the current user, and if not found raise an error that Quantum would display preventing the status change.
Would that work for you? If there are any global managers, they would just need to be added to every ship status.
-
It’s in the Shipping Status edit screen there is a station field. It does require a location and warehouse, we typically do an _ character to indicate we didn’t choose a specific one.
This maybe just a dead end.
-
Ah, so in the Shipping Status you have the Location field populated? Or Warehouse?
-
It woulld be easy enought to make a temporay fix via creating a trigger on that table on update.
As you update Quantum verions, that temporay fix would have to be ran again until they fix it.
I can look into making the SQL if there is interest.
-
Do you use the Aircraft Maintenance module? I think recreating the Shop Control Cost Analysis would not be all that difficult, what filters would you want to use?
-
I don’t believe we had any data loss, I tried to do various keywords and couldn’t find any SQL from Jason.
What keywords would be good to try and locate that post?
-
I’ve looked and cannot find the attachment.
-
Or go with like Zscaler or similar product to allow secure AD to Azure clients, just is billed at 50 users min. So that’s another way to do it.
-
Do you have a VPN between your AD on prim and Azure, so the machines in Azure can access the directory services? If so yes, if not I would think you would need to have Azure identifies for those users and utilize that (sync AD and Azure for them).
-
Ah! I’ll have to look into the possibilty of replacing those old URLs with ones that work with the new forum software.
-
On a side note, we are checking out Thinfinity Workspace. It’s RDP via HTML5 over HTTPS (Remote Browser Isolation) and the file uploads are very snappy compared to using RDP File sharing. Also allows 2FA to get into the Workspace.
Power users are not happy with the performance hit but most of the folks it works very well.
They are working on a browser plugin to allow remote USB devices, they already have one for like the Zebra barcode printer kind of situaiton.
Didn’t find a real good solution for this, I was going to try but have not yet:
-
For us on V10, if we update the WO Status it does not toggle released correctly. Our event manager job runs the SQL and sets it correctly. If RELEASE_WO is true, it does release the WO but if you change to a status where it’s false it does not update RELEASE_WO after that.
-
Yeah, it’s the way of the world. Rental software. Who knows maybe once.com will come out with one, they discussed it (sort of) on Twitter.
Investingating smallpdf.com to see as they are < $7 per user. Out of the ones I tested, it loaded the fastest which was nice. Who knows, maybe Word will drastically improve their PDF editing functions (joke).
All this Internet connected PDF editors are not allowed if you have ITAR or CUI in your enviornment.
-
When XI gets hit up with security (CVEs) issues, this is the way to go no doubt. Thanks Jae!
-
Right, we are on XI….
-
Ah! It’s https://smallpdf.com/ not simplepdf. Sorry about that.
smallpdf.com
Smallpdf.com - A Free Solution to all your PDF Problems
Smallpdf - the platform that makes it super easy to convert and edit all your PDF files. Solving all your PDF problems in one place - and yes, free.
-
Yes, that function returns a cursor. Glad it worked out.
-
Here is a Stack Overflow talking about VB.NET calling Oracle functions:
https://stackoverflow.com/questions/23453347/call-oracle-function-from-visual-basic
Granted this is very old but I think it shows the basic steps to do so in VB.NET
Private Sub SPU_SM_Header_Status()
Try
Dim connOracle As Oracle.DataAccess.Client.OracleConnection
Dim commOracle As New Oracle.DataAccess.Client.OracleCommand
Dim paramOracle As Oracle.DataAccess.Client.OracleParameter
connOracle = CreateConnection()
commOracle.Connection = connOracle
commOracle.CommandType = CommandType.StoredProcedure
commOracle.CommandText = "QC_SM_PKG.SPU_SM_HEADER_STATUS"
paramOracle = New Oracle.DataAccess.Client.OracleParameter
paramOracle.ParameterName = "smg_auto_key"
paramOracle.DbType = DbType.Int16
paramOracle.Value = 29888
paramOracle.Direction = ParameterDirection.Input
commOracle.Parameters.Add(paramOracle)
paramOracle = New Oracle.DataAccess.Client.OracleParameter
paramOracle.ParameterName = "sms_auto_key"
paramOracle.DbType = DbType.Int16
paramOracle.Value = 20
paramOracle.Direction = ParameterDirection.Input
commOracle.Parameters.Add(paramOracle)
paramOracle = New Oracle.DataAccess.Client.OracleParameter
paramOracle.ParameterName = "comment"
paramOracle.DbType = DbType.String
paramOracle.Direction = 'Y'
commOracle.Parameters.Add(paramOracle)
connOracle.Open()
commOracle.ExecuteNonQuery()
connOracle.Close()
Catch ex As Exception
lbOutput.Items.Add(ex.Message)
End Try
End Sub
stackoverflow.com
Call Oracle Function from Visual Basic
Unsure why my code is returning an error when called from VB, however similar code in PLSQL (Oracle) isn't returning the error. Oracle Function: CREATE OR REPLACE FUNCTION GET_CUST_STRING_FROM_DB (
-
This works in SQL Deveoper which I think should work in interactive Quantum SQL:
DECLARE
SMG_AUTO_KEY NUMBER := 29888;
SMS_AUTO_KEY NUMBER := 20;
COMMENT VARCHAR(10) := 'Y';
c qc_utl_pkg.cursor_type;
BEGIN
c := QC_SM_PKG.SPU_SM_HEADER_STATUS( SMG_AUTO_KEY, SMS_AUTO_KEY, COMMENT);
close c;
END;
/
-
Did you add the QC_SM_PKG. to just before the funciton name in your SQL string? I wouldn’t assume it is automatically finding it.
Is there a specific ORA code it is returning?
-
What language are you trying to write this in?
-
You could perhaps in the Users area create shifts and assing those to specific people, then have an Event Manager event that runs every 5 minutes or whatnot and if their shift is over, clock them out of the task if they forgot to clock out.
If overtime is authorized or they work an alternate shift, that would require a temporary change to their sift.
Might not be practical.
-
Will check out the options. Do you guys use Geo Code so you know which user is where?