AnsweredAssumed Answered

How to resolve XOG-3636 error when trying to XOG Cost plans?

Question asked by koks on Dec 31, 2012
Latest reply on Mar 11, 2013 by navzjoshi00
Hi,

I am trying to xog Cost Plans into clarity through XOG client in UI. The Cost plan input xml is as follows,

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nonamespaceSchemaLocation="../xsd/nikuxog_costPlan.xsd">
<Header action="write" externalSource="NIKU" objectType="costPlan" version="8.0"/>
<CostPlans>

<CostPlan code="FINPLANX5005745" finishPeriod="Dec 1, 2013-Dec 31, 2013" investmentCode="PM00033696" investmentType="PROJECT" isPlanOfRecord="1" name="Funding For Mar/2013 to Dec/2013 2013 Original Budget Cost Plan" periodType="MONTHLY" primaryPlanBy="ROLE" secondaryPlanBy="UTILITY1" startPeriod="Mar 1, 2013-Mar 31, 2013" status="NOT_SUBMITTED">


<Details>



<Detail detail2Name="10000190:Books &amp; Periodicals" detailName="11706:EMP" glAccountMain="Books &amp; Periodicals" glAccountSub="6531000010">




<PlanData cost="75276.666577" end_date="2013-03-31" revenue="0.0" start_date="2013-03-01" units="852.800111"/>




<PlanData cost="75276.6666" end_date="2013-04-30" revenue="0.0" start_date="2013-04-01" units="852.80013"/>




<PlanData cost="75276.666577" end_date="2013-05-31" revenue="0.0" start_date="2013-05-01" units="852.800111"/>




<PlanData cost="75276.6666" end_date="2013-06-30" revenue="0.0" start_date="2013-06-01" units="852.80013"/>




<PlanData cost="75276.666577" end_date="2013-07-31" revenue="0.0" start_date="2013-07-01" units="852.800111"/>




<PlanData cost="75276.666577" end_date="2013-08-31" revenue="0.0" start_date="2013-08-01" units="852.800111"/>




<CustomInformation>





<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>





<ColumnValue name="costcenter">10000190</ColumnValue>




</CustomInformation>



</Detail>


</Details>


<CustomInformation>




<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>




<ColumnValue name="met_cp_allowrecalc">true</ColumnValue>



</CustomInformation>

</CostPlan>
</CostPlans>
</NikuDataBus>

I am getting warning : XOG-3636: Plan detail for 10000190:Books &amp; Periodicals could not be added because 10000190:Books &amp; Periodicals is invalid. While analyzing the reason, i found that this issue occurs only when i select 'Time Entry User Lookup field 1' 'PRTIMEENTRY_USER_LOV1) value in User Value 1 Lookup in Timesheet Options page (Project Management). The following query is causing the problem (NOT EXISTS).

SELECT ID, LOOKUP_CODE NAME, LOOKUP_CODE CODE, LOOKUP_CODE DESCRIPTION
FROM USER_LOV1_ALL_V
WHERE NOT EXISTS (
SELECT 'A' FROM CMN_OPTION_VALUES WHERE OPTION_ID IN (
SELECT ID FROM CMN_OPTIONS WHERE OPTION_CODE = 'NKT.GEN.LOOKUP_4_USER_VALUE1')
AND USER_ID IS NULL
AND VALUE = 'PRTIMEENTRY_USER_LOV1')






) DATA

So i have removed 'NOT' keyword from the lookup queries User Lookup field 1 (FIN_BROWSE_USER_LOV1) and User Value 1 Lookup All (BROWSE_USR_VAL1_ALL) and tried to xog cost plans. However this doesn't resolve this issue. Still I am getting the XOG-3636 error.

I took an sql trace of xogging Cost plans and i found that Clarity internally executes some queries with NOT EXISTS. Those queries are different from lookup queries (FIN_BROWSE_USER_LOV1,BROWSE_USR_VAL1_ALL). That is,

WHERE NOT EXISTS (
SELECT 'A' FROM CMN_OPTION_VALUES WHERE OPTION_ID IN (
SELECT ID FROM CMN_OPTIONS WHERE OPTION_CODE = 'NKT.GEN.LOOKUP_4_USER_VALUE1')
AND USER_ID IS NULL
AND VALUE = 'PRTIMEENTRY_USER_LOV1')






) DATA

Please help me in resolving this issue?

Thanks,
Koks

Outcomes