OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Current Period set and start date of current financial Year

Home » Applications » Oracle Fusion Apps & E-Business Suite » Current Period set and start date of current financial Year (EBS R12)

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

Current Period set and start date of current financial Year [message #565287]

Mon, 03 September 2012 02:29

kmistry@onwardinfosys.com
Messages: 2
Registered: September 2012
Location: Nashik

Junior Member

Hello

I have a requirement in that I have to find out period set used by transaction and start date of current Financial year. I am using EBS R12.

I created following query to get result,

SELECT p.period_set_name,p.year_start_date
FROM gl_periods p,
gl_sets_of_books_v b,
hr_operating_units ou
WHERE b.set_of_books_id = ou.set_of_books_id
AND p.period_set_name = b.period_set_name
AND p.period_type = b.user_period_type
AND TRUNC(SYSDATE) BETWEEN p.start_date and p.end_date
AND organization_id = FND_PROFILE.VALUE('ORG_ID');

Please let me know if it is correct, if not then which is the correct way to get result

Regards,
Kapil

Report message to a moderator

Re: Current Period set and start date of current financial Year [message #565469 is a reply to message #565287]

Tue, 04 September 2012 11:43

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

What do you mean by "transaction" ?

By
Vamsi

Report message to a moderator

Re: Current Period set and start date of current financial Year [message #565511 is a reply to message #565469]

Tue, 04 September 2012 23:39

kmistry@onwardinfosys.com
Messages: 2
Registered: September 2012
Location: Nashik

Junior Member

Hi,

If you see GL period setup (General Ledger Super User->Setup->Financial->Accounting Canlder)
there is too many period sets.
I want current period set name used by Sales and Receivables.

Regards,
Kapil

Report message to a moderator

Re: Current Period set and start date of current financial Year [message #566450 is a reply to message #565511]

Fri, 14 September 2012 12:15

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Hi Kapil,

Why can't you take it from gl_ledgers and gl_periods only using profile 'GL_SET_OF_BKS_ID' ?

By
Vamsi

Report message to a moderator

Previous Topic:	R12 Cloning Windows 64Bit
Next Topic:	Could someone please explain what Procurement to Pay and Order to Cash cycles mean? Thanks.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:47:52 CST 2024