4000009 Unknown Value

4000009 Unknown Value

Postby TammyJo » Thu Aug 16, 2012 1:34 pm

I am getting this error in a Result inbound in the ACS_ImpSetOrderResultWsync mapping. My initial assumption was that the QC_EntryName contained Basic Metobolic Panel (T), so I did a substitute ( to nothing and also ) to nothing. When I refile I see that the () is gone but I'm still getting the error and I'm not sure why? I do not see another field with any problems. Any help would be appreciated? Do I need to do something different instead of the Sub Sub?
You do not have the required permissions to view the files attached to this post.
TammyJo
 
Posts: 4
Joined: Thu Aug 11, 2011 12:25 pm

Re: 4000009 Unknown Value

Postby tsuacci » Thu Aug 23, 2012 10:55 pm

Tammy,

That error indicates a problem in the OID Sync table - Orderitem_identifier.

From the ACS_ImpSetOrderResultWsync SP:

select @count = count(*) from Orderitem_identifier
where EntryCode = @QC_EntryCode
AND ReqPerfLocDE = @RPL

If the count is greater than one, then this error code is returned. It means that you have the same RPL order code synced to multiple OID's. I would do an SSMT:Order Performing Facility Identifiers extract and search for the order code that is giving the error. You'll probably find the Performing Location Specific Orderable EntryCode assigned to multiple OID's. Find the one that is incorrectly synched, mark it for deletion, and import via SSMT. That should resolve the ConnectR error after a refile.

Tyler
Tyler Suacci
Consultant
Galen Healthcare Solutions
707.335.4710
tyler.suacci@galenhealthcare.com
tsuacci
 
Posts: 55
Joined: Mon Apr 04, 2011 12:08 pm


Return to Order/Result

Who is online

Users browsing this forum: No registered users and 1 guest

cron