Transcript SCMnet Troubleshooting Tips Cass Smith Business Systems Analyst

SCMnet Troubleshooting Tips
Tips for resolving common Agile to Oracle transfer issues
Cass Smith
Business Systems Analyst
Symmetricom
[email protected]
Agenda
 Review basic transfer process
 Questions to ask
 Checking change orders in the SCMnet GUI
 Common problems and what to do
 Additional Info
 Questions?????
Agile – Oracle Transfer
Key Questions
 Was the PDX file exported from Agile?
 Were there processing errors in SCMnet?
 Did batch processes complete in Oracle?
Agile Questions

What status should trigger the export?

What is the current status of the change order?

Did an export occur?

Was a change made in Agile after the export?
SCMnet Questions

Is the status Pending or Locked or Cancelled?

Is the status Errored?

Can you find the CO using ‘Search COs’?

Is SCMnet polling PLM files?

Is SCMnet processing Change Orders?

Are SCMnet customizations working as expected?
Oracle Questions

Did the ‘Engineering Change Order Implementation’
request run (if ECOs are not manually implemented)?

Is the Item/BOM in Prototype Engineering rather than
Manufacturing?
Checking Status in SCMnet
Click on ‘Search COs’ and enter
the change order number
Then click on the
‘Search’ button
SCMnet – Search COs Results
Note that other change
orders may also be
displayed because it ends
with the change order
number you entered.
Log Error Messages
Some error messages to look for and what to do –
Data Issues
Error Message
What’s Wrong
How to Fix It
Invalid <attribute value> … for item <part
number>
You must enter an item revision for revised
item <part number> that is greater than or
equal to the current revision
Value too large for column ... reference
designator
Failed to get OLD_EFFECTIVITY_DATE for
Assembly: <BOM assembly number>
Component: <BOM component number>
The attribute value in Agile is not valid in
org(s) in Oracle
The new revision for an item is not
alphanumerically higher than the old revision
Activate the <attribute value> in the needed
org(s) in Oracle - or - correct the value in Agile
In Agile, change the new revision to something
higher than the old revision
<part number> does not exist in
<organization>
Agile ref des field cannot be limited to 15
In Agile, reduce the reference designator to no
characters, this is the max Oracle allows
more than 15 characters (including spaces)
BOM ID Synchronization issue - either value is Enter correct value in DFF in Oracle or run
not in SCMnet cross reference or is
BOM ID Synchronization
missing/incorrect in Oracle BOM Component
DFF
Item has been assigned to an Organization in Assign the item to the Organization in Oracle Agile but is not assigned to the Organization in or - correct the data in Agile
Oracle
More Log Error Messages

Processing Issues
Error Message
What’s Wrong
How to Fix It
<Oracle attribute> can not be updated since
Onhand <attribute type> quantity exists
A template is being applied or attribute is
being updated that will change an item
attribute that can only be changed when QOH
= 0 in all orgs
Contact the stockroom(s) where QOH exists to
have them temporarily issue the parts to an
account so QOH = 0 in Oracle. After the
change order has processed, all the stockroom
should receive the parts from the account
back to the correct subinventories.
Cancel this .PDX in SCMnet
<change order> already exists
Another .PDX file for this change order has
already completed
File exported from Agile but cannot be found SCMnet is not finding and/or processing new Use buttons 'Poll PLM Files' and 'Process
in SCMnet using 'Search COs'
PDX files
Change Orders' on SCMnet GUI or stop/restart
scheduled SCMNet task on Agile applications
server
Change order is locked in SCMnet by another Previous change order that has items in
Either resolve the error so the previous
change order
common (possibly in subassemblies of
change order completes or cancel the
Affected Items) is errorred in SCMnet
previous change order in SCMnet (this will
allow the new change order to process)
Circular lock on change orders processing thru Multiple change orders that have items in
Run script that updates status of affected
SCMNet (multiple change orders locking each common (possibly in subassemblies of
changes orders in SCMnet tables. The script
other)
Affected Items) are locked waiting for each
should set these change orders to
other to process in SCMnet
'CANCELLED' then they can be resubmitted
one at a time.
SCMnet GUI cannot be opened
Service on application server has stopped
restart Apache Tomcat service on Agile
application server
Where to Retry

If correction was made in Oracle – resubmit the change
order in SCMnet

If correction was made in Agile – cancel the current PDX in
SCMnet then re-release the change order in Agile

If Dependency Check is turned off (SCMnet stops
processing when it hits an error) – cancel dependent
change orders in Pending queue before cancelling change
order with error
Where is it stored?

PDX files and related scripts are stored on the Agile
application server

SCMnet mapping tables and SCMnet procedures are
stored in the SCMnet schema in the Oracle instance
Set Up/Link Instances

Set up folders on Agile Test server with exactly the same
names as are/will be used on Agile Production server
(necessary to maintain links after refresh)

When the Test Oracle instance is refreshed, refresh the
linked Agile instance, too.
For More Info

SCMnet 4.1 Installation and Configuration Guide
(includes instructions for BOM ID Synchronization)

Agile Documentation http://www.oracle.com/technology/documentation/agile.
html
Q and A

Questions?????