Title

Thursday, 22 June 2017

What’s the functionality of Auto invoice master program?



It will insert the data from interface tables to invoice base tables.
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
AR_PAYMENT_SCHEDULES_ALL

What’s the functionality of workflow background process?



It will move the data from OM base tables to AR Interface tables (RA_Interface_lines_all) in case of “Line – Flow Generic Workflow”

When data will be inserted into wsh_delivery_details and wsh_delivery_assignments



At the time of book order records will be inserted into wsh_delivery_details with released_status =’R’ (Ready to Release) and wsh_delivery_assignments

Saturday, 3 June 2017

How we can skip header records while loading?



By using the "SKIP=n" keyword. "n" specifies the number of logical rows to skip.
i.e. SKIP=1