 |
| |
Frequently Asked Questions (FAQ's)
|
Summary:
I need to do a table
conversion without using the TC tool. Is it just a matter of doing the ER in a
BV instead of in the TC?
Full Article:
Answer1
We used the report writer to read the tab or comma delimited flat files we
created from our Legacy systems, and have them outputted to a JDE table or
z-file. Within the UBE, we performed the necessary checks to ensure the data was
valid.
Answer2
There are a couple of ways to do this.
If you are writing to a table defined within JDE you can use Table I/O to write
records through the UBE Event Rules.
The Report Design Aid (RDA) also has the functionality to export data from a
section to a non-JDE table using the Database Output option. Basically, you set
focus on the section that you want exported, select "Section" and select
"Database Output".
Then, define the Database Output parameters. The Name field will be the name of
the output file. The Operation(s) can be Insert Only, Update, Insert or Update
or Delete. The Type can be a Fixed length record file, or Comma delimited
file. For a Fixed length record file or Comma delimited file, the file name must
end in ".txt".
Next, map the parameters of the input business view columns to the output
file. The Source Section is the name of the Section and the Source Object will
allow you to select the business view column or variable you wish to export
(double click on the blank field).*Questions excerpted from
ITToolBox.com*
Disclaimer: Contents are not reviewed for correctness and are not endorsed or
recommended by PeopleSoft-Planet.com. |
|
|
|
|
|
|
|
|
|
