Hello All,
I have a requirement of creating CSV file in IFS 10 and sending it to external services .
I need to send the file using SFTP connector(integration)
Does anybody have an Idea on how to create a csv file and send it through Clob variable in PLSQL_Server_Api. Any sample code would help.
Regards,
Thej
Best answer by heibde
Hi,
it’s extremly simple to send csv files in Apps 10:
That’s all.
Best regards
Heinz
Hi,
it’s extremly simple to send csv files in Apps 10:
That’s all.
Best regards
Heinz
+9Hi
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
+9Hi
I used the attached sample for testing.
It has the clob variable structure.
+9Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
