Parameters   Output Objects  

Deletes Oracle Fusion Cloud Financials data.

Syntax

Remove-OracleERP [parameters]

Remarks

The Remove-OracleERP cmdlet allows you to use a syntax similar to SQL DELETE statements to delete Oracle Fusion Cloud Financials data.

$conn = Connect-OracleERP -Url "https://abc.oraclecloud.com" -User "user" -Password "password" 
Remove-OracleERP -Connection $conn -Table "Invoices" -Id "6"

The Where parameter can also be used to specify the primary key:

Remove-OracleERP -Connection $conn -Table "exTablePowershell;" -Where "Id = 6"

The primary key can also be passed to the cmdlet along the pipeline:

Select-OracleERP -Connection $conn -Table Invoices -Where "Supplier = 'Bob'" | Remove-OracleERP