Best Of
Re: ODACLI configure-dataguard fails around step 7 Restore missing archivelog (Primary Site)
I don't think there's any workaround on the old version, at least using the oda commands.
You can configure it using dgmgrl on that version though.
Koop
Re: Script see who added a responsibility or removed end date of responsibility to user
Oops, in the query
ug.last_updated_by
should be
ug.last_update_date
Apologies for that, was typing along and wrote the wrong thing.
Thanks,
J
Re: Script see who added a responsibility or removed end date of responsibility to user
Hi Linda,
This query should work. It will prompt for the user name and the responsibility name Be aware that it can only show who last updated it. So if the responsibility has been taken away again, you will see the person who took it away.
select u.user_name, t.responsibility_name, ug.start_date access_began, ug.end_date access_ends
, ug.last_updated_by access_change_date, uc.user_name access_updated_by
from apps.fnd_user_resp_groups_all ug, apps.fnd_responsibility_tl t
, apps.fnd_user u, apps.fnd_responsibility r, apps.fnd_user uc
where nvl(ug.end_date,sysdate+1) > sysdate -- user has the responsibility as of today
and nvl(r.end_date,sysdate+1) > sysdate -- responsibility itself is not end-dated as of today
and nvl(u.end_date,sysdate+1) > sysdate -- user is not end-dated as of today
and ug.responsibility_id = t.responsibility_id
and ug.responsibility_application_id = t.application_id
and t.responsibility_id = r.responsibility_id
and t.application_id = r.application_id
and ug.user_id = u.user_id
and uc.user_id = ug.last_updated_by
and u.user_name = '&USER_NAME'
and t.responsibility_name = '&RESPONSIBILITY'
If this works, please check Yes where it asks if this answers the question.
Thanks,
J
Re: AR WorkCenter - Regular Deposit Results
Thank you so much for your kind and prompt response, Pere; I will definitely add this on the Ideas lab.
Have an excellent day!
Maty
Re: Why Can't PO matched Invoice Distribution charge account be updated, Once the AP posted to GL and th
Hi @User_5RRJX ,
Please refer
R12: Invoice and Invoice Distribution Adjustment Charts - Explains what Fields can be Adjusted on an Invoice and when the System Prevents Update (Doc ID 1300685.1)
Thank You,
Anees
Re: AR WorkCenter - Regular Deposit Results
Hello @FIN_USER_7 ,
I hope all is well with you over there ;o)
Thanks for your latest post in the PeopleSoft Financial Management Community!!
Having reviewed your comments, I am assuming that you are talking about the below Entered Date column:
Note that the Regular Deposit within the Links > Payments section from Fluid Receivables WorkCenter is basically pointing to the Regular Deposit search page under the below navigation path:
- Accounts Receivable > Payments > Online Payments > Regular Deposit
The Entered Date column has been listed in the search results for many releases now. Adding the Accounting Date, while a valid point, would be an Enhancement Request. I would suggest you raise this same post into the Receivables Ideas Lab site, so it can be considered by the Strategy and Development teams for future FSCM 9.2 PUM Images.
The Search Record behind the Regular Deposit page within the Component PAYMENT_ENTRY is based on DEPOSIT_NP_VW (Deposits - Not Posted). You will see the fields within this View include ENTRY_DT. If you wish to have the Accounting Date, you would need to customize this View to include/list ACCOUNTING_DT field as well.
I hope that the information provided has clarified all your doubts. Should you have additional related questions, do not hesitate letting us know. On the contrary, if all your queries, and doubts have been successfully addressed, please make sure to mark 'YES' on the 'Did this answer the question? Yes-No' link. This will enable other Community Users to quickly identify the solution suggested, and see that this post has been successfully
answered.
Have an excellent day!
Pere Taulé
AR WorkCenter - Regular Deposit Results
When querying the AR Regular Deposits link of the Links> Online Payments section of the WorkCenter, the results include Entered Date. Would it be more beneficial to have Accounting Date instead, or have that field added to the delivered functionality?
Re: BOE not showing while creating Receipt when clicking on Receipt Line Application?
Hi @P.Priyanka.S.Singh-Oracle ,
Issue is resolved now. We have completed the receipts.
Thank you all for the inputs.