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
Messages: 198
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


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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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,
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.

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

Current Time: Mon Oct 24 07:42:59 CDT 2016

Total time taken to generate the page: 0.14185 seconds