9 Processing Interoperability for Product Data Management

This chapter contains the following topics:

9.1 Processing Outbound Interoperability for Product Data Management

This section provides an overview of outbound interoperability for Product Data Management, lists a prerequisite, and discusses how to:

  • Set selected processing options for Work Center Revision (P3006).

  • Set processing options for Workday Calendar (P00071).

  • Set selected processing options for Enter/Change Bill (P3002).

  • Set selected processing options for Work With Routing Master (P3003).

9.1.1 Understanding Outbound Interoperability for Product Data Management

You might send transactions that you create or change in Product Data Management to another system. For example, if the organization uses hand-held scanning devices, you can use interoperability transactions to update the database that is used by the scanning devices.

To process outbound interoperability in JD Edwards EnterpriseOne Product Data Management:

  1. Specify a transaction type in the processing options of the originating programs listed in the table that follows these steps.

  2. Enter or change a transaction using any of the originating programs.

    The JD Edwards EnterpriseOne Product Data Management system calls a business function that writes records to the corresponding transaction table listed in the table that follows these steps. For example, when you run the Work Center Revision program (P3006) with the interoperability processing option turned on, the system places a copy of updated work center data in the Work Center Transaction File table (F30006Z1).

    The same business function calls a special subsystem API that sends a message to the subsystem kernel running on the server. The subsystem kernel adds a record to the Subsystem Job Master table (F986113).

  3. Create a custom UBE or function to process the data from the transaction tables in such a way that it can be used by the external system.

  4. Use the Data Export Controls program (P0047) to specify the custom UBE or function for the transaction type you specified in the processing options of the originating program.

    The system stores this information in the Data Export Control table (F0047).

  5. Run the Interoperability Generic Outbound Subsystem UBE program (R00460).

    The Interoperability Generic Outbound Subsystem UBE program fetches the F986113 record and retrieves the name and version of the custom UBE from the F0047 table. The Interoperability Generic Outbound Subsystem UBE program passes information about the order to the custom UBE. The custom UBE then retrieves the records from the transaction tables and processes that information.

You can send transactions to an external system from these programs in Product Data Management:

  • Work Center Revision (P3006)

  • Work Day Calendar (P00071)

  • Enter/Change Bill (P3002)

  • Work With Routing Master (P3003)

Originating Program Transaction Type Transaction Table
Work Center Revision (P3006) JDEWC Work Center Transaction File (F30006Z1)
Workday Calendar (P00071) JDEWDC Work Day Calendar Transaction File (F0007Z1)
Enter/Change Bill (P3002) JDEBOM Bill of Material Transaction File (F3002Z1)
Work With Routing Master (P3003) JDEROU Routing Transactions File (F3003Z1)

9.1.2 Prerequisite

Define the data export controls for the type of outbound transaction. The system uses data export controls to determine the batch programs or business processes that third parties supply for use in processing transactions.

See Setting Up Data Export Controls.

9.1.3 Setting Selected Processing Options for Work Center Revision (P3006)

This section lists only the processing options for the Work Center Revision program (P3006) that are specific to outbound interoperability.

9.1.3.1 Interop

You use these processing options to set up outbound interoperability.

1. Enter the transaction type for the interoperability transaction.

Specify the transaction type for the interoperability transaction. If you leave this processing option blank, the outbound interoperability is not performed.

Note:

We provide transaction type JDEWC for work center transactions.
2. Enter a '1' to write before images for Outbound change transactions.

Specify whether the system creates a record of the work center transaction before it was changed, in addition to a record of the work center transaction after the change. The system creates these records in the Work Center Transaction File table (F30006Z1) when outbound interoperability processing is enabled. Values are:

Blank: Write the work center record only after it has been changed; do not write a before image record.

1: Write two work center records: one before the work center transaction is changed and one after the work center transaction is changed.

9.1.4 Setting Processing Options for Workday Calendar (P00071)

This section lists all the processing options for the Workday Calendar program (P00071).

9.1.4.1 Interop

You use these processing options to set up outbound interoperability.

Type - Transaction

Specify the transaction type for the interoperability transaction. If you leave this processing option blank, the outbound interoperability is not performed.

Note:

We provide transaction type JDEWDC for workday calendar transactions.
Before Image Processing

Specify whether the system creates a record of the workday calendar transaction before it was changed, in addition to a record of the workday calendar transaction after the change. The system creates these records in the Work Day Calendar Transaction File table (F0007Z1) when outbound interoperability processing is enabled. Values are:

Blank: Write the workday calendar record only after it has been changed; do not write a before image record.

1: Write two workday calendar records: one before the workday calendar transaction is changed and one after the workday calendar transaction is changed.

9.1.5 Setting Selected Processing Options for Enter/Change Bill (P3002)

This section lists only the processing options for the Enter/Change Bill program (P3002) that are specific to outbound interoperability.

9.1.5.1 Interop

You use these processing options to set up outbound interoperability.

