My Oracle Support Banner

Calendar Exceptions and Notebook Descriptions Do Not Import/Export Using XER Format (Doc ID 2869022.1)

Last updated on MAY 20, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12.19.0 to 21.12.4.0 [Release 19.12 to 21.12]
Primavera P6 Professional Project Management - Version 19.12.19.0 to 21.12.4.0 [Release 19.12 to 21.12]
Information in this document applies to any platform.

Symptoms

Import XER from older P6 releases does not bring in full Calendar Exceptions and Notebook Descriptions when the data element exceeds 4096 characters.

To see if this affects calendars in the XER import, open the XER in Notepad++.

The following example is how the data element exports from P6 16.2 XER.  The character length in Notepad++ for this specific calendar is 4980.

%R 12405 N 6 DAY WORKWEEK W/HOLIDAYS  2022-04-22 00:00 CA_Base 8 40 172 2000 N (0||CalendarData()( (0||DaysOfWeek()( (0||1()()) (0||2()( (0||0(s|08:00|f|16:00)()))) (0||3()( (0||0(s|08:00|f|16:00)()))) (0||4()( (0||0(s|08:00|f|16:00)()))) (0||5()( (0||0(s|08:00|f|16:00)()))) (0||6()( (0||0(s|08:00|f|16:00)()))) (0||7()( (0||0(s|08:00|f|16:00)()))))) (0||VIEW(ShowTotal|Y)()) (0||Exceptions()( (0||0(d|37865)()) (0||1(d|37952)()) (0||2(d|37953)()) (0||3(d|37980)()) (0||4(d|37981)()) (0||5(d|37987)()) (0||6(d|38138)()) (0||7(d|38173)()) (0||8(d|38236)()) (0||9(d|38316)()) (0||10(d|38317)()) (0||11(d|38345)()) (0||12(d|38352)()) (0||13(d|38502)()) (0||14(d|38537)()) (0||15(d|38600)()) (0||16(d|38680)()) (0||17(d|38681)()) (0||18(d|38712)()) (0||19(d|38719)()) (0||20(d|38866)()) (0||21(d|38902)()) (0||22(d|38964)()) (0||23(d|39044)()) (0||24(d|39045)()) (0||25(d|39076)()) (0||26(d|39083)()) (0||27(d|39230)()) (0||28(d|39267)()) (0||29(d|39328)()) (0||30(d|39408)()) (0||31(d|39409)()) (0||32(d|39441)()) (0||33(d|39448)()) (0||34(d|39594)()) (0||35(d|39633)()) (0||36(d|39692)()) (0||37(d|39779)()) (0||38(d|39780)()) (0||39(d|39807)()) (0||40(d|39814)()) (0||41(d|39958)()) (0||42(d|39997)()) (0||43(d|40063)()) (0||44(d|40143)()) (0||45(d|40144)()) (0||46(d|40171)()) (0||47(d|40172)()) (0||48(d|40173)()) (0||49(d|40179)()) (0||50(d|40180)()) (0||51(d|40329)()) (0||52(d|40364)()) (0||53(d|40427)()) (0||54(d|40502)()) (0||55(d|40507)()) (0||56(d|40508)()) (0||57(d|40509)()) (0||58(d|40536)()) (0||59(d|40537)()) (0||60(d|40539)()) (0||61(d|40543)()) (0||62(d|40544)()) (0||63(d|40693)()) (0||64(d|40694)( (0||0(s|08:00|f|16:00)()))) (0||65(d|40728)()) (0||66(d|40791)()) (0||67(d|40871)()) (0||68(d|40872)()) (0||69(d|40873)()) (0||70(d|40900)()) (0||71(d|40901)()) (0||72(d|40903)()) (0||73(d|40910)()) (0||74(d|41057)()) (0||75(d|41094)()) (0||76(d|41155)()) (0||77(d|41235)()) (0||78(d|41236)()) (0||79(d|41237)()) (0||80(d|41265)()) (0||81(d|41267)()) (0||82(d|41268)()) (0||83(d|41275)()) (0||84(d|41421)()) (0||85(d|41459)()) (0||86(d|41519)()) (0||87(d|41606)()) (0||88(d|41607)()) (0||89(d|41608)()) (0||90(d|41632)()) (0||91(d|41633)()) (0||92(d|41640)()) (0||93(d|41785)()) (0||94(d|41824)()) (0||95(d|41825)()) (0||96(d|41883)()) (0||97(d|41970)()) (0||98(d|41971)()) (0||99(d|41972)()) (0||100(d|41998)()) (0||101(d|41999)()) (0||102(d|42000)()) (0||103(d|42005)()) (0||104(d|42149)()) (0||105(d|42188)()) (0||106(d|42189)()) (0||107(d|42254)()) (0||108(d|42334)()) (0||109(d|42335)()) (0||110(d|42336)()) (0||111(d|42362)()) (0||112(d|42363)()) (0||113(d|42364)()) (0||114(d|42370)()) (0||115(d|42371)()) (0||116(d|42520)()) (0||117(d|42555)()) (0||118(d|42618)()) (0||119(d|42698)()) (0||120(d|42699)()) (0||121(d|42727)()) (0||122(d|42730)()) (0||123(d|42737)()) (0||124(d|42884)()) (0||125(d|42920)()) (0||126(d|42982)()) (0||127(d|43062)()) (0||128(d|43063)()) (0||129(d|43094)()) (0||130(d|43095)()) (0||131(d|43101)()) (0||132(d|43248)()) (0||133(d|43285)()) (0||134(d|43346)()) (0||135(d|43426)()) (0||136(d|43427)()) (0||137(d|43458)()) (0||138(d|43459)()) (0||139(d|43466)()) (0||140(d|43612)()) (0||141(d|43650)()) (0||142(d|43710)()) (0||143(d|43790)()) (0||144(d|43791)()) (0||145(d|43824)()) (0||146(d|43825)()) (0||147(d|43831)()) (0||148(d|43976)()) (0||149(d|44015)()) (0||150(d|44081)()) (0||151(d|44161)()) (0||152(d|44162)()) (0||153(d|44189)()) (0||154(d|44190)()) (0||155(d|44197)()) (0||156(d|44345)()) (0||157(d|44347)()) (0||158(d|44380)()) (0||159(d|44382)( (0||0(s|08:00|f|16:00)()))) (0||160(d|44443)()) (0||161(d|44445)()) (0||162(d|44525)()) (0||163(d|44526)()) (0||164(d|44527)()) (0||165(d|44554)()) (0||166(d|44555)()) (0||167(d|44562)()) (0||168(d|44709)()) (0||169(d|44711)()) (0||170(d|44744)()) (0||171(d|44746)()) (0||172(d|44807)()) (0||173(d|44809)()) (0||174(d|44889)()) (0||175(d|44890)()) (0||176(d|44891)()) (0||177(d|44918)()) (0||178(d|44919)()) (0||179(d|44921)()) (0||180(d|44926)()) (0||181(d|44928)()) (0||182(d|45073)()) (0||183(d|45075)()) (0||184(d|45111)()) (0||185(d|45171)()) (0||186(d|45173)()) (0||187(d|45253)()) (0||188(d|45254)()) (0||189(d|45255)()) (0||190(d|45283)()) (0||191(d|45285)()) (0||192(d|45292)()) (0||193(d|45437)()) (0||194(d|45439)()) (0||195(d|45477)()) (0||196(d|45535)()) (0||197(d|45537)()) (0||198(d|45617)()) (0||199(d|45618)()) (0||200(d|45619)()) (0||201(d|45650)()) (0||202(d|45651)()) (0||203(d|45657)()) (0||204(d|45658)()) (0||205(d|45801)()) (0||206(d|45803)()) (0||207(d|45842)()) (0||208(d|45843)()) (0||209(d|45899)()) (0||210(d|45901)()) (0||211(d|45981)()) (0||212(d|45982)()) (0||213(d|45983)()) (0||214(d|46015)()) (0||215(d|46016)()) (0||216(d|46022)()) (0||217(d|46023)()) (0||218(d|46165)()) (0||219(d|46167)()) (0||220(d|46207)()) (0||221(d|46270)()) (0||222(d|46272)()) (0||223(d|46345)()) (0||224(d|46346)()) (0||225(d|46347)()) (0||226(d|46381)()) (0||227(d|46382)()) (0||228(d|46388)()) (0||229(d|46389)()) (0||230(d|46536)()) (0||231(d|46538)())))))

