ValidateJournal
Describes the Oracle Smart View for Office VBA function, ValidateJournal.
Description
ValidateJournal() validates dimensions, members, and journal properties by communicating with Oracle Hyperion Financial Management server.
Syntax
Function ValidateJournal(
errNames() As String,
errValues() As String
) As Long
Parameters
errNames: An output argument. Returns the categories of validations that failed as an array of strings.
errValues: An output argument. Returns which validation failed as an array of strings.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Sub TestValidateJournal()
‘Call TestCreateJournal
TestCreateJournal
Dim errNames() As String
Dim errValues() As String
retVal = jObj.ValidateJournal(errNames, errValues)
If retVal = 0 Then
Debug.Print "Validation Succeeded"
If (Not Not errNames) <> 0 Then
Debug.Print "Following are the Validation Errors"
Debug.Print "Error Type Description"
Dim i As Integer
For i = 0 To UBound(errNames)
Debug.Print errNames(i); Spc(10); errValues(i)
Next
Else
Debug.Print "No Validation Errors."
End If
Else
Debug.Print "ValidateJournal Failed : " + GetErrorMessage(retVal)
End If
End Sub