Home » Applications » Oracle Fusion Apps & E-Business Suite » inventory_item_id is null in table (11i)
inventory_item_id is null in table [message #298376] Tue, 05 February 2008 23:57 Go to next message
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
Senior Member
hi experts

i need to join mtl_system_items_b with ra_customer_trx_lines_all, and it seems very easy but problem is .. my ra_customer_trx_lines_all.inventory_item_id is null and doesnt record any code but description is there.. what is this??? is this a kind of implimentation error ??
can anybody tell me what to do with this problem or anyother way to join with material file




regards


anwer

Report message to a moderator

Re: inventory_item_id is null in table [message #298574 is a reply to message #298376] Wed, 06 February 2008 09:11 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I don't think so. I think it is expected behaviour.

When you check the User Guide (for link have a look at Oracle Applications Forum Guide), Section Setting Up -> AutoAccounting -> Standard Lines
(Or) Section Transactions -> Adjusting Revenue or Sales Credits,
Quote:
the transaction line must be
either an inventory item or standard memo line
Also check etrm.
It is possible to have inventory_item_id as null and memo_line_id as null and both can't be populated in same row.

By
Vamsi

Report message to a moderator

Previous Topic: Tax registration No
Next Topic: Invoice payment
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 05:15:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.