ERPstuff - Oracle EBS Community

We are trying to create graphical reports from Oracle Financial Statement Generator (FSG) xml output. I personally have extensive exposure working with XML (BI) Publisher but until recently I have never tried to use the BIP charting wizard to create graphical reports from FSG xml output out of EBS ...

Instead of report paste the query in the sqlplus and check the results. May be returning multiple values or data size issue. thanks

<i><div align="right">Originally posted by admin - Apr 23 2009 : 08:29:29 AM</div id="right"></i>
function CUSTOMER_NAMEFormula return Char is
t_customer_name ...

Did you manage to get an answer to this issue; I'm having the same issue with one of my reports6i.


Thanks,

Leo

Do I really have to pass the period_name input parameter or I can just leave it NULL?

I did open the period from the GL and AP but it still gives the same message.

After I did correct date format it appears like it's calling utilities package for GL_open_periods which is why it's giving an uotput as below.

Connecting to the database Mahwah Dev.
P_MESSAGE_NAME = AP_DISTS_NO_OPEN_FUT_PERIOD
P_INVOICE_AMOUNT =
P_BASE_AMOUNT =
P_TAX_AMOUNT =
P_TEMP_CANCELLED ...

Here is the PL/SQL block that I'm hardcoding my invoice values for testing and I have pasted the error that I'm getting.

DECLARE
P_INVOICE_ID NUMBER;
P_LAST_UPDATED_BY NUMBER;
P_LAST_UPDATE_LOGIN NUMBER;
P_SET_OF_BOOKS_ID NUMBER;
P_ACCOUNTING_DATE DATE;
P_PERIOD_NAME VARCHAR2(200);
P_MESSAGE ...

Ramkic,

Maybe I'm having issues calling it. How can I test this package manually ? I tried to cancel one invoice manually using this package but it didn't cancel the invoice that I had hardcoded onto the parameter list. I will follow up with a sample code that I used shortly.

Thanks for the follow ...

I already tried to call that pkg but it appears like the process first calls AP_Utilities_pkg and Ap_invoices_pkg and it also calls ap_payment_schedules_pkg.

I tried to call the package is follows:

i_success:= ap_cancel_pkg.Ap_Cancel_Single_Invoice which is the function that cancels single ...

These invoices are validated but not yet paid. We don't want to delete them but cancel.
For accounting you have to run Accounting Process SRS in Payables to create accounting for the transaction. W

Leo

Hi Gurus

We are trying to find if there is a way to cancel mass invoices from applications or from the backend. We have about 20000 invoices that we want to cancel but since in applications you can cancel not so many invoices at a time; we are trying to find out if there is any other way to do this ...