Business Function Specification
Source NameB7900040DesignerKevin Clearwater
Data Structure D7900040ProgrammerKevin Clearwater
Function NameExtractFDASpecSystem CodeH79
Function Category
Function Use
Revisions Log
DateModifications bySAR NumberDescription
10/1700Kevin Clearwater4458107CM Token OneWorld Application
1.Functional Description
1.1Purpose
The purpose of this function is to convert FDA spec records (F98750, F98751) into a non-blob format so that they can read and be displayed by an
interactive application's grid.
1.2Setup Notes and Prerequisites
This function is intended for use only with Content Manager while in Non-Delta Mode.
1.3Special Logic
Multiple Environments must be opened within the BSFN so th ePO accepts environment names not data source names therefore the table F98750 and
F98751 must be mapped within an environment. Usually they are not because the apps that use FDA spec ignore OCM for those tables.
Must be run from UBE. API's used are only supported in UBE batch engine.
2.Technical Specifications
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
DELTATBLEszDeltaTableIYUse F79750. This will tell the function that we are converting FDA spec.
DELTASRCSzDeltaSourceEnvironIYSource environment that the source for the FDA spec exists (F98750, F98751).
DELTADESTSzDeltaDestinationEnvironIYDestination Environment that you want the F79751 records exist.
MATH01MnMaxCacheINDon't Use
MATH01MnMaxErrorsINMax Number of errors allowed before the process will stop.
EV01CErrorCodeONError code passed out (Fatal, Minor, Success)
DELTATOTMnTotalRecordsONNumber of total records processed
DELTACHGMnChangeRecordsONNumber of changed records
EV01CCompareWithCacheIYAlways 1 so that cache is not used
OBNMSzFromObjectNameINPasses in from PO for range. If no range then all will be processed.
OBNMszToObjectnameINPasses in from PO for range. If no range then all will be processed.
2.2Related Tables
Table Table Description
2.3Related Business Functions
Source NameFunction Name
2.4Processing
Pass in object Range or not.
Convert all F98750 and F98751 records from their BLOB state into a readable format in the F79751 table
Report records changed and errors of occured
D7900040 - Content Manager FDA Spec and Text BLOB Conversion
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szDeltaTable | DELTATBLE | char | REQ | INPUT |
The table name of the delta table. Delta table include the following:
F0004 - User Defined Code Types
F0005 - User Defined Codes
| ||||
| szDeltaSourceEnviron | DELTASRC | char | REQ | INPUT |
The delta source environment is the production environment to check the English text with a destination translation compare environment.
| ||||
| szDeltaDestinationEnviron | DELTADEST | char | REQ | INPUT |
A code that specifies the delta destination environment. The delta destination environment is the translation compare environment to
| ||||
| mnMaxCache | MATH01 | MATH_NUMERIC | OPT | INPUT |
- - - Good Performance Low Value. | ||||
| mnMaxErrors | MATH01 | MATH_NUMERIC | OPT | INPUT |
- - - Good Performance Low Value. | ||||
| cErrorCode | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
| mnTotalRecords | DELTATOT | MATH_NUMERIC | OPT | OUTPUT |
A number that indicates the total records processed per table when the delta process completes. | ||||
| mnChangeRecords | DELTACHG | MATH_NUMERIC | OPT | OUTPUT |
The total number of records per table that changed status after a delta process completed. | ||||
| cCompareWithCache | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
| szFromObjectName | OBNM | char | OPT | NONE |
The name that identifies a system object. J.D. Edwards ERP architecture is object-based. Discrete software objects are the building blocks
| ||||
| szToObjectname | OBNM | char | OPT | NONE |
The name that identifies a system object. J.D. Edwards ERP architecture is object-based. Discrete software objects are the building blocks
| ||||
| None |
| None |