ORacle error code cont.

ORA-34344 (MXDSS03) Analytic workspace string is not attached.

Cause: The command attempted to operate on an analytic workspace that is not currently attached, or the name of the analytic workspace is misspelled.

Action: Attach the analytic workspace or correct the spelling.

ORA-34346 (MXDSS04) The string analytic workspace cannot be detached.

Cause: The specified analytic workspace is an internal workspace and may not be detached by the user.

Action: Specify a different analytic workspace to detach.

ORA-34348 (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.

Cause: The command attempted to operate on an internal analytic workspace used by the system.

Action: Specify a different analytic workspace.

ORA-34350 (MXDSS06) string is an open analytic workspace.

Cause: The specified analytic workspace is currently in use.

Action: The desired action requires an analytic workspace that is not currently in use.

ORA-34357 (MXDSS10) %a string string %p is not an alias of analytic workspace %p.

Cause: User attempted to use AW UNALIAS on a non-existent alias.

Action: Make sure that the command specified the correct analytic workspace and alias. The alias must have been assigned (using AW ALIAS) during the current session and must not have been removed by a previous AW UNALIAS or AW DETACH command.

ORA-34359 (MXDSS11) string appears twice in the alias list.

Cause: User included the same name twice in the alias list of an AW ALIAS or AW UNALIAS command.

Action: Remove the duplicate name and try again.

ORA-34489 (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.

Cause: The user attempted to use the MAINTAIN command on a dimension surrogate. The MAINTAIN command can only be used with real dimensions, not surrogates.

Action: Use the MAINTAIN command to modify the underlying dimension of the surrogate instead.

ORA-34514 (MXOPERR) %a string string string You cannot %p %p data in the expression that begins with '%p'.

Cause: The user attempted an invalid operation.

ORA-34719 (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion

Cause: When character set conversion happens between TEXT and NTEXT either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.

Action: Make sure all the characters can be mapped to destination character sets or set the NLS_NCHAR_CONV_EXCP initialization parameter to false.

ORA-35276 (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] USING aggmap

Cause: The user used incorrect syntax for the ALLOCATE command.

Action: Correct the calling syntax.

ORA-35280 (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]

Cause: The user used incorrect syntax for the AGGREGATE command.

Action: Correct the calling syntax.

ORA-35282 (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])

Cause: The user used incorrect syntax for the AGGREGATE function.

Action: Correct the calling syntax.

ORA-36178 (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.

Cause: The user used the ALLOCMAP command to define the AGGMAP, so the AGGMAP can only be used with the ALLOCATE command, or the AGGMAP has no contents attached to it.

Action: Use the AGGMAP command to define the AGGMAP.

ORA-36180 (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.

Cause: When using AGGREGATE, only simple permissions and permissions on base dimensions are valid.

Action: Remove the permissions clause from the variable causing problems.

ORA-36182 (XSAGGR09) %a workspace object number Could not locate a value for variable %p in measure dimension %p.

Cause: A measure dimension was supplied in the AGGMAP, but a position for the variable was not found in it.

Action: Add a position for the variable in the measure dimension.

ORA-36184 (XSAGGR10) You do not have sufficient permissions for the variable workspace object.

Cause: The user lacked the permissions necessary for the aggregation variable.

Action: Remove the restricting permissions from the variable or base dimension.

ORA-36188 (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is a problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle Support Services.

Cause: Either someone improperly changed the COUNTVAR variable, or AGGREGATE has an error.

Action: Set the COUNTVAR variable to NA before starting AGGREGATE. If you previously set the COUNTVAR variable to NA, then contact Oracle Support Services.

ORA-36198 (XSAGGR33) %a string workspace object number workspace object The AGGREGATE operator %p does not require a weight, but ARGS variable %p with text 'number' specified %p as a weight.

Cause: The ARGS variable specified a weight even though one is not needed.

Action: Modify the ARGS variable so that it does not specify a weight for that operation.

ORA-36200 (XSAGGR34) %a string workspace object string AGGREGATE operator %p requires a WEIGHTBY clause, but ARGS variable %p did not specify one with text expression "%p".

Cause: The given operator requires a WEIGHT specification, but the ARGS variable did not supply one.

Action: Modify the ARGS variable to specify a weight for the operation.

ORA-36202 (XSAGOP01) 'number' is not a valid aggregation operator.

Cause: An invalid string was provided for an aggregation operator.

Action: Check the spelling of the operator to make sure you are specifying a valid one.

ORA-36204 (XSAGOP04N) %a workspace object string In AGGMAP %p, the NAOPERATOR %p must be HFIRST, HLAST or HEVEN.

Cause: An invalid NAOPERATOR was specified.

Action: Specify HFIRST, HLAST or HEVEN.

ORA-36206 (XSAGOP04R) %a workspace object string In AGGMAP %p, REMOPERATOR %p must be MIN, MAX, FIRST, LAST, HFIRST, or HLAST.

Cause: An invalid REMOPERATOR was specified.

Action: Specify one of the legal operators.

ORA-36208 (XSAGOP05N) %a workspace object string string In AGGMAP %p, you can only specify NAOPERATOR %p with the PROPORTIONAL or EVEN operators, not %p.

Cause: The user specified an NAOPERATOR when you were not using PROPORTIONAL or EVEN.

Action: Remove the NAOPERATOR clause from the RELATION line.

ORA-36210 (XSAGOP05R) %a workspace object string string In AGGMAP %p, you can only specify the REMOPERATOR %p with the PROPORTIONAL, EVEN, or HEVEN operators, not %p.

Cause: The user specified a REMOPERATOR without using PROPORTIONAL, EVEN, or HEVEN.

Action: Remove the REMOPERATOR clause from the RELATION line.

ORA-36212 (XSAGOP06) %a workspace object string In AGGMAP %p, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not %p.

Cause: The user specified MIN, MAX, FLOOR, or CEILING when using an operator other than PROPORTIONAL.

Action: Remove the incorrect argument from the RELATION line.

ORA-36258 (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.

Cause: The AGGMAPINFO function was called with an object that is not an AGGMAP.

Action: Modify the call to AGGMAPINFO to specify an AGGMAP object.

ORA-36260 (XSAGINFO01) You specified an invalid keyword when calling the AGGMAPINFO function.

Cause: The call to AGGMAPINFO is invalid.

Action: Modify the call to specify a valid syntax.

ORA-36290 (EIFMAKEF14) %a workspace object number You cannot export object %p, because EIFVERSION is set to %p. That version does not support dimensions of type NUMBER.

Cause: The user tried to export a NUMBER dimension to an EIF file with the EIFVERSION option set to a number less than 80000. Versions previous to that eversion do not support NUMBER dimensions.

Action: A NUMBER dimension cannot be used in a version older than 9.2.0. If the EXPORT file is going to be read by version 9.2.0 or higher, then set EIFVERSION to a number greater than or equal to 80000 and execute the EXPORT command again.

ORA-36342 (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3...] [USING aggmap]

Cause: The syntax for the CLEAR command was invalid.

Action: Modify your syntax using the correct format.

ORA-36376 (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.

Cause: A calculation in the current AGGREGATE command attempted to divide by zero as a result of an AVERAGE, WAVERAGE, HAVERAGE or HWAVERAGE operation.

Action: Either fix the data, or set DIVIDEBYZERO to YES to return NA instead of signalling an error.

ORA-36378 (XSAGTHRWEIGHT) %a workspace object workspace object workspace object While running AGGREGATE with multiple threads, the weight variable %p specified by your ARGS variable %p must exist in the same analytic workspace as your AGGMAP %p.

Cause: While running AGGREGATE in threaded mode, you attempted to specify a WEIGHT variable in another analytic workspace.

Action: Use a weight variable from the same analytic workspace as the aggmap and rollup variable.

ORA-36380 (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.

Cause: A model, NATRIGGER, or other object called the AGGREGATE function or command while another AGGREGATE function or command was already in progress.

Action: Modify your objects so that they do not need to have two AGGREGATE commands or functions executing at once.

ORA-36608 (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.

Cause: The depth of the hierarchies that are part of a composite exceeded 4 billion levels during the merge.

Action: Reduce the number of levels in the hierarchies, reduce the number of dimensions in the composite, or do not aggregate over all dimensions at once.

ORA-36610 (XSLMS00) %a value value Unable to locate a message file for product '%p' and facility '%p'.

Cause: An application called the INTL.MESG function with an incorrect or uninstalled product / facility combination.

Action: Make sure that the appropriate binary message file is stored on the host in the correct location:

ORACLE_HOME/product/facilitylanguage.msb

ORA-36612 (XSLMS01) %a value value value An application attempted to retrieve a non-existent user message. (Product: %p, Facility: %p, Message Number: %p)

Cause: The caller of INTL.MESG tried to retrieve a non-existent message.

Action: Add the message to the application's message file, and recompile or reinstall the binary message file.

ORA-36614 (XSLMS02) %a string number %p attempted to retrieve a nonexistent user message. (Message number %p)

Cause: An internal Oracle OLAP error occurred. Oracle OLAP attempted to retrieve a message that does not exist in the installed message file OLAP_HOME/aps*.msb.

Action: Ignore this error message.

ORA-36616 (XSAGMODHIER01) %a workspace object workspace object MODEL %p cannot be added to AGGMAP %p, because it is dimensioned by a dimension not contained in the AGGMAP.

Cause: The dimension of the model is not a dimension of the aggmap.

ORA-36628 (XSAGMODLIST03) %a workspace object workspace object MODEL %p could not be added to AGGMAP %p.

Cause: The dimension of the model must match a hierarchy of the aggmap.

Action: Add a RELATION statement to the AGGMAP for that dimension.

ORA-36630 (XSDUNION00) An empty CONCAT dimension list was specified.

Cause: An empty union DIMENSION list was specified.

Action: Specify a valid list of dimensions when defining a union DIMENSION.

ORA-36634 (XSDUNION02) INTEGER dimension workspace object cannot be used as a CONCAT dimension base.

Cause: The user cannot specify a prefix list or the UNIQUE keyword when defining a MERGE DIMENSION.

ORA-36636 (XSDUNION03) The CONCAT base dimensions have inconsistent datatypes.

Cause: The union dimension's base dimensions have inconsistent datatypes.

Action: Specify a valid list of dimensions when defining CONCAT DIMENSION.

ORA-36638 (XSDUNION04) workspace object is an invalid CONCAT prefix dimension.

Cause: An invalid prefix list dimension was specified.

Action: Specify a valid prefix list when defining CONCAT DIMENSION.

ORA-36640 (XSDUNION05) An invalid or ambiguous prefix was specified for workspace object.

Cause: An invalid or ambiguous prefix was specified.

Action: Specify a valid prefix list when defining a union DIMENSION.

ORA-36642 (XSDUNION06) Duplicate CONCAT dimension workspace object found

Cause: A duplicate CONCAT dimension was found.

ORA-36644 (XSDUNION07) CONCAT dimension workspace object contains a previously detected leaf dimension.

Cause: Union dimension contains a previously detected leaf dimension.

ORA-36688 (NTEXTCNV00) Error during conversion from TEXT to NTEXT

Cause: An unknown character set conversion error occurred when converting a TEXT value to an NTEXT value.

ORA-36690 (NTEXTCNV01) Error during conversion from NTEXT to TEXT

Cause: An unknown character set conversion error occurred when converting an NTEXT value to a TEXT value.

ORA-36691 (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string

Cause: The user called the UNISTR function on a string that had an invalid escape sequence. The only valid escape sequences in UNISTR are:

1. An escape-escape sequence
2. An escape, followed by exactly four hexadecimal digits

Action: Make sure that all escape sequences in UNISTR arguments are exactly four hexadecimal digits. To represent codepoints whose value is less than 0x1000, use preceding zeros. WRONG: 0x10; RIGHT: 0x0010.

ORA-36692 (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d]

Cause: The user input the wrong format or object types.

Action: Make sure number of arguments and all object types are correct.

ORA-36694 (XSRELTBL01) The value cannot be added to dimension workspace object.

Action: Check the context and permission for dimension maintainance.

ORA-36696 (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.

Cause: Try to limit relation dimension using qdr list.

Action: Delete the part of qdr list for relation dimension.

ORA-36698 (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

Cause: Use other dimensions than dimensions in relation dimensions.

Action: Make sure all dimensions of qdrs dimension the relation.

ORA-36700 (XSRELTBL04) QDR dimension workspace object repeats.

Cause: Repeat the qdr dimension.

Action: Delete the repeated qdr.

ORA-36702 (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.

Cause: The HIERHEIGHT function was specified incorrectly.

Action: Make sure the format is correct.

ORA-36704 (XSRELTBL06) %a workspace object workspace object %p should be dimensioned by %p.

Cause: The level relation is not dimensioned by the source relation dimension.

Action: Make sure the level relation has the correct definition.

ORA-36706 (XSRELTBL07) %a workspace object workspace object %p should be dimensioned by %p and one integer/number dimension.

Cause: The destination relation has the wrong definition.

Action: Make sure the destination relation has the correct dimensions.

ORA-36708 (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

Cause: The user supplied an undimensioned (scalar) variable to the ALLOCATE command.

Action: Use a dimensioned variable.

ORA-36710 (XSMXALLOC01) %a workspace object workspace object TARGETLOG variable %p must be dimensioned identically to TARGET variable %p.

Cause: The user attempted to execute ALLOCATE with mismatching TARGET and TARGETLOG variables.

Action: Use TARGET and TARGETLOG variables with matching dimensionality.

ORA-36712 (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

Cause: The user specified an invalid source or basis relation on the ALLOCATE command line.

Action: Modify the relation to be a one-dimensional self-relation.

ORA-36714 (XSMXALLOC03) %a workspace object workspace object TARGETLOG variable %p must have the same datatype as TARGET variable %p.

Cause: The user specified a TARGETLOG variable that had a different datatype from the TARGET variable.

Action: Use TARGETLOG and TARGET variables with an identical datatype.

ORA-36716 (XSMXALLOC04) %a workspace object workspace object You can only use the ACROSS phrase when allocation BASIS %p is a FORMULA.

Cause: The user specified an ACROSS composite when the BASIS is not a FORMULA.

Action: Remove the ACROSS phrase or use a FORMULA for the BASIS.

ORA-36718 (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.

Cause: The user did not have sufficient permissions to run the ALLOCATE command.

Action: Change to a user ID with the appropriate permissions, or use objects that you have permission to use.

ORA-36720 (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.

Cause: The user used the AGGMAP command to define the AGGMAP, so either the AGGMAP can only be used with the AGGREGATE command, or the AGGMAP has no contents attached to it.

Action: Use the ALLOCMAP command to define the AGGMAP.

ORA-36722 (XSALLOC02) %a workspace object workspace object In AGGMAP %p, you specified an NA or ZERO sourceval but supplied formula %p as your source for ALLOCATE.

Cause: The user requested that source values be modified during the allocation, but that is not possible when using a formula source.

Action: Either use a VARIABLE source or remove the SOURCEVAL specification for your ALLOCMAP.

ORA-36726 (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.

Cause: The user specified an invalid formatter in the ALLOCERRLOGHEADER or ALLOCERRLOGFORMAT options.

Action: Correct the option to have a valid format.

ORA-36728 (XSALERR01) %a workspace object number While performing the ALLOCATE command with AGGMAP %p, the error logging limit of %p was exceeded.

Cause: The user specified an ERRORLOG MAX value in the ALLOCMAP, but more errors were encountered while performing the allocation.

Action: Either set ERRORLOG NOSTOP, reduce the allocation errors, or// increase the ERRORLOG MAX setting.

ORA-36742 (XSRELTBL08) %a string workspace object %p is not a valid qualified data reference for dimension %p.

Cause: The qdr is not in its dimension.

Action: Make sure the qdr is in its dimension.

ORA-36744 (XSRELTBL09) workspace object is not a valid level relation.

Cause: The level relation includes the invalid content.

Action: In level relation, all parents should be always either greater or less than their children.

ORA-36746 (XSRELTBL10) workspace object must be a dimension.

Cause: Use other objects than dimension in qdr list.

Action: Must use dimensions only in qdr list.

ORA-36748 (XSRELTBL11) workspace object must be a relation.

Cause: Wrong object type for either source or destination.

Action: Give the correct object.

ORA-36750 (XSRELTBL12) workspace object must be a self-relation.

Cause: Source relation is not self-relation.

Action: Give a self-relation as source.

ORA-36752 (XSRELTBL13) %a workspace object workspace object Relation %p must be dimensioned by %p.

Cause: Destination relation is not dimensioned by source relation dimension.

Action: Give a correct destination relation.

ORA-36756 (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID relation1 INTO {variable | relation2}

Cause: Command format is not correct.

Action: Check the object type and number, and give the correct format.

ORA-36758 (XSRELGID01) workspace object must be a self-relation.

Cause: Source relation is not a self-relation.

Action: Give a source relation as self-relation.

ORA-36760 (XSRELGID02) Variable workspace object must have a numeric datatype.

Cause: Destination variable is not numeric type variable.

Action: Make sure the variable is numeric.

ORA-36762 (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object which have more than one element in status.

Cause: Destination variable/relation does not have enough dimensionality to hold the result from the multi-dimensional source relation.

Action: Either limit the status of hierarchy dimensions or redefine the destination variable/relation with the extended dimensionality.

ORA-36764 (XSRELGID04) A value cannot be inserted into dimension workspace object.

Action: Make sure the dimension can be inserted.

ORA-36766 (XSRELGID05) %a workspace object workspace object Relation %p must be dimensioned by %p.

Cause: The destination relation is not dimensioned by the dimension of the source relation.

Action: Change the definition of the destination relation to be dimensioned by the dimension of the source relation.

ORA-36768 (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.

Cause: The destination relation has the wrong dimension type.

Action: Change the definition of the destination relation so that its dimension is an Oracle number.

ORA-36780 (IOSEC01) Current Directory Alias is not set. Cannot complete string.

Action: Use CDA command to set current directory alias or include the directory alias in the file name.

ORA-36782 (IOSEC02) Directory Alias used in string does not exist, or you do not have sufficient privileges to access it.

Action: Use CREATE DIRECTORY name AS 'path'. Then grant privileges to that directory alias.

ORA-36788 (IOSEC05) Access to the directory specified by string denied.

Action: Use GRANT command to assign permissions to the directory alias.

ORA-36800 (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP

Cause: The given olap table function used more than one LOOP statement.

Action: It is currently impossible to specify more than one LOOP composite, either remove one of the statements (and loop densly over relevant dimensions), or create a new composite that encompasses both loops and have a single loop statement refer to that.

ORA-36802 (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP

Cause: There is no limitmap on the table function and either the datamap does not contain a fetch, or it errored before the fetch was called.

Action: Check the datamap for errors, make sure that it executes a fetch statement, if it is not intended to execute the fetch then make sure that the table function has a valid limitmap.

ORA-36804 (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP

Cause: Invalid LIMITMAP syntax, or the name resolution failure of an ANALYTIC WORKSPACE OBJECT.

Action: Check the syntax of the limit map, check that the OLAP_TABLE function refers to a valid analytic workspace, and check that all analytic workspace objects within the limitmap actually exist within the analytic workspace.

ORA-36806 (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string

Cause: The limitmap refers to a matching of ADT attribute to AW object, but the ADT attribute is not an element of the specified ADT table. Most commonly this is a typographical error.

Action: Add the attribute to the ADT, correct the LIMITMAP, or remove the reference from the LIMITMAP.

ORA-36902 (XSAGDNGL43) %a workspace object workspace object In AGGMAP %p, MODEL %p cannot be calculated dynamically because it contains simultaneous/step equations or equations which refer to variables.

Cause: Model may include equations other than dimension values, or blocks other than simple blocks.

Action: Make sure model only includes the simple blocks with dimension values.

ORA-36904 (XSAGDNGL44) %a workspace object workspace object In AGGMAP %p, RELATION %p occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.

Cause: Before the current relation, dynamic model exists.

Action: Make sure the dynamic model is the last statement.

ORA-36906 (XSAGDNGL45) %a workspace object workspace object AGGMAP %p, MODEL %p occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.

Cause: Before the current model, the dynamic model exists.

Action: Make sure the dynamic model as the last calculation statement, and only at most one dynamic model exists.

ORA-36950 (XSFCAST22) %a string number number The list of %p values cannot have more than %p members. You supplied %p.

Cause: There are more than the maximum number of OFFSET or PERIODICITY values.

Action: Remove some of the values.

ORA-36952 (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.

Cause: A cycle number was specified in a call to FCQUERY to retrieve forecast data not related to a cycle.

Action: Remove the cycle specification from the call to FCQUERY.

ORA-36954 (XSFCAST24) %a number number The cycle number must be between 1 and %p. You specified %p.

Cause: A cycle number less than 1 or greater than the maximum value was specified in a call to FCQUERY.

Action: Specify a number in the indicated range.

ORA-36956 (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.

Cause: More OFFSET values were specified than PERIODICITY values.

Action: Supply only as many OFFSETs as there are PERIODICITY values.

ORA-36958 (XSFCAST26) %a number number number The OFFSET value for cycle %p cannot be greater than the cycle's PERIODICITY, which is %p. You specified %p.

Cause: The OFFSET for a cycle exceeded the PERIODICITY for that cycle.

Action: Supply an OFFSET less than or equal to the PERIODICITY for the corresponding cycle.

ORA-36960 (XSFCAST27) %a string number The value of the %p expression must be an odd number. You specified %p.

Cause: An even number was given for an option that requires an odd number.

Action: Supply an odd number or let the option default.