| Miss [message #216525] |
Mon, 29 January 2007 03:14  |
|
|
Hi
I am currently creating an insurance claim module on forms 6i.
for my price claims i need to raise an invoice in AR that will inform the supplier there is a claim.
How do I go about creating an autoinvoice in AR?
Can anyone give me a sample on how to create the invoice?
I am new in the Oracle enviroment so i need as much details as possible.
Regards
Mpume
|
|
|
|
| Re: Miss [message #216531 is a reply to message #216525] |
Mon, 29 January 2007 04:22  |
vin_odks
Messages: 153
Registered: July 2006
Location: -
|
Senior Member |
|
|
In order to create Invoice in AR thru Autoinvoice,
the interface table ra_interface_lines_all needs to be populated.
The task is then to bring the data (Insurance claim module) into the interface table (develop interface programs). Then you may run the Autoinvoice program.
Regards
Vinod
|
|
|
|
| Re: Miss [message #216783 is a reply to message #216531] |
Tue, 30 January 2007 06:32 |
|
|
Hi Vinod
Thank you very much for your help.
Do you perhaps have an example on how to go about the whole process.
where do i get the data to pupulate the ra_interface_lines_all tables for the mandatory collumns.
I understand that INTERFACE_LINE_CONTEXT, BATCH_SOURCE_NAME, and TRX_TYPE, CUST_TRX_TYPE_ID needs to be setup form a functional perspective but i don't know which tables to collect all the data from like the set_of_books_id,Currency_code,Terms_id/name.
Do I get all the data from the orders management or what?
I am a bit stuck i have never done any interfaces before and i am a bit pressed for time.
Your help would greatly appreciated.
regards
Mpume
|
|
|
|
| Re: Miss [message #217025 is a reply to message #216525] |
Wed, 31 January 2007 06:38 |
vin_odks
Messages: 153
Registered: July 2006
Location: -
|
Senior Member |
|
|
Apart from the mandatory columns there are other important columns which needs to be populated.
Eg : TRX_NUMBER,ORIG_SYSTEM_BILL_CUSTOMER_ID,TAX_CODE,TAX_RATE,AMOUNT
and more..
Please go thru the Receivable Guide and TRM for further info...
There are important informations to be collected before you create any interface program, like :
1) Understand the need for Auto invoice
2) Understand the functional details of Auto invoice
a) Understand the Setups.
b) Understand the validation done by oracle.
3) Understand the technical details of Auto invoice
a) Understand the structure of interface table.
b) Map Interface table with oracle standard table values.
c) Map your Custom table with Interface table .
d) Understand the required validation.
4) Create the Interface program to populate the ra_interface_lines_all table
As for
| Quote: |
which tables to collect all the data from like the set_of_books_id,Currency_code,Terms_id/name.
|
Set of books - HR_OPERATING_UNITS Currency_code- GL_SETS_OF_BOOKS
Terms id/Name - RA_TERMS
Hope it provides an insight..
Regards
Vinod
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
