This chapter contains the following topics:
This section provides overviews of inbound interoperability and of the Inbound Flat File Conversion program and discusses how to:
Run the Inbound Flat File Conversion program (R47002C).
Set processing options for the Inbound Flat File Conversion program (R47002C).
The external system sends data to JD Edwards EnterpriseOne interface tables, which hold the data before it is copied to the application tables.
The external system is responsible for conforming to the format and other requirements of the interface tables. If the external system cannot write the information in the required format, it can write the data to a flat file, and you can use the Inbound Flat File Conversion program to convert the data to the required format.
You run a transaction process (a batch program) that validates the data, updates valid data from the interface tables to the JD Edwards EnterpriseOne application tables, and sends action messages to the Employee Work Center about invalid data.
You use an inquiry function to interactively review and revise the incorrect data, and then run the transaction process again.
You repeat this step as often as needed to correct errors.
When receiving data, the system stores the unedited data sent from the external system in interface tables. With this method, unedited transactions do not affect application tables. The next step is to run the appropriate transaction process to edit the transactions and update the appropriate application tables.
To be received into the interface tables, data from an external system must conform to the minimum field requirements specified for the interface table.
The receiving transaction process performs these tasks:
Validates the data in the interface table to ensure that data is correct and conforms to the format defined for the application table system.
Updates the associated application table with validated data.
Produces a report that lists invalid transactions and sends an action message for each invalid transaction to the Employee Work Center.
Marks, in the interface tables, those transactions that have been successfully updated to the application tables.
If the report indicates errors, access the Employee Work Center from Workflow Management (G02) and review the messages in the message center. Then use the associated inquiry function to review and revise the transactions and to rerun the transaction process.
Note:When you run the Inbound Flat File Conversion program (R47002C) and it completes successfully, the system automatically starts the transaction process if that action is specified in the processing option for the conversion.
You use the Inbound Flat File Conversion program (R47002C) to import flat files into JD Edwards EnterpriseOne interface tables. You can create a separate version of the Inbound Flat File Conversion program for each interface table. This program recognizes both the flat file from which it reads and the record types user-defined code (UDC) (00/RD) within the flat file. Each flat file contains records of differing lengths, based on the interface table record to which they correspond. The Inbound Flat File Conversion program uses the Flat File Cross-Reference Table (F47002) to convert the flat file into the interface tables. The F47002 table indicates to the conversion program which flat file to read from and which interface table to use, based on the transaction type that you are receiving.
The conversion program reads each record in the flat file and maps the record data into each field of the interface tables, based on the text qualifiers and field delimiters that are specified in the flat file.
The conversion program inserts the field data as one complete record in the interface table. If the conversion program encounters an error while converting data, it withholds the data in error and continues processing the conversion. If the data is successfully converted, the system automatically starts the transaction process for that interface table, provided that you set the processing options in the conversion program to do so.
Use one of these navigations:
Select Condition-Based Maintenance Interoperability (G13CBM311), Inbound Condition-Based Alerts Flat File Conversion.
Select Forecast Interoperability (G36301), Inbound Flat File Conversions.
Select Inventory Interoperability (G41313), Inbound Flat File Conversion.
Select Meter Reading Interoperability (G1332), Inbound Meter Readings File Conversion.
Select Product Data Interoperability (G30311), Inbound Flat File Conversion.
Select Purchasing Interoperability (G43A313), Inbound Flat File Conversion.
Select Electronic Commerce Interoperability (G47311), Inbound Flat File Conversion.
Select Shop Floor Management Interoperability (G31311), Inbound XX Flat File Conversion, where XX is the process that the conversion completes, such as Inbound Completion Flat File Conversion.
Specify the type of transaction (00/TT) to be processed.
This value identifies the interoperability transaction type used to convert the flat file.
Specify the separator used to delimit fields.
The field delimiter is used by the system to identify field separation. For example, if you specify the field delimiter as a comma (,), order number and order type flat file entries would be:
"Order Number", "Order Type"
Specify the text qualifier that surrounds text value objects.
Specify the batch processor to run after the conversion completes successfully.
Indicate the version of inbound processor to use during inbound conversion. If you leave this processing option blank, the system uses XJDE0001.
This section provides an overview of outbound interoperability and lists a prerequisite.
You might need to send transactions that you create or change in the JD Edwards EnterpriseOne system to an external system. For example, you might need to send information about changes on a journal entry or a purchase order to an external system.
To enable outbound processing, you specify a transaction type in the processing options of the appropriate originating program or interoperability processing options program. Additionally, some entry programs enable you to specify a version of the Master Business Function Processing Options program that, in turn, enables you to specify a version of the Interoperability Processing Options program. You can differentiate outbound transactions by transaction type by creating multiple versions of the interoperability processing option programs. For example, you might want to differentiate vouchers that are generated by Procurement from vouchers that are generated manually.
Using the master business function for the type of transaction, the system creates a copy of the transaction and places it in the interface table where external systems can access it.
If a program modifies a transaction without going through the master business function, the system still sends a copy of the transaction to the interface table where external systems can access it.
The default outbound transaction is a copy of a transaction after you create or change it (an after image). With interoperability, you can also send a copy of each transaction as it was before you changed it (a before image). To control the type of image, you set a processing option on the appropriate interoperability processing options program.
Note:Creating and sending before images requires additional processing time.
The system places a copy of each transaction in the interface table (Z table) that corresponds to the type of transaction that you specify in the processing option. The system also adds a record to the Subsystem Job Master table (F986113).
To retrieve the data from the interface tables:
Create a custom UBE (universal batch engine) or function to process the data from the interface tables in such a way that it can be used by the external system.
Use the Data Export Controls program (P0047) to specify the custom UBE or function for the transaction type you specified in the interoperability processing options.
The Interoperability Generic Outbound Subsystem UBE program fetches the F986113 record and retrieves the name and version of the custom UBE or function from the F0047 table. The Interoperability Generic Outbound Subsystem UBE program passes information about the transaction to the custom UBE or function. The custom UBE or function then retrieves the records from the interface tables and processes that information.
Define the data export controls for the type of outbound transaction.
The system uses data export controls to identify the batch programs or business processes that third parties provide for use in processing transactions.
This section provides an overview of the processing log and lists the form used to review the processing log.
You use the processing log to review whether the system has processed specific outbound transactions successfully. The system creates a record in the processing log for every outbound transaction that is processed. The processing log contains key fields from the F0047 table, such as transaction type, sequence number, batch process or function, and corresponding version.
The information in the processing log is for review only and cannot be changed in the processing log.
|Work With Processing Log||W0046A||You can access the Work With Processing Log form through multiple navigation paths. This list presents the most frequently used paths:
Inventory Interoperability (G41313), Processing Log
Financials Interoperability Processing (G00313), Processing Log
Forecast Interoperability (G36301), Processing Log
Product Data Interoperability (G30311), Processing Log
Purchasing Interoperability (G43A313), Processing Log
Sales Interoperability (G42A313), Processing Log
Shop Floor Management Interoperability (G31311), Processing Log
|Review the processing log.|