Home » Applications » Oracle Fusion Apps & E-Business Suite » Issue with AR  () 1 Vote
Issue with AR [message #268442] Tue, 18 September 2007 11:50 Go to next message
raazintouch
Messages: 27
Registered: August 2007
Junior Member
Hi Friends,

I have created a combo responsibility and tried using receivables. But it is showing error “The set of books ID in receivables system is not invalid in GL system”

Please help me to resolve this issue.

Regards,
Raju K
Re: Issue with AR [message #268446 is a reply to message #268442] Tue, 18 September 2007 12:28 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
is not invalid
Copy and paste the error with the error code.
Is it on R12 or 11i?

By
Vamsi
Re: Issue with AR [message #268633 is a reply to message #268446] Wed, 19 September 2007 04:00 Go to previous messageGo to next message
raazintouch
Messages: 27
Registered: August 2007
Junior Member
Hi Vamsi,

Its in 11i only and I am not getting any error code. Just its not allowing me to tansact anything or opening any windows. Its working in Vision Operations. I think we need activate some profile options or something like that.

Please help me??


Regards,
Raju K
Re: Issue with AR [message #268663 is a reply to message #268633] Wed, 19 September 2007 05:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
is not invalid
Still you have not given the exact error.

Is it "is invalid"? When I say exact error messages, please use the same case also.
I think it is
Quote:
The set of books ID in the Receivables system options does not belong to a valid set of books in Oracle General Ledger. Please contact your system administrator.
Cross check your SOB in ar_system_parameters and whether it is there in gl_sets_of_books.

By
Vamsi
Re: Issue with AR [message #268665 is a reply to message #268663] Wed, 19 September 2007 05:34 Go to previous messageGo to next message
raazintouch
Messages: 27
Registered: August 2007
Junior Member
Hi Vamis,

I am sorry I am not clear. The error message you have provided is the exact error message I am getting. Kindly let me know how to check "ar_system_parameters". Is this a profile option or...?

Help!

Regards,
Raju K
Re: Issue with AR [message #268669 is a reply to message #268665] Wed, 19 September 2007 05:48 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check the profile option 'ORG_ID' value. If it is null then set that value, as your business needs.
Check the SOB attached to that in ar_system_parameters_all table
select set_of_books_id
  from ar_system_parameters_all
 where org_id = <your irg_id>;
Now check whether it is present in gl_sets_of_books table.

I think the profile option ORG_ID hasn't been set in your case.

By
Vamsi
Re: Issue with AR [message #268671 is a reply to message #268669] Wed, 19 September 2007 05:58 Go to previous messageGo to next message
raazintouch
Messages: 27
Registered: August 2007
Junior Member
Hi Vamsi,

Thanks for help... I will do as u advised and let you know if I have queries.

Thanks again

Regards,
Raju K
Re: Issue with AR [message #269043 is a reply to message #268442] Thu, 20 September 2007 09:34 Go to previous messageGo to next message
raazintouch
Messages: 27
Registered: August 2007
Junior Member
Hi vamsi,

Below are the errors I am getting when I tried using AR in my systems.

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.ARP_STANDARD", line 2240
ORA-20001: APP-AR-11218: The set of books ID in the Receivables system options does not belong to a valid set of books in Oracle General Ledger. Please contact your system administrator.
ORA-06512: at "APPS.ARP_UTIL", line 632

--------------------------------------------------------------
FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-06502.


I have mentioned my set of books ID

Set of books ID=7609

When I tried running query for the blow code

select set_of_books_id
from ar_system_parameters_all
where org_id = <your irg_id>; (I tried org id with 7609 and org_id in my system too)

the below error is showing

ORA-00911: invalid character

Please find the attached screenshots for your reference and advise.

Regards,
Raju K
  • Attachment: Errors.doc
    (Size: 97.50KB, Downloaded 761 times)
Re: Issue with AR [message #269047 is a reply to message #269043] Thu, 20 September 2007 09:57 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Can you paste exact sql on ar_system_parameters_all (on the sql prompt)?
By the way you said your Set of Books Id is 7609.
Quote:
I tried org id with 7609 and org_id in my system too
How come your org_id is also same?

Also
Quote:
where org_id = <your irg_id>;
is a typo. replace your org_id there.

By
Vamsi

[Updated on: Thu, 20 September 2007 10:01]

Report message to a moderator

Re: Issue with AR [message #529375 is a reply to message #268442] Mon, 31 October 2011 07:10 Go to previous message
p_shripad
Messages: 1
Registered: October 2011
Location: India
Junior Member
Hi Raju,

The error is because of: AR- System Option setup is incompleate. Once you compleate the setup the issue will get resoved.

Regards
SVP
Previous Topic: move order and reservation
Next Topic: Flag this message Reg ADF , chekbox and af:table
Goto Forum:
  


Current Time: Mon Oct 20 17:14:00 CDT 2014

Total time taken to generate the page: 0.10986 seconds