1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

IN AGIS AP Invoice is not generated

Discussion in 'Oracle Financials' started by krishna, Feb 1, 2015.

  1. krishna

    krishna Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Hyderabad
    Hi

    We have issue in AGIS We have approved IC batch and run both the program to generate AR and AP invoice, but only AR invoice got generated and also batch status is Transferred to Receivables instead of Complete status.I have verified AP Interface tables. every thing is fine.

    Regards

    apps
     
  2. Iwanhe

    Iwanhe Active Member

    Messages:
    30
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    Indonesia
    Hi Krishna,

    Have you checked the interface tables from AP ?

    Have you checked the workflow status ?

    (a) Responsibility ->Workflow Administrator Web Applications -> Oracle Applications Manager --> Workflow Manager
    (b) Notification Mailers  Check all the components in this region.
    (c) Agent Listeners  Check all the components in this region
    (d) If any of the listener components are not in ‘Running’ status, then stop and start the listeners.
    (e) If all the listeners are running as expected, then follow the next set of steps to check licenses.

    Check License:

    (a) To check licenses, execute the following query
    Code (SQL):
    SELECT we.name, wes.wf_process_type, wes.wf_process_name,
            wes.licensed_flag
            FROM wf_events we, wf_event_subscriptions wes  
            WHERE we.guid = wes.event_filter_guid
            AND wes.wf_process_type LIKE 'FUN%';
    For AGIS workflow to work as expected the value in the field licensed_flag must be ‘Y’.
    (b) If the value in the licensed_flag is ‘N’, then execute the below query.
    Code (SQL):
        SELECT app.APPLICATION_SHORT_NAME,
                prod.STATUS
                FROM fnd_product_installations prod,
                fnd_application app
                WHERE app.application_id = prod.application_id
                AND app.APPLICATION_SHORT_NAME = 'FUN';
    (c) If the value in the status field is ‘I’ or ‘S’, then submit the concurrent program, ‘Synchronize Product License and Workflow BES License’. This program synchronizes (sets/resets) the license flag on all Events/Subscriptions based on the product license settings.
    (d) If status is NOT ‘I’ or ‘S’, then follow the metalink note: Note 351453.1 (Replace the Product code FPA with FUN).
    (e) Execute the concurrent program, ‘Synchronize Product License and Workflow BES License’.
    (f) Execute the query in step a, and check for the value of the field licensed_flag, it must be ‘Y’.
    (g) If the licensed_flag is NOT ‘Y’, then follow metalink NOTE: 430588.1(application_id = 435)
    (h) Repeat steps e-f.


    Regards,
    Iwan
     
  3. krishna

    krishna Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Hyderabad
    Hi Iwan,

    Thank for your replay. It is not Work flow issue.

    Regards
    krishna.
     
  4. Iwanhe

    Iwanhe Active Member

    Messages:
    30
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    Indonesia
    Dear Krishna,

    Is that already solved right now ?

    Regards,
    Iwan
     
  5. krishna

    krishna Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Hyderabad
    Hi,
    Yes it is already solved.

    Regards