Members   Search   Help    Register    Login   Home
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: 61
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 34 times)
Report message to a moderator
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: 1597
Registered: October 2003
Location: Hyderabad, India
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 Go to previous messageGo to next message
bananaman
Messages: 61
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 20 times)
Report message to a moderator
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: 1597
Registered: October 2003
Location: Hyderabad, India
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 Go to previous messageGo to next message
bananaman
Messages: 61
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 18 times)
Report message to a moderator
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: 61
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 14 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: 1597
Registered: October 2003
Location: Hyderabad, India
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 Go to previous messageGo to next message
bananaman
Messages: 61
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 18 times)
Report message to a moderator
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: 1597
Registered: October 2003
Location: Hyderabad, India
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 Go to previous messageGo to next message
bananaman
Messages: 61
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 Go to previous messageGo to next message
vamsi kasina
Messages: 1597
Registered: October 2003
Location: Hyderabad, India
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: 1
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 Go to previous message
bananaman
Messages: 61
Registered: March 2009
Member
thanks.
Report message to a moderator
Previous Topic:Customize java class "ItemInfoHelper.java" and compile in OAF
Next Topic:cash forecast value date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 7 23:24:32 CST 2009

Total time taken to generate the page: 0.20262 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.