CreateSchema
Generates schema definitions for tables in Oracle Fusion Cloud SCM manufacturing.
CreateSchema
Creates a local schema file (.rsd) from an existing table or view in the data model.
The schema file is created in the directory set in the Location connection property when this procedure is executed. You can edit the file to include or exclude columns, rename columns, or adjust column datatypes.
The add-in checks the Location to determine if the names of any .rsd files match a table or view in the data model. If there is a duplicate, the schema file will take precedence over the default instance of this table in the data model. If a schema file is present in Location that does not match an existing table or view, a new table or view entry is added to the data model of the add-in.
Input
| Name | Type | Description |
| TableName | String | Specifies the name of the table for which the schema is generated. This should match the table name in the database. |
| SchemaName | String | Defines the name of the schema that contains the table. Use the exact schema name from the database. |
| FileName | String | The complete file path and name where the generated schema is saved (for example, 'C:\\scripts\\Accounts.rsd'). This field takes priority for file-based outputs. |
| SimplifyNames | String | Indicates whether column names should be simplified in the output. By default, names are simplified to remove special characters or formatting. |
Result Set Columns
| Name | Type | Description |
| Result | String | Returns a success or failure status indicating whether the schema generation process completed successfully. |
| FileData | String | Provides the generated schema encoded in Base64 format. This output is available only if FileName and FileStream are not specified. |