Showing posts with label SEND SEPERATE REMITTANCE. Show all posts
Showing posts with label SEND SEPERATE REMITTANCE. Show all posts

Saturday, 24 July 2021

'Send Separate Remittance Advice' program completed in error: IBY_XDO_DELIVERY_CFG_FILE profile option is not set or is invalid.

 'Send Separate Remittance Advice' program completed in error 

Error :

Exit: iby.scheduler.SRAAndPayerNotif.extractAndFormat()
Finished extract and formatting.
Error: IBY_XDO_DELIVERY_CFG_FILE is not set
oracle.apps.iby.exception.PSException: Error: the IBY_XDO_DELIVERY_CFG_FILE profile option is not set or is invalid.
at oracle.apps.iby.scheduler.SRAAndPayerNotif.doElectronicProcessing(SRAAndPayerNotif.java:610)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runSRA(SRAAndPayerNotif.java:346)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runProgram(SRAAndPayerNotif.java:170)
at oracle.apps.iby.scheduler.FDSeparateRemittanceAdvice.runProgram(FDSeparateRemittanceAdvice.java:45)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Error: the IBY_XDO_DELIVERY_CFG_FILE profile option is not set or is invalid.
An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.


Solution :

1. Please create the configuration file $XDO_TOP/resource/xdodelivery.cfg if it does not already exist. 
2. Set the profile option IBY_XDO_DELIVERY_CFG_FILE (IBY: XML Publisher Delivery Manager Configuration File) to point to the location of configuration file.






Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...