OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » create accounting error (r12)

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

create accounting error [message #410577]

Mon, 29 June 2009 02:02

bananaman
Messages: 71
Registered: March 2009

Member

Hi! I'm trying to use the Create Accounting program. Attached is the output of the program. Any detailed suggestion to fix this problem?

Attachment: FNDWRR.pdf
(Size: 8.46KB, Downloaded 3300 times)

Report message to a moderator

Re: create accounting error [message #410603 is a reply to message #410577]

Mon, 29 June 2009 04:07

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

Senior Member

As it says, it is not able to derive the CCID for cash_clearing.
Check the setup.
Ledger -> SLAM -> AAD -> JLD -> JLT -> ADR.

Check the sources attached to the ADR's and check the values of the sources.

By
Vamsi

Report message to a moderator

Re: create accounting error [message #410615 is a reply to message #410603]

Mon, 29 June 2009 04:53

bananaman
Messages: 71
Registered: March 2009

Member

Hi! I'm not familiar with this new feature in R12. Attached is the screenshot of the Account Derivation Rules window for Cash Clearing Account that I found up. What should I do next with this? Kindly advise. All of the fields are protected for update.

Attachment: Doc1.doc
(Size: 63.50KB, Downloaded 2729 times)

Report message to a moderator

Re: create accounting error [message #410618 is a reply to message #410615]

Mon, 29 June 2009 05:04

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

Senior Member

Quote:

Check the sources attached to the ADR's and check the values of the sources.

Here Bank Cash Clearing Account is the source.
If you check the conditions tab, you may find some more sources.
You need to find out the columns attached these sources and check whether the conditions are met and the source is having some value or not.
Check the sources window.

By
Vamsi

Report message to a moderator

Re: create accounting error [message #410623 is a reply to message #410618]

Mon, 29 June 2009 05:19

bananaman
Messages: 71
Registered: March 2009

Member

Hi! When I clicked the Conditions button for Bank Cash Clearing Account, the Account Derivation Rule Conditions window is empty.
Attached is the screenshot. Please advise.

Attachment: Doc1.doc
(Size: 106.00KB, Downloaded 2616 times)

Report message to a moderator

Re: create accounting error [message #410624 is a reply to message #410623]

Mon, 29 June 2009 05:24

bananaman
Messages: 71
Registered: March 2009

Member

This is what I've got in the Sources window upon checking the Bank Cash Clearing Acount. Kindly see the attached file.

Attachment: Doc1.doc
(Size: 131.50KB, Downloaded 2597 times)

[Updated on: Mon, 29 June 2009 05:29]

Report message to a moderator

Re: create accounting error [message #410626 is a reply to message #410624]

Mon, 29 June 2009 05:42

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

Senior Member

Good! As you don't have conditions, this ADR will execute always.
The Source Code is the columns name of your transaction object.
For your transaction object view, check the window Accounting Event Class Options, second tab.

Then you can check whether the value of the column is null or not, If it is null, then that is the issue. You should correct that.

By
Vamsi

Report message to a moderator

Re: create accounting error [message #410715 is a reply to message #410626]

Mon, 29 June 2009 21:51

bananaman
Messages: 71
Registered: March 2009

Member

Hi! I checked the Accounting Event Class window and found out the following Transaction Objects: AP_PAYMENT_EXTRACT_DETAILS_V and AP_PAYMENT_EXTRACT_HEADER_V.

Under the AP_PAYMENT_EXTRACT_DETAILS_V, its corresponding Primary Reference Objects have checkbox "Always Populated" unchecked. On the other hand, the Reference Objects under AP_PAYMENT_EXTRACT_HEADER_V have checkbox "Always Populated" checked. In addition to that, both object types in the Join Condition field have different values for each object name.

How can I check if the column is null or not based on these data? Attached is the screenshot of the window.

Attachment: Doc1.doc
(Size: 115.00KB, Downloaded 2438 times)

Report message to a moderator

Re: create accounting error [message #410716 is a reply to message #410715]

Mon, 29 June 2009 22:13

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

Senior Member

Check the Transaction View also, which is in the header block of that window.
Check whether which of these views are having your source code as the column in the database by desc <viewname>.

Try to select from the view. If it is not returning any rows, might be some GT table is getting used.
Check the view definition using user_views.text
Get the base table of your column.
Now try to get the column value from the base table using the filters, which are in the view definition.

By
Vamsi

Report message to a moderator

Re: create accounting error [message #410719 is a reply to message #410716]

Mon, 29 June 2009 22:37

bananaman
Messages: 71
Registered: March 2009

Member

Hi! I'm a confused with the instructions given. Can we accomplish it step by step? Let's start with this one.

vamsi kasina wrote on Mon, 29 June 2009 22:13

Check Check whether which of these views are having your source code as the column in the database by desc <viewname>.

From the Transaction View field, this is the value "AP_SLA_PAYMENTS_TRANSACTION_V". What's next to this?

Report message to a moderator

Re: create accounting error [message #410960 is a reply to message #410719]

Wed, 01 July 2009 05:22

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

Senior Member

You are not reading my posts fully. My answers are becoming redundant.

Quote:

desc <viewname>.

Describe all the 3 views.
Check which view is having the column as (source_code), which you have got in the sources window.

Select from the database.

Quote:

Try to select from the view. If it is not returning any rows, might be some GT table is getting used.
Check the view definition using user_views.text
Get the base table of your column.
Now try to get the column value from the base table using the filters, which are in the view definition.

By
Vamsi

[EDIT: Please upload jpg instead of doc, if you are uploading pictures.]

[Updated on: Wed, 01 July 2009 06:46]

Report message to a moderator

Re: create accounting error [message #415568 is a reply to message #410960]

Tue, 28 July 2009 04:45

m.wattar
Messages: 2
Registered: July 2009

Junior Member

Hi bananaman ,

The bank account you generate the payment you don't assign cash clearing account , You can assign it from : Setup-->Payment-->Bank Accounts-->Account Controls and from Account Control window Options Button from Bank Account window also.

Thanks
Mohammed Moustafa

Report message to a moderator

Re: create accounting error [message #416766 is a reply to message #415568]

Tue, 04 August 2009 04:49

bananaman
Messages: 71
Registered: March 2009

Member

thanks.

Report message to a moderator

Re: create accounting error [message #547555 is a reply to message #415568]

Wed, 14 March 2012 12:46

rajeshknl
Messages: 1
Registered: March 2012
Location: New York

Junior Member

Hi Water,
I got the same issue with error 95353. What if the transactions are before the setup of cash clearing account has be rectified.

Thanks
Rajesh

Report message to a moderator

Re: create accounting error [message #548990 is a reply to message #410577]

Tue, 27 March 2012 07:22

nishant_sah2006
Messages: 1
Registered: March 2012
Location: Kolkata

Junior Member

this is a create accounting issue.

the bank setup requires the cash clearing natural account code to be put in.

the same is not being found.

once the code put in the payment will be posted to the cash clearing account.

Report message to a moderator

Previous Topic:	report running problem
Next Topic:	How to list records in form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 05:41:18 CST 2024