1. Transaction Type

Specify the transaction type for the interoperability transaction. If you leave this processing option blank, the outbound interoperability is not performed.

Note:

We provide transaction type JDEBOM for bill of material transactions.
2. Write Image for a Change Transaction

Specify whether the system creates a record of the bill of material transaction before it was changed, in addition to a record of the bill of material transaction after the change. The system creates these records in the Bill of Material Transaction File table (F3002Z1) when outbound interoperability processing is enabled. Values are:

Blank: Write the bill of material record only after it has been changed; do not write a before image record.

1: Write two bill of material records: one before the bill of material transaction is changed and one after the bill of material transaction is changed.

3. Interoperability Outbound (R00460)

Specify the version of the Interoperability Outbound Subsystem program (R00460) that the system uses for export processing. If you leave this processing option blank, the system uses the ZJDE0001 version.

Versions control how the Interoperability Outbound Subsystem program displays information. Therefore, you might need to set the processing option to a specific version to meet your needs.

9.1.6 Setting Selected Processing Options for Work With Routing Master (P3003)

This section lists only the processing options for the Work With Routing Master program (P3003) that are specific to outbound interoperability.

9.1.6.1 Interop

You use these processing options to set up outbound interoperability.

1. Transaction Type

Specify the transaction type for the interoperability transaction. If you leave this processing option blank, the outbound interoperability is not performed.

Note:

We provide transaction type JDEROU for routing transactions.
2. Outbound Processing Version

Specify the version that the system uses when you access the Outbound Processing program (R00460) from the Enter/Change Routing form. If you leave this processing option blank, the system uses version ZJDE0001

3. Before Image Processing

Specify whether the system creates a record of the routing transaction before it was changed, in addition to a record of the routing transaction after the change. The system creates these records in the Routing Transactions File table (F3003Z1) when outbound interoperability processing is enabled. Values are:

Blank: Write the routing record only after it has been changed; do not write a before image record.

1: Write two routing records: one before the routing transaction is changed and one after the routing transaction is changed.

9.2 Processing Inbound Interoperability for Product Data Management

This section provides an overview of inbound interoperability for Product Data Management, lists prerequisites, and discusses how to:

  • Set processing options for Process Inbound Routing (R3003Z1I)

  • Run the inbound processing programs.

9.2.1 Understanding Inbound Interoperability for Product Data Management

In an inbound transaction, you accept data from another system into this system.

9.2.1.1 Inbound Work Center Data

The Inbound Flat File Conversion program (R47002C) copies the data from a flat file to the Work Center Transaction File table (F30006Z1) if you have set up a flat file cross-reference to this table.

Note:

We provide transaction type JDEWC for work center transactions.

You run the Process Inbound Work Center program (R30006Z1I) to copy the information from the F30006Z1 table to the Work Center Master File table (F30006).

9.2.1.2 Inbound Work Day Calendar Data

The Inbound Flat File Conversion program (R47002C) copies the data from a flat file to the Work Day Calendar Transaction File table (F0007Z1) if you have set up a flat file cross-reference to this table.

Note:

We provide transaction type JDEWDC for work day calendar transactions.

You run the Process Inbound Work Day Calendar DC program (R0007Z1I) to copy the information from the F0007Z1 table to the Workday Calendar table (F0007).

9.2.1.3 Inbound Bill of Material Data

The Inbound Flat File Conversion program (R47002C) copies the data from a flat file to the Bill of Material Transaction File table (F3002Z1) if you have set up a flat file cross-reference to this table.

Note:

We provide transaction type JDEBOM for bill of material transactions.

You run the Process Inbound Bill of Material program (R3002Z1I) to copy the information from the F3002Z1 table to the Bill of Material Master File table (F3002).

9.2.1.4 Inbound Routing Data

The Inbound Flat File Conversion program (R47002C) copies the data from a flat file to the Routing Transactions File table (F3003Z1) if you have set up a flat file cross-reference to this table.

Note:

We provide transaction type JDEROU for routing transactions.

You run the Process Inbound Routing program (R3003Z1I) to copy the information from the F3003Z1 table to the Routing Master File table (F3003).

9.2.2 Prerequisites

Before you complete the tasks in this section:

9.2.3 Setting Processing Options for Process Inbound Routing (R3003Z1I)

Processing options enable you to specify the default processing for programs and reports.

9.2.3.1 Versions

Version

Specify a version of the Work With Routing Master program (P3003). If you leave this processing option blank, the system uses version ZJDE0001

9.2.4 Running the Inbound Processing Programs

To process inbound work center data, select Product Data Interoperability (G30311), Process Inbound Work Center Transactions.

To process inbound work day calendar data, select Product Data Interoperability (G30311), Process Inbound WDC Transactions.

To process inbound bill of material data, select Product Data Interoperability (G30311), Process Inbound BOM.

To process inbound routing data, select Product Data Interoperability (G30311), Process Inbound Routing.

