identify record number being processed in Custom Integrator?
Hi gurus,
We have developed a custom integrator using a PL/SQL packaged procedure as the interface. Inside this package we insert into a custom table.
We are on Oracle Financials 11.5.10.2.
The custom table is located in a custom schema called CGL.
Our requirement is to perform some validation in the database package when the Web ADI infrastructure is processing the first row in the excel spreadsheet that the user is using to upload data.
We have a header row with the following columns.
Source System
Feeder System
Version Number
When the user chooses Oracle => Upload option from the Excel menu, we have to validate that the Version Number is valid i.e. we have to validate that the previous version of the file for the Source System and Feeder System combination has been successfully processed by the subsequent programs before the user is allowed to upload the next version of the file for this combination.
We have developed a custom integrator using a PL/SQL packaged procedure as the interface. Inside this package we insert into a custom table.
We are on Oracle Financials 11.5.10.2.
The custom table is located in a custom schema called CGL.
Our requirement is to perform some validation in the database package when the Web ADI infrastructure is processing the first row in the excel spreadsheet that the user is using to upload data.
We have a header row with the following columns.
Source System
Feeder System
Version Number
When the user chooses Oracle => Upload option from the Excel menu, we have to validate that the Version Number is valid i.e. we have to validate that the previous version of the file for the Source System and Feeder System combination has been successfully processed by the subsequent programs before the user is allowed to upload the next version of the file for this combination.
0