This discussion is archived
4 Replies Latest reply: Oct 15, 2013 7:28 PM by 610338f8-21b0-4ddc-bf67-8b52fe6d3c21 RSS

Create Accounting Program in Request set

610338f8-21b0-4ddc-bf67-8b52fe6d3c21 Newbie
Currently Being Moderated

There is a requirement from my client to create a request set for following

 

Stage 10: Create Accounting (AP)

Stage 20: Create Accounting (AR)

Stage 30: Create Accounting (CE)

 

The problem is these programs trying to use the responsibility application id which is purchasing and failing. I tried to hard code them in the request set definition but not quite working. Does any one have done this sort of thing before? Any pointers would be greately appreciated.

  • 1. Re: Create Accounting Program in Request set
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Please post the details of the application release, database version and OS.

     

    What is the exact/complete error message you get?

     

    Thanks,

    Hussein

  • 2. Re: Create Accounting Program in Request set
    610338f8-21b0-4ddc-bf67-8b52fe6d3c21 Newbie
    Currently Being Moderated

    Thanks for looking into this. Here is the info.

     

    Application version: 12.1.3

    Databese: 10g

     

    log file:

     

    +---------------------------------------------------------------------------+
    Subledger Accounting: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    XLAACCUP module: Accounting Program
    +---------------------------------------------------------------------------+

    Current system time is 16-OCT-2013 09:40:04

    +---------------------------------------------------------------------------+

    **Starts**16-OCT-2013 09:40:04
    **Ends**16-OCT-2013 09:40:08
    An internal error occurred.  Please inform your system administrator or support representative that:

    An internal error has occurred in the program XLA_00200_AAD_C_011130_PKG.AcctLineType_63.  ORA-01427: single-row subquery returns more than one row.
    An internal error occurred.  Please inform your system administrator or support representative that:

    An internal error has occurred in the program XLA_00200_AAD_C_011130_PKG.AcctLineType_63.  ORA-01427: single-row subquery returns more than one row.
    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    16-OCT-2013 09:40:04 - Executing Unit Processor ...
    16-OCT-2013 09:40:04 - Initializing variables
    16-OCT-2013 09:40:04 - Security Context Set
    16-OCT-2013 09:40:04 - Ready to cache the Application and Ledger Level Sources ...
    16-OCT-2013 09:40:05 - Cached the Application and Ledger Level Sources
    16-OCT-2013 09:40:05 - AAD Package XLA_00200_AAD_C_011130_PKG is valid. Ledger Category is PRIMARY.
    16-OCT-2013 09:40:05 - Entering the loop to read document units from the queue ...
    16-OCT-2013 09:40:05 - Checking status of the parent Accounting Program
    16-OCT-2013 09:40:05 - Dequeuing the unit from the queue
    16-OCT-2013 09:40:05 - Fetching event information for the documents in the unit
    16-OCT-2013 09:40:05 - executing extract hook
    event key = 64346-59686831-E8D0AF41C01A17F8E04400144F3A6E37
    16-OCT-2013 09:40:06 - extract hook executed successfully
    +---------------------------------------------------------------------------+
    End of log messages from FND_FILE
    +---------------------------------------------------------------------------+


    +---------------------------------------------------------------------------+
    Executing request completion options...

    Output file size:
    0


    Finished executing request completion options.

    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 16-OCT-2013 09:40:09

    +---------------------------------------------------------------------------+

  • 3. Re: Create Accounting Program in Request set
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Please see if the following docs help.

     

    Create Accounting Program errors with ORA-01427 when run For Purchasing Transactions (Doc ID 1390489.1)

    How to avoid Create Accounting error "ORA-01427: single-row subquery returns more than one row" (Doc ID 1519408.1)

    Accounting Program Assets Errors with Xla_ae_code_combination_pkg.create_ccid. ORA-01427: Single-row Subquery Return (Doc ID 1522748.1)

     

    Thanks,

    Hussein

  • 4. Re: Create Accounting Program in Request set
    610338f8-21b0-4ddc-bf67-8b52fe6d3c21 Newbie
    Currently Being Moderated

    Thanks Hussein. I will try that and let you know.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points