9.3 Reviewing and Revising Interoperability Transactions for Product Data Management

This section provides an overview of reviewing and revising inbound interoperability transactions for Product Data Management, lists the forms used to review and revise interoperability transactions for Product Data Management, and discusses how to:

  • Set common processing options for revision programs.

  • Set additional processing options for Bill Of Material Transaction Revisions (P3002Z1).

9.3.1 Understanding Reviewing and Revising Interoperability Transactions for Product Data Management

Running one of the transaction processes, such as the Work Center Transaction Revisions, often identifies one or more inbound transactions that contain invalid transactions. For example, a work center might have an invalid location branch. In that case, the program cannot add that work center to the Work Center Master File table (F30006). Instead, the program sends an error message to the Employee Work Center indicating the transaction number for the transaction in error.

Use the inquiry menu selections to add, change, or delete transactions containing errors. Then run the transaction process again. Continue to make corrections and rerun the transaction process until the program runs without errors.

You can also use the inquiry menu selects to review and revise outbound transactions.

9.3.2 Forms Used to Review and Revise Interoperability Transactions for Product Data Management

Form Name FormID Navigation Usage
Work Center Transaction Revisions W30006Z1B Product Data Interoperability (G30311), Work Center Transaction Revisions

Locate a transaction and click Select.

Review and revise inbound transactions.

After you correct the errors that are identified by the Process Inbound Work Center, run the transaction process again.

Work Day Calendar Transaction Revisions W0007Z1B Product Data Interoperability (G30311), WDC Transaction Revisions

Locate a transaction and click Select.

Review and revise inbound transactions.

After you correct the errors that are identified by the Process Inbound Work Day Calendar DC, run the transaction process again.

Bill of Material Transactions Revisions W3002Z1B Product Data Interoperability (G30311), Bill of Material Transaction Revisions

Locate a transaction and click Select.

Review and revise inbound transactions.

After you correct the errors that are identified by the Process Inbound Bill of Material, run the transaction process again.

Revise Routing Transactions W3003Z1B Product Data Interoperability (G30311), Routing Transaction Revisions

Locate a transaction and click Select.

Review and revise inbound transactions.

After you correct the errors that are identified by the Process Inbound Routing, run the transaction process again.


9.3.3 Setting Common Processing Options for Revision Programs

The revision programs use many of the same processing options. The processing options discussed in this section apply to:

  • Work Center Transaction Revisions (P30006Z1)

  • WDC Transaction Revisions (P0007Z1)

  • Bill of Material Transaction Revisions (P3002Z1)

  • Routing Transaction Revisions (P3003Z1)

Level of Inquiry

Specify the type of processing for an event. Values are:

Blank: Inquire at the transaction level.

1: Inquire at the batch level.

Processed Status.

Specify the type of processing for an event. Values are:

Blank: Both Possessed and Unprocessed

1: Processed

2: Unprocessed

Direction

Specify a flag that indicates that data is case sensitive. Values are:

Blank: Both Inbound and Outbound

1: Inbound

2: Outbound

9.3.4 Setting Additional Processing Options for Bill of Material Transaction Revisions (P3002Z1)

The Bill of Material Transaction Revisions program has a unique processing option in addition to the processing options that are common to all of the revision programs.

9.3.4.1 Versions

Default Version:

Enter the version for Processed Inbound Bill of Material to submit. If you leave this processing option blank, the system uses ZJDE0001.

9.4 Purging Interoperability Transactions for Product Data Management

This section provides an overview of purging interoperability transactions and discusses how to purge interoperability transactions.

9.4.1 Understanding Purging Interoperability Transactions

When data becomes obsolete or when you need more disk space, you can use the Purge Interoperability Table programs to remove data from the interoperability tables.

Product Data Management contains purge options for both inbound and outbound transactions. Use these purges to remove data from the corresponding interoperability tables:

  • Purge Work Center Transactions (R30006Z1P)

  • Purge Work Day Calendar Transactions (R0007Z1P)

  • Purge BOM Transactions (R3002Z1P)

  • Purge Routing Transactions (R3003Z1P)

For records in the Processing Log table (F0046) that are marked as processed, the program purges the associated transactions in the corresponding interoperability tables, as well as the records in the F0046 table. If the records in the F0046 table are not marked as processed, the program does not purge any records.

See JD Edwards EnterpriseOne Tools Interoperability Guide

9.4.2 Purging Interoperability Transactions

To purge interoperability transactions for work center transactions, select Product Data Interoperability (G30311), Purge Work Center Transactions.

To purge interoperability transactions for workday calendar transactions, select Product Data Interoperability (G30311), Purge WDC Transactions.

To purge interoperability transactions for bill of material transactions, select Product Data Interoperability (G30311), Purge BOM Transactions.

To purge interoperability transactions for routing transactions, select Product Data Interoperability (G30311), Purge Routing Transactions.