Hi,

it’s extremly simple to send csv files in Apps 10:

1. define a variable cvs_ of datatype CLOB and fill it with the content of the csv file.
2. call Plsqlap_Server_API.Post_Outbound_BizAPI(bizapi_name_ => '', xml_ => csv_, sender_ => 'IFS', receiver_ => '<any value for identifying it in routing condition, e, g. MY_CSV>');

That’s all.

Best regards

Heinz

Thank you for Sharing Heinz .. I will give it a try .

Hi ​@Thejaswini 

Did you generate the csv file with this option?
I used the same mechanism in APPS10, but it is getting below error

Error while preparing input data. 
Caused by: ifs.fnd.base.SystemException: Invalid xml format

 

I tried with below code.

 PLSQLAP_Server_API.Post_Outbound_BizAPI(
      bizapi_name_  => null,
      xml_   => csv_clob, 
      sender_ => 'IFS',
      message_type_ => 'MALJLK');

Did I miss anything??

Hello Malan,
Yes, I was able to generate CSV and your code looks good.

How did you structure your Clop variable?

Regards

Thej

Hi ​@Thejaswini 

I used the attached sample for testing.
It has the clob variable structure.

I have attached the Sample code I have used.

Hope this helps.

Hi ​@Thejaswini 

Thank you for providing the sample file. I have identified the root cause of the issue.

Initially, I implemented the solution in the APPS10 UPD0 version, where the CSV file format was not supported. I then reimplemented the same solution in the APPS10 UPD21 environment, and the CSV file was successfully transferred without any issues.

It is possible that the CSV file format was not supported in earlier UPD versions.

/Malan Jayanka