Hi Guys,
Our Post Integration job reported an error yesterday when it reached the combination Purchase Order-Result. The error was..
Table tfgld008000 does not exist.
Cannot continue..
After terminating the job and checking the Integration Transaction by Project/Order it was found out that for one particular Purchase Order, the combination of Purchase Order-Result was picking 000 as Fin Company and 0000-0 as the Fiscal Year/Period. The Purchase Order-Receipt combo for the same order got posted but the Result part got stuck because of the wrong Fin Company and Periods.

Can anyone tell me why this would have happened?

The same combination got posted the day before without any hiccups and there has been no changes in the integration setup.

To rectify this, could we use GTM to manually feed in the correct Fin company & Period and then post again?

sk

Hi, looking for the reason will only take time, we had the same problem a few times and did not find the reason. Check the table for other records with company 000 and change them with GTM

regards
nwbfin

Hi,
Its not just the fin year or fin company but other crucial information like supplier, dimensions, ledgers etc are missing from the Integration table for the above mentioned combination... Finding the reason was part of the knee-jerk reaction... Its the rectification thats high on the list...

Apart from tfgld410, is there any other table i need to look into or do any modification to rectify this problem?

Appreciate your help...

sk

Update..

I filled up the missing information in tfgld410, 415 & 417 for the above mentioned combo and now a new error is being thrown back..

Read Row Error 506 on tfgld007000
Error 506 Table does not exist
Cannot continue...

..gld007 is Period Status table and i can see the fiscal year & period 2008 -08 is set as Open for ACP, ACR, CMG & GLD in this table...

Have i missed out on updating any table other than whats already mentioned?

sk

..Final Update.

Resolved the situation as i missed out on one other table tfgld418..
So in all, i had to manually update gld410, 415, 417 & 418 and the collective fields that needed to rectified manually included Fin Company, Fisc Year/Period, Tax Year/Period, Supplier Code, Reference, Fin Supplier Group, Country, Area & Line of Business

sk