OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » GL date, 31-MAR-10, is not in an open or future-enterable period (merged)

Home » Applications » Oracle Fusion Apps & E-Business Suite » GL date, 31-MAR-10, is not in an open or future-enterable period (merged) (R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GL date, 31-MAR-10, is not in an open or future-enterable period (merged) [message #473304]

Fri, 27 August 2010 06:05

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello to All,

I am Using Receipt API(AR_RECEIPT_API_PUB,Create_Apply_On_Acc) to create Receipts.
Its Returning me an Error stating : "GL date, 31-MAR-10, is not in an open or future-enterable period."

While The Period is Already in 'Open' stage at GL as well as AR level.

Please Help !!

Thanx in Advance...

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473317 is a reply to message #473304]

Fri, 27 August 2010 06:41

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

I'll respond to a random of the 3 posts Smile

Smile

What is the exact APP- message that you get? Did you initialize your session with apps_initialize?

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473318 is a reply to message #473317]

Fri, 27 August 2010 06:42

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello Arian,

Yup i am already Using the Initialization :
FND_GLOBAL.APPS_INITIALIZE(FND_PROFILE.VALUE('USER_ID'),
FND_PROFILE.VALUE('RESP_ID'),
FND_PROFILE.VALUE('RESP_APPL_ID'),
NULL,
NULL);
and then the : AR_RECEIPT_API_PUB.Create_Apply_On_Acc Procedure

Thanx,
Deepak

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473321 is a reply to message #473318]

Fri, 27 August 2010 06:46

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

so what is the exact message you get?

AR_INVALID_APP_GL_DATE ?

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473323 is a reply to message #473321]

Fri, 27 August 2010 06:50

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello,

I am trying to make it run from SQL.

The DBMS Output is as follows :
Return Status = E
Message Count = 42
Message Data =
GL date, 31-MAR-10, is not in an open or future-enterable period.

while the periods are Open at GL Level and AR level too...

The below mentioned query returns 1 as result :

SELECT COUNT ( * )
--INTO v_count
FROM gl_period_statuses gps
WHERE gps.application_id = 101
AND gps.set_of_books_id = 2021
AND gps.closing_status IN ( 'O', 'F' )
AND '31-MAR-2010' BETWEEN gps.start_date and
gps.end_date;

Regards,
Deepak

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473326 is a reply to message #473323]

Fri, 27 August 2010 06:58

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

and for application_id 222?

Also what are your receipt and apply dates? If i'm not mistaken, apply(_gl_)date needs to be >= receipt_date.

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473333 is a reply to message #473326]

Fri, 27 August 2010 07:10

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello,

and for application_id 222? - Its resulting in 1(one).

Also what are your receipt and apply dates? If i'm not mistaken, apply(_gl_)date needs to be >= receipt_date.

Answer - Receipt Date - 31-Mar-2010
Gl-Date - 31-Mar-2010
Apply date - 27-Aug-2010

Thanx and regards,
Deepak

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473337 is a reply to message #473333]

Fri, 27 August 2010 07:33

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

when I check fnd_new_messages, your error is 'AR_INVALID_APP_GL_DATE'. Since the gl_date appears to be valid, it could be the 'apply_gl_date'.

Do you set the apply_gl_date separately? What is the gl_date of the transaction that you are applying to?

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473341 is a reply to message #473337]

Fri, 27 August 2010 07:54

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello Arian,

Do you set the apply_gl_date separately? What is the gl_date of the transaction that you are applying to?

Answer :-

Nope i amm not passing the apply_gl_date separately.

But i have tried that too on my Instance.

Even if i try with apply_gl_date(Both the dates as same):

,p_gl_date => p_gl_date
,p_apply_gl_date => p_gl_date

It do not works. It again gives the same message: 'GL date, 31-MAR-10, is not in an open or future-enterable period'

Regards,
Deepak

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473345 is a reply to message #473341]

Fri, 27 August 2010 08:14

Alien
Messages: 292
Registered: June 1999

Senior Member

My bad. I thought you were using create_receipt_and_apply. But you're applying on account. So no problem there.

Can you try and run the following sql: (After initializing your session):

Set Serveroutput On;

Begin
If Arp_util.Is_gl_date_valid(P_gl_date,'Y') Then
Dbms_output.Put_line('Valid 1: '||to_char(p_gl_date));
Else
Dbms_output.Put_line('Invalid 1: '||to_char(p_gl_date));
End If;
If Arp_util.Is_gl_date_valid(p_gl_date,'N') Then
Dbms_output.Put_line('Valid 2');
Else
Dbms_output.Put_line('Invalid 2');
End If;
End;

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473346 is a reply to message #473345]

Fri, 27 August 2010 08:20

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello Arian,

Its Output is as follows :
Invalid 1: 31-MAR-10
Invalid 2

Regards,
Deepak

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473349 is a reply to message #473346]

Fri, 27 August 2010 08:35

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

just to make sure. It is not an adjustment period, is it?

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473350 is a reply to message #473349]

Fri, 27 August 2010 08:36

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello Arian,

Yes it's an Adjustment Period also(31-MAR-2010).
and the Adjustment Period is Open too...

Regards,
Deepak

[Updated on: Fri, 27 August 2010 08:39]

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473352 is a reply to message #473350]

Fri, 27 August 2010 08:43

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

ok. Let's try this statement:

Select period_name,closing_status,adjustment_period_flag, start_date,end_date
From Gl_period_statuses
Where Application_id in (101,222)
and set_of_books_id = 2021
And Adjustment_period_flag = 'N'
And to_date('31-MAR-2010','dd-mon-yyyy') Between Start_date And End_date
And Closing_status In ('O', 'F', 'N') ;

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473353 is a reply to message #473352]

Fri, 27 August 2010 08:46

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello Arian,

Please find the attached file for result.

Deepak

Attachment: abc.csv
(Size: 0.17KB, Downloaded 1275 times)

[Updated on: Fri, 27 August 2010 08:48]

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473355 is a reply to message #473353]

Fri, 27 August 2010 09:13

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

ok. I'm giving up. It doesn't make sense to me. I thought the adjustment period would be in the way. But the code excludes adjustment periods, and the regular periods are ok.

I checked in a number of my environments, and can't find any reason.

Sorry, but I think you'll need to go to Oracle Support.

Regards,

Arian

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473412 is a reply to message #473355]

Sat, 28 August 2010 00:11

deepak3arora
Messages: 32
Registered: October 2009
Location: chandigarh

Member

Hello,

Anyhow A BIG THANX Arian for your Help !!!

Keep up the Good Work...

Deepak

Report message to a moderator

Re: GL date, 31-MAR-10, is not in an open or future-enterable period [message #473510 is a reply to message #473412]

Sun, 29 August 2010 16:18

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

I hope you'll be able to work out a solution. Do let us know what it was.

Good luck,

Arian

Report message to a moderator

Previous Topic:	How to disable a package..
Next Topic:	Ar_receipt_api_pub.Create_cash Unexpected Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:08:16 CDT 2024