Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: PAXSUDPT Errors With 'You can enable budgetary
control for only one cost budget type'
Symptoms:
You can enable budgetary control only
for one cost budget type.
occurs in Project Types form PAXSUDPT.
occurs in Project Types form PAXSUDPT.
Solution:
Cause
Incorrect definition of
PA_BUDGETARY_CONTROL_OPTIONS table.
A trace on the form shows the following error:
INSERT INTO PA_BUDGETARY_CONTROL_OPTIONS ( PROJECT_TYPE,
...
ERROR #107:err=1400 tim=17565111
The insert fails with ORA-1400 cannot insert NULL
A trace on the form shows the following error:
INSERT INTO PA_BUDGETARY_CONTROL_OPTIONS ( PROJECT_TYPE,
...
ERROR #107:err=1400 tim=17565111
The insert fails with ORA-1400 cannot insert NULL
Solution
1. Connect to the
database
2. Execute the following two SQL statements:
ALTER TABLE PA_BUDGETARY_CONTROL_OPTIONS MODIFY PROJECT_TYPE NULL;
ALTER TABLE PA_BUDGETARY_CONTROL_OPTIONS MODIFY PROJECT_ID NULL;
3. Test and see if the issue is resolved.
Alternatively apply Patch 11724195 which provides form paxprepr.fmb in version 120.99.12010000.77
or higher.
2. Execute the following two SQL statements:
ALTER TABLE PA_BUDGETARY_CONTROL_OPTIONS MODIFY PROJECT_TYPE NULL;
ALTER TABLE PA_BUDGETARY_CONTROL_OPTIONS MODIFY PROJECT_ID NULL;
3. Test and see if the issue is resolved.
Alternatively apply Patch 11724195 which provides form paxprepr.fmb in version 120.99.12010000.77
or higher.
References:
PAXSUDPT Errors With 'You can enable budgetary
control for only one cost budget type' [ID 604786.1]
3 comments:
Simply want to say your article is as amazing.
The clarity in your post is simply spectacular and i could assume you're an expert on this subject. Well with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please continue the gratifying work.
my web page > on this site
When I originally left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and from now on every time a comment is added I get 4 emails with
the same comment. Is there a means you are able to remove me from
that service? Thank you!
Have a look at my webpage ... over here
Good post! We will be linking to this particularly great post
on our site. Keep up the good writing.
Also visit my homepage ... phen 375
Post a Comment