ERPstuff - Oracle EBS Community

hi all

this is my first post here

whenever i execute ap_checks_v it says "no rows returned"[:(]
i have a report developed by someone previously before me,the client requirement is to display check_number with PAYMENT_METHOD_LOOKUP_CODE=WIRE
(PAYMENT_METHOD_LOOKUP_CODE is column in ap_checks_v and ap_checks_all)
i took this query which when executed in TOAD gives no rows returned[:(]
<b>SELECT
ac.check_id ac_check_id, ac.amount amount,
ac.currency_code currency_code, fcv.NAME currency_name,
fcv.PRECISION currency_precision, ac.doc_sequence_value voucher_number, ac.check_date check_date, ac.vendor_name paid_to,
ac
.description description, ac.bank_name bank_name,
' ' || ac.bank_account_name || ' ' bank_account_name,
' ' || ac.check_number || ' ' check_number,
NVL
(ac.future_pay_due_date, ac.check_date) maturity_date
FROM ap_checks_v ac, fnd_currencies_vl fcv
WHERE ac.check_number = :p_check_number
AND ac.currency_code = fcv.currency_code </b> i replaced ap_checks_v with ap_checks_all but it says ac.bank_name invalid identifier
whereas when i do select * from ap_checks_all i am able ot view CHECK_NUMBER having values when PAYMENT_METHOD_LOOK_UP_CODE=WIRE
currently i suppose only CHECK_NUMBER with Payment_method_look_up_code=CHECK is being displayed
i require WIRE too

kinldy help me

thanking in advance
kincly help me

Hello.

To see the records in AP_CHECK_V you need to set the org_id before executing the query.

Octavio.

hi
thank u for the response
i did BEGIN
dbms_application_info.set_client_info ( org_id );
END;
i found under examine-$PROFILE-org_id is 0
still it gives "no rows returned"

kindly help me

Hello.

The org_id can't be zero. That corresponds to a seeded organization. You should go to Payments windows, locate the check number and examine to see which is value for ORG_ID field.

Octavio

hi
i did this in payments window
i found under examine-$PROFILE-org_id is 0
could u please elaborate on the step u have mentioned
kindly help me

Hello.

Open the payments window and search for the check number. Then use Diagnostics/Examine and look for the ORG_ID value, not under the $PROFILE Block but unser the PAY_SUM_FOLDER Block. This should give you the correct org_id.
Are you using multiorg?
Also execute the following query and see if you can identify you org_id:

SELECT organization_id, name
FROM hr_all_organization_units;

Let me know if you solved the problem.
Octavio.

hi

i tried putting the block as pay_sum_folder in payments still org_id was showing 0

the issue is resolved ,i had changed the nls lang setting for arabic reports

now i changed it back ,it is working

Thanks a lot!!

regards
lincy