XOG Fiscal Time Periods gets "Invalid Tag" error - 14.3

[ABT Product Support]

Hello all,

 

Hoping some of you "gurus" can point me in the right direction... I have generated a XOG XML file based on the steps outlined here in hopes of being able to XOG in 50 years worth of monthly, quarterly, and yearly fiscal period data. The other alternative of entering it all manually sounds... less than pleasant. Currently running CA PPM 14.3, no patches.

 

When I try to execute the XOG, I get a fatal error stating that "GL Periods" tag is not allowed. I've attached both of the input and output files to this post. The entity is set up, I have previous periods for 2015 and 2016 in the system, and I'm stuck. Any help is appreciated.

 

Thanks,

ABT

Attachment(s)

FiscalTimePeriods_Years_Example.xml.zip   1K 1 version

FiscalTimePeriods_Years_Results.xml.zip   537B 1 version

[Martti Kinnunen]

Did you read the entity out first?

That would give the correct format

 

Your error is

 

<Description>[Error] :0:0: tag name "GLPeriods" is not allowed. Possible tag names are: <obsTypes>

</Description>

 

What it is saying is that you cannot have GLPeriods at that point, You need to have obsTypes

 

This is what I get when I read an entity from 13.3

 

<Header action="write" externalSource="NIKU" objectType="entity" version="8.0"/>

  <Entities>

    <Entity billingCurrency="EUR" defaultLaborRateSource="Matrix1" defaultLaborSourceLocation="resource" defaultProjectClass="Project" defaultWIPClass="WIP" entity="Entity1" exchangeRateTypeEquipment="AVERAGE" exchangeRateTypeExpense="AVERAGE" exchangeRateTypeLabor="AVERAGE" exchangeRateTypeMaterials="AVERAGE" externalId=" " finPeriodCode="MONTHLY" geoOBS="locs" homeCurrency="EUR" orgOBS="deps" reportingCurrency="EUR">

      <description><![CDATA[entity1]]></description>

      <shortDescription><![CDATA[entity1]]></shortDescription>

      <obsTypes>

        <obs code="deps" name="Deps">

          <level depth="1" name="Level 1"/>

          <objectAssociation associationType="Any Unit" object="project"/>

          <objectAssociation associationType="Any Unit" object="resource"/>

          <unit code="it" name="IT"/>

        </obs>

        <obs code="locs" name="Locs">

          <level depth="1" name="Level1"/>

          <objectAssociation associationType="Any Unit" object="project"/>

          <objectAssociation associationType="Any Unit" object="resource"/>

          <unit code="america" name="America"/>

        </obs>

      </obsTypes>

      <GLPeriods>

        <GLPeriod endDate="2011-12-31" entityId="Entity1" isActive="true" periodName="2011_01" periodType="MONTHLY" quarter="0" startDate="2011-12-01" year="2011">

          <nls languageCode="cs" name="1.12.2011-31.12.2011"/>

 

Add something similar to the data following the tag obsTypes and  remember to close the tag.

 

Just wondering why would you need 50 years of fiscal periods for if you don't mind me asking.

Are you gonna be there after 50 years or is CA PPM gonna be there?

[ABT Product Support]

urmas - Thanks for the guidance. I did do a read on the entity itself, but stripped down the output in an effort to reduce the noise in the XOG file. Do you happen to know if I can leave a single "unit" per "obs" and "location" tags, or if I have to leave the entire OBS and Location structure in place? I'm currently working against my Test system that might be slightly different, and I was hoping to leverage the same XOG file against Production later on. Would it work to just leave the highest level "unit" for a point of reference?

 

Also, to answer your question on 50 years: It's more of a "I don't ever want to have to do this again" than a real business requirement.

[Martti Kinnunen]

Sorry, I don't know.

It should not take too long to try just with

<obsTypes>

 

</obsTypes>   If that errors then add more.

[ABT Product Support]

It does work with empty tags, and all 50 years XOGged in about 25 seconds. Thanks for the help!

[Martti Kinnunen]

;-)

I normally only do a couple of years at a time. When those run out I read them out and do search a replace for the years in the file and fix the end of February for leap and non leap years.

Does not take that long.