Incentive Compensation - EBS (MOSC)

MOSC Banner

Error:Cause: FDPSTP failed due to ORA-01722 while collecting the AR data to OIC. Urgent help needed

edited Nov 28, 2014 4:35AM in Incentive Compensation - EBS (MOSC) 3 commentsAnswered

This is error i am getting and really show stopper for us as not able to collect data from AR.. Please help.

Problem Summary

---------------------------------------------------

Error while collecting the AR data to OIC

Problem Description

---------------------------------------------------

Error while collecting the AR data to OIC

Details are

Cause: FDPSTP failed due to ORA-01722: invalid number

ORA-06512: at "APPS.CN_COLLECT_INVOICES_82", line 769

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SQL", line 1825

ORA-06512: at "APPS.CN_COLLECT_INVOICES", line 70

ORA-06517-NOV-2014 00:37:38

+---------------------------------------------------------------------------+

Incentive Compensation: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

CN_COLLECT_INVOICES module: Collect Invoices

+---------------------------------------------------------------------------+

Current system time is 17-NOV-2014 00:37:28

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Incentive Comp Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center