ERPstuff - Oracle EBS Community

Hi, first check the following table. select * from ap_accounting_events_all where event_status_code <>'ACCOUNTED' Here you can chack the following column event_status_code='ACCOUNTED WITH ERROR' if this error occur you may need to run the undoatg script. If this error occur you can raise the SR and ...

Hi, We can find out the batch status in following way. Go to payment batch and press F11 enter status column as Selecting Selected Built Formatting Formatted Confirming and enter respective Paygroup then Ctl+F11. I am sure your batch is selected in above either one status.either you can confirm the ...

Hi,

You can add the report parameters like this.

select * from ap_checks_all where trunc(check_date) between &from_check_date and &To_check_date;

I hope you can understood now.

Thanks & Regards,

Siva

Hi, Please check with following query. SELECT DISTINCT(ffv.FLEX_VALUE),ffv.DESCRIPTION FROM fnd_id_flex_segments fis,FND_FLEX_VALUES_vl ffv WHERE fis.FLEX_VALUE_SET_ID=ffv.FLEX_VALUE_SET_ID AND END_DATE_ACTIVE IS NULL AND fis.SEGMENT_NAME=' key flexfield Segment name' if any more queries please let ...

Hi,

please find the seeded reports in FA.

India - Depreciation detail report.
Journal Entry Reserve Ledger Report
Asset Retirements Report

if you want more clarification,Please let us know.

Thanks & Regards,

Siva

Hi, While doing DD payment following accounting entries will generate. Invoice Level Accounting: ----------------------------- Charge Account Dr Liability Account Cr Payment Level Accounting: Liability Account Dr Pay order account Cr Please let me know if any clarifications Thanks & Regards, Siva

Hi,

Please run the following request.

Navigation:
AP-->view-->Requests-->Submit New request-->Single request

Payables accounting process

Thanks & Regards,

Siva

Hi,

Please provide me the exact requirement and what are the columns you required in the report.

Thanks & Regards,

Siva

Hi Hari,

Please run the following report and let me know the status.

India - Creditors Trial Balance Report

Thanks & Regards,

Siva

Hi All,

In my GL interface table i found some entries status is "ER09" (ER09 Default reversal information could not be determined). How to resolve the issue? and let me know the solution please.

Thanks & Regards,

Siva

Hi, Following are the GL Error codes. Period Error Codes ------------------ EP01 This date is not in any open or future enterable period. EP02 This set of books does not have any open or future enterable periods. EP03 This date is not within any period in an open encumbrance year. EP04 This date is ...

Hi,

Please Contact your DBA. He can try to extend the table space.

Hi,

Please try this one...

LOAD DATA
INFILE ?C:\FIRST.DAT?
INFILE ?C:\SECOND.DAT?
INSERT INTO TABLE FIXED_EMP
FIELDES TERMINATED BY ?,?
(EMPNO, ENAME, DEPTNO)

if any queries please let me know.

Hi Uma,

Please log on to the server database,then use this query to find out the PL/SQl Procedure.

Select * from user_objects where OBJECT_TYPE='PROCEDURE'

It will shows the list of all procedure names.
Extension of the file is .SQL

If you have any queries please let me know.

Hi,

5.where do you test your pl/sql code?

We have different types of environments are there like Development,Testing & production.

when we are in developing stage.
we can test the pl/sql code in development environment.

If any queries please let me know