Manage CLOB Fields

You can use the CLOB data type to manage fields that require a vast amount of text such as Detailed Description and Result Summary.

Consider these examples:

1. Update DetailedDescription for the Financial Reporting Compliance Process REST API
2. Update ResultSummary for the Process Assessment Results REST API

Note:

CLOB fields can also be used to manage Control, Control Assessment, Risk, and Risk Assessment.

Update DetailedDescription for the Financial Reporting Compliance Process REST API

Your customer wants to update the Financial Reporting Compliance Process record detailed description.

They create a process and provide a multi-page detailed description of the process. The customer then updates an existing process by modifying a section of a multi-page detailed description based on changes in how the process is performed.

cURL Command

curl -i -u "<username>:<password>" -H "Content-Type: application/octet-stream" -X PUT -d "<description>" https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/frcProcesses/10001/enclosure/DetailedDescription

Example Request

Here's an example of the request body in TEXT format:

When initiating the sale and delivery of a new project, it is important to ensure that proper steps have been put in place to mitigate the risk of lack of subsequent payment either by misunderstandings, miscommunications, insufficient vetting of the customer’s ability to pay. It is important that all of the standard risks related to project implementations are reviewed. In addition, the individual steps of each control implemented to mitigate those risks must each be performed and sufficient review and approval of all such activities must be performed by a pre-authorized executive of the organization.
 
The Project Oversight Committee will review all projects on regular basis. The frequency of this review will be determined by the committee based on the associated risks of the project.

Example Response

Here's an example of the response body in TEXT format:

Status: 204

No Content

The customer submits a GET request to view the update.

cURL Command

curl -i -u "<username>:<password>" -H "Content-Type: application/octet-stream" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/frcProcesses/10001/enclosure/DetailedDescription

Example Response

Here's an example of the response body in TEXT format:

When initiating the sale and delivery of a new project, it is important to ensure that proper steps have been put in place to mitigate the risk of lack of subsequent payment either by misunderstandings, miscommunications, insufficient vetting of the customer’s ability to pay. It is important that all of the standard risks related to project implementations are reviewed. In addition, the individual steps of each control implemented to mitigate those risks must each be performed and sufficient review and approval of all such activities must be performed by a pre-authorized executive of the organization.
 
The Project Oversight Committee will review all projects on regular basis. The frequency of this review will be determined by the committee based on the associated risks of the project.

Update ResultSummary for the Process Assessment Results REST API

Your customer wants to update the Process Assessment Results result summary.

They create a process assessment result record and provide a multi-page result summary of the process assessment result. The customer then updates an existing process assessment result by modifying a section of a multi-page result summary based on changes in how the process assessment result is performed.

cURL Command

curl -i -u "<username>:<password>" -H "Content-Type: application/octet-stream" -X PUT -d "<resultSummary>" https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/frcProcessAssessmentResults/10004/enclosure/ResultSummary

Example Request

Here's an example of the request body in TEXT format:

The company processes a significant number of routine intercompany transactions on a monthly basis. Individual intercompany transactions are not material and primarily relate to balance sheet activity, for example, cash transfers between business units to finance normal operations. A formal management policy requires monthly reconciliation of intercompany accounts and confirmation of balances between business units. However, there is not a process in place to ensure performance of these procedures. As a result, detailed reconciliations of intercompany accounts are not performed on a timely basis. Management does perform monthly procedures to investigate selected large-dollar intercompany account differences. In addition, management prepares a detailed monthly variance analysis of operating expenses to assess their reasonableness. Based only on these facts, the auditor should determine that this deficiency represents a significant deficiency for the following reasons: The magnitude of a financial statement misstatement resulting from this deficiency would reasonably be expected to be more than inconsequential, but less than material, because individual intercompany transactions are not material, and the compensating controls operating monthly should detect a material misstatement. Furthermore, the transactions are primarily restricted to balance sheet accounts. However, the compensating detective controls are designed only to detect material misstatements. The controls do not address the detection of misstatements that are more than inconsequential but less than material. Therefore, the likelihood that a misstatement that was more than inconsequential, but less than material, could occur is more than remote.

Example Response

Here's an example of the response body in TEXT format:

Status: 204

No Content

The customer submits a GET request to view the update.

cURL Command

curl -i -u "<username>:<password>" -H "Content-Type: application/octet-stream" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/ 11.13.18.05/frcProcessAssessmentResults/10004/enclosure/ResultSummary

Example Response

Here's an example of the response body in TEXT format:

The company processes a significant number of routine intercompany transactions on a monthly basis. Individual intercompany transactions are not material and primarily relate to balance sheet activity, for example, cash transfers between business units to finance normal operations. A formal management policy requires monthly reconciliation of intercompany accounts and confirmation of balances between business units. However, there is not a process in place to ensure performance of these procedures. As a result, detailed reconciliations of intercompany accounts are not performed on a timely basis. Management does perform monthly procedures to investigate selected large-dollar intercompany account differences. In addition, management prepares a detailed monthly variance analysis of operating expenses to assess their reasonableness. Based only on these facts, the auditor should determine that this deficiency represents a significant deficiency for the following reasons: The magnitude of a financial statement misstatement resulting from this deficiency would reasonably be expected to be more than inconsequential, but less than material, because individual intercompany transactions are not material, and the compensating controls operating monthly should detect a material misstatement. Furthermore, the transactions are primarily restricted to balance sheet accounts. However, the compensating detective controls are designed only to detect material misstatements. The controls do not address the detection of misstatements that are more than inconsequential but less than material. Therefore, the likelihood that a misstatement that was more than inconsequential, but less than material, could occur is more than remote.