Help With File Layout...
i need some help with File Layout.
I have simple File Layout which Reads a Flat File and Loads into Voucher staging Tables:
VCHR_HDR_STG ,
VCHR_LINE_STG
VCHR_DIST_STG .
( VCHR_HDR_STG ==> VCHR_LINE_STG ==> VCHR_DIST_STG )
It is a simple File Laout reading the File and loding the Staging tables.
The Problem we are facing is when we run this Process it is loading on ly the Header Records, it is not loading the Line Records. I am able to preview the Data in the File Layout.
This is happening in Production.
But when i try to run the same Process in QA with the same File , it loads fine into all the Tables. This is very confusing and any help in this regard would be greatly appreciated.