0 Replies Latest reply on Jul 8, 2014 5:53 PM by IvanRivera

    Loading Virtual Requisition for Expenditure Items from a Plaintext.

    IvanRivera

       

      I have a requierment to create the requisitions from a plaintext separated by pipes. This plaintext have the next fields:

       

      No Temporary Req  | COMPANY | DESCRIPTION | PREPARER | Number of Row | TYPE | ARTICLE | DESCRIPTION | UDM | QUANTITY | PRICE | NECESSARY TO | BUYER | FRANCHISOR | BRAND | OPERATING UNIT | ORGANIZATION | Street address | ORIGIN | project| task | TYPE | ORG | DATE


      In my procedure I read the lines, validate the info, and then insert this info in the interface PO_REQUISITIONS_INTERFACE_ALL. After that I call the concurrent REQIMPORT to create the requisition

      At this point its all OK.


      Requisition Import Run Report Date: 07-JUL-14

      -------------------------------------------------

       

      Number of approved requisitions created = 0

      Number of unapproved requisitions created = 3

      Number of interface lines in error = 0

       

      -------------------------------------------------

       

      End of Report

       

      Im able to see the requisition with the info in the app, but the proyect and task doesnt appear.

       

      Problems

      1. I have to update the task and project but I dont know where

      2. The approval status of the requisition is incomplete and I have to put it in reserve.

       

      Could you help me to understand better the process to know where I have to update and in wich table, and where can I call the program to put it in reserve?

      Thanks