Billing Interface Spreadsheet Succeeds but not loading staging table
I have followed the setup in 9.2 documentation about using the BillingInterfaceExcelUpload.xlsm in Peoplesoft Financials.
I run the process and it runs to success and states that it has created the Interface id of 5399. When I try to find that interface ID in the INTFC_BI and the INTFC_BI_HDR table it does not exist. I do this thru sql on the backend and not thru the application. XML is well formed and transformed correctly and messages are being relayed across IB for the transaction.
When I rerun the process to it states that it has created the same interface id of 5399. Verifying that the table was not updated with the information for the process to pick up next in sequence.