Page 1 of 1

Problem in Open/Close Period form

Posted: Mon Jul 07, 2008 3:21 am
by akumar.oracle
When trying to Open the form Open/Close Periods

Receivables: Control > Accounting > Open/Close Periods

I get the following error

ORA-01403: no data found

--------------------------------------------------------------
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-01403.


Please help

Regards

Avin

Posted: Tue Jul 08, 2008 1:32 am
by Murthyoracle
Hi Avin,

I think u got the another data error in Auto Accounting in AR. Let me know have u got any data errors in other Modules or else only in AR. First of all in which version you are woring. One more thing is in which instance you got this error like Vision Operations or Your Development or Production instances.

If other modules like GL , AP working successfully means you should verify the set ups in AR from Starting like defining KFFs and also your GL Calender upto which period it has been defined.

And If other modules like GL , AP are also getting same data error , you have to take the help of Tech and DBA Consultant.

Posted: Sun Jul 13, 2008 9:10 am
by akumar.oracle
I am using the vision operation.
Release 11.5.10.2

The problem right now is at AR. In GL i am able to see that Period Type.

Posted: Mon Jul 14, 2008 9:51 am
by fayyaz.tak
i think you will check the system options in oracle receivable setup
not confirmed same problem as i see in the R12 correct or define the system option in receivable setup

Regards
Fayyaz tak

Posted: Mon Jul 14, 2008 10:33 am
by Murthyoracle
Hi Avin,

Verify and ensure that the calender in GL and AR shoul be same. This means that verify which SOB assigned to AR responsibility. It should same SOB with GL.

Otherwise, you should take help of Sys admin , DBA and Tech. People .

Regards,