7 Replies Latest reply on Nov 11, 2018 11:10 AM by Ebenezer Illango

    Unable To Run Balance Forward Billing

    Ebenezer Illango

      Hi Team,

       

      Whenever I run the Balance forward billing in the EBS suite, I am getting the below error.

       

      Language function associated with program BPA Balance Forward Bill Print Program determined no data exists for the given set of parameters

       

      It occurs in the AR module. kindly please help!.

       

      Below is the whole message in output log.

       

       

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

      Application Object Library: Version : 12.0.0

       

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

       

      FNDMLSUB module: Multiple Languages

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

       

      Current system time is 19-SEP-2018 18:50:40

       

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

       

      **Starts**19-SEP-2018 18:50:40

      **Ends**19-SEP-2018 18:50:40

      Language function associated with program BPA Balance Forward Bill Print Program determined no data exists for the given set of parameters

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

      Start of log messages from FND_FILE

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

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

      Calling language function AR_BPA_BFPRI_CONC.PRINT_MLS_FUNCTION : 19-SEP-2018 18:50:40

      userenv_lang: US

      p_org_id:

      p_job_size:

      p_cust_num_low:

      p_cust_num_high:

      p_bill_site_low:

      p_bill_site_high:

      p_bill_date_low:

      p_bill_date_high:

      p_bill_num_low:

      p_bill_num_high:

      p_request_id: 138228446

      No documents matched the input parameters.

      Language function returned the following languages : . : 19-SEP-2018 18:50:40

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

       

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

      End of log messages from FND_FILE

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

       

       

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

      No completion options were requested.

       

      Output file size:

      0

       

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

      Concurrent request completed

      Current system time is 19-SEP-2018 18:50:41

       

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

       

       

      Thanks,

      Ebenezer Illango

        • 1. Re: Unable To Run Balance Forward Billing
          Bharat -Oracle

          Hi

           

          I have seen that such error will come when there are no eligible records to be picked by BFB program.

          There must be one more program spawned, check its log file.

          It will give a query which you can run separately to know if if fetches any records.

           

          Best Regards

          Bharat

          • 2. Re: Unable To Run Balance Forward Billing
            Bommi

            Hi Ebenezer,

                 Why don't you create one AR invoice and see if it is being fetched by BFB Program.

                 If it fetches, then i think it is working fine (As said by Bharath, there may not be any transactions)

                 If didn't fetched, then

                      1. Check if BFB setups are done properly or not

                      2. If properly done, then check for that Customer, Site BFB is enabled

                      3. If enabled, then check what is the billing data (Monthly/Weekly or daily or anything else and also the bill generation data). The program will/will not fetch based on billing date also

                      4. If it is also good, then check if it enabled at Site level/Account level and override level. It will also effect the BFB

             

             

            Regards,

            Bommi

            1 person found this helpful
            • 3. Re: Unable To Run Balance Forward Billing
              Ebenezer Illango

              Thank you So much for your response Bharath. I was able to figure out the error. Now BFB working perfectly. And sorry for the late response.

              • 4. Re: Unable To Run Balance Forward Billing
                Ebenezer Illango

                Thank you so much Bommi. The pre-requisite data, that is while running the Auto Invoice, proper selection of Invoice or credit memo must be chosen. Then we won't get into trouble.

                Sorry for the late response.

                 

                Many Thanks to Bommi and Bharath

                • 5. Re: Unable To Run Balance Forward Billing
                  Bharat -Oracle

                  Captured in the My Oracle Support Community discussion threads is a vast amount of valuable insights and answers that has been accumulated thanks to the collective efforts of our energetic community.

                  If you had a question answered here, others coming after you may encounter a similar issue. However, easily finding the correct or most useful response in a long thread may not always be simple. This is where the original thread poster can do a great service to the rest of our community by marking replies correct or helpful. Not only does this make it much more clear and straightforward for others to resolve the same problem, but it also recognizes the contributing member(s) for having provided that valuable information.

                  So don't forget that when threads include replies marked correct and helpful, you can click on the green/blue correct/helpful icon beside the thread title to be taken directly to that reply.Thanks

                  • 6. Re: Unable To Run Balance Forward Billing
                    Bommi

                    Hi Ebenezer,

                         Good to hear that the issue is resolved

                         Mark my response as helpful/correct if it anyway helped you

                     

                     

                    Regards,

                    Bommi

                    1 person found this helpful
                    • 7. Re: Unable To Run Balance Forward Billing
                      Ebenezer Illango

                      Thank you Bommi, In addition to the SIte/Account Level, there is also a check in BILL TO and SHIP TO in the Profiling process.

                      Not a big thing just to ensure Payment term is reflected in the Bill To and Ship To or not.

                       

                       

                      Thanks,

                      Ebenezer Illango