Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to get Org id / dist code combination for Importing into Payables

edited Jul 1, 2009 6:24PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
Hello,

   I am trying to develop a  Custom import for Payable Invoices and need help loading the data to the staging tables.Our chart of accounts is of 3 segments.Company, account and department.

 The data file that comes in just  has the Department number.

Now depending on the items the account segment varies.What is the best way to get the proper account number. Do I need to create a lookup code to say that if it s item A then  the account is 4000 and B then 5000 etc..

 Also, some departments (say x ) are associated with more than one company(1,3,5),though they have just one active company(5). The other company segments associated with x are old and not valid, but those companies are not deactivated either.What could be  the possible way to get the Company segment.I am trying to get the  code combo to import to the table.

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