42Q-MES0190-A Oracle Adapter Configuration Guide

From 42Q
Jump to navigation Jump to search

42Q Home > Tools > Oracle Adapter Configuration Guide

 

 

         

Tools
Oracle Adapter Configuration Guide
Version MES15.80
Revision A1

 

 

 

Introduction

This guide is designed to assist the users with the Post-Installation steps after installing the XX42Q Oracle Adapter.

Post Installation Setup

After installation, users need to set up the Attribute Lookup form and API program defaults form, and then schedule the Concurrent Managers.

42Q Attribute Lookup Form

  • Custom attributes are used to send additional fields to 42Q in the WO create/change XML in addition to the standard fields that are mapped in the 42Q Define Discrete Job form.
  • The 42Q Attribute Lookup form maps the custom attributes with the 42Q Attribute Name. 
  • As it is plant-specific, if the customer is required to map the same field for different organizations, they should add them in the new line.
  • 42Q Attribute lookup form is also used to map the additional attribute information that 42Q sends to the ERP in the WIP or Mat move transaction.
  • HANDS_ON_TIME is used as a custom attribute in the lookup form as it sends the time taken to complete each operation during the WIP Move in 42Q.
  • Users can add, delete, or update the required attribute tags as required.

 

Figure 1: 42Q Attribute Lookup

OC 42QAttributeLookup.png

 

FIELD NAME

DATA TYPE

DESCRIPTION

MANDATORY

Lookup Name

Varchar

Type of attribute

Yes

Plant

Varchar

The Organization in which the particular WO has been created.

Yes

Customer Attribute Name

Varchar

The name of the attribute.

Yes

Attribute Value

Varchar

The field ID that is to be included. Users are allowed to select only from the predefined list of values. By using this field ID, the values are fetched for the custom attribute name.

Yes

Enabled

Checkbox

Enable/Disable an XML attribute/tag from appearing in the WO outbound XML

No

 

The 42Q Attribute Lookup Form maintains four types of attributes depending on the location of the field. They are as follows:

 

WO_ATTRIBUTE

  1. The fields are available at the WO header level.
  2. To access navigate to 42Q Admin(OUR) > Discrete Jobs form.
  3. Enter the WO number and click Find

 

Figure 2:  Discrete Jobs Form

OC DiscreteJobsForm.png

 

WO_PART_ATTRIBUTE

  1. The fields that are available in the Organization item form for the assembly item, are used in the work order.
  2. To access navigate to Inventory > Items > Organization Items.
  3. Enter the Part number, and click Find.

 

Figure 3: Organization Item Form

OC OrganizationItemForm.png

 

 

WO_BOM_ATTRIBUTE

  1. The fields that are available and used in BOM are specific to the work order.
  2. To access navigate to 42Q Admin(OUR) > 42Q Define Discrete Jobs form 
  3. Enter the WO number, click Find, and click Components.

 

Figure 4: Components- Discrete Jobs form

OC ComponentsDiscreteJobsform.png

 

Figure 5: Material Requirement

OC MaterialRequirement.png

 

 

COMPONENT_PART_ATTRIBUTE

  1. It contains the fields that are available in the Organization item form for each component used in the work order.
  2. To access navigate to Inventory > Items > Organization Items 
  3. Enter the Component Item, and click Find.

 

Figure 6: Inventory tab

OC Inventorytab.png

       4. To find the Field name and value for all the forms, Select the field and navigate to Help > Diagnostics > Examine

 

Figure 7: Examine the Field name and Value

OC ExaminetheFieldnameandValue.png

 

 

HANDS_ON_TIME

  1. This attribute mapping is used to select the HANDS_ON_TIME from XML and post it in the mapped resources for each operation.
  2. HANDS_ON_TIME in the Lookup form consists of Organization, Operations, and Resources which are displayed in the Plant, Custom Attribute Name, and Attribute Value fields.

 

Figure 8: 42Q Attribute Lookup Form

OC 42QAttributeLookupForm.png

      3. While the 42Q performs WIP moves, each operation contains different resources.
      4. The HANDS_ON_TIME  value of the resources has been updated based on two charge types: Wip Move and Manual.

 

Figure 9: Charge types
OC Chargetypes.png

  • If the Charge type is WipMove, no action will occur from the adapter. The oracle will post the standard WO resource value. To access, navigate to Manufacturing Manager> Bill of Materials > Routing > Standard Operations > Click the form button Operation Resources.

 

Figure 10: WIP Charge type

OC WIPChargetype.png

  • If the Charge type is Manual, the adapter will check for the toggle ‘Post Hands on Time’ in the 42Q API Program default form.

 

Figure 11: Post Hands on Time 

OC PostHandsonTime .png

If ‘Post Hands on Time’ is enabled, the adapter will check whether the resources are mapped in the lookup form.

 

Figure 12: 42Q Attribute Lookup form

OC 42QAttributeLookupform.png

The HANDS_ON_TIME value from 42Q will be updated in the WO resource field, only for the mapped resources. 

OC WIP.png

 

Figure 13: Costing Tab

OC Costingtab.png

 

Figure 14: Quantities Tab 

OC QuantitiesTab .png

The HANDS_ON_TIME value from the WipMove XML will be converted from seconds to hours and posted in the resource field.

If the resources are not mapped in the lookup form, then the standard resource value will be updated in the WO.

 

Figure 15: 42Q Attribute Lookup form

OC 42QAttributeLookupform1.png

To access, navigate to Manufacturing Manager> Bill of Materials > Routing > Standard Operations > Click the form button Operation Resources.

 

Figure 16: Manual Charge Type

OC ManualChargeType.png

 

