كيفيه التعامل مع interface table
مثال auto invoice

ممكن شرح زيادة......

interface table are intermediate table that oracle provides for integration purposes so u hit in those interface tables instead of hitting in the base tables which is strictly prohibited
be sure to enter data in the correct format of the interface
otherwise this data will fail the validation that the apps performs to check that this data is correct before loading it to the apps

regards

i need to understand how to make the feeder program that loads the data in the invoices interface tables such as
RA_INTERFACE_LINES_ALL
i need an example please....
THANKS U 4 UR HELP

You must have the Order Entry Module to load data into RA_INTERFACE_LINES_ALL table

EX:

1- make an order
2-book the order
3-realase the order
4-ship the order
after ship confirmed stage the data of this order will be loaded into
RA_INTERFACE_LINES_ALL table

then you goto
Receivables---->Interfaces---->Autoinvoice

also You can edit the data befoe autoinvoice
Receivables---->control---->interface lines

Thank u but, This is not exactly what i meant..
i'm working in The 'Receivables' Module,
When i make an Autoinvoice Request i have Two Choices:
- Autoinvoice Master Program
- Autoinvoice Purge Program

But i need to make a My Customized "Autoinvoice Masetr Program" Which Loads the data from External Financial System into The Oracle Interface Tables and then make the oracle issues the invoice.

Well, After searching i found a way to do this by making my own Concurrent Program with Execution Method SQL*Loader but i don't know which tables to insert the data into and what is the minimum columns required to import a very simple invoice into these table.

el salam alykom

u can define new custom concurrent request and register them in side the apps the type of the concurrent request that u'll use to import the data from the external system in the interface table ra_interface_lines depends on what output u can get from that external system .
ex u can use the request type of sql to import the data from the external system if can get it through issuing select statment against the database for example if the external system is on the same db as the application or in another db that u can connect to using a database link and remember u can connect to non oracle dbs
also u can use the type sql loader to load the data but this will mean that u must prodive a data file from the external system into a specific directory on the server to upload it also u must make another program to generate this file from the external system

hope i did help
regarding which fields in the interface u'll need to use this depends on the auto invoice setup that u have on the application also u;ll find documentation on that subject in the recivables user guide
also u 'll find documentation regarding defining the new concurrent request and there types in the application developer guide documentation also there is a white paper on the metalink called defining custom concurrent requests

regards
alaa