Home » Applications » Oracle Fusion Apps & E-Business Suite » Miss
Miss [message #216525] Mon, 29 January 2007 03:14 Go to next message
mpumee
Messages: 2
Registered: January 2007
Location: SA
Junior Member

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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
mpumee
Messages: 2
Registered: January 2007
Location: SA
Junior Member

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 Go to previous message
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
Previous Topic: PO: Vacation rule Doubt
Next Topic: what is set of books?
Goto Forum:
  


Current Time: Thu Dec 05 18:54:16 CST 2024