Export from the latest Patch Sets (19.12.19.0, 20.12.14.0, and 21.12.4.0) does not Export full Calendar Exceptions and Notebook Descriptions when they are greater than 4096 characters.

Example of how the calendar exports from the above affected versions (19.12.19.0 XER Export in Notepad++ Character length 1898):

%R 20006 N  6 DAY WORKWEEK W/ HOLIDAYS  2022-04-22 00:00 CA_Base 8 40 172 2000 N ()) (0||151(d|44161)()) (0||152(d|44162)()) (0||153(d|44189)()) (0||154(d|44190)()) (0||155(d|44197)()) (0||156(d|44345)()) (0||157(d|44347)()) (0||158(d|44380)()) (0||159(d|44382)( (0||0(s|08:00|f|16:00)()))) (0||160(d|44443)()) (0||161(d|44445)()) (0||162(d|44525)()) (0||163(d|44526)()) (0||164(d|44527)()) (0||165(d|44554)()) (0||166(d|44555)()) (0||167(d|44562)()) (0||168(d|44709)()) (0||169(d|44711)()) (0||170(d|44744)()) (0||171(d|44746)()) (0||172(d|44807)()) (0||173(d|44809)()) (0||174(d|44889)()) (0||175(d|44890)()) (0||176(d|44891)()) (0||177(d|44918)()) (0||178(d|44919)()) (0||179(d|44921)()) (0||180(d|44926)()) (0||181(d|44928)()) (0||182(d|45073)()) (0||183(d|45075)()) (0||184(d|45111)()) (0||185(d|45171)()) (0||186(d|45173)()) (0||187(d|45253)()) (0||188(d|45254)()) (0||189(d|45255)()) (0||190(d|45283)()) (0||191(d|45285)()) (0||192(d|45292)()) (0||193(d|45437)()) (0||194(d|45439)()) (0||195(d|45477)()) (0||196(d|45535)()) (0||197(d|45537)()) (0||198(d|45617)()) (0||199(d|45618)()) (0||200(d|45619)()) (0||201(d|45650)()) (0||202(d|45651)()) (0||203(d|45657)()) (0||204(d|45658)()) (0||205(d|45801)()) (0||206(d|45803)()) (0||207(d|45842)()) (0||208(d|45843)()) (0||209(d|45899)()) (0||210(d|45901)()) (0||211(d|45981)()) (0||212(d|45982)()) (0||213(d|45983)()) (0||214(d|46015)()) (0||215(d|46016)()) (0||216(d|46022)()) (0||217(d|46023)()) (0||218(d|46165)()) (0||219(d|46167)()) (0||220(d|46207)()) (0||221(d|46270)()) (0||222(d|46272)()) (0||223(d|46345)()) (0||224(d|46346)()) (0||225(d|46347)()) (0||226(d|46381)()) (0||227(d|46382)()) (0||228(d|46388)()) (0||229(d|46389)()) (0||230(d|46536)()) (0||231(d|46538)())))))

 

Note the missing Calendar Exceptions cause Duration differences.




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.