Procurement - EBS (MOSC)

MOSC Banner

PO Accrual Account Generator does not work while autocreating PO from PR

edited Oct 3, 2014 5:00AM in Procurement - EBS (MOSC) 2 commentsAnswered

Our PO Account generator works well from PO form, but does not work while autocreating PO from PR. I check the fnd log message and below is the root cause, and I am so confused. While autocreate from pr to po, the po account generator is not called in po_interface_s.generate_shared_proc_accounts because the cursor l_SPS_lines_csr does not return records. The root cause of it is below cursor sql condition: AND hoi.org_information3<>TO_CHAR(g_purchasing_ou_id) -- DOU<>POU our operating unit id is 1512 and inventory organization id is 1513 in above condition the g_purchasing_ou_id=1512, and hoi.org_information3 is also 1512. Below is the cursor: CURSOR l_SPS_lines_csr

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center