Home » Applications » Oracle Fusion Apps & E-Business Suite » create accounting error (r12)
create accounting error [message #410577] Mon, 29 June 2009 02:02 Go to next message
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 2903 times)
Re: create accounting error [message #410603 is a reply to message #410577] Mon, 29 June 2009 04:07 Go to previous messageGo to next message
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
Re: create accounting error [message #410615 is a reply to message #410603] Mon, 29 June 2009 04:53 Go to previous messageGo to next message
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 2342 times)
Re: create accounting error [message #410618 is a reply to message #410615] Mon, 29 June 2009 05:04 Go to previous messageGo to next message
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
Re: create accounting error [message #410623 is a reply to message #410618] Mon, 29 June 2009 05:19 Go to previous messageGo to next message
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 2235 times)
Re: create accounting error [message #410624 is a reply to message #410623] Mon, 29 June 2009 05:24 Go to previous messageGo to next message
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 2221 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 Go to previous messageGo to next message
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
Re: create accounting error [message #410715 is a reply to message #410626] Mon, 29 June 2009 21:51 Go to previous messageGo to next message
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 2069 times)
Re: create accounting error [message #410716 is a reply to message #410715] Mon, 29 June 2009 22:13 Go to previous messageGo to next message
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
Re: create accounting error [message #410719 is a reply to message #410716] Mon, 29 June 2009 22:37 Go to previous messageGo to next message
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?
Re: create accounting error [message #410960 is a reply to message #410719] Wed, 01 July 2009 05:22 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: create accounting error [message #416766 is a reply to message #415568] Tue, 04 August 2009 04:49 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
thanks.
Re: create accounting error [message #547555 is a reply to message #415568] Wed, 14 March 2012 12:46 Go to previous messageGo to next message
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
Re: create accounting error [message #548990 is a reply to message #410577] Tue, 27 March 2012 07:22 Go to previous message
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.
Previous Topic: report running problem
Next Topic: How to list records in form
Goto Forum:
  


Current Time: Mon Mar 18 22:26:30 CDT 2024