Best Of
Re: why redo and undo logs are required during flashback of database? aren't flashback logs enough?
Well, that is not really the thruth…
You need to set a flashback retention target to use Flashback Database. The retention target signals the database to copy images of each altered block in every data file into the flashback log at regular intervals. This does NOT mean, if you want to roll back to SCN 1000 it will roll back the blocks to SCN 1000. It may roll back some blocks to SCN 900, other to 947 and if you are lucky - also some to SCN 1000.
These images are later used to reconstruct a previous incarnation of the database on demand. Any remaining changes are recovered using online and archived redo logs if available. That means, these older images may also have COMMITTED transaction between SCN 900 and SCN 1000 - this part does come out of the Archive Logs…
You may let translate the following article to english to understand it better….
Re: Shared directory rights problem
hello
When you do share -F nfs without option, by default the file system is shared in rw
that's correct ?
Re: Can we run the pick slip report to be printed from MWA mobile application after Kanban replenishment
Unfortunately , there is no option to generate the pick slip report from Mobile. It needs to be printed from the Application.
Re: Removing Duplicate Calendars - Finding Where They are Assigned
Unfortunately there is not a way to check this via the app.
You will need to log an SR so we can check with Development on the calendar associations from the backend.
Re: Added on-hand qty, we have given Qty 0.1, instead of .1, in On Hand Qty form.
Hello,
Please check note: Why is the Display Format Of Quantity And Price Fields Not Consistent When Decimal Value Is Less Than 1? (Doc ID 2634816.1).
Currently, the preferred display option is without the leading zero.
However, Enhancement Request Bug 2642902 has been logged so that the display format can be controlled at the user level.
Thank you and regards,
Irina
Re: Expense Accrual on receipt balances not displaying in of the reports
Hi Team,
At first you need to check if the PO are set to Online Accruals ( ACCRUE_ON_RECEIPT = Y at PO shipment and PO distributions ).
If yes, the If the received quantity > Billed quantity.
If yes,
If the Receive accounting moved to SLA and GL and posted in GL.
Then
Run the Accrual Reconciliation Load run program covering the Receipt date.
Only if Accrual Reconciliation Load run program populates data into CST table,
CST_AP_PO_RECONCILIATION , CST_RECONCILIATION_SUMMARY then only AP and PO Accrual Reconciliation Report will have the output.
You can create a new PO, receipt, run the Create Accounting program to move the receipt accounting to GL and Post it. Then run the Load run program and then verify the output in AP and PO Accrual Reconciliation Report will have the output. Let me know the outcome.
Thanks
Pramod
Re: Share An Issue in HAMI We Had With Applying ODA 19.27 in DBS
Hi Ocean,
The developer who worked with you confirmed that the workaround was required on your ODA version.
From Dev:
At that time, I identified that the HamiCtl tool was unable to determine which was the localhost when the DB System private names had the form name1-1-priv and name1-2-priv.
I joined a call with that CT to help him revive the DCS infrastructure since the patching was left unfinished, only the first node finished the update-dcscomponents but the second node was still pending.
The w/a was indeed move the dcs#-priv name to the beginning of the line in /etc/hosts, since the Agent takes the first name as the private name.
The HamiCtl tool was able to determine which was the localhost when the private names were dcs0-priv and dcs1-priv.
Br,
krisz
Re: Advisor Webcast for Applications Unlimited: Enabling Modernization with Artificial Intelligence
Was there an answer to @Matheshwaran V - PeopleSoft Delivery Architect question above? We run Peoplesoft onprem.
Re: Error while approving Journal
Does the multiledger responsibility have access to the ledger that the journal notification is for? If not, then something is defaulting to that responsibility (as opposed to choosing the responsibility for you based on the access it has).
Re: Error while approving Journal
Hi,
The reported issue might be reproduced via below steps:
- User selects a notification (Belongs to Ledger A).
- Click on link "Enter/Review Journals".
- User gets an option of selecting a responsibility.
- User selects "Responsibility 1"
- Journal Opens in Oracle Forms.
- User then navigates to open another notification which Belongs to Ledger B
- Click on link "Enter/Review Journals"
- Pick a responsibility 2 ;
However the system tries to use the responsibility1 from cache to open the Journal using Responsibility 1
and gives error message: "APP-FND-01347: You no longer have access to the specific information requested in this screen."
In this case, use a responsibility that has access to a single Ledger when you click on the Workflow Notification for the Journal Batch Approval.
Or
Enable Internet Explorer Options “Delete Browsing History On Delete”
Logout and login back.
Regards,
Phanendra.