Figure 17: Main Tab

OC MainTab.png


In the WO Resource field

 

Figure 18: Main Tab Setup

OC MainTabSetup.png

 

Figure 19: Quantities Tab

OC QuantitiesTab.png

If ‘Post Hands on time’ is not enabled, users should manually enter the resource value. Thus, no action will be taken by the adapter for the ‘HANDS_ON_TIME’ sent from the 42Q WIP move.

 

Figure 20: Post Hands on time check box

OC PostHandsontimecheckbox.png

Before entering the values manually,

 

Figure 21: Resource Requirement Coasting Tab

OC ResourceRequirementCoastingTab.png

 

Figure 22: Resource Requirement Quantities Tab

OC ResourceRequirementQuantitiesTab.png

Enter the values manually for resources
To access, navigate to Order Management Super User, Vision Operations(USA) > WIP> Resource Transactions.

 

Figure 23: Transaction Tab

OC TransactionTab.png

In the WO Resources:

 

Figure 24: Resource Requirement Quantities Tab

OC ResourceRequirementQuantitiesTab(1).png

 

 


42Q API Program Defaults Form

  1. The 42Q URL field is used to send each outbound transaction from Oracle.
  2. After the WO creation, the preliminary validation will happen in the table XX42Q_MDSWIP_DEFAULT_PARAMS by using fields such as Org ID, Application, and Project ID.
  3. Only after the preliminary validation, the adapter will allow inbound and outbound transactions.
  4. To access, navigate to 42Q Admin(OUR) > 42Q API Program Defaults.

 

Figure 25: 42Q API Program Defaults Form

OC 42Q APIProgramDefaultsForm.png

 

FIELD NAME

DATA TYPE

DESCRIPTION

MANDATORY

Application

Varchar

42QMES (This is a default value for this interface)

Yes

Organization Code

Varchar

This is the Discrete Job (DJ) Inventory Organization code considered for interfacing with 42QMES Job Processing. The adapter will pick the Discrete Jobs, created under this inventory organization only.

Yes

Project ID

Varchar

Customer Code | Organization code

Yes

Activation Date

Date

Work Orders created from this date are only considered for interfacing with 42QMES.

Yes

Scrap Account

Varchar

This is the inventory scrap account that will be considered by the adapter when a work order quantity has to be scrapped or WIP move transaction received has a scrap transaction.

Yes

ORG Default

Varchar

INCLUDE (This is a default value)

Yes

Completion Subinventory

Varchar

The sub-inventory where the completed assemblies should be available when WIP completion transactions are processed.

Yes

Completion Locator

Varchar

The sub-inventory locator where the completed assemblies should be available when WIP completion transactions are processed.

Yes

Backflush Subinventory

Varchar

This is the supply sub-inventory code for backflush of components.

No

Backflush Locator

Varchar

This is the supply sub-inventory locator for backflush of components.

No

Customer Code

Varchar

Enter the Customer code setup/provided by 42Q.

Yes

Complete without all Push Mat

Varchar

If the check box is enabled, the adapter will bypass the PUSH components validation while completing the WIP job quantity. Thus, the work orders can be completed without PUSH items material issues.

No

Post Hands On Time

Varchar

If the check box is enabled, It Identifies all the resource transactions whose charge type is “Manual” and whose from operation and resource codes are set up in the custom Lookup table.

If disabled, it ignores the procedure call to process hands on time.

No

Online Call for Route/Component

Varchar

If the checkbox is enabled, an online call will be triggered. If the checkbox is disabled no online call will not be triggered.

Yes

Online call URL

Varchar

Outbound URL for online web service call for verifying if the job quantity can be decreased or not in Oracle.

Yes

42Q URL

Varchar

The endpoint URL for all the outbounds from Oracle.

Yes

Notify User

Varchar

User Details

No

Notify Responsibility

Varchar

Responsibility Details

No

Notify Program

Varchar

Calls the customer’s ERP program details

No

Serial validation Flag

Varchar

-

No

Customer Intent Enabled

Varchar

-

No

 

Schedule Concurrent Managers

This action is intended for Oracle DBA/SysAdmin only, once this option is selected, follow the next steps: 

 

Setting up of XX42Q concurrent managers 

  1. Navigate to Inventory > Setup > Transactions > Interface Managers

 

Figure 26: Navigation to Interface Managers
OC NavigationtoInterfaceManagers.png

       2. Select Material Transaction > Tools 

       3. Ensure the below Managers are active.

 

Figure 27: Interface Managers 

OC InterfaceManagers.png

 

 

Schedule the below Concurrent programs from 42Q Admin(OUR)

  1. 42Q WIP Job Extract and Webservice Outbound 
  2. 42Q Shipment Notification Extract and Webservice Outbound 
  3. 42Q WIP Move and Material Issue Inbound Processing with ACK

 

 Scheduling the Concurrent Programs

  1. Navigate to the respective responsibility where the concurrent program is to be scheduled exists.
  2. Then, navigate to View > Requests and click on Submit a New Request

 

Figure 28: Submitting a New Request
OC SubmittingaNewRequest.png

 

Figure 29: New request confirmation

OC Newrequestconfirmation.png

     3. Enter the concurrent program name to be scheduled and the respective parameters and click Schedule.
 

Figure 30: Run the Request
OC RuntheRequest.png   

    4. A Schedule window will appear. 

 

Figure 31: Schedule Window 

OC ScheduleWindow .png

  5. The user has to specify the interval/frequency that requires the program to run and click OK. 
  6. Then, Click on the Submit.

 

Figure 32: Submit the schedule 
OC Submittheschedule.png