Best Of
Re: Primavera P6 Standalone licensing
Hi @User_RMDHQ
Uninstall from the old machine
Install on the new machine
With standalone, it's that simple.
David
PMO
Re: What does allowed transaction in material status define 'Staging transfer on a sales order ' mean
Hi @Ionut-Oracle ,
Thanks for the quick response , this helped understand the status definition.
Re: MessageBox with question using %MsgStyle_OKCancel makes my jsonarray empty ?!
Bart- When you use an OK/Cancel MessageBox, the PeopleCode runtime can destroy certain object references (like JsonArray). That’s why the array length looks reset after the dialog.
A reliable workaround is to wrap your array in a JSON object before showing the dialog, then re-parse it afterward. This preserves the contents.
Local JsonArray &jArray;
Local JsonObject &wrapper, &root;
Local JsonParser &parser;
Local number &length_before_question, &length_after_question, &Answer;
Local string &jsonStr;
&jArray = CreateJsonArray();
&jArray.AddElement("Name");
&jArray.AddElement("Name2"); &length_before_question = &jArray.Length(); /* Wrap array inside an object /
&wrapper = CreateJsonObject();
&wrapper.AddJsonArray("data", &jArray);
&jsonStr = &wrapper.ToString();
WinMessage(&jsonStr);
/ Prompt user */
&Answer = MessageBox(%MsgStyle_OKCancel, "", 0, 0, "Question?");
WinMessage(&Answer); /* Rebuild after dialog /
&parser = CreateJsonParser();
If &parser.Parse(&jsonStr) Then
&root = &parser.GetRootObject();
&jArray = &root.GetJsonArray("data"); / <-- correct for your parser */
&length_after_question = &jArray.Length();
Else
&length_after_question = - 1;
End-If; Warning "&length_before_question: " | &length_before_question | " - &length_after_question: " | &length_after_question;
Have tested and it does works/
-Velu
Re: On Account Receipt Report
Unapplied and Unresolved Receipts Register
Use the Unapplied and Unresolved Receipts Register to review detailed information
about your customers' on-account and unapplied payments for the date range that you
specify. Having an understanding of a customer's on-account and unapplied payments
more accurately indicates how much a customer actually owes you.
This report includes all receipts that are not fully applied to customer transactions. This
includes receipts with unapplied cash, in addition to receipts with applications that
require resolution, such as applications to:
• On Account
• Claim Investigation (for users of Oracle Trade Management only)
• Prepayment
This report excludes receipts applied to activities that do not affect the customer
balance, such as receipt write-offs, short-term debt, and credit card refunds. For
example, when you create a credit card refund, it is the credit memo associated with the
refund that affects the customer balance (and is reported in the Transaction Register).
This report also excludes miscellaneous receipts.
When reconciling, the Unapplied and Unresolved Receipts Register's total should match
the Unapplied Receipts Journal.
If the profile option AR: Sort Customer Reports by Alternate Fields is Yes, Receivables
will sort information using the value of the Alternate Name field in the Customers
window.
The Unapplied and Unresolved Receipts Register is an RXi report.
Thanks
Philip
AR CoE
Re: Peoplesoft Schedule Query Reccurence field not enabled
Hello User,
Please perform this activity:-
- Navigate to PeopleTools > Security > User Profiles > User Profiles and search for the user needing the rights.
- Check for the permission set under "Process Profile".
- Navigate to PeopleTools > Security > Permissions and Roles > Permission Lists and search for the permission listed in the "Process Profile".
- Open the permission and navigate to the "Process" tab.
- Click on "Process Profile Permissions".
- Under "Allow Requestor To" enable "Enable Recurrence Selection" option.
- Save and log-off.
Perform above task by Security Administrator and impacted user is not logged in it PeopleSoft application.
Thanks,
Akash
Re: NEW EBS Monitoring Analyzer
The Specific Diagnostic for Shipping Execution signals problems with Sales Order Lines Shipped but not Interfaced. The sql does take in to account that a sales order line can be linked to multiple delivery detail record where some can be cancelled. The Cancelled delivery details are not going to be marked as interfaced. They are then producing a false positive for the signal in the Diagnostic.
For instance the following sql could be used instead in order not to include where cancelled delivery details:
select ORD.HEADER_ID, LIN.LINE_ID, DET.INV_INTERFACED_FLAG, LIN.SHIPPED_QUANTITY, LIN.FLOW_STATUS_CODE from OE_ORDER_HEADERS_ALL ORD, OE_ORDER_LINES_ALL LIN, WSH_DELIVERY_DETAILS DET where ORD.HEADER_ID = LIN.HEADER_ID AND DET.SOURCE_LINE_ID = LIN.LINE_ID AND DET.SOURCE_CODE = 'OE' AND DET.INV_INTERFACED_FLAG = 'N' AND LIN.SHIPPABLE_FLAG = 'Y' AND nvl(LIN.SHIPPED_QUANTITY,0) > 0 AND LIN.FLOW_STATUS_CODE = 'CLOSED' AND det.released_status <> 'D' AND rownum < 1000
Please consider this a change request!
Regards
Niels LM
Re: One employee can have setup 2 PCARDS in two different Operating Units?
Thanks Hosana!
Accepted Answer
Re: Why Does R12 Web ADI Not Mark Valid Rows With Green Smiley Face?
Hi,
Glad to know that you was able to find the issue for the related custom integrator.
You may check also the below note:
Green Smiley Face Missing / Success Status If There Is An Error On One Of The Records Of Custom Integrators (Doc ID 1529685.1):
Commit statement in interface pl/sql api is not allowed.
The upload takes place in batch mode, i.e upload of data is designed to take place only if ALL the rows are valid. Only then is the data is committed in the database and green smileys are shown against ALL the valid rows.
If some of the rows have errors, then none of the rows should get uploaded and only the rows having error are shown with a red sad face and none of the data is committed into the database. Once the errors are fixed, upon the next upload, then ALL of the rows will be uploaded at once and then you will see the green smiley face for all of the rows.
This is a problem with the custom code. Remove the commit(s) from the pl/sql api.
Thanks and regards,
Anca
We're Releasing! QUARTERLY FULL STACK DOWNLOAD PATCH FOR SUPERCLUSTER (Q3.2025) (Patch 37952752)
QUARTERLY FULL STACK DOWNLOAD PATCH FOR SUPERCLUSTER (Q3.2025) (Patch 37952752)
Why should you install the SuperCluster Q3.2025 QFSDP Patch?
- Update your SuperCluster environment with the Oracle Solaris Operating System (S11.4) that includes new security and availability fixes.
- Update your SuperCluster Oracle Database environments with the July 2025 database patches.
- Update your SuperCluster tooling to reflect the improved functionality of the latest Exa-Family tools.
Profile of the Q3.2025 QFSDP Release
The Q3.2025 QFSDP Patch provides the following features and updates for SuperCluster customers.
This SuperCluster Quarterly Full Stack Download Patch is applicable for SuperCluster version 1.x, 2.x and 3.x systems.
Re: How do I get an updated RTF template to show changes?
Yes, so you should talk to the PO team about how their form calls templates.
Kevin







