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