Having an error on the SIT when adding information (Oracle eBS 11i)
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Good day all,
When inserting data in the SIT as shown in the screenshot below i get the following error :
enter image description here
I've no idea about the origin of this error. I've tried to remove all the value set from the related KFF segment without success. Here after the text of the error (the error is not listed in MOS nor Google) :
APP-FND-01564: ORACLE error 1722 in FDFICD
Cause: FDFICD failed due to ORA-01722: invalid number.
The SQL statement being executed at the time of the error was: INSERT INTO PER_ANALYSIS_CRITERIA(ENABLED_FLAG, SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, SEGMENT1, SEGMENT2, SEGMENT3, REQUEST_ID, ID_FLEX_NUM, ANALYSIS_CRITERIA_ID) VALUES ('Y', :sumflg, to_date(:sdate, 'J'), to_date(:edate, 'J'), SYSDATE, :user_id, :SEGMENT1, :SEGMENT2, :SEGMENT3, :REQUEST_ID, :ID_FLEX_NUM, :ANALYSIS_CRITERIA_ID) and was executed from the file &ERRFILE.
Thank you for your help,
Regards,
Moussa
oracle
edited Nov 17 '18 at 3:01
codeLover
2,2551620
asked Nov 16 '18 at 21:02
MoussaMoussa
11
add a comment |
Good day all,
When inserting data in the SIT as shown in the screenshot below i get the following error :
enter image description here
I've no idea about the origin of this error. I've tried to remove all the value set from the related KFF segment without success. Here after the text of the error (the error is not listed in MOS nor Google) :
APP-FND-01564: ORACLE error 1722 in FDFICD
Cause: FDFICD failed due to ORA-01722: invalid number.
The SQL statement being executed at the time of the error was: INSERT INTO PER_ANALYSIS_CRITERIA(ENABLED_FLAG, SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, SEGMENT1, SEGMENT2, SEGMENT3, REQUEST_ID, ID_FLEX_NUM, ANALYSIS_CRITERIA_ID) VALUES ('Y', :sumflg, to_date(:sdate, 'J'), to_date(:edate, 'J'), SYSDATE, :user_id, :SEGMENT1, :SEGMENT2, :SEGMENT3, :REQUEST_ID, :ID_FLEX_NUM, :ANALYSIS_CRITERIA_ID) and was executed from the file &ERRFILE.
Thank you for your help,
Regards,
Moussa
oracle
edited Nov 17 '18 at 3:01
codeLover
2,2551620
asked Nov 16 '18 at 21:02
MoussaMoussa
11
The error is clear: you passed in a string whereas you should have passed in a number. You'll need to verify the parameters one by one.
– Ole EH Dufour
Nov 16 '18 at 21:16
Thank you for your reply, The code is generated by the system, I've only setup the KFF. I've created another simple KFF with only one field and the error still appearing.
– Moussa
Nov 16 '18 at 22:12
Formatted the post
– codeLover
Nov 17 '18 at 3:01
add a comment |
Good day all,
When inserting data in the SIT as shown in the screenshot below i get the following error :
enter image description here
I've no idea about the origin of this error. I've tried to remove all the value set from the related KFF segment without success. Here after the text of the error (the error is not listed in MOS nor Google) :
APP-FND-01564: ORACLE error 1722 in FDFICD
Cause: FDFICD failed due to ORA-01722: invalid number.
The SQL statement being executed at the time of the error was: INSERT INTO PER_ANALYSIS_CRITERIA(ENABLED_FLAG, SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, SEGMENT1, SEGMENT2, SEGMENT3, REQUEST_ID, ID_FLEX_NUM, ANALYSIS_CRITERIA_ID) VALUES ('Y', :sumflg, to_date(:sdate, 'J'), to_date(:edate, 'J'), SYSDATE, :user_id, :SEGMENT1, :SEGMENT2, :SEGMENT3, :REQUEST_ID, :ID_FLEX_NUM, :ANALYSIS_CRITERIA_ID) and was executed from the file &ERRFILE.
Thank you for your help,
Regards,
Moussa
oracle
edited Nov 17 '18 at 3:01
codeLover
2,2551620
asked Nov 16 '18 at 21:02
MoussaMoussa
11
Good day all,
When inserting data in the SIT as shown in the screenshot below i get the following error :
enter image description here
I've no idea about the origin of this error. I've tried to remove all the value set from the related KFF segment without success. Here after the text of the error (the error is not listed in MOS nor Google) :
APP-FND-01564: ORACLE error 1722 in FDFICD
Cause: FDFICD failed due to ORA-01722: invalid number.
The SQL statement being executed at the time of the error was: INSERT INTO PER_ANALYSIS_CRITERIA(ENABLED_FLAG, SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, SEGMENT1, SEGMENT2, SEGMENT3, REQUEST_ID, ID_FLEX_NUM, ANALYSIS_CRITERIA_ID) VALUES ('Y', :sumflg, to_date(:sdate, 'J'), to_date(:edate, 'J'), SYSDATE, :user_id, :SEGMENT1, :SEGMENT2, :SEGMENT3, :REQUEST_ID, :ID_FLEX_NUM, :ANALYSIS_CRITERIA_ID) and was executed from the file &ERRFILE.
Thank you for your help,
Regards,
Moussa
oracle
oracle
edited Nov 17 '18 at 3:01
codeLover
2,2551620
asked Nov 16 '18 at 21:02
MoussaMoussa
11
edited Nov 17 '18 at 3:01
codeLover
2,2551620
asked Nov 16 '18 at 21:02
MoussaMoussa
11
edited Nov 17 '18 at 3:01
codeLover
2,2551620
edited Nov 17 '18 at 3:01
codeLover
2,2551620
edited Nov 17 '18 at 3:01
codeLover
2,2551620
2,2551620
asked Nov 16 '18 at 21:02
MoussaMoussa
11
asked Nov 16 '18 at 21:02
MoussaMoussa
11
asked Nov 16 '18 at 21:02
MoussaMoussa
11
11
The error is clear: you passed in a string whereas you should have passed in a number. You'll need to verify the parameters one by one.
– Ole EH Dufour
Nov 16 '18 at 21:16
Thank you for your reply, The code is generated by the system, I've only setup the KFF. I've created another simple KFF with only one field and the error still appearing.
– Moussa
Nov 16 '18 at 22:12
Formatted the post
– codeLover
Nov 17 '18 at 3:01
add a comment |
The error is clear: you passed in a string whereas you should have passed in a number. You'll need to verify the parameters one by one.
– Ole EH Dufour
Nov 16 '18 at 21:16
Thank you for your reply, The code is generated by the system, I've only setup the KFF. I've created another simple KFF with only one field and the error still appearing.
– Moussa
Nov 16 '18 at 22:12
Formatted the post
– codeLover
Nov 17 '18 at 3:01
The error is clear: you passed in a string whereas you should have passed in a number. You'll need to verify the parameters one by one.
– Ole EH Dufour
Nov 16 '18 at 21:16
The error is clear: you passed in a string whereas you should have passed in a number. You'll need to verify the parameters one by one.
– Ole EH Dufour
Nov 16 '18 at 21:16
Thank you for your reply, The code is generated by the system, I've only setup the KFF. I've created another simple KFF with only one field and the error still appearing.
– Moussa
Nov 16 '18 at 22:12
Thank you for your reply, The code is generated by the system, I've only setup the KFF. I've created another simple KFF with only one field and the error still appearing.
– Moussa
Nov 16 '18 at 22:12
Formatted the post
– codeLover
Nov 17 '18 at 3:01
Formatted the post
– codeLover
Nov 17 '18 at 3:01
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53345329%2fhaving-an-error-on-the-sit-when-adding-information-oracle-ebs-11i%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53345329%2fhaving-an-error-on-the-sit-when-adding-information-oracle-ebs-11i%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
The error is clear: you passed in a string whereas you should have passed in a number. You'll need to verify the parameters one by one.
– Ole EH Dufour
Nov 16 '18 at 21:16
Thank you for your reply, The code is generated by the system, I've only setup the KFF. I've created another simple KFF with only one field and the error still appearing.
– Moussa
Nov 16 '18 at 22:12
Formatted the post
– codeLover
Nov 17 '18 at 3:01