QUOTE:

---

原帖由 donkey0424 于 2008-10-5 18:35 发表
在metalink上copy的，希望对你有用！

*** 08/19/98 03:36 pm *** .Tries to enter Req?  Gets error: app-14142 get_po_parameters-10 ora-01403 no data found cause a sql error occ in get_po_parameters error is &lsql_err .Tries to go to Autocreate and gets error user is not an employee . Had ct check to see if they can access PO Options since most of the entries on this have to do with the parameters.  Was able to change options. Had ct run the following script: select fsp.inventory_organization_id  FROM    financials_system_params_all fsp,           gl_sets_of_books sob,           po_system_parameters_all psp,           rcv_parameters  rcv   WHERE   fsp.set_of_books_id = sob.set_of_books_id Ct received 1 row of output which is their master org id.  They said they have multiple inventory orgs. (Looks like possible problem?) Asked them to check the MO:Operating Unit to be sure it was not different at site vs responsibility. . They went to the sql fnd_profile_option_values tables and found there were 3 rows created about the same time the system went down.  Dont know if it is relevent. a Alert patch and increased the Next parameter in FND. Also had set up a user with more responsibility, but the user was able to run the report with the new responsibility with no problem. *** 08/19/98 05:19 pm *** They need to run the same sql stmt as above, but change the _all tables so that the _all is removed from the statement. They may have incorrect/mismatched org id\'s in the financials sys parameters tables and the po_system param tables. *** 08/19/98 05:25 pm *** (CHG: Sta->30) See if those two tables have a value in the org_id field in the _all version of the table. The values should match.  If the values are not null the value should be be the same as the value in the MO profile option. *** 08/19/98 05:30 pm *** if that looks good, double check by running the sql again 1st setting clientinfo : begin dbms_application_info.set_client_info(&op_unit); end; then run sql:  
SELECT  sob.currency_code,           sob.chart_of_accounts_id,           nvl(fsp.purch_encumbrance_flag,\'N\'),           nvl(fsp.req_encumbrance_flag,\'N\'),          sob.set_of_books_id,           fsp.ship_to_location_id,           fsp.bill_to_location_id,           fsp.fob_lookup_code,           fsp.freight_terms_lookup_code,           fsp.terms_id,           psp.default_rate_type,           psp.taxable_flag,           psp.receiving_flag,           nvl(psp.enforce_buyer_name_flag, \'N\'),           nvl(psp.enforce_buyer_authority_flag,\'N\'),           psp.line_type_id,           psp.manual_po_num_type,           psp.user_defined_po_num_code,           psp.price_type_lookup_code,           psp.invoice_close_tolerance,           psp.receive_close_tolerance,           psp.security_position_structure_id,           psp.expense_accrual_code,           fsp.inventory_organization_id,           fsp.revision_sort_ordering,           psp.min_release_amount,           nvl(psp.notify_if_blanket_flag,\'N\'),           nvl(sob.enable_budgetary_control_flag,\'N\'),           psp.user_defined_req_num_code,           nvl(psp.rfq_required_flag,\'N\'),           psp.manual_req_num_type,           psp.enforce_full_lot_quantities,           psp.disposition_warning_flag,           nvl(fsp.reserve_at_completion_flag,\'N\'),           psp.user_defined_receipt_num_code,           fsp.use_positions_flag,           psp.default_quote_warning_delay,           psp.inspection_required_flag,           psp.user_defined_quote_num_code,           psp.manual_quote_num_type,           psp.user_defined_rfq_num_code,           psp.manual_rfq_num_type,           fsp.ship_via_lookup_code,           rcv.qty_rcv_tolerance  FROM    financials_system_parameters fsp,           gl_sets_of_books sob,           po_system_parameters psp,           rcv_parameters  rcv   WHERE   fsp.set_of_books_id = sob.set_of_books_id *** 08/19/98 10:57 pm *** This may need to wait to morning US time *** 08/20/98 07:33 am *** TAlked to their DBA (AL ORR) and they were able to isolate the problem. Looks like they have some problem with the MO:Operating Unit profile option not defined correctly for the responsibility. . Doing select statement on the fnd_profile_option_values table, they identified records with a space value in the profile_option_value column. . They are going to the SYSADMIN responsibility to fix those records using the Applications forms and they wil make the profile option not updatable to users under the Applictions Dev responsibility. Customer agreed to close BUG. *** 08/20/98 07:34 am *** (CHG: Sta->92)

---

QUOTE:

---

原帖由 Andy_xixi 于 2008-10-5 18:43 发表
查看一下这个权限的profile是否都已经设置，帮你顶

---

QUOTE:

---

原帖由 Andy_xixi 于 2008-10-5 18:43 发表
感觉跟你另一个贴的出现的账本问题有关系

---

QUOTE:

---

原帖由 Andy_xixi 于 2008-10-5 18:44 发表
LZ是在帮人实施ORACLE EBS吗？

---