CreateSchema
Generates a schema definition of a table in Oracle Fusion Cloud Procurement, supporting consistent data structures.
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 cmdlet 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 cmdlet.
Input
| Name | Type | Description |
| TableName | String | The name of the table for which the schema is being generated. This input is used to specify the table whose structure needs to be defined in the schema. |
| SchemaName | String | The name of the schema to which the table belongs. This input helps define the database context in which the table's schema will be created. |
| FileName | String | The full file path and name of the schema to generate (for example, 'C:\\scripts\\Accounts.rsd'). This input is used to specify where the generated schema file should be saved. |
| SimplifyNames | String | Determines whether to output simplified column names in the generated schema. By default, this is set to simplify the names for easier reading and use. |
Result Set Columns
| Name | Type | Description |
| Result | String | Indicates whether the schema was successfully generated and downloaded. This output helps confirm whether the schema creation process completed without errors. |
| FileData | String | The generated schema encoded in Base64 format. This output is returned only if neither 'FileName' nor 'FileStream' is specified, providing the schema data in a portable, encoded format. |