Record successed to write back :0

[former_member981277]

Hi ALL,

I have tested one allocation by using "/CPMB/ALLOCATION" PROCESS chain. After execution of that package one message I have observed in the formula log. The message is "Record successed to write back :0".

Please let me know about this and how to write back the record. Help me in this.

THE FORMULA LOG:

LOG BEGIN TIME:2011-12-14 09:10:42

FILE:\ROOT\WEBFOLDERS\Global_PandL_BAC\ADMINAPP\CorpBudget\TEST.LGF

USER:Z-BPCSYS

APPSET:Global_PandL_BAC

APPLICATION:CorpBudget

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ENTITY:PC10101501,

CATEGORY:BUDGET,

RPTCURRENCY:LC,

TIME:2011.JUN,

PROJECT:WHAT:8392321,WHERE:<<<,USING:<<<,TOTAL:<<<

ENTITY:WHAT:PC10101501,WHERE:<<<,USING:<<<,TOTAL:<<<

ACCOUNT:WHAT:880072,WHERE:880073,USING:880074,TOTAL:880075

DATASRC:WHAT:INPUT,WHERE:<<<,USING:<<<,TOTAL:<<<

RPTCURRENCY:WHAT:LC,WHERE:<<<,USING:<<<,TOTAL:<<<

CLIENT_GROUP:WHAT:1010,WHERE:<<<,USING:<<<,TOTAL:<<<

CATEGORY:WHAT:BUDGET,WHERE:<<<,USING:<<<,TOTAL:<<<

INTCO:WHAT:Non_InterCo,WHERE:<<<,USING:<<<,TOTAL:<<<

-

---

--Read WHAT region

[ACCOUNT] =880072

[TIME] =2011.JUN

[CATEGORY] =BUDGET

[CLIENT_GROUP] =1010

[DATASRC] =INPUT

[ENTITY] =PC10101501

[INTCO] =Non_InterCo

[PROJECT] =8392321

[RPTCURRENCY] =LC

--Time to load WHAT :0.16703 second(s).

-

---

--Read USING region

[ACCOUNT] =880074

[TIME] =2011.JUN

[CATEGORY] =BUDGET

[CLIENT_GROUP] =1010

[DATASRC] =INPUT

[ENTITY] =PC10101501

[INTCO] =Non_InterCo

[PROJECT] =8392321

[RPTCURRENCY] =LC

--Time to load USING :0.125511 second(s).

-

---

--Merge WHAT and USING

--Time to merge WHAT and USING :0.000007 second(s).

-

---

--Apply factor

[ACCOUNT] =880075

[TIME] =2011.JUN

[CATEGORY] =BUDGET

[CLIENT_GROUP] =1010

[DATASRC] =INPUT

[ENTITY] =PC10101501

[INTCO] =Non_InterCo

[PROJECT] =8392321

[RPTCURRENCY] =LC

WHERE=WHAT *USING/TOTAL

--Time to apply factor :0.130708 second(s).

-

---

--Read destination and calculate difference

[ACCOUNT] =880073

[TIME] =2011.JUN

[CATEGORY] =BUDGET

[CLIENT_GROUP] =1010

[DATASRC] =INPUT

[ENTITY] =PC10101501

[INTCO] =Non_InterCo

[PROJECT] =8392321

[RPTCURRENCY] =LC

--Time to read destination and calculate difference :0.128111 second(s).

-

---

--Records succeeded to write back

-

---

--Time to run Allocation :0.555839 second(s).

SCRIPT RUNNING TIME IN TOTAL:0.68 s.

LOG END TIME:2011-12-14 09:10:43

Thanks and Regards,

Krishna.

[Former Member]

Hi,

This kind of message comes when the logic was not able to do anything, typically because the logic couldnt find any records on which it should work.

[krishna_priya1]

1) Make sure there is some data to allocate in What section .

ACCOUNT =880072

TIME =2011.JUN

CATEGORY =BUDGET

CLIENT_GROUP =1010

DATASRC =INPUT

ENTITY =PC10101501

INTCO =Non_InterCo

PROJECT =8392321

RPTCURRENCY =LC

2) Same way make sure there is some data in Using and Total section

Using

ACCOUNT =880074

Total

ACCOUNT =880075

3) if data exists in all above 3 data intersection , then there would be one record to write back, that would be posted to where section.

ACCOUNT =880073

Hope this helps.

Regards,

Krishna.