CreateSchema
Creates schema definitions for tables in Oracle Fusion Cloud SCM, enabling database management.
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 connector 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 connector.
Input
| Name | Type | Description |
| TableName | String | The name of the table for which the schema is being generated. This helps identify the specific table for schema creation. |
| SchemaName | String | The name of the schema that contains the table. This provides the context for where the table resides within the database structure. |
| FileName | String | The full file path and name where the schema will be saved. For example, 'C:\\scripts\\Accounts.rsd' specifies the location and file name for the generated schema. |
| SimplifyNames | String | Flag indicating whether to use simplified names for columns in the schema. If set to 'true', longer or more complex column names are shortened for ease of use. Default behavior is to simplify names. |
Result Set Columns
| Name | Type | Description |
| Result | String | Indicates whether the schema was successfully generated and downloaded. A value of 'true' means the process completed successfully, while 'false' indicates an error or failure. |
| FileData | String | The generated schema encoded in Base64 format, returned when both FileName and FileStream are not set. This provides the schema in a data format that can be decoded and saved. |