Go Back > Forum > Baan Quick Support: Functional & Technical > Manufacturing & Supply Chain

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 4

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 23rd October 2008, 15:36
Judgement Judgement is offline
Junior Member
Join Date: Dec 2005
Posts: 11
Judgement is on a distinguished road
Baan: 4 - DB: don't know - OS: don't know
Fatal Error when creating BOM which contains ITtem Planning Data
Baan: Other/Unknown

Oracle 10


I get a fatal error when I want to add items to a BOM which have Items-Planning Data. The error occurs when trying to save. The same fatal error also comes when trying to use the session generate order planning with the fields Bottom up or Top down checked.

log.bshell comes up with a select statement of cprpd730 to cprpd100, but cprpd730 is empty, it is (as far as I know) only used for multisite planning.

As this happends in all our companies even the stand alone ones I don't think it has something to do with migrated master data, tested it in an empty shell.

After talking to a consultant he said the key must be cprpd120. Can someone explain me what that table is used for?

He also said if I get that fatal error it might have something to do with my item number segmentation (domain segmentation), which could be right as it happens in all companies and that is maintained in tools.

We have 2 records in there which are interesting, 1 for tc which is just 9 for project and 38 for item and 1 for ep which has 3 for cluster 9 for project and 38 for item. Do we need that cluster setup? We are not using it.

Well any idea where I could search for this error and what could cause the same fatal error when trying to create BOM with Planning Data and generate order planning with Bottom up / Top Down are helpfull.

Reply With Quote
Old 12th June 2009, 09:06
elrusodemanpac elrusodemanpac is offline
Junior Member
Join Date: Feb 2007
Posts: 4
elrusodemanpac is on a distinguished road
Baan: 5.0c - DB: sql server 2000 - OS: windows 2003
Check max of t_code in cprpd120

We found that the creation of plan items slowed down dramatically once the maximum of t_code in cprpd120 got to 2147483647.

Infor haven't resolved this yet.
Reply With Quote
Old 12th June 2009, 12:41
elrusodemanpac elrusodemanpac is offline
Junior Member
Join Date: Feb 2007
Posts: 4
elrusodemanpac is on a distinguished road
Baan: 5.0c - DB: sql server 2000 - OS: windows 2003
solution 138710

Hi Infor's support team have now suggested we apply solution 138710. This is for version B50_b,B50_c, but hopefully you can quote this to your support team and they will know the LN equivalent.
Reply With Quote
Sponsored Links
Old 19th November 2010, 12:03
Renegade's Avatar
Renegade Renegade is offline
Senior Member
Join Date: Sep 2001
Location: Norway
Posts: 223
Renegade is on a distinguished road
Baan: BaaNERP5.0c, LN10.5 - DB: Oracle - OS: Windows
is it always?

is it always getting populated in cprpd120 when record is inserted into cprpd100? What if data is loaded into cprpd100 and not into cprpd120. Does any process session populates cprpd120 later?
Knowledge is experience, everything else is just information. - A. Einstein
Reply With Quote
Old 6th December 2010, 11:52
roys11_in roys11_in is offline
Join Date: Aug 2009
Location: New Delhi
Posts: 86
roys11_in is on a distinguished road
Baan: baanIVC4 - DB: sql 2003 - OS: Windows XP

Yes, its true that once you update the cprpd100, cprpd120 will automatically get updated, there's no any other process/session you need to run later for updating cprpd120.

Reply With Quote
Old 28th August 2018, 07:40
Sarath Sarath is offline
Junior Member
Join Date: Nov 2015
Posts: 18
Sarath is on a distinguished road
Baan: Infor erp LN - DB: ERP - OS: windows XP

In Our system some records are not showing in cprpd120 table, But records are showing in cprpd100 table.
When am creating the new record throgh GTM in cprpd120 table record will be saved.
But Planned purchase order not generated for those items.( Demand is there for those items).
Please suggest any idea.
Thanks in advance.

Best Regards,
Namburi Sarath Kumar.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 08:16
getting fatal error while creating company baancust Operating Systems & Databases 2 22nd August 2008 05:45
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
print of graph generated through data selection for planning board loveubaan Manufacturing & Supply Chain 1 26th May 2005 14:17

All times are GMT +2. The time now is 18:22.

©2001-2018 - -